Hi,
I need to back up tables and possibly data inside a mysql database on a Unix server running MySQL.
Unfortunally I don't have any telnet access but I can only send commands trought php scripts.
I have tried something like:
$action=mysql_db_query("db_name","SELECT * INTO OUTFILE 'path/filename.txt' FROM table_name", $db);
but does nothing :-(
So I made a "Select * ..." from each table and I have saved tables content in files but it is not very usefull to import in new tables in the new server...
How could I do ?
Thank you
I need to back up tables and possibly data inside a mysql database on a Unix server running MySQL.
Unfortunally I don't have any telnet access but I can only send commands trought php scripts.
I have tried something like:
$action=mysql_db_query("db_name","SELECT * INTO OUTFILE 'path/filename.txt' FROM table_name", $db);
but does nothing :-(
So I made a "Select * ..." from each table and I have saved tables content in files but it is not very usefull to import in new tables in the new server...
How could I do ?
Thank you