Mysql database migration

Posted June 5, 2014 2.4k views
Hello there, i want to know , what are the possible method's to migrate a mysql database without any downtime ? early reply is so much appreciated :-)

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
2 answers
Not entirely possible, But you can try this:

function openDBConn() {
static $link;
if (!isset($link)) {
$link = mysqli_connect('localhost', 'my_user', 'my_password', 'my_db');
return $link; // returns the link

by Etel Sverdlov
This article covers the process required to transfer MySQL data between two servers. This tutorial includes steps on how to perform a MySQL dump, transfer the database with SCP, and then reimport it on the second server.