sql backup problem

[clarksta]

i have a few diffrent sites on my server i can a full sql backup from phpmyadmin no problem.
now when i try to get a sql backup from share4life it dls 2.6mb then fails
oh thats gzipped if its zipped then it 987kb if its just the text file ill get the whole backup at around 80mb
does anyone have any idea why this would be?

some help here could go down well

clarksta Reviewed by clarksta on 4th Feb 2008. sql backup problem i have a few diffrent sites on my server i can a full sql backup from phpmyadmin no problem. now when i try to get a sql backup from share4life it dls 2.6mb then fails oh thats gzipped if its zipped then it 987kb if its just the text file ill get the whole backup at around 80mb does anyone have any idea why this would be? some help here could go down well:) Rating: 5

[Lease]

Have you got ssh access?

[clarksta]

yes i have
ive been talking with a friend and he thinks its a gunzip problem and that there are some commands that need running to fix it
my self have no idea

[Lease]

I find backing up or restoring from phpmyadmin is the worst possible way.
1. It's slow as hell.
2. The connection somtimes times out, making you have to restart the whole process again.

Try using these commands.. they have never failed in the past for me

Backup your database:
mysqldump --opt -Q -u dbusername -p databasename > /path/to/backup.sql

If you need to zip it up, use this command to tar and gzip up your folder or file:
tar -zcvf newfilename.tar.gz /path/to/fileordirectory/to/compress

Hope no errors will popup

[clarksta]

thank you lease i will give this a go and let you know how i get on

[Lease]

Np, just remember to change directories bfore zipping it up, or the .gz file will end up in some other folder

[Prince]

Well phpmyadmin is very annoying to retore big databases 10MB and higher.

Try to used MySQLDumper

http://www.mysqldumper.de/en/

It is script used to backup and restore the database, it make things go easier.