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?
Find us on Facebook
Connect with other TWF members on Facebook! We'll also let you know about new articles and interesting forum discussions.
pr0gr4mm3r posted this at 23:38 — 2nd March 2010.
He has: 1,505 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.
PHP Starter | My Blog
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.
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.