Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have a single 32GB .sql file and i have to split files in smaller pieces as i have to extract email address string from .sql file. Since file is so huge and i can't wait for long time. Please suggest me for some optimal solution to do this task!! Thank You in advance

share|improve this question
1  
you can use split on unix/linux systems. on windows system tools like zip and rar allows you to zip a file in smaller archives. this seems not to be a database question – miracle173 May 14 '12 at 3:17
Please update the question in response to the points raised and we'll re-open – Jack Douglas♦ May 14 '12 at 8:43

closed as not a real question by Jack Douglas♦ May 14 '12 at 8:43

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

up vote 0 down vote

Do you mean you have a column you'd like to extract from a large SQL file or you have 32GB worth of email addresses?
It does change the approach somewhat as if it's a 32GB SQL file with a column of addresses, then it would be easiest to simply run a query to extract that column from the source data. If it's 32GB worth of email addresses (which I think would be unlikely) then you're better off using linux/cygwin and sed to extract the parts of the email either side of the @ symbol.

If it's unstructured data then you are probably SOL

Either way, only the first choice is potentially an SQL question, and you may get more help asking in the appropriate area

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.