PDA

View Full Version : Reading the sql file..


Zacarias
2-27-06, 04:56 PM
I have a forum and I accidently deleted a section.. I was wondering what program I could use to open the sql file and only pick out the queries that I need..

I used Notepad before, but it's taking even longer to open the file, to the point of hours. Is there an easier way?

extras
2-27-06, 06:36 PM
If you know how to use MySQL:
Create a new DB, import the data into that DB, and then delete the portion you don't want or create new table with the portion you want.

If you know how to use grep, you can select lines that match certain criteria.
You can do the same with sef, perl, python, and so on.

Some editors have search & replace features.
You can use it to eliminate the part you don't want.

Probably, there are many other ways.
Pick the one you like. :)