Import / Export a Database via PHP MyAdmin
Posted by - NA -, Last modified by Mark [Elevated X Support] on 15 August 2018 07:09 PM
Export a Database via phpMyAdmin
Step 2) Click the Export tab.
Step 3) Make sure that:
a) Under Export, ALL the tables are selected
b) Under Export, SQL is selected
c) The Structure tab is checked, along with the following options underneath:
-- Add DROP TABLE
-- Add AUTO_INCREMENT value
-- Enclose table and field names with backquotes
d) Make sure the data tab is checked, and the follow options underneath:
-- Complete inserts
-- Extended inserts
-- Use hexadecimal for binary fields
-- Export Type = INSERT
e) Make sure Save as File is checked. For compression, none is recommended
f) Press the "Go" button at the bottom when ready.
Import a Database via phpMyAdmin
Step 1) Either select the database you wish to use from the dropdown on the left side of the screen - OR - If you only have access to one database, click that database link (in this case, development_dev01) on the left.
NOTE - This may be on a different phpMyAdmin panel. Make sure you're on the right system and phpMyAdmin panel before attempting an import.
(See above screenshot from Export Database for reference)
Step 2) Click the Import tab.
Step 3) Upload the file that you generated from the export.
NOTE - Using the export settings from above will overwrite any existing tables within the destination database.