MySQL is a powerful open source Relational Database Management System or in short RDBMS. It was released back in 1995 (20 years old). It uses Structured Query Language which is probably the most popular choice for managing content within a database. The latest MySQL version is 5.6.25 and was released on 29 May 2015.
An interesting fact about MySQL is the fact that the name comes from Michael Widenius’s (MySQL’s creator) daughter My. Even though there are plenty of interesting facts about MySQL, this article is meant to show you some useful practices to help you manage your MySQL server.
Option 1 – phpMyAdmin
Migrate a MySQL database is as simple as selecting the DB in the left column, clicking the Export link, and saving the database to a file. Then on the new server, select the DB in the left column, click the Import link, and choose the file you just exported.
Use this method when:
- Both servers have phpMyAdmin installed
- The database size is under 50MB
- The database export file is small enough to overcome upload size
With large or very complex databases, you run the risk of the PHP request timing out before the operation completes. This will leave you with a partial import. So this method is best used for smaller databases.