Re: How to Archive and restore the data in MySQL database.

[Stefan Hinz]

Prasad,

>  Can any of you give me links about Archiving and restoring the data in
> MySQL database. Are there any utilities for the same?

You can use mysqldump in several ways to backup data, and mysqlimport
or mysql (the command line tool) to import data backuped with
mysqldump. There are many other solutions, and I can't tell which one
is best for your specific needs, so you might want to read the
appropriate manual section:

http://www.mysql.com/doc/en/Backup.html

Regards,
--
  Stefan Hinz <hinz@stripped>
  iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: [phone]  Fax: [phone]