backup methods

[Anon]

I have a mysql database with about 7 tables in it that hold a lot of information. Some have over 1,000 rows and some have 50,000.

I need a way to back all this information up into a log file. This way I can back it up each day and store it on a few local computers incase of server failure.

Now, each table has a different amount of fields and rows.

I am running PHP and MySQL (version 3.23.38)

Can someone help or write the code out for me that will back up a table that I enter into the script. I don't want to set it up each time because it has a differen't amount of fields.

I just want script, that will back up any table into a text file.

Also, when it writes it into a text file, I would like it to be seperated by '|'

I guess you call it a vertical bar.

Thanks.

[Anon]

mysqldump --opt database > backup-file.sql

may help

Kai

[Anon]

Can you please give me some examples on how to use it, i'm familiar with MySQL but not with mysqldump

would this work?

Do I replace anything with --opt database?

mysql_query("mysqldump --opt database > /home/username/logs/backup-file.sql
");