http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Backup
mysqldump is my preferred method
[snip]
The most normal use of mysqldumpis probably for making
a backup of whole databases. See section 4.4.1
Database Backups.
mysqldump --opt database > backup-file.sql
You can read this back into MySQL with:
mysql database < backup-file.sql
[/snip]
here's a recent thread that may help
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msp:129215:aflndljbbfiablpcodgj
olinux
--- Prasad Budim Ram <pram@stripped> wrote:
> Hi,
> Can any of you give me links about Archiving and
> restoring the data in
> MySQL database. Are there any utilities for the
> same?
> Thanks in advance,
> Ram
>
>
---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list
> archive)
>
> To request this thread, e-mail
> <mysql-thread131811@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-olnx=yahoo.com@stripped>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
