How to open .sql file in Notepad++
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?
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 posted this at 23:38 — 2nd March 2010.
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.
olecranon posted this at 23:22 — 3rd March 2010.
They have: 9 posts
Joined: Apr 2009
Thanks so much for your help! It worked fine
sequencehosting posted this at 11:28 — 24th April 2010.
They have: 24 posts
Joined: Feb 2010
Great information guys thanks for sharing with the community!
mrsandman posted this at 19:14 — 16th May 2010.
They have: 1 posts
Joined: May 2010
Helpful find for me as well. I needed to do that.
ronaldwilcox posted this at 05:11 — 26th May 2021.
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.
josha3 posted this at 14:05 — 28th March 2022.
They have: 6 posts
Joined: Mar 2014
Notepad++
It is a great and simple tool to view and edit any file be it .sql or anything!
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.