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. 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 support people
Regards Karam
--- Gleb Paharenko <[EMAIL PROTECTED]> wrote:
http://lists.mysql.com/[EMAIL PROTECTED]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:
server(192.168.1.1) from my host(192.Dear All,
I wish to backup all databases to my
168.1.5) with (mysqldump),how can we possible,plztell me command or Script
--with brief description.
Thanks in advance aaziz
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET
http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
__________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]