Mysqldump syntax error
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.
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Right, in case someone is wondering, I figured this out. Mysqldump is standalone and shouldn't be runing inside mysql.
Originally Posted by renesis
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)