MySQL - Anyway to read it?
Hi,
I recently backed up a MySQL Database for one of my websites, and like right after that, I added two articles to my site. Upon doing so, though, I accidently deleted an article of mine!
I know the MySQL file I downloaded to backup my database still has the article within the file somewhere. It's a gZipped file, and I was wondering if there was any way that I could read the content within that file?
I tried opening the .gz file up in NotePad, but all these strange characters plopped up. I don't want to replace my database, I just want to retrieve one article. Anyway I can do this with a program or something without going online?
Thanks.
James posted this at 23:33 — 12th December 2005.
He has: 127 posts
Joined: Dec 2005
I presume that you have a control panel where you downloaded the backup from.
Ideally you should be viewing it online from your control panel with such programs as phpmyadmin.
But offline is also possible.
Open the gzip with winzip.
It will ask for you to enter an extention. Use .DOC
Then open it with winword.
free-space.net: free cpanel web hosting for new webmasters
sitemanaged: click here to visit our site
Premium quality web hosting for the elite webmasters and hosts. (ThePlanet and Savvis networks)
Contact me for a quote today and discuss your requirements.
EGS posted this at 20:19 — 13th December 2005.
They have: 161 posts
Joined: Jan 2005
I don't have WinZip and I really don't want it. I have Windows 2000's .NET installed which automatically reads and opens .zip files on the fly. :x
Any other way to decompress it?
Busy posted this at 20:31 — 13th December 2005.
He has: 6,151 posts
Joined: May 2001
what about WINRAR then - freeware zip/unzipping program
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.