Re: Backup Problem

--On Saturday, November 12, 2005 9:23 PM -0800 Prashant Mamtora 
<prashant_indies@xxxxxxxxx> wrote:

> I am new to MySQL. I want to know that how to take backup of data stored
> in any database of MySQL. for example my data is in one pc and i want to
> transfer it to other pc or want to take it on CD. how can i do it? also
> specify how to restore backup data. for example from cd to pc again.

Here's what I use:

DATE=`date +"%Y%m%d%H%M%S"`
mysqldump --user=username --password=secret --opt --all-databases \
   > mysql-dump-${DATE}.sql
bzip2 mysql-dump-${DATE}.sql


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx