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
