Mysql database migration

June 5, 2014 1.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 :-)
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.
Have another answer? Share your knowledge.