Restoring WP from a DB only

[emp]

I am an idiot and just deleted a bunch of my WP files.

So basically, all I have left is the mysql database.

Anyone know what to do?

::emp::

 

[barman]

setup Wordpress as you normally would.

if you're on cpanel, myPhpAdmin -> Import the sql file. If you're not on cpanel then do it however you would through shell.

Then just save a new password with MD5 under the 'users' table

 

[(O_o)]

reupload WP

import sql file

set config.php w db info

BLAM your good

 

[nickCR]

Listen be fucking careful.

Backup your db first through cpanel, phpmyadmin or whatever. Then upload the wordpress files but i strongly suggest you upload the same version you have now. You can upload a newer version but you need to go through the upgrade process.

This does not require the import as suggested if its on the exact same server.

If you want I'll help you do this or walk you through it on screen share or something. Add me to skype nicholasCR

 

[zxcvb]

Whatever else you do: Keep a backup of your MySQL DB first.

MOVE the whole WP directory to somewhere else (as a backup and as a reference).

Now, copy (the original - download if you have to) WP files into the place (which is now empty) reeking of your misdeed.

Create wp-config.php from wp-config-sample.php and edit the values to whatever you gave before. If you don't remember the password, set a new password there and then go to phpmyadmin and set the same password (make sure to select MD5) there.

You should be alright, except for the loss of plugins and themes. For them, you will have to copy them over and install again.

 

[nickCR]

Your host should have a back-up ask them to restore it. That's another option

 

[emp]

Thanks for all the advice, guys... will test and report back.

This is a personal site, so no revenue lost, still, it is shit I'd love to have back.

::emp::