The other day, I accidentally overwrote an older post. Luckily, I have daily backups running, so it wasn’t too hard to get a backup SQL file. But my backups are all SQL files, so I had to think hard about how to edit one.
I first tried downloading all kinds of database editors that only wanted to connect to a remote SQL database. Since my file was local, I didn’t want this.
As it turns out, the database files weren’t necessary. NotePad and NotePad++ are easily capable of opening text-based SQL files. which only require a search, a removal of \n and \f lines, editing of \” lines, and then a reposting onto WordPress.
Kind of a “duh” moment. Try what you have before you go wild with useless effort.