I was wondering what I miss out below in mysqldump syntax
mysql> mysqldump -u root -p dbaseName >file.sql;
mysql> mysqldump -u root dbaseName >file.sql;
I connect as "root" and tehre is no password.
In both cases I get errors.
mysqldump is standalone application,
so go C:\Program Files\MySQL\MySQL Server 5.0\bin folder
copy the path
past in command prompt
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -uroot -p directorymaps >a.sql
now it will work, i am sure
Open the Command Line utility by Clicking on 'Start' and 'Run' and typing 'CMD' and pressing 'ok'
Type -u and your username '-uusername'
Type -p and your password '-ppassword'
Type your database name 'mydatabase'
Type a greater-than sign to put the results in to a file '>'
Type the name of the file to put the results in 'mybackupfile.sql