Re: backup databases one to another

[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. 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]