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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
