How to backup MySQL table in phpMyAdmin

Sometimes when you are going to execute an SQL statement to your production database, you need to be very careful especially when you are using DELETE or UPDATE command.

To ensure your original data will be available, you can backup the whole table that you are going to do the operation.

To backup the whole table is very easy in phpMyAdmin (even in other SQL tool).


After you done with the operation and it is successful, you can easily drop the temporary backup table.

2 thoughts on “How to backup MySQL table in phpMyAdmin

  1. hawk

    well… got a question..

    how did you get that screenshot and what tool that have been used
    to create such a nice figure for this content?

Leave a Reply

Your email address will not be published. Required fields are marked *