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.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!