Create cron job to prune certain entries in MySQL

$10-30 USD

Cancelled

Posted

over 8 years ago

$10-30 USD

Paid on delivery

Hello, I have a table in MYSQL database in Plesk that would need automatic pruning. All entries in a table have a timestamp, I would like to have entries older than 72 hours automatically deleted every day. You won't have access to the database, I will give you all details (screenshots) so you can create a php file and then tell me which command to enter in the Scheduled Task in Plesk. Quite an easy job :)

MySQL

Plesk

Project ID: 8507652

About the project

10 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

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

10 freelancers are bidding on average $27 USD for this job

@ShiaFirst

DONT AWARD PROJECT BEFORE DISCUSSION, its pretty simple for me but I have few questions to ask, knock me for further discussion, thank you!

$30 USD in 1 day

5.0

(16 reviews)

6.2

@turturkeykey

Hi, I think i can help you with this project. If awarded, i will deliver the file within 2 hours (debugging included). I hope we can collaborate together. Have a nice day.

$25 USD in 0 day

5.0

(55 reviews)

5.9

@harshatilva

Hi, I hope you are doing fine. I am new to freelancing but I have 4 to 5 year experience in designing and developing. I read your project description and would like to work with you. I will provide you 100% satisfaction guaranteed. You can release payment after work is done. My services include Data Migration, Server Transfer, Magento, OS commerce, WordPress, PHP, Designing, PSD to HTML, Jquery, Angular Js and technical support. Awaiting for your positive reply and looking forward to working on your project. Feel free to ask me any question you may have. Thank you,

$30 USD in 1 day

5.0

(37 reviews)

5.3

@TenSidesDev

Hello, I can do that for you, right now... I'm not busy and don't have anything else to do.. so if you interested.. Send me those screenshots I'll get right at it. Thanks, Alek

$20 USD in 0 day

5.0

(8 reviews)

4.4

@RedMoonTech

Hi - I can get this project done for you immediately. Ready when you are. Thanks ............................................................................

$25 USD in 0 day

5.0

(2 reviews)

4.0

@xpoh

Hello! I'm ready to help with this p roject. all I need from u is table names and field name with timestamp. Whill send u finished script in 30 minutes. Contact me to discuss details.

$20 USD in 0 day

5.0

(3 reviews)

2.4

@digitaldock

The SQL you need will be something like: DELETE FROM my_table_name WHERE my_date_column < DATE_SUB( NOW(), INTERVAL 72 HOUR ); You can make it executable without a PHP script as a simple BASH command line: echo "DELETE FROM my_table_name WHERE my_date_column < DATE_SUB( NOW(), INTERVAL 72 HOUR );" | mysql -uYOUR_USER_NAME -pYOUR_PASSWORD DATABASE_NAME

$25 USD in 1 day