Fermé

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.

Compétences : MySQL, PHP, Architecture Logicielle

Voir plus : 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

Concernant l'employeur :
( 9 commentaires ) Accra, Ghana

N° du projet : #1637693

17 freelance ont fait une offre moyenne de 308 $ pour ce travail

Dunkoh

See PMB. Lets do this with you.

400 $ USD en 3 jours
(109 Commentaires)
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 en 7 jours
(82 Commentaires)
6.7
shinydgn

Interesting project. Regards

300 $ USD en 3 jours
(52 Commentaires)
5.8
gachomeo

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

250 $ USD en 4 jours
(22 Commentaires)
5.1
silviani

Hello sir. Please chec your inbox

340 $ USD en 2 jours
(18 Commentaires)
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 Plus

250 $ USD en 1 jour
(19 Commentaires)
4.6
hamm

I can start immediately.

300 $ USD en 10 jours
(24 Commentaires)
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 en 3 jours
(6 Commentaires)
4.2
liuxinran

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

250 $ USD en 2 jours
(16 Commentaires)
4.1
elixirsoftsols

Please check inbox for proposal.

250 $ USD en 10 jours
(10 Commentaires)
4.0
analystdeveloper

Ready to carry out this mySQL/php project.

250 $ USD en 5 jours
(2 Commentaires)
3.0
Mubbshirkazmi

Please Read Your PM.

600 $ USD en 15 jours
(1 Commentaire)
1.8
senthil1975

i have more than 14 years experience in php with mysql

250 $ USD en 8 jours
(0 Commentaires)
0.0
droidco

Hi , Check PM.

250 $ USD en 0 jours
(0 Commentaires)
0.0
Kentinfotech

HELLO SIR PLEASE CHECK PMB

400 $ USD en 4 jours
(0 Commentaires)
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 en 7 jours
(0 Commentaires)
0.0
daxesh20

Please check pm.

275 $ USD en 3 jours
(0 Commentaires)
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 en 8 jours
(0 Commentaires)
0.0