WordPress database includes all of the website files, such as posts, pages, categories, comments, users, and more. Sometimes, you may need to export WordPress database from your host to the local computer for some specific needs, such as regular local backup for secure data or make a backup of WordPress database before transferring.
Generally speaking, there are two options when exporting a database – you can either export the entire database or export selected tables of a database. In the below part, we just guide you with the detailed steps to export WordPress database with the popular phpMyAdmin tool.
About phpMyAdmin
phpMyAdmin is an open source tool that is free of charge developed to manage the administration of MySQL on the Internet. With great functionality, users can easily to manage the frequent used operations like managing databses, columns, tables, indexes, permissions, relations, users and on via the friendly user interface. Besides, the tool also allows users to execute any SQL statement directly.Actually, phpMyAdmin is regarded as one of the easiest ways to import and export databases on a MySQL environment, which helps you to create, edit, back up, import, export, delete databases, and operate database tables with ease.
In this tutorial, we just use phpMyAdmin to export WordPress databases. Note that all operations are handled within WebHostingHub cPanel control panel.
Export WordPress Database
Log into your cPanel control panel, and click on the icon of phpMyAdmin under databases.
Then, the cPanel brings you to the phpMyAdmin interface, where you can find all of your server databases. Here, you can click on your website and find the database you want to export.
Click on the database you want to export, and then you can see all tables of your site, such as wp_contents, wp_links, wp_terms, wp_users, and so on. If you want to export specific tables, you can simply check them and click on the Export Tab on the top menu bar.
On the other hand, if you want to export the entire database, you can scroll down to the bottom of the table structure, and select the checkbox of Check All, and choose the Export in the drop-down box.
Then, phpMyAdmin takes you to the next screen, where you are required to choose the export method and format.
In general, there are two export methods: Quick – display on the minimal options; Custom – display all possible options. We personally choose the Quick method to quickly export WordPress database. Then, you are needed to choose the format as SQL so that you can export your database as SQL file. At last, click the below Go button and phpMyAdmin will automatically export your database.