Question

Mysql database migration

Posted June 5, 2014 1.6k 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.

×
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.
Submit an Answer