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

6 Data Backup Best Practices Your Business Continuity Plan Needs

Monday, 15 May 2017

John Reilly

Newsletter

0 Comment

The future of any organization is only as good as its business continuity plan. This is a well thought out plan that instructs a company of what to do in the face of a disaster, so they can return to normal operations as quickly as possible. One key part of every business continuity plan that should never be overlooked: the backing up and recovery of your data.

After all, there are many aspects of your business that can be replaced should it be destroyed or lost in a disaster, such as office furniture, computer equipment, and even the office building itself. Although, your company’s data is unique, which makes it irreplaceable. Therefore, we want to share with you six best practices when it comes to backing up your data so that your business will be fully prepared to overcome any potential disaster.

How many of these best practices are you already doing? Which ones can you incorporate into your current IT setup? Read on to find out!

Backup to the Cloud
There are a variety of ways to back up your company’s data, but the best way is to utilize a cloud-based BDR system. In addition to giving you anytime/anywhere access to your data, storing your backed-up data in the cloud assures that it will survive AND be accessible, should something devastating happen to your physical office building--a case that can’t be made with traditional tape backup.

Take Multiple Backups
Another disadvantage of tape backup is that it’s generally used to only take one backup per day, which means you could potentially lose an entire day’s worth of work in the event of a disaster. Alternatively, a solution like BDR takes backup copies of your data every fifteen minutes, and it’s a process that’s done automatically, meaning that you or your staff don’t have to waste time swapping out tapes.

Store Backups in Different Locations
Another advantage of a cloud-based backup system like BDR is that multiple copies of your data are stored across several physical locations. After all, what’s the point of backing up your data to protect your business if one or even two locations where your data was housed ends up becoming devastated by a disaster? This is a serious shortcoming of tape backup that should give every business owner pause.

Have a Quick Recovery Time Objective
After a disaster, it’s ideal for your business continuity plan to include ways to get operations up and running again as quickly as possible. This is especially the case when it comes to accessing your company’s data, seeing as the average modern business can accomplish very little without it. Therefore, you’re going to want to take advantage of BDR’s data recovery feature, which allows the BDR device itself to act as a temporary server, should something happen to your IT infrastructure. Essentially, this feature allows the quickest recovery time objective possible for your business.

Have a Maximum Recovery Point Objective
Another important factor of data recover is the recovery point objective. This is where you set a goal for how much data you wish to be recovered post-disaster. Of course, you’ll want to recover as much data as possible, and working with an IT professional to incorporate this into your business continuity plan is how this is achieved, and it’s another backup best practice that BDR is designed for.

Plan to Protect Your Data From All the Risks
Seeing how even a small amount of data loss can negatively affect your bottom line, you’ll want to take extra precautions to ensure that, no matter what happens, your company will retain as much of its data as possible. This means planning for every conceivable scenario. Infradapt can have this conversation with you to help you make sure that your business continuity plan covers every angle possible.

For assistance with any and all of your data backup needs, call us today at 800.394.2301.

Tags:

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

164 Queries Logged

