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]
