sildmymnpsync
New Member
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? How about try to create a mysql dump manually? do a backup thru SSH... 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. 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 You can take complete backup from SSH using
Code: /script/backup --class=client --name=clientnamereplace 'clientname' with original clientname.
clientname 'admin' will take all items under admin user. including all users/websites created by user.
Regards 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.
"Last Backup Status: failed_due_to__could_not_create_mysql_dump__nname_ _wdps1_"
So how do I fix this? How about try to create a mysql dump manually? do a backup thru SSH... 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. 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 You can take complete backup from SSH using
Code: /script/backup --class=client --name=clientnamereplace 'clientname' with original clientname.
clientname 'admin' will take all items under admin user. including all users/websites created by user.
Regards 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.