There exists multiple methods of taking a backup and restoring the MySQL database. Here, in this tutorial, we will try to learn about how to backup and restore Mambo website database using PhPMyAdmin from the cPanel control panel.
Steps to Back up the Mambo Database
The procedure to backup the Mambo Database is simple, hence one should be able to maintain a regular backup of your websites database. Furthermore, it is essential to take a backup of the database before you install or remove any components.
In order to proceed with the process, you must first login to your cPanel and go to phpMyAdmin.
Step 1 – You must choose the Export tab located at the top of the phpMyAdmin screen. To backup the data, the tool would simply put it in a format which would enable you move it wherever you wish to use the database.
Step 2 – Upon clicking the Export tab, various options would be displayed.
Step 3 – Now, look for a section named “ Export ”, you should be able to find it at the top left location of the screen. Now, click on Select All option, it is located at the bottom of the list. Here, we would be taking a complete backup of the database. But, if you intend not to do this, you can even select certain tables. You can select the tables by holding the Control button on your keyboard and clicking the table name using the left mouse button.
Step 4 – Look of the section named “Structure” located at the right-side of the page. You must check the box against the Structure box. This enables you with backing up the structure of your Mambo database. Further, you must check the “Add DROP TABLE” check-box. Though it isn’t a mandatory step, but can avoid few future hassles at the time of restoring the database.
Step 5 – Incase you are taking backup which would be restored on the same server with no change in the settings, then there isn’t anything to bother about. But, if you plan to move it over to a different server all-together with a different MySQL version, then you must choose a relevant Export Compatibility.
Step 6 – Ensure if the box besides the Data is checked, failing to do that would not successfully take backup of the actual data within the database.
Step 7 – Check the box against Save as file. Failing to do this would backup the database as plain text in a textbox.
Step 8 – Choose the type of compression you intend to have. If you have a website with not much data, you can skip this step. Though, choosing to compress it would cause no harm. But, if you have large amount of data, you must select the option of “gzipped” as it offers better compression of files.
Step 9 – Hit the Go button located at the bottom right of the screen.
Step 10 – Having done that, you would be presented with a dialogue box. You must choose the location on your local machine where you wish to save the file.
This finishes the process of backup.
Steps to Restore the Mambo CMS Database
There may be multiple reasons when you would require to restore the database backup of your Mambo website. The below procedure would enable you to restore it with ease.
Step 1 – Login to your cPanel, go to phpMyAdmin
Step 2 – Go to the Structure tab.
Step 3 – Select and click Check All option located below the list.
Step 4 – At the right side you should be able to find a drop down menu, there you must choose Drop option. You must take caution when doing this. Incase you have multiple systems running on a single database (ie. concurrent forum, Mambo, gallery systems etc.), unless the backup file contains all the tables, you should NOT choose to drop all tables, only the Mambo ones, that begins with the prefix: mos_
Step 5 – You would see a box asking you to confirm the list of tables that you wish to drop.
Step 6 – You must click Yes. Upon doing so, you would be shown a box displaying confirming the execution process.
Step 7 – Now look for the SQL tab, hit the mouse button.
Step 8 – Hit Browse now.
Step 9 – You would be shown a dialogue box where would have to select the destination of the backup file on your local machine.
Step 10 – You can choose the gzipped option if you are are sure about your backup file was gzipped, else you can choose the Autodetect choice.
Step 11 – Hit Go
Upon execution of the request, you would be presented with a box stating the successful completion of the process.
This ends the process of backup and restoration of your Mambo Database.
Like this post ?
Share on your Social Networking Profile ( Facebook, Twitter & Google+ ) and get a flat 10% Recurring discount on our VPS Hosting and Dedicated Servers.
Email us the shared link at : [email protected] or speak to our live chat operator now, by clicking on the “Live Chat” Scroller on the left-hand side of this page and we will provide you with the discount Coupon right away!