开发者

IProblem with backing up mysql database

开发者 https://www.devze.com 2022-12-14 10:42 出处:网络
I have problem when backing up mysql database. When I use the following command, it works fine C:\\Program Files\\MySQL\\MySQL Server 5.0\\bin mysqldump.exe

I have problem when backing up mysql database. When I use the following command, it works fine

C:\Program Files\MySQL\MySQL Server 5.0\bin mysqldump.exe 
    --user=dinesh 
    --password=accounting 
    --host=dinesh 
    -C 
    --routines 
    --default-characte开发者_StackOverflow社区r-set=utf8 
    --Opt inventory 
    > C:\\R14122009_12469.Sql

But when I pass Path like

"C:\Documents and Settings\Wild\Desktop\f report\New Folder\R14122009_12469.Sql"

It shows an error table not found

Is there any way where I can save the backup at any place at runtime selection?


How about using --result-file= parameter to mysqldump? It is anyway recommended on Windows to avoid problems with newlines.

0

精彩评论

暂无评论...
验证码 换一张
取 消