extract .sql file

i have a .sql file and i need to extract data from it. I am using xampp server and it allows extracting maximum 16MB file. Can some1 help me to extract data from the file via some method

 

hmmmm so is the db more than 16mb? if so, just break it up to smaller pieaces (tables by tables).

 

but how do i open it?? only then can i break it rite...

 

you can open it using text

 

but im not able to open it as text. its not opening..

 

Hi,

Try open with Notepad++ text editor. You can download from this web page: http://sourceforge.net/projects/notepad-plus/files/.

Rudolf

 

What data do you want to extract? It is only a text file which you can read in a text editor.

 

Try the navicat . It dump your .sql file easily and quickly.

 

Open it by using Mysql Administrator and restore it

 

Search on google with query "big sql dump".

 

If I was you I would create it on a different server to extract data if it is only allowing a set amount.

Use navicat, make a new database, right click on it and click restore from dump and then browse to the .sql file.

If that isn't what you want then double click it, if it asks what program to open with select notepad or wordpad etc.

 

big sql dump

 

i would say import into phpmyadmin and export the stuff u need