Migrate ABPro to another server

The Backup and Restore in ABPro is all handled internally in database tables. There is no facility to 'Backup' on one server then 'Restore' on another.

You can use Backup/Restore to migrate all you data and settings to another server but it requires using phpMyAdmin or some other database tool to export/import the backup tables.

Step by Step

In ABPro do a Backup..





Now, using phpMyAdmin (or some other database tool)  Export all the ..sv_apptpro.. tables that end in '_backup' to an sql file on your desktop..




This will produce a .sql file on your desktop with all your settings and data.

Alternatively you could export all ABPro tables. That will work also. The reason I suggest just the backup tables is the 'Restore' will adjust for new fields in the case you are installing a newer version of ABPro than you are exporting from.

Now in the destination server use phpMyAdmin again to Import the .sql file.




Finally install ABPro into your destination server in the normal manner then do an ABPro Restore to bring the data and settings from the _backup tables into the production system.

If you have made any modifications to the CSS or Language files, you will need to manually bring them from the original server to the new one.

---

Note: If the database prefix on the new server is different than the destination server you will need to modify the exported sql file.

For example if your new server prefix is j25_ and your original server prefix was jos_, the exported sql file looks like..

DROP TABLE IF EXISTS `jos_sv_apptpro2_requests`;
CREATE TABLE `jos_sv_apptpro2_requests` (
`id_requests_history` int(11) NOT NULL AUTO_INCREMENT,
`id_requests` int(11) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`operator_id` int(11) DEFAULT NULL,
`name` varchar(50) NOT NULL DEFAULT '',...

Change all jos_ to j25_

DROP TABLE IF EXISTS `j25_sv_apptpro2_requests`;
CREATE TABLE `j25_sv_apptpro2_requests` (
`id_requests_history` int(11) NOT NULL AUTO_INCREMENT,
`id_requests` int(11) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`operator_id` int(11) DEFAULT NULL,
`name` varchar(50) NOT NULL DEFAULT '',...