mysql database is gone!

[atarata]

After update, all tables are gone in the main database of my account. Does anyone know what's happened? Is there anyway to get them back? The data was collected over time and there's no other backup. I will appreciate anyone can give me some help.

 

[Gouri]

After update, all tables are gone in the main database of my account. Does anyone know what's happened? Is there anyway to get them back? The data was collected over time and there's no other backup. I will appreciate anyone can give me some help.

Can you see the database and tables in your phpmyadmin.

 

[pennycsf]

I too have lost my MySql database - the size is shown as 0.00mb in cPanel, and any attempt to log in displays:-

General Error

SQL ERROR [ mysqli ]

Table 'pennycsf_forum.phpbb_config' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

I have followed Corey's advice to add % to the hosts in "remote mysql" - no difference!!

 

[Gouri]

I too have lost my MySql database - the size is shown as 0.00mb in cPanel, and any attempt to log in displays:-




I have followed Corey's advice to add % to the hosts in "remote mysql" - no difference!!

Can you provide the link,

As per my knowledge the http://csf-forum.org is working fine.

Check

 

[pennycsf]

The x10 site link (the failing database) is http://csfsudforum.x10hosting.com/phpBB3/index.php , not csf-forum.org

 

[twiztedstudiez]

I'm having the exact same problem. Both my forum and users database is showing, but the tables have been wiped clean. It's kind of frustrating since I spent a while working to get everything set up then at the end of the day have it all wiped out.

http://twizted.pcriot.com/forums/

 

[Gouri]

The x10 site link (the failing database) is http://csfsudforum.x10hosting.com/phpBB3/index.php , not csf-forum.org

When I clicked your site URL I saw the forum folder and I clicked it. http://csfsudforum.x10hosting.com/phpBB3/ And it showed that the forum moved to csf-forum.org So I quoted it.

Anyway

Do this.

Goto mysql Databases and

drop the user(Don't delete user or database)

Then re assign the user to database by giving all privileges.

This should work.

 

[pennycsf]

Do this.

Goto mysql Databases and

drop the user(Don't delete user or database)

Then re assign the user to database by giving all privileges.

This should work.

Did all that - no difference - db size still 0.00mb

 

[twiztedstudiez]

gsonline,

I tried your advice and it didn't work. I'm still receiving the same error like pennycsf. Any other suggestions?

 

[pennycsf]

Some more info - looking at phpMyAdmin, only 6 tables exist, when there were about 50 before.

I assume the database is lost without hope!!

 

[crystal key ministries]

This happened to me too. The DB was there. It appeared the tables were there and the structure was fine. It appears that the contents got 'nulled' out and 2 days of data and testing were obliterated.

Now I'm getting after the re-install and re-creation of the databases and users, that it cannot find a PHP script for the database. Is this related?

 

[pennycsf]

No answers????

As the man said, anything free is worth exactly what you pay for it!!!!!!!

 

[Gouri]

No answers????

As the man said, anything free is worth exactly what you pay for it!!!!!!!

After observing the Error the tables has lost. Do you have the database backup? then try to restore it. So the tables will be restored back.