 | MEMBER LOGIN |
|
|
 |
|
 | SERVICES & FEATURES |
|
|
 |
|
 | THE 20 LATEST PROJECTS |
 | POPULAR NEW PROJECTS |
|
|
Project: MySql Large DB Expert Needed ID: 1209355277 |
|  |  |  |
 |
| |
|
Status: |
Closed (Cancelled)
|
|
Budget: |
N/A
|
|
Created: |
4/28/2008 at 0:01 EST
|
|
Cancelled: |
5/19/2008 at 0:26 EST
|
|
Project Creator: |
|
|
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.
|
|
Job Type: |
|
| |
 |
|
Messages Posted: 13 |
|
Programmers |
Bid  |
Delivery Time |
Time of Bid |
Rating |
|
|
vnb400 |
$180 |
5 days |
5/11/2008 at 3:35 EST |  (25 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 |  (213 reviews) | |
| lets have at it.
| | |
|
hansashish |
$930 |
15 days |
5/3/2008 at 6:26 EST |  (37 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.
| | |
|
bestandcheap |
$1,000 |
5 days |
4/29/2008 at 5:24 EST |  (18 reviews) | |
| Kindly check PMB
| | |
|
sqlhelpdesk |
$1,000 |
5 days |
4/29/2008 at 0:36 EST |  (30 reviews) | |
|
| | |
|
prayukti |
$1,000 |
15 days |
5/8/2008 at 0:00 EST |  (2 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 |  (3 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) | |
|
| | |
|
submitexpress |
$1,800 |
45 days |
4/28/2008 at 3:16 EST |  (2 reviews) | |
| we can do this,pl check pmb.
| | |
| |