How To Set Up Database Replication In MySQL (Slave)

Saturday, June 26th, 2010 175 views

On the slave we first have to create the database exampledb: mysql -u root -p Enter password: CREATE DATABASE exampledb; quit; If you have made an SQL dump of exampledb on the master and have transferred it to the slave, then it is time now to import the SQL dump into our newly created exampledb [...]

How To Set Up Database Replication In MySQL (Master)

Saturday, June 26th, 2010 194 views

This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases [...]