SQL DB backup error !
Posted by htw_Mehdi, 09-14-2007, 09:28 PM hello, when i try to backup mysql database on the dbname.sql i got : no DB tables or any thing ! i have this problem also when i generate a full backup ! please help
Posted by boonchuan, 09-14-2007, 09:34 PM This is better in the Technical Forum. Moved.
Posted by Patrick, 09-14-2007, 09:59 PM Have you tried manually exporting the database? mysqldump -u mysql_user -p --opt database > backup.sql
Posted by htw_Mehdi, 09-14-2007, 10:13 PM hello, thank you for you reply, but i have a question ! where did i execute this command ? ( don't have ssh access ) thank's
Posted by Patrick, 09-14-2007, 10:19 PM You could create a PHP script with the following content: Put that on your website and replace everything in bold, then access the PHP file and it should execute the mysqldump command.
Posted by htw_Mehdi, 09-14-2007, 10:33 PM not working or there are some error !
Posted by david510, 09-16-2007, 03:43 AM Check if there is any syntax error in the php code on your account. The code given by Pat should work fine.
Posted by htw_Mehdi, 09-16-2007, 03:47 AM hi, i have resolved the problem by using a php script for database export thank you