MySQL Data-Backups

[perlone]

I'm a perl programmer and using DBI to connect to MySQL.
What is the best way to backup a MySQL database? (on Linux) ----------------------------------------
There is no Knowledge, That is not power.

Yes, i'm a MySQL Newbie.
-Aaron
----------------------------------------

 

[anjin]

Several ways.

You can copy the database or individual tables to another named yourname-backup or whatever. This is the easiest.

You can do a dump into an sql series of statements - see mysqldump

You can extract the data into a text file and load it in later. Select INTO OUTFILE is what you want to search for.