Mysql database - Backing up problems.

[chop45]

Well I setup another domain on my account to move a forum to. Seems when I try to restore the backed up Database, it looses all the post and membership data. Some reason the back up fails to retrieve this data during backup. I did the backup through the Backup panal in Cpanal. Tried it through phpmysql panel and receive SQL errors during backup. The database is now at 10 megs and I have done this before without problems but the database was only around 5 or six megs. Is there a limit on database size that will be backed up and why is the data being dropped during backup?

Now if there is a limit how would you move or backup large databases????

[Rick G]

You should use SSH to backup. I believe you have to create a ticket and REQUST SSH access an/or Fax a copy of your drvers license etc. Call and ask if that is still true
Then get an SSH client such as the freee "Putty"

Then you login via putty as you would CPANEL then to backup use this command

mysqldump --opt -Q -u username1_username1 -p username1_mydatabase > /home/username/backups/07-29-06-mydatabase.sql

Replace "username" with your login name and make sure the path is correct for you - I have a "\backups" directory above public_html and I add the date in front of "mydatabase". Tweak it to your settings and preferences

To Restore:

mysql -u username1_username1 -p username1_mydatabase < /home/username1/backups//backupname.sql

A good idea is to immediately restore this backup to another database, close your site, change the database login stuf in config.php and go to your site, making sure it was a good backup (then switch and empty the test database to save space on you account)