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

2003-02-10 Thread 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 o

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

2003-02-10 Thread B. van Ouwerkerk
Perhaps you can search the manual before you send a question to this (or any other) list. You really should since several ppl spend time to create and keep it up to date. The manual is here: http://www.mysql.com/doc/en/index.html If you launch a search for the word backup you will find: http://ww

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

2003-02-10 Thread olinux
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-

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

2003-02-10 Thread Dan Nelson
In the last episode (Feb 06), Prasad Budim Ram said: > Hi, > Can any of you give me links about Archiving and restoring the data in > MySQL database. Are there any utilities for the same? http://www.mysql.com/doc/en/Backup.html -- Dan Nelson [EMAIL PROTECTED] --

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

2003-02-10 Thread mysql-list-bot
"Prasad Budim Ram" <[EMAIL PROTECTED]>, Do you think the following links may help? * http://www.mysql.com/doc/en/Asking_questions.html * http://www.mysql.com/doc/en/RESTORE_TABLE.html * http://www.mysql.com/doc/en/Miscellaneous_functions.html * http://www.mysql.com