Sedang Disiapkan

218650 MySql Large DB Expert Needed

I am looking for someone with good mysql experience. Preferably dealing with over 100 million records.

I have 4 files that all carry the same format. I need help importing this info into mysql & making sense of the info, providing 2 simple mysql search queries after I can import the files into mysql sucessfully.

So far, I am able to import 3 out of the 4 files. The 3 files I have imported into the database are under 1GB in size. The one I cannot import is [url removed, login to view] in size. It seems to hang my system, although it is capable of handling this file size.

The files I am importing must be imported every 24 hours. Same format & same info, however some of the lines in the files will have changed. I must then pull a report for all changes.

I would also like to be able to do a "keyword search" across the above 4 databases.

If you'd liek to bid, I can show you my databases & their contents. For future reference, here is the commands I am using to import the file into mysql:

mysql> LOAD DATA INFILE 'C:/xampp/php/[url removed, login to view]' INTO TABLE table;

I would like help in comparing the databases daily.

Kemahiran: Semua Boleh, MySQL, PHP

Lihat lagi: xampp mysql import, mysql data files, Xampp, mysql report, import mysql, report mysql php database, mysql search table, php mysql load table, php load table, mysql amp, mysql help table, mysql search database table, search across, php mysql amp, large file, 100 million, mysql data import, import needed, expert xampp, report mysql database using php, daily report php mysql, php mysql database report, help contents mysql, expert format, mysql load data infile

Tentang Majikan:
( 11 ulasan )

ID Projek: #1964883