Programs that read MySQL?

Question

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.

Answer 1

Backup your databases in CSV format: you can then read them with Excel.

You can also write a small function in php that creates a csv file to save your data.  It also allows you to restore your data in an easy way.

Answer 2

you need the mysql program.