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: > 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. > > 168.1.5) with (mysqldump),how can we possible,plz > tell 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: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ 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]