> 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 .
Ah okay now i see what you are trying to do. The [mysqldump] is a utility that sits outside of the main mysql engine. You cannot invoke this from within the mysql shell from the best of my knowledge. As for pulling in backups from the mysql shell, then yes that is possible using a number of techniques: % mysql> SOURCE [path to your file] or % mysql> LOAD DATA [path to your file] Links to more information: http://dev.mysql.com/doc/mysql/en/load-data.html http://blog.spikesource.com/mysql_hotbackup.htm hope this helps, alan -- Alan Williamson, Technology Evangelist SpikeSource Inc. t: 650 249 4279 b: http://compiledby.spikesource.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
