 | MEMBER LOGIN |
|
|
 |
|
 | SERVICES & FEATURES |
|
|
|
|
 | THE 20 LATEST 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: |
speed4life
Rating:
 (5 reviews)
|
| 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 Within |
Time of Bid |
Rating |
| vnb400 |
$180 |
5 days |
5/11/2008 at 3:35 EST |
(15 reviews) |
| kindly refer PMB, Thanks
|
| 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.
|
| lookfie |
$200 |
0 days |
4/30/2008 at 3:29 EST |
(4 reviews) |
|
|
| raydon202005 |
$200 |
3 days |
4/29/2008 at 1:28 EST | (No Feedback Yet) |
| I can do it in 3 days... best regardz...
|
| coderextraordinaire |
$400 |
7 days |
4/28/2008 at 11:02 EST |
(128 reviews) |
| lets have at it.
|
| hansashish |
$930 |
15 days |
5/3/2008 at 6:26 EST | 
(26 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 |
(13 reviews) |
| Kindly check PMB
|
| prayukti |
$1,000 |
15 days |
5/8/2008 at 0:00 EST |
(1 review) |
| Kindly check pmb.
|
| sqlhelpdesk |
$1,000 |
5 days |
4/29/2008 at 0:36 EST |
(6 reviews) |
|
|
| aruhat |
$1,500 |
30 days |
4/28/2008 at 5:18 EST |
(1 review) |
| Hi,
Please check PMB for more details.
Regards,
Shyam
|
| skylab |
$1,500 |
30 days |
4/28/2008 at 10:39 EST | (No Feedback Yet) |
|
|
| squareframe |
$1,500 |
25 days |
4/28/2008 at 13:24 EST |
(30 reviews) |
| Please check pmb for details. Thank you.
|
| submitexpress |
$1,800 |
45 days |
4/28/2008 at 3:16 EST | 
(2 reviews) |
| we can do this,pl check pmb.
| | |
