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 <[EMAIL PROTECTED]> 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 > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > 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 --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php