MySql Large DB Expert Needed
Project ID: 1209355277
Project Details
- Status: Closed (Cancelled)
- Posted: 4/28/2008 at 0:01 EST
- Cancelled: 5/19/2008 at 0:26 EST
- Project Creator:
- Budget: N/A
- Description: 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 5.9GB 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/file.txt' INTO TABLE table;
I would like help in comparing the databases daily. - Tags:
| Project Bids |
| Programmer | Bid |
Delivery Time | Time of Bid | Rating | |
| vnb400 |
$180 | 5 days | 5/11/2008 at 3:35 EST | (32 reviews) |
|
| kindly refer PMB, Thanks | |||||
| lookfie | $200 | 12 hours | 4/30/2008 at 3:29 EST | (5 reviews) |
|
| bogo | $200 | 2 days | 4/29/2008 at 6:56 EST | (No Feedback Yet) | |
| I can do it without problems. I'm dabase administrator, with 6 years. Thanks. | |||||
| raydon202005 | $200 | 3 days | 4/29/2008 at 1:28 EST | (No Feedback Yet) | |
| I can do it in 3 days... best regardz... | |||||
| coderxo |
$400 | 7 days | 4/28/2008 at 11:02 EST | (370 reviews) |
|
| lets have at it. | |||||
| hansashish | $930 | 15 days | 5/3/2008 at 6:26 EST | (69 reviews) |
|
| Hello speed4life, I read your requirements. We are a group of designers,developers, who are experts in .NET(C#),php,AJAX, flash,FLASH MEDIA SERVER, AMFPHP Remoting.Please see PMB for sample urls. | |||||
| sqlhelpdesk | $1,000 | 5 days | 4/29/2008 at 0:36 EST | (60 reviews) |
|
| bestandcheap | $1,000 | 5 days | 4/29/2008 at 5:24 EST | (18 reviews) |
|
| Kindly check PMB | |||||
| prayukti | $1,000 | 15 days | 5/8/2008 at 0:00 EST | (6 reviews) |
|
| Kindly check pmb. | |||||
| squareframe | $1,500 | 25 days | 4/28/2008 at 13:24 EST | (77 reviews) |
|
| Please check pmb for details. Thank you. | |||||
| aruhat | $1,500 | 30 days | 4/28/2008 at 5:18 EST | (7 reviews) |
|
| Hi, Please check PMB for more details. Regards, Shyam | |||||
| skylab | $1,500 | 30 days | 4/28/2008 at 10:39 EST | (No Feedback Yet) | |
| pgcodingtheguru | $1,800 | 45 days | 4/28/2008 at 3:16 EST | (8 reviews) |
|
| we can do this,pl check pmb. | |||||






