SugarCRM Backups

There is a backup tool included in the application. We won't consider using it though because it is not complete - it does not take care of your database which is very important.

In order to restore fully your SugarCRM you need to have the database restored and the files copied backed to the server.

So first we need to export the database. It can be done from PhpMyAdmin. In order to reach it you have to log in your Cpanel, go to MySql databases and at the bottom of the page is the link to PhpMyAdmin. Exporting your database is simple. First on the left side choose your SugarCRM database. Then click the Export tab. Next select all the tables. From Structure options check also Add DROP TABLE and then click Go. Thus you'll download a sql file. Now we have the MySql file needed for backups.

We can restore our backup by importing the mentioned sql file into an empty database or into a SugarCRM database. In order to do that we go again to our PhpMyAdmin and choose the database we've specified to use with our SugarCRM. Then we click on the SQL tab and from the second menu we browse to the sql file on our PC and click Go. If the query is successful our database has been populated with the backup data.

After clearing out the database backup procedure we'll proceed with managing the files. The easiest option is to copy the whole folder with SugarCRM from the server to your local PC by ftp. Later when you want to restore your old SugarCRM just copy back the files from your pc to the server in the proper directory.