Tamamlanmış

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.

Beceriler: Veritabanı Programlama, Linux, MySQL, PHP, Yazılım Mimarisi

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) Singapore, Singapore

Proje NO: #17861322

Seçilen:

web4x4

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 120%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(16 Değerlendirme)
3.9

Bu iş için 20 freelancer ortalamada $233 teklif veriyor

osmanbsd

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(142 Değerlendirme)
7.4
ITPyramid85

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)
6.8
microwebtechs

reply please

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(181 Değerlendirme)
6.4
shiningdevelopor

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(49 Değerlendirme)
6.0
rehmatclick

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(63 Değerlendirme)
5.6
manojmalviya93

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(29 Değerlendirme)
5.0
techradiusptyltd

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
4.7
barrima

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(36 Değerlendirme)
4.9
cma93

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
4.5
parmarnaharsingh

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(47 Değerlendirme)
5.1
nguyentam

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
3.7
huai99

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde1400%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
1.6
Jincowboy9174

[login to view URL] Web Development for Business Growing? My experiences range from building responsive software design that work well cross-browser to Business Goal. I am glad to discuss with you for providing full solution to Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
1.5
in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
1.7
sazzadhossain55

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

in %bids___i_period_sub_35% gün içinde144%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.2
wearefreelancer8

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
haseebabdul695

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] Daha Fazla

in %bids___i_period_sub_35% gün içinde277%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
DaniilSpasov

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
ilaravel

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] https:// Daha Fazla

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.0