Closed

Mysql Database migration of records to a new database

This project received 19 bids from talented freelancers with an average bid price of $308 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$250-$750 USD
Total Bids
19
Project Description

We need a php/mysql script that migrate all data from old database to new tables - We have about 2000 databases and each database has about 40 tables. So Total 80,000 tables and almost 16,000,000 records.
We now want to have only one database and about 40 tables and about 1,000,000 records.

NB: they are on the same database server and instance.
There is a main database (users) that has a table(userinfo) that stores user's info.
Amongst the info’s stored in the userinfo table is a column with some generated chars called username.
These generated usernames are the database names of our 2000 databases.
eg. if fa43tebfd is username, then his database will be bayuobie_fa43tebfd.

Database bayuobie _fa43tebfd just like the others, are made up of mainly 40 tables with data.
Among the tables are google, amazon, ebay, etc...
NB: remember each of the 2000 databases has these tables but some not populated with data.

Now, we need one database (universal) and 40 tables . each of these 40 tables will now be populated with all the data contained in the old database.

We have designed the schema of the new database. Its left with the transfer of data.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online