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.
17 freelancers are bidding on average $308 for this job
I am experienced developer in php/mysql. I can write a script which will fetch records from all database you have. I have few questions. Please reply to me in PMB.
Hello, I'm German, living in Bangkok and am specialized on database evelopment. Please see PM, after answering my questions I can adjust my bid. Thank you in advance
Hi, I have a very good and long experience with such works/tasks: migration of databases, PHP/MySql, algorithmic, security, ect. So I could help you efficiently and rapidly. Thanks,
My work is reliable and complete. I have 7 years of experience in DBMSs like mysql, oracle, and db2. I can begin the project right away and have it completed thoroughly.