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.