Find Jobs
Hire Freelancers

Sync Data between two MySQL databases using PHP batch job

€30-250 EUR

Completed
Posted over 8 years ago

€30-250 EUR

Paid on delivery
I would need a PHP script which does the following: -Retrieve data from remote MySQL database and insert data into local MySQL db -There are 7 database fields which need to get synced (1 way sync from remote to local DB) -After the data has been pulled from the remote MySQL database server, update the remote table to mark the entries as "processed" (update 2 fields, set status to processed and set timestamp). -Log all data that has been synced into local logfile -If any error occurs (e.g MySQL connect error) mail error log to system administrator The script will be run on a Ubuntu 14.04 LTS server every 30 minutes using crontab. The MySQL version is 5.5.40. The script should work using PHP 5.4 and above.
Project ID: 8908726

About the project

16 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
Awarded to:
User Avatar
Hi, Ni to see you here again! How is my old script? Does it work normally? :) I'd like to do perform this task for you. Think, it'd take 3-2 days, and I'd get a result script on the Thursday or Friday. Best wishes from Hamburg Sergey
€160 EUR in 3 days
5.0 (10 reviews)
4.7
4.7
16 freelancers are bidding on average €145 EUR for this job
User Avatar
Hello! With 98% to 99% completion rate, 850+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... you can never go wrong choosing me :) I am available to get started on your project right away. I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
€210 EUR in 1 day
4.9 (1060 reviews)
8.9
8.9
User Avatar
Dear Sir/Madam, I Have already read your project description & fully understand this project for you. Also I have solid experienced professional in-house team of designers, developers and coders. We are offering best price in this market & providing best quality of work for you. Please check your PMB for more details & award me for this project. ~~~~~~~~~~~~~~~~~Few reasons to select us as a service provide~~~~1. Post delivery free bug fixing support.------- 2. Industry standard modern design.------- 3. Secure coding SQL injection and XSS (cross site scripting),------- 4. Well documented code.------- 5. Regular work update. ~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~ Thanks with Regards
€150 EUR in 2 days
5.0 (517 reviews)
8.2
8.2
User Avatar
hi: i'ma n experienced php developer, I can develop a script that can sync your local db with the remote db and set the appropriate flags on the remote fields. Please share the db details with me to get started
€142 EUR in 1 day
5.0 (149 reviews)
7.7
7.7
User Avatar
Hi, Yes, it can be completed within ONE day. and we have 2 ways that we can use. 1. Either we can use MySql Trigger on the remote database, if you have access to it. but will not send any emails. 2. Or we will build that in PHP ( PDO ) and will setup CRON job to automate the process as you mentioned every 30 minutes. Please note mysql library for PHP has been deprecated. So we MUST USE PDO Thank you
€70 EUR in 1 day
4.8 (246 reviews)
6.8
6.8
User Avatar
A proposal has not yet been provided
€155 EUR in 3 days
4.8 (197 reviews)
6.2
6.2
User Avatar
Aucune proposition n'a encore été fournie.
€94 EUR in 1 day
4.9 (58 reviews)
5.8
5.8
User Avatar
Dear Rssc, I will make mysql sync script using php. I have 4+ years of experience in web development I will give you quality work with your complete satisfaction Please come into chat for more discussion I'm waiting for your response. Thanks
€150 EUR in 4 days
5.0 (16 reviews)
5.1
5.1
User Avatar
Dear Sir, It’s a great pleasure me to bid on your project. I am a 7 years experienced web Developer.. I hold a master degree for Computer Science. Please see my profile, I have enough experiences and gained lot of job experiences working in various world recognized institutions. I am maintaining 100% on time job completion rate with 5 star rating in freelancer.com customer reviews. And also I have passed the necessary skill examinations in freelancer.com which are related to complete your project. As a master for Computer Science I can handle your project to meet your requirements which are listed in the project description. I will start your project for a minimum initial payment and balance you can pay at the end of each milestone or you can create milestones at your convenience according to satisfaction of my work. Further I will give you 3 months free of charge bugs fixing and maintenance service to improve your application’s performance. I will let you to see progress of your project by hosting your application on my live testing server. Please accept my bid if u are satisfy with my proposal. Thank you for giving opportunity to bid on your project…!
€155 EUR in 5 days
4.4 (55 reviews)
5.7
5.7
User Avatar
Hello. More 20 years programming experience. May I suggest any other solution (perl, python) or you insist on php? Regards. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
€155 EUR in 3 days
4.9 (18 reviews)
4.7
4.7
User Avatar
Hi, I am a Web Designer and Developer with more than 7 year experience. I have worked as Web Design & concept Consultant. I do care for concept, typo, Fonts, color culture, neatness and User friendliness presentation of the Designs. My work Standard includes: W3C Valid XHTML/HTML/HTML5 Transitional Table-less CSS markup, W3C Valid and optimized CSS 3, effective jQuery/JavaScript Compatible with IE, Firefox, Opera, Chrome, Safari and all mobile device such as tablets iPad, Android Tablet, BlackBerry Playbook and others. I have completely understand your requirement and I am sure that I have complete with best quality with your satisfaction. Let's initiate the PMB so we can discuss on different approach and provide you best solution in minimum time frame. Looking Forward work with you. Regards, WEB RSS
€155 EUR in 3 days
5.0 (11 reviews)
3.9
3.9
User Avatar
Hello, i am ready to start working from tonight. If you are interested in hiring me, please feel free to contact me!
€200 EUR in 3 days
5.0 (6 reviews)
3.0
3.0
User Avatar
Hello, I've more than 10 years of experience programing with php and linux. I can help you with this job without a problem
€125 EUR in 1 day
4.8 (2 reviews)
1.1
1.1
User Avatar
A proposal has not yet been provided
€68 EUR in 3 days
5.0 (1 review)
0.2
0.2

About the client

Flag of SWITZERLAND
Seewen, Switzerland
5.0
10
Payment method verified
Member since Dec 19, 2012

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.