How to open .sql file in Notepad++

They have: 9 posts

Joined: Apr 2009

Hi!

How can I open a .sql file with notepad++, so that it can be edited?
Also, I made a backup with wp-backup-plugin and got a .sql.gz file... What kind of extension is this and what should I do with it?

pr0gr4mm3r's picture

He has: 1,502 posts

Joined: Sep 2006

The .gz means that it was GZipped or compressed. Windows can't natively uncompress it, so you need another program to do it. I recommend IZarc for managing compressed filed in Windows.

Once you have the file extracted to wp-backup-plugin.sql, you should be able to open it in Notepad++ like a regular text file. (Right-click the SQL file and select "Edit in Notepad++" if Notepad++ isn't your default text editor)

Be careful though, if it's a large backup file, it may slow down or freeze up your computer when the file is opened.

They have: 9 posts

Joined: Apr 2009

Thanks so much for your help! It worked fine Smiling

sequencehosting's picture

They have: 24 posts

Joined: Feb 2010

Great information guys thanks for sharing with the community!

They have: 1 posts

Joined: May 2010

Helpful find for me as well. I needed to do that.

They have: 22 posts

Joined: May 2021

Open notepad and type in the SQL code. When you save the file, save it with a .sql extension - “.sql” and remember to use double quotes when you save it.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.