Exporting Database Using phpMyAdmin

Last modified by Shielah Aradillos on 2017/04/19 05:17

1. Log in to your cPanel account.

2. From your cPanel account, ciick phpmyadmin.png.

3. From your phpMyAdmin main page, select the database you want to export located at the left navigation panel. (e.g. mysql database)

    Then click export.png.

                                                                          9.png

                                                                (Left navigation panel where database is located.)

4. There are two methods for exporting database:

                   

                                exportmethod.png

The Quick method should work most of the time, though if you need to get more granular with your export options, click Custom

If you choose Custom, you can configure the following:
       

  • Tables: Choose which tables to export.
            
  • Output: Choose the template, character set, and compression for the export.
            
  • Format: Choose to display comments, enclose the export in a transaction, disable foreign key checks, dump table (structure, data, or both).
            
  • Object creation options: Add statements.
          
  • Data dump options: Use INSERT DELAYED or INSERT IGNORE statements, select the function to use when dumping data, select the syntax to use when inserting data, maximal length of created query.

5. Select the file format of your database from the Format drop-down (e.g. SQL).


                                                        fileformat.png

6. Click go.pngto proceed.


7. Save and edit the filename of your database.

Tags:
Created by DemiJalandoon on 2015/07/03 16:10