Een database tabel kopieren met phpMyAdmin

When copying a table the user may select to copy the table’s data, table structure, or both. Copying a table means creating a new table out of the original, thus a new title should be given to the identical copy.

The steps below in the video tutorial or demo will show you how to copy a database table with phpMyAdmin:

Klik hier voor de video

1. Log in to a “phpMyAdmin” account.

2. To copy a database table, click the desired database table to be copied; located at the left of the screen. For this tutorial, the table “details” has been set as an example.

3. Then click the “Operations” button.

4. Scroll down to view the selection box. Select one of the following options:
     • Structure only
     • Structure and data
     • Data only

5. Enter the name of the new table in the specified text box. Then, click the “Go” button.
The user will then be redirected to a page wherein a confirmation message says that the table has been successfully copied. To confirm this, the newly created table can be seen at the left side of the screen, along with the only table seen at the start of the tutorial.

6. Click the “Home” icon (the house picture), to go back to the main menu.

7. This is the end of the demo for copying database table with phpMyAdmin.

8. Thank you and please contact us for further questions.

Our Solutions

Service

Social Link