Copy TL instance via php script

Hi All,

I am using a production environment as well as a test environment. To test extensions and try other things, we use the testing environment.

What I want to do is create a script to copy the production environment to the test environment so I can start with a fresh copy of our production server.

This script has to copy all files (and subdir's) from the production path to the test path, except for the localconf.php (which contains the user-id and password to the test database.

Also, the database has to be copied.

So the sequence will be:
- remove all files from test (except localconf.php)
- copy all files from prod to test (except localconf.php)
- delete all tables from database test
- copy all tables from database prod to test

Now, I know little of php programming, so if anyone can help me a bit to achieve the goals above, this is very welcome.

Thanks,
Paul

I don't know of any automated scripts to do this, but there may be something out there. You may want to look into syncing the installations by FTP and using something like MySQL Workbench to speed things up. This still won't be an automated process, though.