PDA

View Full Version : newbie backup question


yosemite
13th of June 2006 (Tue), 12:35
after the recent attack i have been taken backing up my site more serious. i back up the whole site through cpanel, i back up all apps and db after any changes.

while working with ee i have noticed that in /public_html/gal/input/backup/ee_backup_files/ there are the bu sql files for my site.

are these the files listed in the bu utility in ee?

and if i ever have to do a restore and by db is corrupted and i cant upload files larger than 2 megs in myphp can i upload the mysql files to this folder and will ee see them and be able to restore from them?

does anybody know if the full site bu created in cpanel will restore the whole and databases?

thank you for your help.

cf

Pekka
13th of June 2006 (Tue), 13:30
Files created by EE Backup are in form "databasename_date@time.sql", like

exhibit_engine_2_2006-04-19@18_58_59.sql

If there are files in ee_backup_files directory that you do not know what they are (i.e. they are not created by you making a backup) then delete them.

You can upload and download EE Backup files with normal ftp if you run into server limits.

A full EE backup is done with

1. Full SQL backup (i.e. dump) of EE database (all ee_xxx tables), using EE Backup, phpMyAdmin, Plesk, Ensim, Cpanel, mysqldump or any other tool that can make SQL dumps. If EE is in its own database, mysqlhotcopy is by far the fastest way to backup (only worthwhile to set up if you have very large databases).

2. Backup all photo folders (big sizes, thumbs and microthumbs) with all photos. Backup also UPLOAD folder if there is stuff you need.

3. Download everything to your home machine. If backups are on server disk and the disk fails, there is no way to get them back. You have to distribute backups to different physical locations.

yosemite
13th of June 2006 (Tue), 13:35
thank you, yes the sql files are mine.