Programming :: Redesign Existing Mysql Db In Php?

i inherited 200 tables in a mysql db from each of the 200 table there are table created on php pages

the information is organized pretty much the same (fields) in each of them, so i dont see the point of having so many different tables

i wanna redesign the db, in 4 tables each of this 200 table have a few essential characteristics, like: table name is (version_country_type), ie: v8_de_pro, v8_de_std, v9_uk_pro the fields are: No, Document_file, Document_path, ISBN, Book_Name, Subtitle, Status, Year_issue, Author

i will need to break the table name, and put each part in the new redesigned 4 tables separate fields...
ill have something like:

id, version, country, type, Document_file, Document_path, ISBN, Book_Name, Subtitle, Status, Year_issue, Author

but i have no idea how to do it i know i cant do it in mysql... so ill need to build up a php script which will need to read every table, and drop it in the new format:

table1 called Main: ID, version
table2 called Cat: ID, IDmain, Country
table3 called Sub: ID, IDmain, IDcat, type
table4 called files: ID, IDmain, IDcat, IDsub, Document_file, Document_path, ISBN, Book_Name, Subtitle, Status, Year_issue, Author