Announcement

**glennrocksvb** · 02-26-2017, 04:05 PM

Hi willie53! Welcome to the forums. You rock!

**willie53** · 03-03-2017, 08:45 PM

I thought i would recreate a situation that happened to me a couple of weeks ago and how i solved it.
I got into the habit a few years ago of backing up my database atleast once a night sometimes twice depending how busy it got but in the situation that happened i was going to add a php module to my forums and was not sure how or if it would work so i backed up the database about 2 minutes before adding the module video demo of how i got my site up and running again within less than 30 seconds when the module i was going to use went all wrong.

The video demo may not be as professional as some out there but the method i used worked for me the demo can be found
here

**glennrocksvb** · 03-03-2017, 09:57 PM

Thanks for sharing the video. But in that particular scenario, if a PHP module (or HTML module or Ad module for that matter) breaks the site, you don't have to restore the database from a backup. You just have to temporarily disable rendering of PHP/HTML/Ad module. You do that in AdminCP > Settings > Options > General Settings > Disable PHP, Static HTML, and Ad Module rendering > Yes.

And to avoid breaking the site caused by invalid PHP/HTML/Ad module, here are the following rules:

Do not include PHP open and close tags <?php and ?> (for PHP module only)
Do not include <html>, <head> and <body> tags in the module. The module has to output the main content only (the ones inside the body tags) without those tags which the site already has. Having duplicate tags will break the layout of the page.
Make sure the module outputs valid HTML markup. Having unclosed tags (e.g. <div> without </div> tag) may break the layout of the page.

**William** · 03-03-2017, 10:34 PM

Originally posted by willie53 View Post

I got into the habit a few years ago of backing up my database atleast once a night sometimes twice depending how busy it got but in the situation that happened i was going to add a php module to my forums and was not sure how or if it would work so i backed up the database about 2 minutes before adding the module video demo of how i got my site up and running again within less than 30 seconds when the module i was going to use went all wrong.

Hi Willie,

Like you I backup my database before doing an update or doing something in depth.

For regular backups though, I made a Cron job that auto backups my website throughout the day and night. Right now I have it set to backup every six hours and only keep 7 days worth of backups on file (so as to not take a horrendous amount of space). Thought you may want to take a peek. I'm sure someone more savvy than I could probably help you custom tailor the code to your server's needs in case the code does not work. It took me awhile to put this script together which were found scattered across the web

The MySQL Dump Code for Cron

Enjoy,
William

**glennrocksvb** · 03-03-2017, 11:29 PM

In my case, I use automysqlbackup script. It can create daily, weekly or monthly backups. And you can do backup rotation to only keep x number of backup files. It can also send email notification when a backup is done.

How to do Painless MySQL Server Backups with AutoMySQLBackup - Linux.com

https://www.linux.com/learn/how-do-painless-mysql-server-backups-automysqlbackup

AutoMySQLBackup is a clever script that takes the pain out of setting up automated incremental daily, weekly, and monthly backups of MySQL databases. Its only dependency is the mysqldumpcommand, which comes with mysql-client. AutoMySQLBackup dumps your databases at whatever intervals you desire, and rolls them up into compressed tarballs. Then you can copy the tarballs to other …

**willie53** · 03-03-2017, 11:46 PM

Thanks for the replies guys glennrocksvb you learn something new every day what i was really trying to do was get a live rss feed to display the latest virus threats from sophos i did have it working using java but the ssl cert would not display it saw it as a threat hence the php module will try it your way later after a little sleep.

William i do have a cron job set up to run once a day i do a manual one every time i make changes to any of the files like upgrading as i always update to the latest version even in alpha release
Regards
Willie

Announcement

Hello all

Hello all

Comment

Comment

Comment

Comment

Comment

Comment

Users Viewing This Page

Latest Posts