Category: Databases

Convert Existing MySQL Database to Innodb

  Converting existing MySQL Database Tables from MyISAM to InnoDB can be done from PHPMyAdmin but if there are too many tables the following script will help you to convert all the tables of a particular database to InnoDB Pre-requisites: 1. This tutorial assumes that you have .my.cnf configured with MySQL credentials for auto-login 2. […]

Setting Up MySQL Replication (Master-Slave) – PART 2

  Setting Up MySQL Replication (Master-Slave) – PART 2 My Environment : MySQL Server 01 – Master : 192.168.10.10 MySQL Server 02 – Slave : 192.168.10.11 DB To Replicate – hdada Things to Remember : 1. MySQL version should be the same on Master and Slave 2. During configuration of Replication once the DBDump is […]

Setting Up MySQL Replication (Master-Slave) – PART 1

  Setting Up MySQL Replication (Master-Slave) – PART 1 My Environment : MySQL Server 01 – Master : 192.168.10.10 MySQL Server 02 – Slave : 192.168.10.11 DB To Replicate – hdada Things to Remember : 1. MySQL version should be the same on Master and Slave 2. During configuration of Replication once the DBDump is […]

www.hostingdada.net © 2016