Secure MySQL database import and update process

I have a web server that hosts a MySQL database.

On a regular basis (possibly several times a day), I need to update this db with hundreds of records. However, I need the update process to be VERY difficult and/or very secure. Not sure if this makes sense, but I'm thinking something like this:

1) I FTP into the server using SSH and drop a pre-formatted CSV file in a specified directory.

2) the server has a CRON job running that scans for a new upload every 30 seconds or so.

3) The CSV is imported into the db.

4) A results text file report is left in place of the CSV.

I need to know that the database was not tampered with between actions. There needs to be some sort of verification process that checks the db before import, verifies that it matches the previous report, then imports the new CSV and produces a new verification ID.

I'm sure you can easily build me a nice import panel, but that's not what I want. I want VERY limited access. Part of the security of our process will be in the difficulty of actually accessing and writing to the db.

Right now, I can make a CSV, connect to the server with SFTP, drop the CSV in a directory. The rest is up to you.

Attached is a sample CSV file. It includes 3 columns - a bitcoin public key, a Coin ID, and the date of production. This is all the DB will contain, for now - it may be improved later with additional fields, but this is it for today.

So, every day, I generate a new batch of the bitcoin keys, and need to securely update the DB. I do NOT want the DB to be publicly accessible, and i do NOT want any records to change. This is a record of all the addresses I've generated, and it will not change. I will ADD to it, but the data will never be modified.

I can't give you live access to the server. You will have to setup your own test environment that we can use to demo the process. Then, you'll provide install instructions and copy of code to make it work.

Please let me know if you have any questions.

Skills: Database Programming, Linux, MySQL, PHP, Software Architecture

See more: export mysql database command line ubuntu, copy mysql database from one server to another windows, mysql migrate all databases and users, mysql import database, mysql database migration from one server to another, copy mysql database from one server to another remote server, how to copy mysql database to another computer, copy mysql database folder to another server, mysql huge database import, javascript mysql database update click, update mysql database web form godaddy, mysql database import gigabyte, php copy mysql database online update database local, mysql database slow update records, magento mysql database import products, mysql database trigger update send email, cacti mysql database import, secure mysql database, secure mysql database markers google maps, php script mysql database import sql file

About the Employer:
( 2 reviews ) Singapore, Singapore

Project ID: #17861322

Awarded to:


Hello! Let's work. I have experience in implementing similar tasks. I will make it with PHP and PDO. I'm new here (but not a beginner in my profession), so I'm ready to perform inexpensively, but at the same tim More

$120 USD in 3 days
(45 Reviews)

17 freelancers are bidding on average $246 for this job


I can do that for you in Perl. I will write a script which will process your file check if rows are valid and then insert into DB. Will checksum the mysql table and write checksum in a file Before execution it wi More

$333 USD in 3 days
(143 Reviews)

hello,how are you. i read your bid carefully. i am C#, .Net expert and have full experience for 7 years. C#, .Net is my top skill and my interested skill. I can provide most quality and high fast. if you want to su More

$155 USD in 3 days
(21 Reviews)

Hello nice to meet u I have good skills about csv converter I have good skills about cron job in php I can make your job perfectly I think that your job is good for me I m ready for your job I m attractive fo More

$200 USD in 1 day
(70 Reviews)

reply please

$94 USD in 1 day
(201 Reviews)

Hi, Am Muhammad Ghaffar I have great experience in Database management and make more secure I have read you project details and I believe its very serious project and important for you I would like to work on this task More

$100 USD in 3 days
(95 Reviews)

Hi.. I hope you're doing good. I have read the all work details carefully for the website changes and also checked the attached CSV file. I am an experienced backend database developer and very able to do this wor More

$250 USD in 3 days
(21 Reviews)

As per your requirement, I have expertise in MySQL Database Migration. I can help you in that I have 5 years of experience in this domain and I have done this type of projects much time for my local and remote client.s More

$155 USD in 3 days
(40 Reviews)

Hi, how about a bash script that runs every X (30?) seconds that would verify the db hasn't been tampered, check fo the existence of the CSV file, import it and then create the report file. If you would like, I c More

$200 USD in 1 day
(37 Reviews)

Hi, I'm an experienced web developer. I'm interested in your task and would like to do it. I don't need to ask anything else, your instructions are clear enough for me. I may ask something while working on it. I'm avai More

$250 USD in 3 days
(21 Reviews)

Hi, I have understand what you actully need i will help you out in this i have a very good experience in website development and design. having good skill in php skill php, html, css, mysqli, wordpress and also gr More

$222 USD in 3 days
(52 Reviews)

Dear Sir. I am interested in your job. I am a web developer from Russia who is specialized in Word press,P H P,MEAN,React and so on.I’m applying for your project spec offer for remote working WordPress Developer to More

$155 USD in 3 days
(6 Reviews)

Hello there, Ping me back if the offer is still active, i am very much experienced in the work you need and I have done such documented work before. You can also visit my previous projects. [login to view URL] More

$277 USD in 5 days
(1 Review)

xReady To Help 24x7 MotionGraphics, Video Editor & FullStack Developer Thanks for taking the time to review my proposal! I’ve looked over my notes regarding your graphic design needs, and have created a proposal fo More

$100 USD in 10 days
(2 Reviews)

Hi, I am a professional software engineer based in Singapore. I understand what you need and could provide you with the code and setup instructions. Just let me understand the structure of the report and I can find wa More

$1400 USD in 10 days
(2 Reviews)
$30 USD in 3 days
(3 Reviews)


$144 USD in 3 days
(1 Review)