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.
How to create a full backup of Mambo
It is always a good idea to create a backup on your own, at least when you make major changes on your Mambo website. This way, you will have a working copy of your website that can be restored if something goes wrong with it.
To create a backup of your Mambo website, you need to:
If you access your website account with your FTP client, you will notice a folder called public_html/. This is the main folder for content that is accessible via the primary domain name of your account. This means that if your website is accessible directly through your domain, the Mambo contents are located within the public_html/ directory of your account and this is the folder that you need to create a backup for. However, if your website is in a subfolder, for example called "cms" and your website is accessible via example.com/cms/, where example.com is your actual domain. In this case, you need to create a backup of the "cms" folder only.
Once you are sure about the location of your Mambo website on your Todhost account, you need to download the whole folder, using your FTP client.
To create a backup of your database, you first need to see it's exact name. You can see such information within the configuration file of your Mambo webstie.
Once you find the database set on your Mambo website, you need to log into your cPanel account and locate the Databases tab. Within that section, you need to locate and access the phpMyAdmin service.
Select the database of your Mambo website from the list on the left-side of the screen.
Click on the Export button from the top menu.
Click on the Go button to export a dump backup copy of your database on your local computer.
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.
Understanding Mambo CMS
What is Mambo CMS
Mambo (some time ago named Mambo Open Source or MOS) was a free programming/open source content administration framework (CMS) for making and overseeing sites through a straightforward web interface. Its last launch was in 2008, by which time the greater part of the engineers had left for successors of the venture, for the most part Joomla and MiaCMS. Mambo included elements, for example, page reserving to enhance execution on occupied destinations, progressed template methods, and a genuinely strong Programming interface giving RSS channels and robotize numerous errands, including web indexing of static pages. Interface highlights included printable forms of pages, news flashes, web journals, discussions, surveys, date-books, site looking, dialect internationalization, and others.
The rights to the Mambo CMS codebase, name and copyrights, are secured by the Mambo Establishment, a non-benefit organization framed to bolster and advance the Mambo Open Source venture. The Mambo Establishment’s brief is to cultivate the advancement of the Mambo framework and to shield the venture from dangers and abuse. Mambo is business-arranged, written in PHP and utilizes the MySQL database. It was initially created by Miro Global. It can be utilized on Linux, Unix, Windows and Macintosh OS X servers the length of it runs PHP and MySQL, it can run Mambo. Mambo is the ideal answer for designers and unpracticed clients alike who need a basic yet exquisite approach to convey proficient sites quickly.
Advantages of Mambo CMS:
1) Effortlessness of Mambo made sites
2) High secure and safe programming improvement
3) Simple sensible custom Mambo programming arrangements
4) Sensible improvement expenses and time diminishing outsourcing
5) Life-time backing and support for existing Mambo applications
6) Full-included and polished Mambo programming applications
Mambo is the motor behind a site, that improves the creation, administration, and sharing of substance. As every day being developed passes by we are getting ever closer. While in the meantime fabricating a strong center can be reached out by outsider designers. In the hands of a custom designer, this makes Mambo an effective stage for a wide assortment of Web applications that go far well beyond the straightforward formation of substance.
Mambo is not a run of the mill “gateway” arrangement. While Mambo can be altered or stretched out to give this style of site this is not the objective of the task. Mambo is gone for the all the more soundly at corporate sites or locales for little to medium organizations, families or individual destinations. The Mambo Advancement Group concentrates on building a strong application system instead of on additional items that are commonly found in numerous entrance arrangements. This keeps the Mambo center to a great degree lightweight and proficient, along these lines making it simpler for anyone to amplify Mambo through custom outsider segment and modules that straightforwardly serve their requirements.