I need a script that will copy ALL information from table i specify (can be configured in variable) from one mysql database to another.
I need this done in PHP .
Both databases have same table structure.
Scenario as follows:
DB1 = Main DB
DB2 = Replicated DB.
Script should do the following.
1. Empty table XXX in DB2
2. Copy all information from Table XXX in DB1 to Table XXX to DB2.