If you have a WordPress website you may want to it is often a good idea to backup your website database from time to time. Your WordPress database keeps the text and settings information for your website. You can do the database backup in SQL through phpMyAdmin if you want. When you are using phpMyAdmin or SQL you should be very careful when doing that as it is easy to make mistakes in there that may cause problems on your website or even to delete the website. That is one reason why it is good to have a backup. If you are not experienced with SQL or phpMyAdmin or if you do not feel comfortable using it to make the backup you may want to use a backup plugin instead.
To make a backup of your website database manually using a SQL program like phpMyAdmin you open the SQL program and then log onto your database using your SQL username and password details. If you do not know that you can usually find it in your hosting. Then you navigate to the database that your website is on. If you have multiple websites or databases in your hosting there may be more than one database listed. If there are more than one you need to find the right database. One way you can do this is click on each and click on the options table and that usually would list the website url. When you have the right database you go to the main database view page and click on check all to check all of the tables then click on export and then download the exported database then save that on your computer there.
This is only the website database. For WordPress you may want to backup the website files too.
Leave a Reply