{"id":3903,"date":"2020-02-05T15:00:02","date_gmt":"2020-02-05T14:00:02","guid":{"rendered":"https:\/\/qodeinteractive.com\/magazine\/?p=3903"},"modified":"2020-09-01T15:08:02","modified_gmt":"2020-09-01T13:08:02","slug":"how-to-backup-wordpress-database","status":"publish","type":"post","link":"https:\/\/qodeinteractive.com\/magazine\/how-to-backup-wordpress-database\/","title":{"rendered":"How To Make a WordPress Database Backup Manually"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]WordPress stores all the information and changes you make to your website within its central database. This database, consequently, becomes an integral part of the backup process which allows you to protect and store changes to your WordPress site. This way you can always be prepared with a working version of the database should anything happen to the live version. [\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]You can backup the database manually or using a WordPress backup plugin. In this article, we will show you how to create a copy of the database manually. However, if you prefer using plugins, we suggest you first explore the top backup plugins<\/a> on the market.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]There are multiple ways to make a manual WordPress backup of your database. A couple of them utilize your hosting\u2019s cPanel functionalities, namely the access to phpMyAdmin and your database. The other way requires you to use the Backup Wizard, an automated functionality provided by some hosting packages.[\/vc_column_text][vc_empty_space height=”68px”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

How to Backup WordPress Database Using phpMyAdmin<\/h2>\n

[\/vc_column_text][vc_column_text]To start the backup process, you need access to the database. If you’re working on a live server, you will either have to contact your hosting provider<\/strong> or access your hosting\u2019s cPanel<\/strong>. If you choose the second option, navigate to phpMyAdmin<\/strong>.[\/vc_column_text][vc_empty_space height=”50px”]

\n
\n \"phpMyAdmin\" <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]If you’re working on a local server (while you\u2019re developing your website, for example), go to the designated dashboard for your chosen local server application. For the purposes of this article, we will be using XAMPP and accessing it via the control panel. This is a program that will let you work with WordPress locally, so if you are curious, you can learn more about installing XAMPP<\/a> for you. Once you access it, press<\/strong> the admin button<\/strong> for MySQL<\/strong>.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Press <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]You will be redirected to the phpMyAdmin dashboard page within your default browser.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"phpMyAdmin <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]On the left-hand side of the page, you will see a list of your databases. Select the one you need. This will open an overview of its tables. [\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]Don\u2019t be confused if the prefix for the tables is different. WordPress sets \u201cwp_\u201d as the default prefix, but there are a few ways to change this table prefix within your database<\/a>.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]When you choose the database you want to backup, click on the Export tab<\/strong>. You can choose the Quick or Custom export methods. If you\u2019re not familiar with this process, go with the Quick export method.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Export <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Leave the format as SQL<\/strong> and click the Go button<\/strong>. This will start the download of the database file with the .sql extension. Save it to a local file and you will have a database WordPress backup on hand.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]If you\u2019re a more experienced WordPress user, you can choose the Custom export method. With this type of export, you\u2019ll be able to save a lot more options from the database. This is why the Custom export method is recommended for larger websites that have robust settings and dozens of WordPress plugins.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Custom <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]If you want to customize the settings for your backup version, here are some of the options that will come in handy.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]Firstly, the custom export option allows you to choose the tables you\u2019d like to incorporate<\/strong> into the backup file. For example, if you have a WordPress plugin that is not particularly important to the functionality of the website, you might want to exclude it from the backup process as it would make the file unnecessarily bulky. This is a practical decision if you intend to make regular, perhaps weekly or even daily, WordPress backups. Any storage space that you could save using this option will greatly improve and speed up the backup process<\/strong>.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]The second section of the Custom export feature is Output<\/strong>. This is a set of options that enables you to fine-tune how the backup will be packaged. In other words, you can choose a custom name for the file, its character set and the way you\u2019d prefer it to be compressed. For example, it is helpful to change the file name template to include the date and time stamps. This will allow you to easily navigate through them within the chosen directory. This template is constructed as follows:[\/vc_column_text][vc_empty_space height=”30px”][vc_column_text]@DATABASE@__%Y-%m-%d_%H-%M-%S<\/code>[\/vc_column_text][vc_empty_space height=”34px”][vc_column_text]The names of the created files will consist of the database name, followed by two underscores – the year, month, day, and time of the extraction separated by dashes.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]Other options include exporting tables separately and setting a limit to the size of the tables. Unless you have a clear idea of how you want your backup file to look like, do not change the default values. However, if you\u2019re going to backup your WordPress site often, take some time to learn more about these customizing options. It will make the process easier and quicker.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]When you choose the optimal setup for your backup, click on the Go button and the file will be downloaded to your computer. Make sure to create a proper folder for all of the WordPress backups for better organization.
\n[\/vc_column_text][vc_empty_space height=”72px”][vc_separator color=”custom” accent_color=”#f0f0f0″][vc_empty_space height=”50px”][vc_widget_sidebar sidebar_id=”top-picks-banner”][vc_empty_space height=”28px”][vc_separator color=”custom” accent_color=”#f0f0f0″][vc_empty_space height=”84px”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

How to Backup WordPress Database Using the Backup Wizard<\/h3>\n

[\/vc_column_text][vc_column_text]The entire process to backup WordPress can be partially automated with the use of the Backup Wizard feature that is provided with some hosting packages. Once you navigate to your hosting\u2019s cPanel, you can choose between the Backup or Backup Wizard features.[\/vc_column_text][vc_empty_space height=”50px”]

\n
\n \"Using <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Both of these are extremely simple and will result in the same backup file as the previous method. However, this method of backing up WordPress offers less autonomy over the backup options and process.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]If you opt for the Backup functionality, all you have to do is find the name of the database<\/strong> you\u2019d like to backup and click on it<\/strong>. The file download will start and you can store it.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]If you opt for the Backup Wizard, you will have slightly more customization options compared to the Backup functionality. Once you click on the Backup Wizard, you will open a three-step process screen<\/strong>. The first step prompts you to choose to either backup or restore a previous backup. Click on the Back Up button<\/strong>.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Back <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]In the second step, you get to choose the type of backup you\u2019d like to perform. You have a choice between a full and partial backup of the website.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Full <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]If you go with the partial option, you can select the Home Directory, MySQL Database, as well as Email Forwarders and Filters backup options. If you\u2019re not familiar with the differences between these options, use the MySQL Database option. It will allow you to back up the database. [\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]If you choose the Full backup option<\/strong>, you will be able to backup your website files<\/a> as well. This will result in a complete backup of your website. However, if you\u2019d like to exclude some of the parts of your website, here are brief explanations of the available options.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]The Home Directory<\/strong> option stores any files from your server\u2019s directory that you have ownership over.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]The MySQL Databases<\/strong> option is the one we have covered in this article. It stores all of the information saved within the database. You select the database in the MySQL Databases<\/strong> menu and save it in the local folder as a .sql file.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]The Email Forwarders and Filters<\/strong> backup option stores configuration for all email forwarders and account-level email filters created for your domain name. However, it only stores the domain\u2019s account-level email filters from the \/etc\/vfilters\/$domain file that does not include the user account-level email filters.[\/vc_column_text][vc_empty_space height=”68px”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

Final Thoughts<\/h2>\n

[\/vc_column_text][vc_column_text]With this guide, you can understand the different methods used to optimize and create a backup of your website\u2019s database. Using this knowledge you will have fewer issues with the sudden crashes of themes, plugins or servers. This means you\u2019ll avoid unwanted scenarios of going offline and being unavailable for users – issues that can seriously affect your website performance and search engine rankings. Keep this tutorial in your bookmarks and rest assured that your website and all of the changes are stored safely.[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

Having a backup of your database is always a good idea. This step-by-step guide will show you how to back up your WordPress database manually.<\/p>\n","protected":false},"author":278,"featured_media":4414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[49,50,4,13],"class_list":["post-3903","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-database","tag-sql","tag-tips","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts\/3903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/users\/278"}],"replies":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/comments?post=3903"}],"version-history":[{"count":0,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts\/3903\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/media\/4414"}],"wp:attachment":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/media?parent=3903"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/categories?post=3903"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/tags?post=3903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}