tj0001

FYI - a similar thing happened a while back - in that instance one of the support guys recovered the site for me. So I'm just wondering if "helionet" has a proper backup of the DB as it must have had then, to have been able to restore the site then?

Thankfully though, this is only a small site so I better start rebuilding it now

Thank you for your reply.

I updated the wp-config.php for 'DB_NAME', DB_USER and DB_PASSWORD with the new values.

I've gone through the procedure you mentioned, but it is still asking for a fresh wp-install.

As I said in my previous post, this database backup seems empty - please note the message I got after importing the backup:

-- MySQL dump 10.13 Distrib 5.6.21, for Linux (x86_64)
--
-- Host: localhost Database: tj0001_wp896
-- ------------------------------------------------------
-- Server version 5.6.21

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows).

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;# MySQL returned an empty result set (i.e. zero rows).

/*!40103 SET TIME_ZONE='+00:00' */;# MySQL returned an empty result set (i.e. zero rows).

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;# MySQL returned an empty result set (i.e. zero rows).

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=[...]

Thanks for your reply.

Yes, I did exactly as you say. I unzipped the FB but the the database is only 1KB - is this not too short?

The following is the response I got after I did a restore:

Restoring Database

Determined database name from sqlRestoring database “tj0001_wp896”--------------/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */----------------------------/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */----------------------------/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */----------------------------/*!40101 SET NAMES utf8 */----------------------------/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */----------------------------/*!40103 SET TIME_ZONE='+00:00' */----------------------------/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */----------------------------/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */----------------------------/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */----------------------------/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */----------------------------/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */----------------------------/*!40101 SET SQL_MODE=@OLD_SQL_MODE */----------------------------/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */----------------------------/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */----------------------------/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */----------------------------/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */----------------------------/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */----------------------------/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */--------------

Sorry, I don't follow why I have to re-create the database if I've just restored it?

And please can you elaborate what exactly you mean by "reassign the user to db" - Do you mean "delete/re-add User To Database" or "re-entering the user password details" in the wp-config?

Edit: After importing the database in phpMYAdmin it's now asking me to install the WP-Software and it's not picking up my existing site.

I can now get into phpMyAdmin - when I click on the database, there are no tables there.

Any idea how to get my site back?

Also, I did a full backup prior to the crash.

Hello,

My DB is not working - I deleted the old DB and User and created a new DB and User.

I've added the User to the DB and.......updated the WP-Config file with the new data/password

But........ when I try to run "phpMyAdmin" it hangs and won't enter the application.

I would appreciate your help very much.

Thank you.

Tj0001

Hello,

I seem to have lost my site as it's asking me to load Wordpress software when I type my site's URL.

All my sites WP files are there as before. Any idea how I can get my site back please?

Thank you.

Everything is working Ok now. I can't believe I've got my site back

Thank you all.

Hi Krydos,

Thanks for your reply.

After having changed the password, I can now login to phpmyadmin and see the database.

I also changed th password in my wp-config accordingly but I still cannot connect to the database -

From mysql menu, the database is showing as having a zero size, so what should I do now please?

Thank you.

Hi,

Could you kindly restore my database please as I don't have a backup.

account name: tj0001

DB_NAME = tj0001_wp896

Server: Stevie

Thank You.