2

I'm dealing with some very massive SQL files and I need to be able to go in and edit them. Are their any editors that work on Windows I can use?

I need to be able to cut out what I don't need and grab the inserts I do need without the system hanging up.

2

2 Answers 2

0

Use phpMyAdmin to work with mysql. It works with a web browser and is quick. You need to set up a Web server for this along with phpMyAdmin. EasyPHP is one such WAMP server with phpMyAdmin included.

1
  • Adminer is a smaller download and easier setup (one file!)
    – TRiG
    Jan 16, 2017 at 12:21
1

There is the MySQL Workbench, but I have not tested it with a large amount of data, yet. It was fine with a few hundred to thousand rows of data, though.

In case you just need a powerful text-editor, you can try Notepad++, in my experience the most performant editor out there.

Not the answer you're looking for? Browse other questions tagged .