Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /var/www/html/jc.infradapt.com/libraries/joomla/html/parameter.php on line 512

Infradapt Blog

This is some blog description about this site

Font size: + –

Bookmark

Data Recovery Is an Important Part of the Backup Process

Monday, 14 May 2018

John Reilly

Newsletter

0 Comment

How does your business manage its data backups? How about restoring them in the event of a disaster scenario? These are questions that no business wants to have no answer to on the spot. You want to have both data backup and disaster recovery put into place to avoid losing a considerable amount of progress.

It can be difficult to see how data backup and disaster recovery are two different things, but the fact remains that they fulfill a very important role for business continuity. Data backup is the process of actually taking the data backup that you will then later restore to a workable state. Disaster recovery is when you restore a working data backup so that it can be used to get your organization into a state where it can operate following a data loss incident.

A business continuity solution needs to include both data backup and disaster recovery, both of which should be used to achieve an ideal recovery point objective and recovery time objective. Here are what they are:

Recovery point objective: The recovery point objective, or RPO, is how much data needs to be restored in the event of a disaster. Basically, the more data that you need to restore to get your operation going again, the larger your RPO is going to be.

Recovery time objective: The recovery time objective is the amount of time your organization has to restore data before your business is in trouble. Every moment wasted waiting for your data to be restored is costly, but there reaches a point where if you don’t have your data, you can’t sustain operations, and the business begins to fail.

Not all data backup and disaster recovery systems are the same. In some cases, they are just inferior to others. Take tape backup as an example. While it may have been the standard solution for quite some time, it’s an inconvenient manner of taking data backups and restoring them. Not only is it time-consuming, but it’s also not automatic and prone to user error. You could potentially lose up to an entire day’s worth of data in the event of a disaster scenario. Network-attached data backup and disaster recovery with cloud functionality is better, as it allows for fast data recovery and for multiple backups to be taken every single hour. In fact, you can take backups as often as every fifteen minutes, making it much better than the singular large data backup that can only be taken once. This helps to minimize downtime and data loss in the event of a disaster.

Does your business need a better way to approach data backup? Infradapt can help. To learn more, reach out to us at 800.394.2301.

About the author

John Reilly

View author's profile More posts from author

John Reilly is Managing Partner at Infradapt, LLC. Prior to joining Infradapt, he was the President of Vital IT Solutions, Inc., where among other roles, he developed a methodology and approach for performing risk and compliance assessments.

Prior to Infradapt, Mr. Reilly founded Vital IT Solutions, Inc., Mr. Reilly worked with Expanets, Inc., as a Senior Converged Account Executive, specializing in VoIP and Security, and a Subject Matter Expert (SME) on HIPAA. His Expanets’ achievements included national Sales awards including Millionaire’s Club and pioneering VoIP deployments for regional clients.

Mr. Reilly also has direct work experience in the banking industry, where he worked in Sales and Management, and in manufacturing, where he worked as an Accountant. John earned his BS in Accounting at Gwynedd-Mercy College, while also studying Negotiation, Decision Making, and Creative Problem Solving. He holds a SANS GIAC security certification and is a member of the Philadelphia Chapter of InfraGard.

Author's recent posts

Tuesday, 19 June 2018 EHR and Other Technologies Moving Healthcare Forward

Friday, 15 June 2018 How Much Time Do You Spend on These Websites?

Wednesday, 13 June 2018 Tip of the Week: How to Improve Your Invoicing Processes

Comments

No comments made yet. Be the first to submit a comment

Joomla! Debug Console

161 Queries Logged

