Arno Coetzee <[EMAIL PROTECTED]> wrote on 09/02/2005 04:37:48 AM: > shuming wang wrote: > > > Hi, > > Could we do a database dump/backup in a query like below ? > > mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1 > > -u root -p -C mydb>mydbfile > > or restore a database in a query like below ? > > mysql.exe -h 192.168.0.1 -u root -p -C mydb<mydbfile > > > > Then we can do backup and restore in GUI mode without call > > mysqldump.exe,mysql.exe in character mode . > > Best regard! > > Shuming Wang > > > > _________________________________________________________________ > > Express yourself instantly with MSN Messenger! Download today it's > > FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > > > > Hi shuming > > i did not look at all your options , but ignoring the options it most > def is possible. > > i am currently doing backups like this > > mysqldump -uuser -ppassword -hIPAddress -n -t >dumpfile > > i then retrieve the files via ftp and then import them as follow > > mysql -uuser -ppassword -hIPAddress <dumpfile > > hope this helps. > > contact me if you need any help. > > -- > Arno Coetzee > Developer > Flash Media Group > Office : 2712 342 7595 > Mobile : 2782 693 6180 >
The alternative to using "mysqldump ... > dumpfile" is to use the -r option to specify a file. That avoids needing to redirect the console output of mysqldump by telling mysqldump where you want it to put the data directly. In a console window, call up mysqldump --help and it will show you all of the options it accepts. Or, if that is too cryptic, you could always RTFM : http://dev.mysql.com/doc/mysql/en/mysqldump.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine
