Closed

Mysql Database migration of records to a new database

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.

Skills: MySQL, PHP, Software Architecture

See more: old database, mysql database software, mysql database server, transfer database, software architecture php mysql, server migration, php software architecture mysql, migrate mysql, data migration software, amazon ebay software, mysql php migration, mysql databases server, ebay databases, mysql table migration php, ebay transfer amazon, migration php, server amazon transfer, schema database mysql, amazon migration, google ebay user, mysql schema, transfer amazon, mysql data transfer script, database database transfer, want script amazon

About the Employer:
( 9 reviews ) Accra, Ghana

Project ID: #1637693

17 freelancers are bidding on average $308 for this job

Dunkoh

See PMB. Lets do this with you.

$400 USD in 3 days
(109 Reviews)
6.9
chitta

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.

$300 USD in 7 days
(82 Reviews)
6.7
shinydgn

Interesting project. Regards

$300 USD in 3 days
(52 Reviews)
5.8
gachomeo

Hi, I usually work with kind of this work and i'm very interesting on this project. Regards.

$250 USD in 4 days
(22 Reviews)
5.1
silviani

Hello sir. Please chec your inbox

$340 USD in 2 days
(18 Reviews)
5.0
Mitoff

We're team of professional MySQL developers who are willing to satisfy all your needs in less than 24 hours. Those databases are rather small, compared to those we have worked with. We can guarantee for the quality of More

$250 USD in 1 day
(19 Reviews)
4.6
hamm

I can start immediately.

$300 USD in 10 days
(24 Reviews)
4.5
larsjedinski

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

$279 USD in 3 days
(6 Reviews)
4.2
liuxinran

Hi I am very confident about this work. Please check the PM.

$250 USD in 2 days
(16 Reviews)
4.1
elixirsoftsols

Please check inbox for proposal.

$250 USD in 10 days
(10 Reviews)
4.0
analystdeveloper

Ready to carry out this mySQL/php project.

$250 USD in 5 days
(2 Reviews)
3.0
Mubbshirkazmi

Please Read Your PM.

$600 USD in 15 days
(1 Review)
1.8
senthil1975

i have more than 14 years experience in php with mysql

$250 USD in 8 days
(0 Reviews)
0.0
droidco

Hi , Check PM.

$250 USD in 0 days
(0 Reviews)
0.0
Kentinfotech

HELLO SIR PLEASE CHECK PMB

$400 USD in 4 days
(0 Reviews)
0.0
webIT4All

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,

$300 USD in 7 days
(0 Reviews)
0.0
daxesh20

Please check pm.

$275 USD in 3 days
(0 Reviews)
0.0
phpdb

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.

$250 USD in 8 days
(0 Reviews)
0.0