• Backup WordPress database without phpMyAdmin: Using CPanel

    WordPress Database supports MySQL database which contains all your pages, posts, and comments. For security, you should have WordPress backup plugin in WordPress website. But if you have not installed any plugin for database backup or you don’t have access to your WordPress Admin page due to some error. Then this tutorial will tell how to take WordPress database backup without phpMyadmin database export option. Also, lots of hacker’s eyes are on your blog and if somehow they manage to hack your blog and now you want it back, then this article will also help you in that.

    Note: In this article, we only giving the tutorial to backup the WordPress database that only contains your posts,pages, and comments. If you want to backup images and theme files of your WordPress Website that resides on your server: See this article – WordPress backup

    You may need theses articles too

    Best WordPress database backup plugin

    Backup WordPress database using Cpanel of Godaddy or other hosting services

    Here we are using Godaddy hosting and cPanel for performing the backup but the steps and process will be same for any other hosting service or cPanel.

    Step 1: Login your cPanel of web hosting

    Every and each web hosting uses a control panel or cPanel to control the whole website and its implementation. Just go to your web hosting area where you have hosted you WordPess website and login in cPanel.

    Step 2: Go to Files category

    After successful login in cPanel, under files category, where you will find several options such as Filemanager, Images, Directory privacy, web disk , Ftp account, backup, backup wizard and so on.

    godaddy wordpress database

    Step 3: WordPress Database Backup

    Under Files category, you will find an option backup and backup wizard. Click on the backup option and windows will open with several options.

    godaddy wordpress database

    Step 4: MySQL database backup

    mysql-database

    Step 5: In the cPanel of any hosting service you will find a backup feature. This feature will allow you to allows you to backup your MySQL database without the help of phpMyadmin.

    Step 6: Download a MySQL Database backup

    Also in the step 4th, you can see that under the Download a MySQL Database backup option you can find your database. Just click that and it will download to your computer locally.

    Step 7:  Download a Full Website Backup

    Besides backing the database you can also take backup of your full website Home directory that includes WordPress files and folder. This option file contains your website images as well as themes along the database.

    backup

    Step 8: WordPress backup & Restore: Home Directory and MySQL backups

    In the backup option, you will also get the option to restore the backup Home directory and WordPress MySQL database. The Restore option will helpful if you are migrating your website. For restoring click on choose file button and upload the SQL database file to restore the database.

     

    mysql-database-restore WordPress backup

    One Response

    1. Kirston June 10, 2017

    Leave a Reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.