Re: RE: Backing up/Creating new database
PR, Monday, May 13, 2002, 8:28:20 PM, you wrote: P Thnaks . I tried several variation and they are giving me sql syntax P error: :) mysqldump is not an SQL command, it's a program for database backup. So, you should run it from DOS prompt, f.e. if MySQL is located in C:\mysql, it would be: C:\mysql\bin\mysqldump --no-data database_name C:\tmp1.sql P Mysqldump --no-data database XXX tmp.sql; P I also tried mysqldump --no-data database c:\tmp1.sql P What is the proper syntax? I also get message outfile disabled? As to your question about restoring database you should create database with CREATE DATABASE statement or with mysqladmin and then mysql your_database C:\tmp1.sql P Thanks P Paul -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Backing up/Creating new database
PR, Monday, May 13, 2002, 5:47:23 PM, you wrote: P I have database developed on my laptop. What is the quickest way to P backup the database and restore it on the server? Can I restore the P database as empty database? Howa bout creating SQL statements based on P the database structure? mysqldump utility. If you want to backup only the structure of your database you should use mysqldump with --no-data option, look at: http://www.mysql.com/doc/m/y/mysqldump.html P Thanks -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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: Backing up/Creating new database
The easiest way is simply to copy the files. Go to the directory that mysql was installed to. There should be a subdirectory called data. Under that should be a subdirectory named after your database. You can simply copy that entire subdirectory to a mysql server and the database will be copied over. Want to change the name of the database? Change the name of the subdirectory. -Rob -Original Message- From: PR [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 7:47 AM To: [EMAIL PROTECTED] Subject: Backing up/Creating new database Hi, I have database developed on my laptop. What is the quickest way to backup the database and restore it on the server? Can I restore the database as empty database? Howa bout creating SQL statements based on the database structure? Thanks - 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 - 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: Backing up/Creating new database
Thnaks . I tried several variation and they are giving me sql syntax error: Mysqldump --no-data database XXX tmp.sql; I also tried mysqldump --no-data database c:\tmp1.sql What is the proper syntax? I also get message outfile disabled? Thanks Paul -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 11:32 AM To: [EMAIL PROTECTED] Subject: Re: Backing up/Creating new database PR, Monday, May 13, 2002, 5:47:23 PM, you wrote: P I have database developed on my laptop. What is the quickest way to P backup the database and restore it on the server? Can I restore the P database as empty database? Howa bout creating SQL statements based on P the database structure? mysqldump utility. If you want to backup only the structure of your database you should use mysqldump with --no-data option, look at: http://www.mysql.com/doc/m/y/mysqldump.html P Thanks -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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 - 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