In the process of troubleshooting a problem with mysqldump I was viewing MySQL backups using Notepad++. I typically view and edit large files using Linux with vi however in this scenario it was more convenient to view the files quickly from a Windows laptop using Notepad++. The first couple of backups were between 50MB and 100MB and while they were a bit slow to open with Notepad++ they did open without further issue and provided an easy method to search through the files.
Eventually I backed up a database file that ended up being 195MB of pure SQL such as mydatabase.sql. When attempting to open this file with Notepad++ I received the below error.Details