Backup Problem

--0-1867237262-1131859435=:70506
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hello,

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.

Prashant


Prashant Mamtora
www.indies.co.in

Prashant@indies.co.in
+91 9879807819
+91 278 2511579






---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
--0-1867237262-1131859435=:70506--

Re: Backup Problem

--On Saturday, November 12, 2005 9:23 PM -0800 Prashant Mamtora
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@m.gmane.org