How to migrate databases on your panel
📽️ Video Guide 📽️
This article will teach you how to import and export a database, whether you're moving it to another provider or to WitherHosting. The import process is simple, so let's get started.
🔓 Accessing the phpMyAdmin Interface 🔓
On your database page, you'll see an icon that looks like a database. Click on that icon, and you'll be logged into phpMyAdmin! Here, you can manage your database rows, tables, etc., and even import and export databases. See our migration guide for more details.
📤 Exporting Your Database 📤
Once you're in phpMyAdmin, click on the database you want to export on the left-hand side. Then, click the export button at the top. Choose the quick export method and click "Go" to download a .sql file of your database to your computer. You can choose the custom option if you want to export all your database's SQL files at once.
📩 Importing Your Database 📩
First, click on the database you want to import to on the left-hand side. If you have a .sql file you want to import to your database, use the import function. Choose the file from your computer (64MB max) and then import it to your server. The import will be complete. Additionally, you can paste a list of SQL commands to run in order to import your data if you prefer.
And you're done! You've successfully migrated a database on your panel. This guide applies to any other host information. Make sure they have a phpMyAdmin website, or use HeidiSQL instead to get a backup of your database to import with us! If you have any other questions, do not hesitate to open a live chat!
Updated on: 29/05/2024
Thank you!