Dismiss Notice
Welcome to Our Community
Wanting to join the rest of our members? Feel free to sign up today.

Backing up database from phpMyAdmin

Discussion in 'Programming' started by SkinnerW, Dec 15, 2007.

Thread Status:
Not open for further replies.
  1. SkinnerW

    SkinnerW New Member Webmaster

    Backing up database or creating a "database dump" is pretty much straight forward process and can be easily done from phpMyAdmin.

    Depending on your host settings you may have separate phpMyAdmin panel for every database or single interface to manage all of them.

    First step - you need to login into phpMyAdmin interface. In the left column you will see list of databases you can manage - click on one you need to back up.

    On the next page you will see list of tables that were created in this database.

    On top of the page click "Export" tab.

    Next page will show options how you can save back up file.

    - In the "Export" section "select" field you want to highlight all options (if they are not highlighted already) and check "SQL" radio.

    - In the "Options" section you can leave default settings. Following boxes should be checked:
    - Structure - checked
    - Add AUTO_INCREMENT value - checked
    - enclose table and field names with backquotes - checked

    - Data - checked
    - Maximal length of created query - leave 50000
    - Use hexadecimal for BLOB - checked
    - Export type - select "INSERT"

    - check "Save as file" box
    - File name template - leave default
    - Compression - check "none" unless your database is huge than you can use "zip" or "gzip" compression

    Click "go"...

    Program will create sql file and you should see pop-up window asking if you want to save or open file - check save and file should be saved to default location on your hard disk.

    That's it. Now you can easy restore your database if there is a problem or you need to move it to different server.
  2. gkd_uk

    gkd_uk Moderator Moderator Webmaster

    Create tutorial SkinnerW :)
  3. temi

    temi Facilitator Webmaster

    Thanks very much for this Skinner, Nick will find it very useful.
  4. vicdigi

    vicdigi New Member Webmaster

    Thanks Skinner, I found this very useful too and will refer to it at a later date.
  5. jackfranklin

    jackfranklin New Member Webmaster

    Nice tutorial, I was just about to google it :D

Featured Resources (View All)

Thread Status:
Not open for further replies.

Share This Page