Hi, I always backup MySQL to my PC, what program do I use to read the SQL file? Yes I know of Notpad, but that's all imcrpted, and Wordpad works just fine, but when I do CTRL A CTRL F it crashes. So is there a SQL program out there that reads SQL files correctly? Thank you.
sql files are just plain text files and you need any text editor to open that and all editors reads sql files correctly if they are within those editor's memory limits.
As already said, they are plain text so any plain text editor can open and read the file, subject to its size. There are applications like Notepad++ that will colour code scripts like SQL to make them easier to read but they ultimately are just text editors too
Better use any free editor like Editplus. You can even notice the key terms of the mysql and this will let you know if any external crashes. Its free only.
You could always put MySQL on your PC and import it? Then you can query it in the way it was intended? But for text editing I like Notepad++ on Windows, TextWrangler on Mac and gEdit on Linux - all of them are free and can cope with pretty large files.