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/doc/en/CREATE_DATABASE.html
* http://www.mysql.com/doc/en/DROP_DATABASE.html

This was an automated response to your email 'How to Archive and restore the data in 
MySQL database.'.
Final search keyword used to query the manual was 'How to Archive  restore the data   
database.'.

Feedbacks, suggestions and complaints about me should be 
directed to [EMAIL PROTECTED]

-
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




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]

-
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




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-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




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://www.mysql.com/doc/en/Backup.html

Another relevant link for you:
http://www.tuxedo.org/~esr/faqs/smart-questions.html



B.


-Oorspronkelijk bericht-
Van: Prasad Budim Ram [mailto:[EMAIL PROTECTED]] 
Verzonden: vrijdag 7 februari 2003 7:31
Aan: [EMAIL PROTECTED]
Onderwerp: How to Archive and restore the data in MySQL database.


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




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 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 [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


-
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




How to Archive and restore the data in MySQL database.

2003-02-08 Thread Prasad Budim Ram
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