SELECT `data` FROM `p3sae_session` WHERE `session_id` = '39f43e12ba22b10f1c6de0015c48c353'
DELETE FROM `p3sae_session` WHERE `time` < '1714035577'
SELECT `session_id` FROM `p3sae_session` WHERE `session_id` = '39f43e12ba22b10f1c6de0015c48c353' LIMIT 0, 1
INSERT INTO `p3sae_session` (`session_id`, `client_id`, `time`) VALUES ('39f43e12ba22b10f1c6de0015c48c353', 0, '1714044577')
SELECT extension_id AS id, element AS "option", params, enabled FROM p3sae_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id FROM p3sae_usergroups AS a LEFT JOIN p3sae_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
SELECT id, rules FROM `p3sae_viewlevels`
SELECT folder AS type, element AS name, params FROM p3sae_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1) ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled FROM p3sae_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT `query` FROM `p3sae_admintools_wafexceptions` WHERE (`option` IS NULL OR `option` = '') AND (`view` IS NULL OR `view` = '') GROUP BY `query` ORDER BY `query` ASC
SELECT `value` FROM `p3sae_admintools_storage` WHERE `key` = 'cparams'
SELECT * FROM `p3sae_admintools_ipautoban` WHERE `ip` = '18.218.184.214'
SELECT `source`,`keepurlparams` FROM `p3sae_admintools_redirects` WHERE ((`dest` = 'index.php/newsletter-content/entry/data-recovery-is-an-important-part-of-the-backup-process') OR (`dest` = 'index.php/newsletter-content/entry/data-recovery-is-an-important-part-of-the-backup-process') OR ('index.php/newsletter-content/entry/data-recovery-is-an-important-part-of-the-backup-process' LIKE `dest`)) AND `published` = '1' ORDER BY `ordering` DESC LIMIT 0, 1
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM p3sae_menu AS m LEFT JOIN p3sae_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT * FROM p3sae_easyblog_configs WHERE `name` = 'config'
SELECT * FROM `p3sae_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC
SELECT * FROM `p3sae_easyblog_acl_group` WHERE `content_id`='1' AND `type`=' group'
SELECT `id` FROM `p3sae_easyblog_post` WHERE `permalink`='data:recovery-is-an-important-part-of-the-backup-process'
SELECT `id` FROM `p3sae_easyblog_post` WHERE `permalink`='data-recovery-is-an-important-part-of-the-backup-process'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '898'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '7828'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='898'
SELECT extension_id AS id, element AS "option", params, enabled FROM p3sae_extensions WHERE `type` = 'component' AND `element` = 'com_rereplacer'
SELECT extension_id AS id, element AS "option", params, enabled FROM p3sae_extensions WHERE `type` = 'component' AND `element` = 'com_easyblog'
SELECT * FROM p3sae_languages WHERE published=1 ORDER BY ordering ASC
SELECT id, home, template, s.params FROM p3sae_template_styles as s LEFT JOIN p3sae_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
DELETE FROM `p3sae_easyblog_mailq` WHERE `status`='1' AND DATEDIFF(NOW(), `created`) >='7'
SELECT `id` FROM `p3sae_easyblog_mailq` WHERE `status`='0' ORDER BY `created` ASC LIMIT 5
SELECT * FROM `p3sae_easyblog_post` WHERE `publish_up`<='2024-04-25 11:29:37' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 5
SELECT id, created_by FROM`p3sae_easyblog_post` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2024-04-25 11:29:37' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'
SELECT * FROM `p3sae_easyblog_uploader_tmp` WHERE `created` <= DATE_SUB('2024-04-25 11:29:37' , INTERVAL 120 MINUTE)
delete a, b from `p3sae_easyblog_post` as a inner join `p3sae_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2024-04-25 11:29:37', INTERVAL 3 DAY)
SELECT * FROM `p3sae_menu` WHERE `published`='1' AND `link` LIKE 'index.php?option=com_easyblog%'
SELECT a.rules FROM p3sae_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
SHOW FULL COLUMNS FROM `p3sae_assets`
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT b.rules FROM p3sae_assets AS a LEFT JOIN p3sae_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.id = 1) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
SELECT * FROM p3sae_easyblog_post WHERE `id` = '898'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '7828'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='898'
SELECT COUNT(1) as `voted`, `uid` FROM `p3sae_easyblog_ratings` WHERE `uid` = '898' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = '39f43e12ba22b10f1c6de0015c48c353' OR `ip` = '18.218.184.214') GROUP BY `uid` ORDER BY NULL
SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `p3sae_easyblog_ratings` AS a WHERE a.`uid` IN(898) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `p3sae_easyblog_comment` AS a WHERE a.`post_id` IN(898) AND a.`published`='1'
SELECT a.`post_id`, COUNT(1) AS `count` FROM `p3sae_easyblog_comment` AS a WHERE a.`post_id` IN(898) AND a.`published`='1' GROUP BY a.`post_id`
select a.*, b.`post_id`, b.`primary` from `p3sae_easyblog_category` as a inner join `p3sae_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN ( 898)
select a.*, b.`post_id` from `p3sae_easyblog_tag` as a inner join `p3sae_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN ( 898)
select a.* from `p3sae_easyblog_revisions` as a where a.`id` IN ( 7828)
select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` from `p3sae_users` as u left join `p3sae_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 295
SHOW FULL COLUMNS FROM `p3sae_users`
SELECT * FROM `p3sae_users` WHERE `id` = 295
SELECT `g`.`id`,`g`.`title` FROM `p3sae_usergroups` AS g INNER JOIN `p3sae_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 295
select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `p3sae_easyblog_category_fields_groups` as a inner join `p3sae_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `p3sae_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `p3sae_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `p3sae_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` where `p`.`post_id` = '898'
select * from `p3sae_easyblog_meta` where `content_id` in (898) and `type` = 'post'
SELECT * FROM p3sae_easyblog_meta WHERE `content_id` = '898' AND `type` = 'post'
SELECT r.* FROM p3sae_rereplacer AS r WHERE r.published = 1 AND (r.area = 'articles') ORDER BY r.ordering, r.id
UPDATE p3sae_easyblog_post SET `hits` = (`hits` + 1) WHERE id = '898'
SELECT COUNT(1) FROM `p3sae_easyblog_featured` WHERE `content_id`='898' AND `type`='post'
SELECT COUNT(1) FROM `p3sae_easyblog_comment` WHERE `post_id`='898' AND `published`='1'
SELECT `group_id` FROM `p3sae_easyblog_category_fields_groups` WHERE `category_id`='9'
SELECT a.* FROM `p3sae_easyblog_fields` AS a INNER JOIN `p3sae_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id` WHERE b.`category_id`='9' AND a.`state`='1' ORDER BY a.`created` DESC
SELECT `key`,`value` FROM `p3sae_easyblog_post_assets` WHERE `post_id`='898'
SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `p3sae_easyblog_post` AS a LEFT JOIN `p3sae_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post' WHERE a.`published`='1' AND a.`state`='0' AND a.`access` = '0' AND a.`created_by` = '295' AND (1 <= (select count(1) from `p3sae_easyblog_post_category` AS acp INNER JOIN `p3sae_easyblog_category` as cat on acp.`category_id` = cat.`id` where acp.`post_id` = a.`id` and ( ( cat.`private` = 0 ) OR ( (cat.`private` = 1) and (0 > 0) ) OR ( (cat.`private` = 2) and ( (select count(1) from `p3sae_easyblog_category_acl` as cacl where cacl.`category_id` = cat.id and cacl.`acl_id` = 1 and cacl.`content_id` in (1)) > 0 ) ) ) )) AND ( (a.`source_type` = 'easyblog.sitewide') ) ORDER BY a.`created` desc LIMIT 3
SELECT `id` FROM `p3sae_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=898%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=898%' ) AND `published`='1' AND (`language`='en-GB' OR `language`='' OR `language`='*') LIMIT 1
SELECT a.`id`, a.`title` FROM `p3sae_easyblog_post` AS `a` WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND a.`source_type`='easyblog.sitewide' AND a.`created` < '2018-05-14 12:30:15' ORDER BY a.`created` DESC LIMIT 1
SELECT a.`id`, a.`title` FROM `p3sae_easyblog_post` AS `a` WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND a.`source_type`='easyblog.sitewide' AND a.`created` > '2018-05-14 12:30:15' ORDER BY a.`created` ASC LIMIT 1
SELECT * FROM p3sae_easyblog_post WHERE `id` = '902'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '7922'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='902'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '897'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '7829'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='897'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '897'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '7829'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='897'
select `id` FROM `p3sae_easyblog_adsense` where user_id = '295'
SELECT * FROM p3sae_easyblog_adsense WHERE `id` = '2'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM p3sae_modules AS m LEFT JOIN p3sae_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN p3sae_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-25 11:29:37') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-25 11:29:37') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 156 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT `group_id` FROM `p3sae_user_usergroup_map` WHERE `user_id` = '295'
SELECT * FROM `p3sae_easyblog_acl_group` WHERE `content_id` IN (2, 3) AND `type`=' group'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '921'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '7886'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='921'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '925'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '8236'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='925'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '924'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '8237'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='924'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT COUNT(1) FROM (SELECT a.*, (count(b.id) - 1) AS `depth` FROM `p3sae_easyblog_comment` AS a INNER JOIN `p3sae_easyblog_comment` AS b LEFT JOIN `p3sae_users` AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '898' AND b.`post_id` = '898' AND a.`published` = 1 AND b.`published` = 1 AND a.`lft` BETWEEN b.`lft` AND b.`rgt` GROUP BY a.`id`) AS x
SELECT a.*, (count(b.id) - 1) AS `depth` FROM `p3sae_easyblog_comment` AS a INNER JOIN `p3sae_easyblog_comment` AS b LEFT JOIN `p3sae_users` AS c ON a.`created_by` = c.`id` WHERE a.`post_id` = '898' AND b.`post_id` = '898' AND a.`published` = 1 AND b.`published` = 1 AND a.`lft` BETWEEN b.`lft` AND b.`rgt` GROUP BY a.`id` ORDER BY a.`lft` asc LIMIT 0,20
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT * FROM p3sae_easyblog_post WHERE `id` = '898'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT id FROM p3sae_assets WHERE parent_id = 0
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT `template` FROM `p3sae_template_styles` WHERE `home`='1' AND `client_id`='0'
SELECT r.* FROM p3sae_rereplacer AS r WHERE r.published = 1 AND (r.area = 'component') ORDER BY r.ordering, r.id
SELECT r.* FROM p3sae_rereplacer AS r WHERE r.published = 1 AND (r.area = 'body') ORDER BY r.ordering, r.id
SELECT r.* FROM p3sae_rereplacer AS r WHERE r.published = 1 AND (r.area = 'everywhere') ORDER BY r.ordering, r.id
UPDATE `p3sae_session` SET `data` = 'joomla|s:1448:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzE0MDQ0NTc3O3M6NDoibGFzdCI7aToxNzE0MDQ0NTc3O3M6Mzoibm93IjtpOjE3MTQwNDQ1Nzc7fXM6NToidG9rZW4iO3M6MzI6ImRlNWVhN2E2YzMxYTg3YTI2ZjIyMzY5MWQ5OWNmMGM1Ijt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MzI6IjQyNjU0NzgxZGUwZWQyY2Q1ZTFlYWM1YzU1MWM0MTA0IjtpOjE7fXM6MTA6Il9fZWFzeWJsb2ciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoic2l0ZSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo4OiJtZXNzYWdlcyI7Tjt9fX19\";' , `time` = '1714044577' WHERE `session_id` = '39f43e12ba22b10f1c6de0015c48c353'

