Find Jobs
Hire Freelancers

Secure MySQL database import and update process

$30-250 USD

Terminado
Publicado hace más de 5 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 17861322

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 time I guarantee the proper quality of work. I propose to discuss the price and terms. Ready to answer your questions immediately.
$120 USD en 3 días
5,0 (89 comentarios)
6,4
6,4
14 freelancers están ofertando un promedio de $257 USD por este trabajo
Avatar del usuario
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 will check for previous table checksum and will verify if still matches will create a log file where it will write down any row if it could not add Will generate email if row could not be added Will generate email if it hits some bug and aborts After processing any CSV it will store it in new location Aslo it will make sure no other copy of script is running Regards usman
$333 USD en 3 días
5,0 (144 comentarios)
7,4
7,4
Avatar del usuario
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 success, please contact me. Then, I will give you good result. hire me.
$155 USD en 3 días
5,0 (31 comentarios)
6,9
6,9
Avatar del usuario
reply please
$94 USD en 1 día
4,9 (257 comentarios)
6,7
6,7
Avatar del usuario
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 if you want. Anyways after read your project details i want to ask some important questions so please message me for other details thanks ..
$100 USD en 3 días
4,9 (158 comentarios)
6,7
6,7
Avatar del usuario
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 design and develop a real Estate website.I have 6 years of experience in Word Press and MEAN, working as an developer in our town company where I am responsible for managing and upgrading company's web site. I have designed and developed a lot of websites and online games for different industries and clients, e.g. a blockgame. Based on the provided project details, I estimate to complete your project within 3 days after clarifying all requirements, project details and mile stones. I would appreciate working with you. I am looking forward to hearing your reply.
$155 USD en 3 días
5,0 (16 comentarios)
6,0
6,0
Avatar del usuario
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 I have complete knowledge Linux Server Administration and I can provide you full support on this. Let me handle this Thanks waiting for your response
$155 USD en 3 días
4,9 (60 comentarios)
5,8
5,8
Avatar del usuario
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 available so contact me anytime to get started.......... Thanks.
$250 USD en 3 días
5,0 (31 comentarios)
5,3
5,3
Avatar del usuario
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 can add a simple notification channel for you (e.g. SMS, email, slack whatever you prefer) to notify you of the results and/or of error state (e.g. the db was tampered). I could finish all this and set-up a test server for you to test within 24 hours :) Drop me a line if interested. Have a nice one!
$200 USD en 1 día
5,0 (37 comentarios)
4,9
4,9
Avatar del usuario
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 graphic designing give me one chance to please you and i have done various work in website development i have 4 years experince you will be happy with my work thanks :)
$222 USD en 3 días
4,5 (57 comentarios)
5,3
5,3
Avatar del usuario
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 for your project which I feel meets your needs. As a freelance graphic designer,& PHP, HTML, AJAX,JSON,ANDROID,SEO,DIGITAL MARKETING I’m able to offer extremely competitive project rates without sacrificing quality. I m a Motion Graphics Designer, Video Editor and web developer know Adobe Premiere Pro,After Effects and Adobe Photoshop PHP, HTML, AJAX,JSON,ANDROID Working for self at home specially learn skills from internet. If you have any questions after reviewing this proposal, Feel free to contact me if you think i am the right person to complete your project. I am looking forward to work with you.
$100 USD en 10 días
3,6 (3 comentarios)
2,3
2,3
Avatar del usuario
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 ways to import the report into the database. The accessing issue can be done by proper authorization. Let me know if you are interested thanks
$1.400 USD en 10 días
5,0 (2 comentarios)
1,6
1,6

Sobre este cliente

Bandera de SINGAPORE
Singapore, Singapore
5,0
2
Miembro desde sept 29, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.