You should know how importance of backup your wordpress database, so I will not going to repeat this topic here. What I want to talk is about how to backup your wordpress database.
To me, normally I will backup my database weekly (suggest you backup your database 2-3 times weekly, but I’m lazy).
Last few days, I have shifted my old web hosting to new hosting because I’m not satisfied with the server uptime for the old hosting, so this is first time I import the data that I had backup to new database. I had backup my database with 3 different ways before shifting the web hosting as below:-
1. Using backup wordpress plugin
2. Backup through Wordpress Admin > Manage > Export
3. Through phpMyAdmin
When the time I want to import my database to new database in new hosting, I’m not sure why I can’t import my database through Wordpress Admin > Manage > Import since my backup file is about 2mb plus only, but maximum file size is allowed to import your database file is 8mb. I have tried to import the database for few times, but at last it still cannot work.
Luckily I have used 3 different ways to backup my database, otherwise I may be already lose all my data. Anyway, I have successfully imported my data using phpMyAdmin finally.
I heard my friend said, you should backup your database through phpMyAdmin if your database file size is very big. Also, my experience told me that this is the safest way to export (backup) and import your database.
If you don’t know how to backup your database through phpMyAdmin, check it out this video tutorial. I hope this can help.