65 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

48 × SELECT `template` FROM `p3sae_template_styles`
19 × SELECT id FROM p3sae_assets
9 × SELECT * FROM p3sae_easyblog_post
8 × SELECT * FROM p3sae_easyblog_revisions
8 × SELECT * FROM `p3sae_easyblog_meta`
4 × SELECT r.* FROM p3sae_rereplacer AS r
4 × SELECT extension_id AS id, element AS "option", params, enabled FROM p3sae_extensions
2 × SELECT * FROM `p3sae_easyblog_acl_group`
2 × SELECT `id` FROM `p3sae_easyblog_post`
2 × SELECT a.`id`, a.`title` FROM `p3sae_easyblog_post` AS `a`
1 × SELECT * FROM p3sae_easyblog_meta
1 × SELECT a.*, (count(b.id) - 1) AS `depth` FROM `p3sae_easyblog_comment` AS a INNER JOIN `p3sae_easyblog_comment` AS b LEFT JOIN `p3sae_users` AS c ON a.`created_by` = c.`id`
1 × select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `p3sae_easyblog_category_fields_groups` as a inner join `p3sae_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `p3sae_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `p3sae_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `p3sae_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id`
1 × select * from `p3sae_easyblog_meta`
1 × SELECT `g`.`id`,`g`.`title` FROM `p3sae_usergroups` AS g INNER JOIN `p3sae_user_usergroup_map` AS m ON m.group_id = g.id
1 × select a.*, b.`post_id` from `p3sae_easyblog_tag` as a inner join `p3sae_easyblog_post_tag` as b on a.`id` = b.`tag_id`
1 × select a.* from `p3sae_easyblog_revisions` as a
1 × select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css` from `p3sae_users` as u left join `p3sae_easyblog_users` as e ON u.`id` = e.`id`
1 × SELECT * FROM `p3sae_users`
1 × SELECT COUNT(1) FROM `p3sae_easyblog_featured`
1 × SELECT a.* FROM `p3sae_easyblog_fields` AS a INNER JOIN `p3sae_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id`
1 × SELECT SQL_CALC_FOUND_ROWS a.`id` AS key1, a.*, ifnull(f.`id`, 0) as `featured` FROM `p3sae_easyblog_post` AS a LEFT JOIN `p3sae_easyblog_featured` AS f ON a.`id` = f.`content_id` AND f.`type` = 'post'
1 × SELECT `id` FROM `p3sae_menu`
1 × select `id` FROM `p3sae_easyblog_adsense`
1 × SELECT * FROM p3sae_easyblog_adsense
1 × SELECT `key`,`value` FROM `p3sae_easyblog_post_assets`
1 × select a.*, b.`post_id`, b.`primary` from `p3sae_easyblog_category` as a inner join `p3sae_easyblog_post_category` as b on a.`id` = b.`category_id`
1 × SELECT `group_id` FROM `p3sae_easyblog_category_fields_groups`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM p3sae_modules AS m LEFT JOIN p3sae_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN p3sae_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT COUNT(1) FROM (SELECT a.*, (count(b.id) - 1) AS `depth` FROM `p3sae_easyblog_comment` AS a INNER JOIN `p3sae_easyblog_comment` AS b LEFT JOIN `p3sae_users` AS c ON a.`created_by` = c.`id`
1 × SELECT `group_id` FROM `p3sae_user_usergroup_map`
1 × SELECT COUNT(1) FROM `p3sae_easyblog_comment`
1 × SELECT COUNT(1) as `voted`, `uid` FROM `p3sae_easyblog_ratings`
1 × SELECT `source`,`keepurlparams` FROM `p3sae_admintools_redirects`
1 × SELECT * FROM `p3sae_admintools_ipautoban`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM p3sae_menu AS m LEFT JOIN p3sae_extensions AS e ON m.component_id = e.extension_id
1 × SELECT * FROM p3sae_easyblog_configs
1 × SELECT * FROM `p3sae_easyblog_acl`
1 × SELECT `value` FROM `p3sae_admintools_storage`
1 × SELECT `query` FROM `p3sae_admintools_wafexceptions`
1 × SELECT `session_id` FROM `p3sae_session`
1 × SELECT b.id FROM p3sae_usergroups AS a LEFT JOIN p3sae_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `p3sae_viewlevels
1 × SELECT folder AS type, element AS name, params FROM p3sae_extensions
1 × SELECT * FROM p3sae_languages
1 × SELECT id, home, template, s.params FROM p3sae_template_styles as s LEFT JOIN p3sae_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT b.rules FROM p3sae_assets AS a LEFT JOIN p3sae_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `data` FROM `p3sae_session`
1 × SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `p3sae_easyblog_ratings` AS a
1 × SELECT a.* FROM `p3sae_easyblog_comment` AS a
1 × SELECT a.rules FROM p3sae_assets AS a
1 × SELECT * FROM `p3sae_menu`
1 × SELECT `id` FROM `p3sae_easyblog_mailq`
1 × SELECT * FROM `p3sae_easyblog_post`
1 × SELECT id, created_by FROM`p3sae_easyblog_post`
1 × SELECT * FROM `p3sae_easyblog_uploader_tmp`
1 × SELECT a.`post_id`, COUNT(1) AS `count` FROM `p3sae_easyblog_comment` AS a

OTHER Tables:

1 × SHOW FULL COLUMNS FROM `p3sae_users
1 × UPDATE p3sae_easyblog_post SET `hits` = (`hits` + 1)
1 × UPDATE `p3sae_session` SET `data` = 'joomla|s:1448:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzE0MDQ0NTc3O3M6NDoibGFzdCI7aToxNzE0MDQ0NTc3O3M6Mzoibm93IjtpOjE3MTQwNDQ1Nzc7fXM6NToidG9rZW4iO3M6MzI6ImRlNWVhN2E2YzMxYTg3YTI2ZjIyMzY5MWQ5OWNmMGM1Ijt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MzI6IjQyNjU0NzgxZGUwZWQyY2Q1ZTFlYWM1YzU1MWM0MTA0IjtpOjE7fXM6MTA6Il9fZWFzeWJsb2ciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoic2l0ZSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo4OiJtZXNzYWdlcyI7Tjt9fX19\";' , `time` = '1714044577'
1 × SHOW FULL COLUMNS FROM `p3sae_assets
1 × delete a, b from `p3sae_easyblog_post` as a inner join `p3sae_easyblog_revisions` as b on a.`id` = b.`post_id`
1 × INSERT INTO `p3sae_session` (`session_id`, `client_id`, `time`) VALUES ('39f43e12ba22b10f1c6de0015c48c353', 0, '1714044577'
1 × DELETE FROM `p3sae_easyblog_mailq`
1 × DELETE FROM `p3sae_session`

Infradapt Blog

Data Recovery Is an Important Part of the Backup Process

About the author

John Reilly

Author's recent posts

Comments

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

161 Queries Logged

65 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: