Project:
We would like to do a MySQL database import from one site and export it to anther site.
The two databases are both in php MySql. However, they do not have the same database structures.
The frist db have 25 tables and secound have 66.
Therefore, most likely, it is going to be a manual.
The web have categories, members, leads (buy/sell) etc…that need to be imported to the new dB.
We have looked and compared the two databases our selves and found the following notes about the import:
1- The two databases table names and columns are different.
2- Due to there differences in structure, some data might not have priority to be transferred (we will discus this at later time).
3- We will help you throughout the import/export with any thing we can to speed up the process.
4- Some data in the old database resides in one table that needs to be extracted and reinserted to the new database in multiple tables or column.
HERE ARE THE TWO WE KNOW ABOUT:
A- The BUY and SELL leads are residing in one column in the old database. The BUY need to be extracted and inserted into its own table in the new dB. The same with the SELL leads, they need to be inserted in their own table in the new dB.
B- The images column from the old dB has to be extracted from a table and reinserted in its own table in the new dB.
5- We would like you to take a careful look at the two databases and give us a time table for the import.
6- After the import in done, a thorough check on the web site front end and admin section is a must.
Please don't bid unless you realy know your php and MySQL well and know how to structure a db.
Project should be done in no more than one week.