Help to back up a MySQL database!

admin

Administrator
Staff member
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
 
Back
Top