Re: backup databases one to another
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: 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]
Re: backup databases one to another
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]
Re: backup databases one to another
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]
