Re: How to Archive and restore the data in MySQL database.
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.
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.
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.
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.
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.
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