Jump to content

Reg MySQL Backup in .txt file


esther

Recommended Posts

mysqldump [db_name] >backup.txt

 

will back up your entire database from the command line.

 

if you want to do it with a query, you can use

SELECT * INTO OUTFILE "/foo/backup.txt" FROM my_table

 

you can control how the fields are delimited etc.:

http://dev.mysql.com/doc/refman/4.1/en/select.html

 

cheers

-pnj

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.