13 {{ upvoteCount | shortNum }}
13 {{ upvoteCount | shortNum }}

How to backup MySQL Database?

by resetrsx
11 replies
  • WEB DESIGN
    • |
I'm trying to backup MySQL database for my Wordpress site and I'm not exactly sure how to go about doing this. Can anyone help?
#backup #database #mysql
  • Profile picture of the author Hostgator Coupon
    I just recently went through this myself. You can do it through phpMyAdmin. You should have that in your web hosting control panel.
    Signature

    Please visit www.asmallorangecouponcode.weebly.com for A Small Orange Coupons.
    Please visit www.hostninecouponcodes.com for Hostnine Coupons.
    Please visit www.hostgatorwebhost.com for Hostgator Coupons.

    {{ DiscussionBoard.errors[8065684].message }}
  • Profile picture of the author Istvan Horvath
    Originally Posted by resetrsx View Post

    I'm trying to backup MySQL database for my Wordpress site and I'm not exactly sure how to go about doing this. Can anyone help?
    And what did you find when searching the WordPress online manual - the Codex?

    Next time try it before posting simple questions... e.g. WordPress Backups « WordPress Codex
    Signature

    {{ DiscussionBoard.errors[8066123].message }}
  • Profile picture of the author michael0109
    You can try MySQLDumper - Backup your MySQL-Database (e.g. forum, guestbooks and online shops) for a big database.
    {{ DiscussionBoard.errors[8066828].message }}
  • Profile picture of the author David
    Originally Posted by resetrsx View Post

    I'm trying to backup MySQL database for my Wordpress site and I'm not exactly sure how to go about doing this. Can anyone help?
    I've managed WP sites on various web hosting accounts, usually the webhost has a Cpanel (Godaddy handles this differently) within the Cpanel there's an option to "create backup"

    Those are typically saved somewhere within your hosting account

    Additional choices: use a WP plugin, and some of those will provide an option to:
    Store the mysql file in the clould
    Download the mysql file to your hard drive
    Email you a tar.gz zipped up format of the mysql file

    hope that helps
    Signature

    David Bruce Jr of Frederick Web Promotions
    Lawyer Local SEO - |

    {{ DiscussionBoard.errors[8068425].message }}
    • Profile picture of the author Karen Blundell
      rather than installing too many plugins, because the more WP
      plugins you have, the more server resources you use, and the more vulnerable you are, learn to rely on your tools that most of you have in your cPanels of your hosting account.
      phpMyAdmin comes installed in your cPanel and allows you to completely control your MySQL databases. It is not very hard to figure out and has full documentation:
      phpMyAdmin - Documentation
      Signature
      ---------------
      {{ DiscussionBoard.errors[8068916].message }}
      • Profile picture of the author Pakiisp
        Originally Posted by Karen Blundell View Post

        rather than installing too many plugins, because the more WP
        plugins you have, the more server resources you use, and the more vulnerable you are, learn to rely on your tools that most of you have in your cPanels of your hosting account.
        phpMyAdmin comes installed in your cPanel and allows you to completely control your MySQL databases. It is not very hard to figure out and has full documentation:
        phpMyAdmin - Documentation
        I'm totaly agree with your points.
        Signature
        Ajnabii.com - ProwpBlogger.com
        WordPress Business Themes
        {{ DiscussionBoard.errors[8094783].message }}
  • Profile picture of the author webdesignseo
    hi
    please visit the link http://www.phpmyadmin.net/home_page/docs.php.I think it will help you
    {{ DiscussionBoard.errors[8070116].message }}
    • Profile picture of the author shaaam2007
      If you are using cpanel then you can go to Databases option and get backup by using "Backup database" option there. You can also go to phpmyadmin installed in you cpanel. You can select the database and expert database using minimum option or custom options.

      If you are using ssh then used command to backup your database. using this command :

      mysql -h servername -u dbusername -p databasename < /path/to/backupname.sql
      Signature
      Free Download Mobile Apps | Mobile Phone Forum | Mobile Phone SMS
      {{ DiscussionBoard.errors[8070298].message }}
  • Profile picture of the author Michael71
    Google: wordpress backup database

    I do not understand why people are not able to use Google...
    Signature

    HTML/CSS/jQuery/ZURB Foundation/Twitter Bootstrap/Wordpress/Frontend Performance Optimizing
    ---
    Need HTML/CSS help? Skype: microcosmic - Test Your Responsive Design - InternetCookies.eu

    {{ DiscussionBoard.errors[8070310].message }}
  • Profile picture of the author annaharris
    Check the given link which contains information about how to backup mysql database and how to restore it.
    How to Backup a MySQL Database
    {{ DiscussionBoard.errors[8080851].message }}
  • Profile picture of the author RenardNET
    If you looking for easy solution and you want to have backup done frequently than I recommend you this plugin:

    WordPress › BackWPup « WordPress Plugins

    I am using this on my blogs and works perfect for me. You can schedule there task to backup DB (and/or files) in defined time range, backup can be compressed and send to your email or Dropbox, SugarSync, Amazon S3 and other clouds.

    Tom
    {{ DiscussionBoard.errors[8083517].message }}

Trending Topics