|
Since you guys seem to have the edge when it comes to Joomla backup/restore etc., I thought I would pose this question here. I am looking for a script or query to do the following:
db1 is original and db2 is new-
Compare db1 and db2 and output report with results from:
compare number of tables and note differences
compare number of records and note differences
compare data and note differences
-------------------
Copy stuff from db2 to db1 based on rules:
select and add tables (structure) into db2 from db1 as needed
select and append data from db1 into db2
select and overwrite data from db1 into db2
-------------------
Files:
I have several file modifications and settings that I'll lose and I would love to be able to identify and back them up as well. I realize that this will be difficult to do and will likely have to be done manually by trying to remember all of the things I've changed.
-------------------
Reason:
After we were hacked I did a fresh install of Joomla, components, modules, and bots along with a new database. I need to get the data from the old (and I'm pretty sure structurally corrupted) database and put it into the new database. However I don't want to overwrite the fresh tables and I don't want to overwrite any data created by the fresh install of the Joomla core, components, modules, bots. I may need to append some of that data but at this point I don't know exactly what is written to the database during the installation of J,c,m,b.
-------------------
End Game: I need a completely new installation of Joomla, components, modules, and bots without losing important data from the old installation/database.<br><br>Post edited by: rjscott2005, at: 2007/05/19 00:02
|
Forums 
Favoured: 0
