Super Simple 3-Step Backup Process - Or??
To backup my site, I:
1. use cPanel File manager to zip up the site folder;
2. download the zip file and store it locally
3. use phpMyadmin to export the sql tables to my local computer.
Should my site need to be restored, I'm expecting to:
4. blow away whatever's left of the site folder
5. upload and unzip the zip file
6. delete the tables from mysql
7. import the previously exported tables back into mysql.
Will this scheme work? I don't like using the backup wizards because I don't know exactly what they do.
You can get the database export to insert the table delete commands for you so that it will do that delete step automatically.
The backup process I use is to export the database using phpmyadmin. All of the other files originated in a corresponding folder on my own computer and so should any restore be needed I can just upload the files again from there. I have backup copies of my site running in web servers on two of my own computers. One serves as a complete copy of the current site and the other is where I am doing the work for the next lot of changes. When I backup the database from BlueHost I restore it to one of my own computers so I know that the restore works fine using the import option in phpmyadmin.