Stupid! Stupid! Stupid!

[Riverside]

I have no idea how I managed to do this.

I'm only thankful my site is in experimental stage. Still, it's a major pain.

My site is a Joomla site. I recently created a backup of its database, I could have sworn I had content in it when I made the backup.

I also have phpBB bridge installed. A couple of days ago, I noticed that only two out of 12 experimental accounts I had set up in Joomla were listed as users in the forum. Obviously something went wrong in the database.

In an attempt to correct the problem, I deleted the database, wiped the configuration.php file (installed a blank, I had a backup of the original), uploaded the Joomla installation folder, and ran the Joomla installation with a new (clean) database.

Then I imported the back up database.

BIG problem. The back up, for some very odd reason, has none of the content I added. All the content is the default stuff Joomla come with.

It's going to take a few hours to replace it all copying and pasting, so it isn't a complete loss. The entire site will also have to be reconfigured as well.

My question is:

Is there any way to retrieve the original database I deleted from the server?

I fear I know the answer already...:eek:

Ah, well. Lesson learned. Damn! I could have SWORN I did that backup after the content was added...

Still, if anyone knows of a way this can be done, please let me know in case this foolishness ever happens again.:rolleyes:

[r2b2]

You could try contacting Hostmonster support - they may have some backups as they do dailys and weeklys I think... (Though I don't know their policy on restoring them)

[superiornc.com]

Holy ****, I am not even sure how you managed to do that! If I was to suggest anything I would call the numer, because its much faster than going to the chat section.

[CafeenMan]

With mySQL you can download (backup) just the database definitions without the data. When you're backing up read the whole screen and carefully check your options.

I have apache and mysql installed on my computer so I can run php pages locally and debug them before upload.

My databases are mostly for visitors to post in so I download them regularly. I clear out my local db and import the downloaded data. Then I check it locally to be sure it's there before I mess with the "real" version online.

[shoshanaz]

If you are running joomla, take a look at joomlapack as an extension to help with backups. (If you do, I suggest getting the stable version, as I've had several problems with the beta versions that are there now.) The code is open source at http://www.joomlapack.net

Joomlapack will pack up your whole joomla site, including the database and put it into a zip file that you can download and works from the joomla admin panel.