mySQL Problems???

[dyear20]

hey i been taking backups from admincp of vbulletin and noticed that they where incomplete backups so i started taking from cpanel and they seems fine but my most recent ones are not downloading fully like it times out or something and act as its completed how can i get this sorted out?

dyear20 Reviewed by dyear20 on 21st Mar 2010. mySQL Problems??? hey i been taking backups from admincp of vbulletin and noticed that they where incomplete backups so i started taking from cpanel and they seems fine but my most recent ones are not downloading fully like it times out or something and act as its completed how can i get this sorted out? Rating: 5

[Royal King]

Use MySQLDumper

[DeLeTeD]

try to back up from phpmyadmin. Not sure if it works. Ive used it's functions before and it worked.

[Lock Down]

Create a new folder in your system on the same level as public_html so no one else can access it. Something like /home/yourname/backups . Make it writable.

Now use cron jobs and run this command once a day(or more if you want).

mysqldump --opt -u username -p password dbname | gzip > /home/yourname/backups/dbbackup1.gz

If you run twice a day use separate cron jobs and change the output to 2 instead of 1.
Now you can use your ftp program to download it.

[dyear20]

try to back up from phpmyadmin. Not sure if it works. Ive used it's functions before and it worked.

i did that and its incomplete it stopped at p and even the host backup incomplete like it stops at 1gb