SELECT `data` FROM `p3sae_session` WHERE `session_id` = 'de60019bab18cbb7bc57752bc275bf8d'
DELETE FROM `p3sae_session` WHERE `time` < '1713568291'
SELECT `session_id` FROM `p3sae_session` WHERE `session_id` = 'de60019bab18cbb7bc57752bc275bf8d' LIMIT 0, 1
INSERT INTO `p3sae_session` (`session_id`, `client_id`, `time`) VALUES ('de60019bab18cbb7bc57752bc275bf8d', 0, '1713577291')
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.191.240.243'
SELECT `source`,`keepurlparams` FROM `p3sae_admintools_redirects` WHERE ((`dest` = 'index.php/newsletter-content/entry/6-data-backup-best-practices-your-business-continuity-plan-needs') OR (`dest` = 'index.php/newsletter-content/entry/6-data-backup-best-practices-your-business-continuity-plan-needs') OR ('index.php/newsletter-content/entry/6-data-backup-best-practices-your-business-continuity-plan-needs' 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`='6:data-backup-best-practices-your-business-continuity-plan-needs'
SELECT `id` FROM `p3sae_easyblog_post` WHERE `permalink`='6-data-backup-best-practices-your-business-continuity-plan-needs'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '680'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '982'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='680'
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-20 01:41:31' 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-20 01:41:31' 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-20 01:41:31' , 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-20 01:41:31', 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` = '680'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '982'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='680'
SELECT COUNT(1) as `voted`, `uid` FROM `p3sae_easyblog_ratings` WHERE `uid` = '680' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = 'de60019bab18cbb7bc57752bc275bf8d' OR `ip` = '18.191.240.243') 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(680) AND `type`='entry' GROUP BY `uid` ORDER BY NULL
SELECT a.* FROM `p3sae_easyblog_comment` AS a WHERE a.`post_id` IN(680) AND a.`published`='1'
SELECT a.`post_id`, COUNT(1) AS `count` FROM `p3sae_easyblog_comment` AS a WHERE a.`post_id` IN(680) 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 ( 680)
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 ( 680)
select a.* from `p3sae_easyblog_revisions` as a where a.`id` IN ( 982)
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` = '680'
select * from `p3sae_easyblog_meta` where `content_id` in (680) and `type` = 'post'
SELECT * FROM p3sae_easyblog_meta WHERE `content_id` = '680' 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 = '680'
SELECT COUNT(1) FROM `p3sae_easyblog_featured` WHERE `content_id`='680' AND `type`='post'
SELECT COUNT(1) FROM `p3sae_easyblog_comment` WHERE `post_id`='680' 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`='680'
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=680%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=680%' ) 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` < '2017-05-15 04:00:59' 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` > '2017-05-15 04:00:59' ORDER BY a.`created` ASC LIMIT 1
SELECT * FROM p3sae_easyblog_post WHERE `id` = '686'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '8083'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='686'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '679'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '983'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='679'
SELECT * FROM p3sae_easyblog_post WHERE `id` = '679'
SELECT * FROM p3sae_easyblog_revisions WHERE `id` = '983'
SELECT * FROM `p3sae_easyblog_meta` WHERE `type`='post' AND `content_id`='679'
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-20 01:41:31') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 01:41:31') 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 * FROM p3sae_easyblog_tag WHERE `id` = '318'
SELECT * FROM p3sae_easyblog_tag WHERE `id` = '15'
SELECT * FROM p3sae_easyblog_tag WHERE `id` = '41'
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` = '680' AND b.`post_id` = '680' 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` = '680' AND b.`post_id` = '680' 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` = '680'
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:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzEzNTc3MjkxO3M6NDoibGFzdCI7aToxNzEzNTc3MjkxO3M6Mzoibm93IjtpOjE3MTM1NzcyOTE7fXM6NToidG9rZW4iO3M6MzI6Ijc3YjY3YTNjNDljOWI0YjczOWMwNGFlYThhNDk1MmEzIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MzI6IjQ0OTVkYzY4ZjE2OTEzNWVkNzYxNTRlOGRmNWYwNGZjIjtpOjE7fXM6MTA6Il9fZWFzeWJsb2ciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoic2l0ZSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo4OiJtZXNzYWdlcyI7Tjt9fX19\";' , `time` = '1713577291' WHERE `session_id` = 'de60019bab18cbb7bc57752bc275bf8d'

66 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
3 × SELECT * FROM p3sae_easyblog_tag
2 × SELECT a.`id`, a.`title` FROM `p3sae_easyblog_post` AS `a`
2 × SELECT `id` FROM `p3sae_easyblog_post`
2 × SELECT * FROM `p3sae_easyblog_acl_group`
1 × SELECT * FROM p3sae_easyblog_meta
1 × SELECT COUNT(1) FROM `p3sae_easyblog_featured`
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 * from `p3sae_easyblog_meta`
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 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 `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 COUNT(1) FROM `p3sae_easyblog_comment`
1 × SELECT `key`,`value` FROM `p3sae_easyblog_post_assets`
1 × SELECT `id` FROM `p3sae_menu`
1 × select `id` FROM `p3sae_easyblog_adsense`
1 × SELECT * FROM p3sae_easyblog_adsense
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 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 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_fields` AS a INNER JOIN `p3sae_easyblog_category_fields_groups` AS b ON a.`group_id`= b.`group_id`
1 × SELECT `group_id` FROM `p3sae_user_usergroup_map`
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_easyblog_category_fields_groups`
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 `data` FROM `p3sae_session`
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 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.`post_id`, COUNT(1) AS `count` 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.*, 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`

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:\"Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJfX2RlZmF1bHQiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjE7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNzEzNTc3MjkxO3M6NDoibGFzdCI7aToxNzEzNTc3MjkxO3M6Mzoibm93IjtpOjE3MTM1NzcyOTE7fXM6NToidG9rZW4iO3M6MzI6Ijc3YjY3YTNjNDljOWI0YjczOWMwNGFlYThhNDk1MmEzIjt9czo4OiJyZWdpc3RyeSI7Tzo5OiJKUmVnaXN0cnkiOjE6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6MDp7fX1zOjQ6InVzZXIiO086NToiSlVzZXIiOjI1OntzOjk6IgAqAGlzUm9vdCI7YjowO3M6MjoiaWQiO2k6MDtzOjQ6Im5hbWUiO047czo4OiJ1c2VybmFtZSI7TjtzOjU6ImVtYWlsIjtOO3M6ODoicGFzc3dvcmQiO047czoxNDoicGFzc3dvcmRfY2xlYXIiO3M6MDoiIjtzOjg6InVzZXJ0eXBlIjtOO3M6NToiYmxvY2siO047czo5OiJzZW5kRW1haWwiO2k6MDtzOjEyOiJyZWdpc3RlckRhdGUiO047czoxMzoibGFzdHZpc2l0RGF0ZSI7TjtzOjEwOiJhY3RpdmF0aW9uIjtOO3M6NjoicGFyYW1zIjtOO3M6NjoiZ3JvdXBzIjthOjA6e31zOjU6Imd1ZXN0IjtpOjE7czoxMzoibGFzdFJlc2V0VGltZSI7TjtzOjEwOiJyZXNldENvdW50IjtOO3M6MTA6IgAqAF9wYXJhbXMiO086OToiSlJlZ2lzdHJ5IjoxOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e319czoxNDoiACoAX2F1dGhHcm91cHMiO2E6MTp7aTowO2k6MTt9czoxNDoiACoAX2F1dGhMZXZlbHMiO2E6Mjp7aTowO2k6MTtpOjE7aToxO31zOjE1OiIAKgBfYXV0aEFjdGlvbnMiO047czoxMjoiACoAX2Vycm9yTXNnIjtOO3M6MTA6IgAqAF9lcnJvcnMiO2E6MDp7fXM6MzoiYWlkIjtpOjA7fXM6MzI6IjQ0OTVkYzY4ZjE2OTEzNWVkNzYxNTRlOGRmNWYwNGZjIjtpOjE7fXM6MTA6Il9fZWFzeWJsb2ciO086ODoic3RkQ2xhc3MiOjE6e3M6NDoic2l0ZSI7Tzo4OiJzdGRDbGFzcyI6MTp7czo4OiJtZXNzYWdlcyI7Tjt9fX19\";' , `time` = '1713577291'
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 ('de60019bab18cbb7bc57752bc275bf8d', 0, '1713577291'
1 × DELETE FROM `p3sae_easyblog_mailq`
1 × DELETE FROM `p3sae_session`

Infradapt Blog

6 Data Backup Best Practices Your Business Continuity Plan Needs

About the author

John Reilly

Author's recent posts

Comments

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries

164 Queries Logged

66 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: