WordPress site backup is quite important, if you run into any situation where you only see error like establishing databases connection for WordPress site or your site breaks, then the first thing that usually comes in mind is Backup, here are some home made tips for you.
he most important thing is your wp-config.php file that connects your wordPress installation with your MySQL WordPress database. Other then that you the most important thing is your wordpress database, you must have its backup for complete Wordpress restoration. In this post i am sharing my personal experience that explains how to create WordPress MySQL database backup.
Both these plugins are used by me and these are great, the first plugin that is by Prashant Walke is fast and creates backup little bit faster than the second one, but sometimes it fails then you need to use WP DB-Backup plugin by Austin Matzko.
After installation Go to Tools click on WP-DB Backup
Click on Create database backup button
if database backup is successfully created then you can download it to your local computer in zip file Now extract this file to find your database backup in .sql file
Similarly you can create backup using WordPress DB Backup plugin by Austin Matzko
If you are using dedicated server and your site is hosted on AWS linux instance you can directly download MySQL database backup by command line For complete database backup of single database via command line in MySQL
Here you need to replace { db-username } with your db-username and { db-password } with your database password similarly db_name for database name db_backup.sql is file name is backup file name
If you find error in running the first command than run this
it will ask for your db-password after entering correct password Wordpress MySQL database backup will be created successfully.
Complete WordPress site backup
For complete backup of WordPress site you need to have complete folder of WordPress installation directory that includes wp-content, wp-admin, wp-includes, index.php, wp-settings.php, wp-comments.php, wp-cron,php etc....these all directories, files and subdirectories.he most important thing is your wp-config.php file that connects your wordPress installation with your MySQL WordPress database. Other then that you the most important thing is your wordpress database, you must have its backup for complete Wordpress restoration. In this post i am sharing my personal experience that explains how to create WordPress MySQL database backup.
Wordpress Database backup Plugins
I have used two wordpress popular plugins that will let you download all your MySQL database tables in a .sql file that can be uploaded to your new site database. First of all you need to install any one of these two mentioned pluginBoth these plugins are used by me and these are great, the first plugin that is by Prashant Walke is fast and creates backup little bit faster than the second one, but sometimes it fails then you need to use WP DB-Backup plugin by Austin Matzko.
How to Create Wordpress Backup using Plugin
Go to add a new plugin search for Wordpress database backup plugin Check for these two plugins, first of all install WP database backup plugin by Prashant Walke, If the first plugin does not work on your site then try second one .After installation Go to Tools click on WP-DB Backup
Click on Create database backup button
if database backup is successfully created then you can download it to your local computer in zip file Now extract this file to find your database backup in .sql file
Similarly you can create backup using WordPress DB Backup plugin by Austin Matzko
If you are using dedicated server and your site is hosted on AWS linux instance you can directly download MySQL database backup by command line For complete database backup of single database via command line in MySQL
$ mysqldump -u { db-username } -p { db-password } db_name > db_backup.sqlHere you need to replace { db-username } with your db-username and { db-password } with your database password similarly db_name for database name db_backup.sql is file name is backup file name
If you find error in running the first command than run this
$ mysqldump -u { db-username } -p db_name > db_backup.sql it will ask for your db-password after entering correct password Wordpress MySQL database backup will be created successfully.
Comments
Post a Comment