2.6.1.2.1.7. Export 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