Please Tell me I haven't Wiped EVERYTHING ! - MySQL Wordpress Issue - DAMNIT !

by Melodican

Posted: 14 years ago 14 replies

INTERNET MARKETING

Hey guys

I'm a purely html guy and have recently started using WP to host and manage my sites. I have a really good profitable blog in the 'health' niche thats taken around 6 months to build into a 5 figure business. I started installing Ultimate footer ad to test out my conversion rates giving away a free offer and head to tread into the unknown waters of config.php and install files.

Foolishly, at 5am with tired eyes, I went to my Cpanel, deleted my old Mysql database (Why !?) and created a new one upon which to install UFA, I edited my config.php to align with the new database info & I started getting error message "Could not connect to a database".... hmmmm

I Managed to fix that problem thanks to youtube, but now whenever I type my domain name in, I'm gettin the wordpress installation screen and a subdomain of /wp-admin/install.php

Today:

Drip bleeding content for the next 6 months - 5 hours
Monetization and list building strategies - 3 hours
Product Creation - 3 hours
Traffic Generation - 3 hours
Submission to ping, social media and bookmarks - 2 hours

I'm such a f***ing idiot - Please tell me I haven't just deleted everything on my blog....

oints Gun To Head Emoticon:

#damnit #issue #mysql #wiped #wordpress

lostdeviant 14 years ago

Deleting your database means you are starting over (where did you think all those entries were stored?). Never use the control panel when you are sleepy especially phpmyadmin.

I don't suppose you ever backed up your database during the last 6 months that you could import back?
- Thanks
{{ DiscussionBoard.errors[1920070].message }}
JasonB 14 years ago

Sometimes your hosting company can recover anything you had deleted.

I now that my hosting company stores and can get anything I deleted up to 7 days prior to. Holla at yours..
- Thanks
- 1 reply
Signature
You Won't Believe What This Guy Did To Make A Coffee Table Out Of $6,525,657.88!

Google First Page Top 10 Rankings - Where Sites Learn To Fly!
{{ DiscussionBoard.errors[1920076].message }}
- Rupps 14 years ago
  
  Not that it will help a lot, but google probably has your pages cached. I had to resort to that once to get my content back.
  
  Thanks
  
  {{ DiscussionBoard.errors[1920081].message }}
cashcow 14 years ago

OMG - I feel for you!

Hopefully your hosting co has a backup, but ask them right away in case they overwrite it every 24 hours or something!

I'll keep my fingers crossed for ya'

Lee
- Thanks
Signature

Gone Fishing
{{ DiscussionBoard.errors[1920737].message }}
sbucciarel Banned 14 years ago

Well, if you've deleted your database, you've deleted all your posts, categories, options, configuration for Wordpress, etc. All that is left is basically your wordpress files, and an empty database with Ultimate footer, whatever that is.

Ask your host if they can back it up for you. Never touch a database until you have exported it to your hard drive so that you can restore it if need be.
- Thanks
{{ DiscussionBoard.errors[1920751].message }}
Istvan Horvath 14 years ago

As others already told you:

1. First thing in such cases (before posting in the forum!) contact your hosting company and ask them about their MySQL backup!

2. Always make a manual backup BEFORE messing around with your database! No exception.

3. phpMyadmin is a very, very powerful tool! It can be very helpful and very dangerous in the same time... Show it the proper respect = knowledge about it

4. When you install different scripts no need to touch any of the existing databases: just create a new one for each of them. (If you run out of databases - some hosts limit how many you can have - use the same DB, just have different prefixes for the tables for different scripts.)

Did I say BACKUP your database before doing anything in it???
- Thanks
Signature
{{ DiscussionBoard.errors[1920762].message }}
Gary King 14 years ago

Sorry, this is not fun...

I'm repeating some advice that has been given but it's a stream of consciousness I'm sharing, not trying to ignore the other posters'...

Contact your web host for restore - that's the best option.

Presuming there's no backup available (yikes!) -
Google may have a cache you could copy/paste as new posts.

You can try using the Internet Archive to see historical views of your page and copy/paste them as new posts. Internet Archive: Free Movies, Music, Books & Wayback Machine it's right in the middle of the page called "the way back machine".

Moving forward:
If your host doesn't do regular (at least weekly) backups, you should do an export of your database yourself and store it on your computer.

Please consider doing so even if the host does backups - hey, no one will take better care of your stuff than you could - I've seen hosts perform backups that for some reason didn't restore properly.

Not trying to add salt to the wound, it's just a forward looking thing when you get through the nasty part here. Hope it helps!
- Thanks
Signature

===========================
OFFLINERS! Warning: Unless You Know These Pricing Secrets, You are Leaving THOUSANDS on the Table. Get Your Free Report Now.
{{ DiscussionBoard.errors[1920777].message }}
aa411853 14 years ago

Even better I'd recommend an automated backup with one of the R1SOFT services. Or with a cloud backup to Amazon s3. It usually only takes a person one time to learn that you can never have too many backups when something like this happens.
- Thanks
Signature
HPBacklinks.com - Homepage Backlink Marketplace
{{ DiscussionBoard.errors[1921135].message }}
Melodican 14 years ago

Sorted, my hosting account are going to back up to end of February...

I've missed out on afew days of work on the site, post wise, but I can add them again no problem.

Cheers for your concern guys

:-)
- Thanks
{{ DiscussionBoard.errors[1921764].message }}
sbucciarel Banned 14 years ago

Good ... glad to hear that.
- Thanks
{{ DiscussionBoard.errors[1922122].message }}
whippet75 14 years ago

I take it you have a recent backup ?????
- Thanks
Signature

*******We have made Thousands of dollars with this Method*******
>>> Now our Secrets are Revealed <<<
****Click this Link to Find out our Secrets****
For our WSO, Click Here
{{ DiscussionBoard.errors[1922142].message }}
Gary King 14 years ago

Glad to hear you have a backup that won't put you out of biz to fully recover from...

I hope you can move forward with more frequent ones (again, no salt shaker in hand, just these are the times that make a catalyst for change).

Happy you're running again.
- Thanks
Signature

===========================
OFFLINERS! Warning: Unless You Know These Pricing Secrets, You are Leaving THOUSANDS on the Table. Get Your Free Report Now.
{{ DiscussionBoard.errors[1923030].message }}
Melodican 14 years ago

Awesome !!

Cheers for the support guys. Luckily I have a folder of all my posts so I've just dripped them all in over the next 6 months... Aaahhh.. The arduousness of it has definitely reminded me to keep a regular backup of everything !
- Thanks
{{ DiscussionBoard.errors[1923138].message }}
seasoned 14 years ago

BTW there is usually NO reason to delete a database. I deal with this for a living and most customers just build on what they have. They MAY truncate/drop tables, etc... but RARELY a database. MYSQL generally stores a database AS and IN a directory. That is appropiate, since that is basically what a database is. And SOME people may have several apps running out of the same database for all sorts of reasons.

What you did COULD have been FAR worse.

Steve
- Thanks
{{ DiscussionBoard.errors[1923241].message }}