{"id":6746,"date":"2021-04-15T18:50:00","date_gmt":"2021-04-15T18:50:00","guid":{"rendered":"https:\/\/readyship.co\/blog\/?p=6746"},"modified":"2021-04-15T18:50:02","modified_gmt":"2021-04-15T18:50:02","slug":"manually-export-import-back-up-restore-wordpress-database-cpanel","status":"publish","type":"post","link":"https:\/\/readyship.co\/blog\/manually-export-import-back-up-restore-wordpress-database-cpanel\/","title":{"rendered":"2 Ways to Manually Export, Import, Back Up & Restore a WordPress Database in cPanel"},"content":{"rendered":"\n

The database is the most important part of a WordPress website. It stores your content, users, settings, URLs, and more.<\/p>\n\n\n\n

If something bad happens to your WordPress website – like getting hacked and losing your data – and you don’t have the database backed up, then your website is gone forever.<\/p>\n\n\n\n

So, it’s critical to either back up your entire WordPress site<\/a>, or, at the very least, back up your database.<\/p>\n\n\n\n

You might need to export your WordPress database for other scenarios as well, not just as a backup in case something goes bad. For example, you might want to manually transfer your WordPress website to another web host.<\/p>\n\n\n\n

So, in this step-by-step tutorial, I’ll show you how to manually export and import your WordPress database using phpMyAdmin, as well as how to back it up and restore it using the Backup tool. All this from your cPanel, which is your server’s control panel that virtually all Shared web hosts have.<\/p>\n\n\n\n

The cPanel interface differs from host to host. So, yours might look a bit different than the one in my screenshots. But don’t worry, the tools should still be there.<\/p>\n\n\n\n

\n

Contents<\/strong><\/p>\n\n\n\n

  1. How to Manually Export a WordPress Database with phpMyAdmin in cPanel<\/a><\/li>
  2. How to Manually Import a WordPress Database with phpMyAdmin in cPanel<\/a>
    1. The “#1050 – Table already exists” error – Deleting tables<\/a><\/li><\/ol><\/li>
    2. How to Manually Back Up a WordPress Database with the Backup Tool in cPanel<\/a><\/li>
    3. How to Manually Restore a WordPress Database with the Backup Tool in cPanel<\/a><\/li><\/ol>\n<\/div><\/div>\n\n\n\n

      <\/p>\n\n\n\n

      How to Manually Export a WordPress Database with phpMyAdmin in cPanel<\/h2>\n\n\n\n

      Step 1<\/h3>\n\n\n\n

      Access and log in to cPanel.<\/p>\n\n\n\n

      Usually, you can quickly access cPanel by adding the \/cpanel<\/code> slug after your domain (e.g. https:\/\/example.com\/cpanel<\/code>).<\/p>\n\n\n\n

      \"cpanel<\/figure><\/div>\n\n\n\n

      If you didn’t receive your login information after purchasing the hosting plan, check the hosting documentation or contact them for help.<\/p>\n\n\n\n

      Step 2<\/h3>\n\n\n\n

      After logging in to cPanel, look for the phpMyAdmin<\/strong> tool. It should be in the Databases section.<\/p>\n\n\n\n

      \"phpmyadmin<\/figure><\/div>\n\n\n\n

      Step 3<\/h3>\n\n\n\n

      If you have multiple WordPress websites on the same hosting plan, you’ll most likely have multiple databases in phpMyAdmin, one for each website.<\/p>\n\n\n\n

      Now, if you want to export them all skip to the next step.<\/strong><\/p>\n\n\n\n

      If you want to export a particular one, not all, then you’ll need to select it, first, by clicking on it on the left sidebar.<\/p>\n\n\n\n

      \"select<\/figure><\/div>\n\n\n\n

      Step 4<\/h3>\n\n\n\n

      Click on the Export<\/strong> tab found in the upper toolbox. If you selected a WordPress database at step 3, it will only export that one. If you didn’t select any, it will export all of them.<\/p>\n\n\n\n

      Leave Quick<\/strong> set as the Export method<\/strong>. Leave SQL<\/strong> as the Format<\/strong> unless you have special plans with your WordPress website, and you need another format.<\/p>\n\n\n\n

      When ready, click on the Go<\/strong> button, which will start the download of the .sql<\/code> file.<\/p>\n\n\n\n

      \"export<\/figure><\/div>\n\n\n\n

      Note that if you opted to export all WordPress databases<\/strong>, it will put them into a single .sql<\/code> file by default. If you want them into separate files, then:<\/p>\n\n\n\n