How to Move Your MySQL Databases
Moving your MySQL database to UnderHost is straightforward. Follow these steps to export and import your database information securely.
Export A MySQL Database
Exporting your database creates a backup file on your local machine, which can be used for restoration or migration purposes.
# mysqldump username -ppassword database_name > FILE.sqlReplace username, password, and database_name with your actual MySQL username, password, and the name of the database you're exporting. This command creates a file named FILE.sql with all your database information.
Import A MySQL Database
Importing a database is as easy as exporting. The import function can be used to restore data from a backup or transfer database information from another server.
# mysql -u username -ppassword database_name < FILE.sqlAfter uploading FILE.sql to the new server, run the command above with your MySQL username, password, and database name where indicated.
These steps are ideal when switching to UnderHost from another hosting provider. By exporting your data from your old server and importing it to UnderHost, you can transition smoothly and quickly.
If you need assistance during the process, our support team is ready to assist you 24/7 to ensure a seamless transition.
