Secure MySQL database import and update process
$30-250 USD
Betalt ved levering
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.
Projekt ID: #17861322
Om projektet
14 freelancere byder i gennemsnit $257 timen for dette job
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 Flere
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 Flere
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 Flere
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 Flere
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 Flere
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 Flere