Re: backup and restore a database in a query ?

2005-09-02 Thread SGreen
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

RE: backup and restore a database in a query ?

2005-09-02 Thread 'Alan Williamson'
> 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 > Then we can do backup and restore in

Re: backup and restore a database in a query ?

2005-09-02 Thread Arno Coetzee
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 mydbThen we can do backup a