//Connect To the Database with PHP and MySQL
// very important -p must be followed by the password, no spaces between
// $output, $return_val are not relevant to the execution of the script
$hostname="your host name";
$username="your user name";
$password="your password";
$dbname="your database name";
$filename='your name'.date('G_a_m_d_y').'.sql';
$command = "mysqldump --opt -h $hostname -u $username -p$password $dbname > $filename";
exec($command,$output,$return_val);
I want to share this phh script to dump the contents of a mysql database with the community. I hope it helps other users.
The current GoDaddy technical support team is only trained to SELL MORE PRODUCTS. In the recents weeks I called several times, only to be told that the company does not support helping customers with coding. The only thing I was asking was the correct syntax for a script that is published on their knowledge base.
The solution was very simple, -p followed by the password without spaces between. Yet either they did not know or did not want to share. In any case, they were not very friendly.
What a SHAME for a big public company like GoDaddy.
