From time to time I release updates, since we don’t have a formal QA crowd, sometimes something might go wrong. No matter how much it’s tested.
I have written a script that will manage your backup and restore procedure. IT BACKS UP YOUR DATABASE AND YOUR WEBSITE … This is how you use it. Make sure you have the latest install files. You can do this by creating a new folder or deleting the contents of your old install folder and getting the new base setup install files. The backup program stores the backup in it’s own folder off your root (/jayfish-backup). You can run the “backup” command when even you like and it will create a current backup of your site.
Create an install folder, change to the install folder then run …
Now that you have the install folder, run a backup by simply typing in …
sudo sh backup.sh
And to restore when ever you want …
sudo sh restore.sh
Here’s how to back up and restore your database MANUALLY if you wanted to.
Below the command mysqldump, will export the database jayfish to >filename.sql
If you wanted it to BACKUP to a specific folder then you would to the following >/backupfolder/filename.sql
mysqldump -u root -p jayfish >jayfish.sql
mysql -u root -p jayfish <jayfish.sql
If you wanted it to RESTORE to a specific folder then you would to the following </backupfolder/filename.sql