Find Jobs
Hire Freelancers

MySQL / mysqldump.exe - Archive and Delete Script

$30-250 USD

In Progress
Posted over 3 years ago

$30-250 USD

Paid on delivery
We need a PHP script that will archive (csv file) and delete records from a MySQL database using mysqldump.exe. The PHP page should accept a date value and archive/delete everything up to that date. Some of the tables do not require archiving.. only delete is necessary. These will run on a Windows server running XAMPP. Our design idea is to have two sections with a single drop down that contains the table names to process as well as a date field to fill out and a submit button that will initiate the process. Section one will contain the table names where only delete is necessary. Section two will contain the table names where archive AND delete is required. The user would select each table they wish to process, provide the date to delete records for, and process each table that way. I have attached a screenshot to illustrate this better. For reference, here are the tables that would be required in this script. (D = DELETE ONLY, A/D = ARCHIVE & DELETE) - All tables have date fields to use as a reference for processing: label_requests - D label_requests_zpl - D pick_timecard - D shipment_details - A/D shipment_headers - A/D so_salesorderhistorydetail - A/D so_salesorderhistoryheader - A/D pick_history - A/D pick_history_headers - A/D
Project ID: 27849271

About the project

25 proposals
Remote project
Active 3 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, I'm an experienced PHP developer. I'm willing to do this project for you for 120 bucks. I'll use PDO library to interact with the MySQL database instead of relying on [login to view URL] utility. I'll create a layout for the webpage similar to the one you've shown in the attached screenshot using Bootstrap CSS framework but I'll also add a file upload box to upload a CSV file. I'll also provide you a date selector so you can easily select date. For CSV files I'd like to know whether there is a one to one mapping between table field names and CSV header names. Or do I have to provide a mapping between CSV header names to table field names. If you think I'm suitable for you project and would like to discuss it with me then send me a message even when I appear offline. I usually reply back within a few minutes when online otherwise within a few hours when offline. Thank you!
$120 USD in 2 days
5.0 (55 reviews)
6.2
6.2
25 freelancers are bidding on average $138 USD for this job
User Avatar
Hi, my name is Josef, i'm professional developer from Czechia, and i would like to offer you my services. I understand your requirements, and i'm completely confident i can easily deliver this project to your full satisfaction quickly and without errors. I'm looking forward to our cooperation. Regards, J.
$140 USD in 2 days
4.9 (269 reviews)
7.4
7.4
User Avatar
Hi, there. I just read your job description properly and understand what you want. If you want I can start your work right now. I am highly interested to work for you. We have finished many projects like this. If you didn't select anyone for this project, you may knock me for more discuss. Best regards
$140 USD in 7 days
5.0 (55 reviews)
6.9
6.9
User Avatar
I read your project description very carefully. I can create required PHP Script as per your requirements. I am available and I can start immediately. Thank You, Amanat
$100 USD in 2 days
5.0 (394 reviews)
6.9
6.9
User Avatar
Hello, I can do your project in a day and I can start work right now. As I worked many php & query projects, this is really piece of cake for me So I hope you can hire me and let’s make a deal. Thanks.
$140 USD in 1 day
4.6 (52 reviews)
7.0
7.0
User Avatar
Hello, I am php mysql expert, i can help you to make the php script based on your requirement, i will complete this project within 48 hours timeline Kindly ping me for further disucssion Thanks
$120 USD in 7 days
5.0 (68 reviews)
6.4
6.4
User Avatar
Okay sir, I will provide user interface with dropdown for mysql table selection . a Button to initiate archive/delete process of table records as per CSV file and conditions . I have some doubts about CSV . Please let me know sir, when you here . thank you .
$180 USD in 4 days
5.0 (51 reviews)
5.7
5.7
User Avatar
Hello, How are you? I checked your job description carefully. *****I am a PHP,MySQL expert*****. I have 7+ years rich experience in web development using these skills. My main skill is to create user-friendly UI and fast, high-quality backend, and fast fix issues. I had worked on several website and APP developments for domestic and foreign companies. As a top developer, I promise a brilliant service for you. I can complete the project at the desired level perfectly. And I'm always ready for you and I can start right now. I will wait for your response and hope for a long term relationship with you. Thank you. Pavel.
$140 USD in 1 day
4.8 (23 reviews)
5.5
5.5
User Avatar
Hello I'm very interested in your project and will provide you 100% quality work. I have enough experience in php, mysql. I want to discuss further via chat. I'm ready to start work immediately. Thanks
$140 USD in 1 day
5.0 (12 reviews)
5.3
5.3
User Avatar
Hello, I have gone through your requirements and understand what you need. I am a Web developer with 7 years experience I have used a lot of technology to implement my clients solutions. List of Services that i can help you - Build custome web applications using Native PHP with all php versions - Build custome web applications using PHP Frameworks ( Codeigniter - Laravel - Cakephp) - Using PHP CMS ( Wordpress - Drupal - Joomla) - Website Management - Server or Website maintenance and technical support - Data Scraping - RestAPI - SDK ( google map - Facebook - Twilio ) - Version control using (Git - Bitbucket) I look forward to speaking with you about this opportunity. I'm mostly on the internet, we can talk there in a fast way. Thanks & Regards Elia Fawzy
$180 USD in 5 days
5.0 (58 reviews)
5.5
5.5
User Avatar
Hi there, Thank you for this wonderful opportunity. I am Lesia. I have reviewed your project requirements very carefully. I am an experienced web developer. Over the last 6 years, I have developed & designed a wide range of websites using my core skills Wordpress, Woo-Commerce, Open Cart, Magento, Prestashop, BigCommerce, Wix, HTML5, CSS3, Bootstrap, Shopping Cart, Web Design, Jquery, Ajax, JavaScript. I am seeking opportunities to build websites from the ground up for you or your business. I can do any website you want. My mode of work: 1. I will upload codes to your server on regular basis, so that you know the exact status of the project at any time & don't have to wait till the end to see the website look, feel & functionality in the making. 2. All codes are tested. So you will get flawless codes. 3. I'll be in touch with you daily all through the duration of the project. I will give you a guarantee for Work Quality and tiame frame and will maintain also efficiency. Looking forward to your positive reply. If you hire me, you will get a real talent developer. Best Regards
$250 USD in 3 days
4.8 (9 reviews)
4.9
4.9
User Avatar
Hello, I have read your task specification carefully and I am very interested in your job. As a senior web developer, I can do your task in a short time successfully. Please feel free to discuss about your task details. Thank you. Regards. Brittany.
$150 USD in 2 days
5.0 (5 reviews)
4.6
4.6
User Avatar
Dear client, I have lot experience in same kind of task.. I can do.. Please contact me.. Thank you.
$40 USD in 2 days
5.0 (33 reviews)
4.4
4.4
User Avatar
Dear client. I have read your description carefully and very interesting in your project. I'm a PHP developer with 5+ years of experience developing applications under both web and mobile environments. I have keenly interested in algorithm-level efficiency and have rich experience working both with front-end and back-end technologies using PHP frameworks. I also take great care & interest in creating APIs and take a position in back-end development with my strong experience with Magento, Laravel, CI, WordPress and NoSQL or relational databases with complex taxonomies. I am sure I can give you perfect results on time and I hope to discuss your project on your chatting. Best regard. Yustina G.
$140 USD in 7 days
5.0 (6 reviews)
4.4
4.4
User Avatar
Good Day use my 10 years of experience My areas of Specialization includes: . Website Designing / Development (ReactJs, PHP, Laravel, WordPress, HTML5, CSS, AngularJs) will send you details about my past project just ping me and release payment after satisfaction project complete
$220 USD in 5 days
4.8 (16 reviews)
4.2
4.2
User Avatar
Hi, Caig L. I have rich experience in php and my sql. I have developed many websites and the results were good. I am very familiar with php and my sql. I have read your description and I can make the scrip that you want. If you hire me, you will get good result in short time. Let's discuss via chat. Regards!
$150 USD in 3 days
5.0 (6 reviews)
3.0
3.0
User Avatar
⭐Dear, client.⭐ Pleasure good to bid you. I am a professional ⭐PHP, MySQL & Top design⭐ expert⭐ with rich experiences that built many sites using ⭐Wordpress, CI, Laravel, ⭐MySQL, Yii, OctoberCMS, CakePHP, etc for ⭐7+ years⭐. I am also working with ⭐Angluar, Node.js, Vue, ⭐React, Django, MEAN, MERN, MySQL, NOSQL, MongoDB⭐. I can complete your project perfectly. Let's discuss more details via chat. Thanks & Regards.
$140 USD in 7 days
5.0 (4 reviews)
1.9
1.9
User Avatar
Dear SIr, I have reviewed your requirements about script and looked at the attached image I am confident about your project ,I can do you task within 5 days that will cost you 50$.lets have some chat to knot the deal. looking forward to work with you. Regards, Ahmad
$50 USD in 5 days
4.8 (1 review)
1.5
1.5

About the client

Flag of CANADA
huntley, Canada
5.0
137
Payment method verified
Member since Aug 24, 2005

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.