[MySQL Upgrade] How to do a full DB backup?

Eli L

Well-Known Member
Aug 9, 2007
61
1
58
Bellingham, Washington, United States
cPanel Access Level
Root Administrator
Hey,

Since upgrading to 11.25 theres a setting to upgrade MySQL from 5.0 to 5.1. Doing this it says:
Although in place upgrades of MySQL are generally safe, it is always recommended that you perform a full database backup before beginning the upgrade process.
I cannot afford to lose my DB's and want to play it safe; so how do I do a full database backup?

Thanks!
 
Last edited:

sven4o

Member
May 21, 2007
19
0
151
All the databases' raw files are stored under the /var/lib/mysql folder. Copy the content of this folder to a separate storage and you will have a backup of your databases. You can also copy the my.cnf file from the etc/ folder. It contains your MySQL configuration.

Alternatively, you can backup the databases one by one from WHM->PhpMyAdmin.

We know cPanel because our web hosting customers love it!
Check out our special cPanel hosting package!
 
Last edited: