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.
How did you perform the backup? It could have been backed up in a variety of formats depending on the technique or script you used.
recreate the database on a test machine export the article you need to into a new sql file upload the new file to the database with the missing article
What you need to do is download an operating system known as knoppix. Its a bootable linux distribution that boots directly off the CD. Search google for "knoppix iso" or find a magazine at a bookstore or Fry's Electronics. Boot into knoppix by putting the cd in the drive before the computer starts up. You may have to press delete to enter setup and change the boot device order so you can boot from the CD. Once your in, you should be able to open up the file with the archiving tool availible.
ok this is really easy...you don't need to download a Linux operating system to do it, but you do need a tool to read the .gz format. 1. Download and install 7zip (http://www.7-zip.org/) 2. Open to folder that your backup is in and right click the file and choose "Extract to...". You can choose another extract option but this will create a new folder. 3. Open the folder that you just extracted the file to. 4. It might still be in a tar ball. It will have a .tar extenstion. If so right click the .tar file and choose "Extract Here". This will untar the file in the present folder. 5. Once that is done you will have to find the MySql data and then you should be able to open it up in a text editor and find the record you lost. 6. If you don't want all that hassle PM me and I will give you my email and I can do it for you and email you back the MySql file in plain text format. 7. Good Luck.
7-Zip! I forgot about that - I had that installed on my old machine! I believe that I can just decompress it through there and I hear if you save it as a .doc file (or .rtf), I'll be able to read it! I'll see if this works. Thanks man!