Kloxo backup error

[rocketo panchi]

Guys whenever I try to perform a back up I always encounter this error
"Last Backup Status: failed_due_to__could_not_create_mysql_dump__nname_ _wdps1_"
So how do I fix this?

rocketo panchi Reviewed by rocketo panchi on 21st Jul 2011. Kloxo backup error Guys whenever I try to perform a back up I always encounter this error "Last Backup Status: failed_due_to__could_not_create_mysql_dump__nname__wdps1_" So how do I fix this? Rating: 5

[masterb56]

How about try to create a mysql dump manually?

[bxflow]

do a backup thru SSH...

[AQH-Michael]

Try this command:
mysql -u database_username -p database_name < /home/folder/file.sql

Whenever you input the command it will ask you for the database password. Input that.

[Lock Down]

That will overwrite his database .. Not Back it up.....

This will back it up and gzip it:

mysqldump -u YourDB -pYOURPW | gzip -9 > YourDB.sql.gz

[kris]

You can take complete backup from SSH using

/script/backup --class=client --name=clientname

replace 'clientname' with original clientname.

clientname 'admin' will take all items under admin user. including all users/websites created by user.

Regards

[what4]

I have had the same problem what I did to fix it was go to the db wdps1 and optimize and repair. There is an error in one of the tables.