mysql - Exporting database using cmdwing -
i trying export database using cmd encountered following error...
c:>cd program files
c:\program files>cd mysql
c:\program files\mysql>cd mysql server 5.1
c:\program files\mysql\mysql server 5.1>cd bin
c:\program files\mysql\mysql server 5.1\bin>mysqldump -u root -p root try > dump _file.sql access denied.
how can past this.
also tried following.....
how can export database using mysql command line client.tried following things didn't work.
mysql> mysqldump -u root -p hms > qaz.sql; error 1064 (42000): have error in sql syntax; check manual corresponds mysql server version right syntax use near 'mysql dump -u root -p hms > qaz.sql' @ line 1
plz me either of these. thank you
try @ end of command store file on desktop.
can use %temp% folder too.
in modern windows can't write program files folders.
>"%userprofile%\desktop\dump _file.sql"
Comments
Post a Comment