HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)

- General (http://www.howtoforge.com/forums/forumdisplay.php?f=15)

- - Urgent! Website MySQL DB disappeared (http://www.howtoforge.com/forums/showthread.php?t=27581)

Urgent! Website MySQL DB disappeared

I am using ISPConfig 2.2.25. I was trying to move a website to a different client and it removed the mysql db. I moved it back and found the db in the recycle bin. I used the built in restore feature but the db is empty and all tables are missing. Please help!! It is urgent I find these data tables and restore them. Any help would be greatly appreciated.:confused:

Something simular happend to me:
Here: http://www.howtoforge.com/forums/showthread.php?t=27575

Most likely the client were you moved the site to belongs to a reseller without the privelige to have mysql databases or the max. number of databases for this reseller is exceeded.

Something similar happened also to me! I was forced to use an external backup to restore the DB, it is very very unpleasant and very very disturbing when such things happen....

Quote:

Originally Posted by till (Post 149011)

Most likely the client were you moved the site to belongs to a reseller without the privelige to have mysql databases or the max. number of databases for this reseller is exceeded.

cannot be something like "pre-check" be made, when moving around databases?

For me this is a serious leak

again losing isp_db during update

It happend the secound time now, that I lost the isp_db during the ISP-update process. I upgraded from 2.2.26 to 2.2.27 and got this message:

Code:

Connected successfully to db isp_db

mysqldump: Couldn't execute 'show fields from `del_status`': Got error 28 from storage engine (1030)



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/src/install_ispconfig/install.php on line 820



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/src/install_ispconfig/install.php on line 828



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/src/install_ispconfig/install.php on line 833



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/src/install_ispconfig/install.php on line 843



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/src/install_ispconfig/install.php on line 860



Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/src/install_ispconfig/install.php on line 1175

I could not log in into ISP an the hole ISP database was gone.

Why the ISP-updaterocess kills the database?

The error message is from mysql and not ISPConfig and means that the harddisk is full.