Re: backup databases one to another

2005-04-13 Thread Forbiddenweb Archive
http://dev.mysql.com/doc/mysql/en/replication.html I would look into the replication features of MySQL. They can be used to create a backup copy of a database. The slave database server will only get the changes from the Master as needed. Karam Chand wrote: This option involves two steps. Firs

Re: backup databases one to another

2005-04-13 Thread Karam Chand
This option involves two steps. First you have to export complete data and then import it again. You can do this more efficiently by using a sync tool like Webyog (www.webyog.com). It will sync any two MySQL databases with changes only done to modified rows/columns. YOu can probably mail their su

Re: backup databases one to another

2005-04-12 Thread Gleb Paharenko
Hello. Something like: mysqldump -h 192.168.1.1 -uroot -p -A >backup.sql See: http://dev.mysql.com/doc/mysql/en/mysqldump.html "Abdul Aziz" <[EMAIL PROTECTED]> wrote: > > > Dear All, > > > I wish to backup all databases to my server(192.168.1.1) from my host(192. > 1