2.6.1.2.1.7. Export of certain database tables using phpMyAdmin

  1. Log in to phpMyAdmin.
  2. Select the database table from the list on the left:
  3. Open the "Export" tab, make sure the toggle switch is set to "Quick" and "SQL" is selected in the "Format" field, then click "Export":

This will download an SQL file containing the current contents of the selected database table. You can use the resulting file for a subsequent import.

  1. Log in to phpMyAdmin.
  2. Select the database from the list on the left:
  3. On the "Structure" tab, select the tables you want to export, click "With selected", and select "Export":
  4. On the "Export" tab, make sure the toggle switch is set to "Quick" and "SQL" is selected in the "Format" field, then click "Export":

This will download an SQL file containing the current data from multiple database tables. You can use this file for a subsequent import.

Content