This article provides step-by-step instructions for exporting and importing a MySQL database using phpMyAdmin.
Database export
1. Log in to phpMyAdmin.
2. Select the database by clicking on its name:
3. Go to the "Export" tab (1). Next, leaving the default export options, click “Go”(2):
4. A pop-up browser window will prompt you to save the database dump file to your local computer. Click "OK"/"Save" (the name of the button differs depending on the specific browser):
Database import
It is assumed that you have already exported the database and the database dump file is located on your local PC.
1. Log in to phpMyAdmin.
2. It is necessary to clear the data from the database. Select a database by clicking on its name:
3. Select all tables using “Check All” (1) and delete them using the “Drop” item from the “With selected” menu (2):
4. Load the dump file to restore the database. Go to the “Import” tab (1), select the “Browse your computer” option, using the “Browse” button (2) indicate the location of the dump file on your local PC. And finally, click “Go” (3):
