Vtiger Backups

Creating backups of Vtiger CRM and its MySQL database and restoring them

There is no backup tool included in the application.

In order to restore fully your Vtiger CRM 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, please choose your Vtiger CRM 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 on you computer. 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 Vtiger CRM database. In order to do that we go again to our PhpMyAdmin and choose the database we've specified to use with our Vtiger CRM. 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 the database backup procedure we'll proceed with the files. The easiest option is to copy the whole folder with Vtiger CRM from the server to your local PC by FTP. Later when you want to restore your old Vtiger CRM just copy back the files from your pc to the server in the proper folder.

Please, feel free to contact us if you have any questions or recommendations about this tutorial at: tutorials 'at' siteground.com