Find Jobs
Hire Freelancers

Convert MySQL Databases

£10-20 GBP

Cancelled
Posted almost 8 years ago

£10-20 GBP

Paid on delivery
Hello I need the following doing, our websites have changed its MySQL schema so your going to have to write a script that will take the data from the old database, and insert the data, in the correct format. The script should check that the correct tables and their structure is the same as the empty new database. At the beginning of the script i will need to enter the following in the PHP code: Copy/Check Database (This will be empty, and just used to check the schema and structure of the tables) New Database (This is where the data is moved to) Old Database (This is where the data is copied from). Once i have updated the PHP script with the database information, i load it in a browser and presented with a "start" button. When i click start the databases will start checking, if anything is wrong it will correct it, if all is ok it will start moving data. Once the data has been moved, it needs to do 1 final operation on the new database only. Any data that's older than 3 months (in a certain table), will be moved to another table. The new database stores a lot of information as JSON so you should know how to use encode/decode and be able to see where the its data is coming from on the old database. I will provide you with an empty (new database), populated (new database) and the old database with data. The old databases are not massive, around 20-50mb of data. Please state how long it would take for you to write the script, i will provide a more indepth details of each table etc on accepting a bid for this project. Thanks and happy bidding.
Project ID: 10301810

About the project

11 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
11 freelancers are bidding on average £93 GBP for this job
User Avatar
Hi, I am very interested to work on your project. I have 11+ years experience in Web Development using a large variety of programming languages, frameworks, database architecture, APIs, CRMs, ERPs, mobile development, web design, development tools. There are more then 1000 projects(small/medium/high complexity) successfully implemented and few of them related with yours can be seen on my freelancer.com portfolio. * * Note that my bid is relative and will be adjusted after detailed estimation of implementation effort/coast ** Let's start our collaboration by sending me all details in a written document which will be used as reference during project implementation
£238 GBP in 6 days
5.0 (66 reviews)
6.0
6.0
User Avatar
Dear Sir/Mam, I have read you project description and understood perfectly what is to be done and ready to start work immediately. I have been in this industry for 4+ years and such jobs are my daily practice. I can assure that if you will work with me once, you would like to hire me repeatedly. I have bid a comparatively lower amount. Please feel free to ask questions before awarding the project. Thanks & regards, Ganpat Desai
£18 GBP in 1 day
5.0 (30 reviews)
4.3
4.3
User Avatar
Hi! I propose you to create SQL function for your copying operation. You may use this function by calling in php if you need or in sql dbms.
£20 GBP in 1 day
4.8 (22 reviews)
4.5
4.5
User Avatar
Hello Sir, Your project interests me. I will be available to participate in its realization. for more information contact me zakariaa benslimane
£18 GBP in 1 day
5.0 (11 reviews)
3.6
3.6
User Avatar
i love to do these type of works and also expert in databases and php and wordpress laravel and many others....
£23 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Greeting If I understand you need to copy data from the old base in the new? It should not be a problem. it is the simple queries, eg. 'DROP TABLE IF EXISTS backup_db.backup_table;', 'CREATE TABLE backup_db.backup_table SELECT * FROM live_db.live_table' ); . Do you have done the validation filters on forms? However, you have my offer, but you have to know, I can not do this before Monday, due to other commitments. Wish you luck!
£18 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Liverpool, United Kingdom
5.0
228
Payment method verified
Member since Jul 6, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.