2.7.2.1.7. Exporting individual database tables via phpMyAdmin

  1. Signin in phpMyAdmin.
  2. Select the database table from the list on the left:
  3. Open the tab "Export", make sure the radio button is set next to the method "Quick" and in the field "Format" selected "SQL", and press "Forward":

As a result, a file in SQL format will be downloaded with the current contents of a separate database table. The resulting file can be used for subsequent import.

  1. Signin in phpMyAdmin.
  2. Select a database from the list on the left:
  3. In the tab "Structure" check the boxes of the tables you want to export, click "With marked" and select "Export":
  4. In the tab "Export" make sure the radio button is set next to the method "Quick" and in the field "Format" selected "SQL", and press "Forward":

As a result, a file in SQL format will be downloaded with the current contents of several database tables. The resulting file can be used for subsequent import.

Content