I had a hosting account with godaddy and it got compromised by someone who had access to a scanned image of my drivers license. Godaddy would not do anything to help me. Someone stole my identity and they said "It is your responsibility to keep up with your own information". So I had to create a new account and cancel the old one, but I can not access the database through phpmyadmin. The dynamic webpages still connect to the old hostname and pull information. I have tried using mysql_dump, and it seems that they block access to it. Through different boards, I have come up with the following code to try and export, or back up all of the tables. It doesn't work, someone please help!
$hostname = "db.hostedresource.com";
$database = "db_name";
$username = "db_name";
$password = "password";
$conn = mysql_connect($hostname, $username, $password);
if (!$conn){
die('Could Not Connect: '.mysql_error());
}
echo 'Connected Successfully';
mysql_select_db($database);
$backupFile = 'file.sql';
$table = 'table';
$query = ("SELECT * INTO OUTFILE '$backupFile' FROM $table");
$result = mysql_query($query);
mysql_close($conn
)
I get a connected successfully, but no output file.