Results 1 to 3 of 3

Thread: Backup of Mysql database using PhpMyAdmin

  1. #1
    mega's Avatar
    mega is offline Newbie Net Builder
    Join Date
    May 2009
    Location
    Hell , Wanna Come ??
    Posts
    62
    Thanks
    0
    Thanked 10 Times in 4 Posts

    Red face

    Backup of Mysql database
    It is assumed that you have phpMyAdmin installed since a lot of web service providers use it.

    0. Open phpMyAdmin.
    1. Click Export in the Menu to get to where you can backup you MySql database. Image showing the export menu.
    2. Make sure that you have selected to export your entire database, and not just one table. There should be as many tables in the export list as showing under the database name.
    3. Select"SQL"-> for output format, Check "Structure" and "Add AUTO_INCREMENT" value. Check "Enclose table and field name with backquotes". Check "DATA", check use "hexadecimal for binary field". Export type set to "INSERT".
    4. Check "Save as file", do not change the file name, use compression if you want. Then click "GO" to download the backup file.

    Restoring a backup of a MySql database
    1. To restore a database, you click the SQL tab.
    2. On the "SQL"-page , unclick the show query here again.
    3. Browse to your backup of the database.
    4. Click Go.
    Never argue with an idiot; First he takes you down to his level and then he beats you with experience.

  2. #2
    ghadeer is offline Net Builder
    Join Date
    Oct 2009
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    i prefer to use cpanel back up
    because at phpmyadmin i have limit file size upload

  3. #3
    Eyes's Avatar
    Eyes is offline Newbie Net Builder
    Join Date
    May 2009
    Location
    In a Party
    Posts
    83
    Thanks
    0
    Thanked 1 Time in 1 Post
    i just export everything into a sql file and save it

Similar Threads

  1. Replies: 3
    Last Post: 29 May, 2010, 03:35 AM
  2. Install MySQL and PHPMyAdmin
    By chatterbox in forum Databases
    Replies: 4
    Last Post: 26 August, 2009, 13:42 PM
  3. Database Backup (to Email and FTP) via Cron
    By Zash in forum Programming
    Replies: 9
    Last Post: 6 July, 2009, 05:28 AM
  4. How to Repair a MySQL Database
    By Will.Spencer in forum Databases
    Replies: 19
    Last Post: 13 January, 2009, 03:20 AM
  5. How to Optimize a MySQL Database
    By Tom in forum Databases
    Replies: 0
    Last Post: 23 December, 2008, 10:48 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •