Replication

[FJR]

Once I create a Master...what do I need to copy over to the slave?

Do I put all of the subfolders of Data (MySql,Test, etc.) on the Slave's machine?

Should the initial .bin and .index files also be put on the Slave's machine?

Thanks in Advance!
fjr

 

[Guest_imported]

Because MySQL mechanism is very simple, it does not holds database informations like the Master database do in MS SQL or in Oracle.

To copy the database:

1) Shutdown the MySQL server
2) Copy your database folder to the slave machine, under the data folder.

That's it.

If you want database compatibility between various platforms (Linux, Unix, Windows etc), you should use MySQL version 3.23.X above by using MyISAM database format.

Hope this helps.

 

[FJR]

Thanks...