Linux How to open a large Database file

ganesh_2218

ganesh_2218

Level E
I have 16 million records in a single csv file which amounts to 36 gb. I need a way to open the file and view the data in it. The data has 500 fields of columns fields. I can't open/view this file without splitting it in Excel 2007 but i was able to split it up in several files and view it.

What software can be used to open the full file and view it. Mysql can be used but how? i don't know nothing abt my sql.

I need advice from u.
 
Any DMBS would be your best bet. MySQL is free so I think that is the way to go. Go through the tutorials on mysql official site for installation. Importing a csv will be a single line sql query, not difficult. Viewing data will also require simple commands like
Code: 
select * from database_name

It is not difficult at all. Try it out and report back if you still face issues.
 
You could bulk insert (SP) to SQL server. Do not open the .CSV file it will corrupt the contents.

1. You should know the column headers in the CSV.

2. And the data types.

If you can get me that, I can give you an easy to run script, which will create the destination table, and pull in the contents. You would need SQL Server installed. I use 2005 which is available free from M$..!
 
Back
Top