"joe collins" <[EMAIL PROTECTED]> wrote:
> I have read the documentation on the MySQLDump, but have been unable to
> launch a mysql dump.
> Is the dump performed while logged on to the database that you want to
> dump, or do you log onto the machine where the database is and specify
> which database you want to dump?. I have looked at and applied some of the
> sample mysqldump commands given in the documentation, but all have resulted
> in syntax errors.
>
> See below
>
> Any advice or pointers would be greatly appreciated.
>
> many thanks for your patience
>
> Joe
>
> nuatech_1 is the name of my database
> nuatech is my password set up for the root user
> I want to dump it to a file called dump1.txt
> My database is set up on localhost
>
> Opted to use the database upon which I want to perform mysqldump:
>
> mysql> use nuatech_1
> Database changed
>
> Tried a mysqldump:
>
> mysql> mysqldump -u root -p nuatech nuatech_1 > dump1.txt;
> ERROR 1064: You have an error in your SQL syntax. Check the manual that
> corresp
> onds to your MySQL server version for the right syntax to use near
> 'mysqldump -u
> root -p nuatech nuatech_1 > dump.txt' at line 1
>
> Tried again removing spaces before parameters
>
> mysql> mysqldump -uroot -pnuatech nuatech_1 > dump1.txt;
>
> ERROR 1064: You have an error in your SQL syntax. Check the manual that
> corresp
> onds to your MySQL server version for the right syntax to use near
> 'mysqldump -u
> root -pnuatech nuatech_1 > dump1.txt' at line 1
>
> logged out of mysql:
>
> mysql> quit
> Bye
>
> Logged back in ( not to a particular database)
>
> C:\mysql\bin>mysql -u root -p mysql
> Enter password: ***
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 3 to server version: 4.0.18-max-debug
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
>
> Tried the mysqldump again:
>
> mysql> mysqldump -uroot -pnuatech nuatech_1 > dump1.txt;
>
> ERROR 1064: You have an error in your SQL syntax. Check the manual that
> corresp
> onds to your MySQL server version for the right syntax to use near
> 'mysqldump -u
> root -pnuatech nuatech_1 > dump1.txt' at line 1
>
> Tried again with spaces before the parameters:
> mysql> mysqldump -u root -p nuatech nuatech_1 > dump1.txt;
>
> ERROR 1064: You have an error in your SQL syntax. Check the manual that
> corresp
> onds to your MySQL server version for the right syntax to use near
> 'mysqldump -u
> root -p nuatech nuatech_1 > dump1.txt' at line 1
> mysql>
mysqdump is not a command of the mysql client. mysqldump is a separate program:
shell> mysqldump -uroot -pnuatech nuatech_1 > dump1.txt
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
