Hello Joe, mysqldump is a seperate programto be execute at the system prompt.
Therefore it is not to be run under the mysql prompt. Bernard On Friday 26 March 2004 06:09, joe collins 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> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]