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

Re: Backup and Restore

2004-12-06 Thread Raj Shekhar
[EMAIL PROTECTED] wrote: Hi All, Mysqldump -h host name -u username -p password --databases > dump.dmp My doubts are as follows. 1. How to take the backup and restore from the client machine using ODBC? mysqldump is a command line utility for making backups. You will have to exec (iirc, i

RE: Backup and Restore

2001-12-20 Thread Kemp Randy-W18971
Have you looked at mysqldump function? -Original Message- From: Alex Shi [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 1:36 PM To: [EMAIL PROTECTED] Subject: Backup and Restore Hello, I have a question regarding to table backup and restore. Suppose we have a table of sa

Re: backup and restore mysql

2001-01-29 Thread Michael A. Peters
Sorry if this is a little late- but at Abriasoft we are currently developing a tool that can be used for automated backup of your MySQL databases from one or more servers with the ability to restore from the backups in the event that you need to. Our tool uses a C daemon and a php web interface