HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   Restore deleted databases (http://www.howtoforge.com/forums/showthread.php?t=28776)

sojic 18th November 2008 00:57

Restore deleted databases
 
I should to transfer some sites from 1 to 2 reseller.

I create new reseller (but forget to "assign" databases"), so when I transfer sites, I receive message like "this reseller do not have enough databases", and database was deleted.

Then I assign more databases to target reseller, I find database in recycle, try to restore, but nothing happens.

Is it possible to "find" deleted database(s) somewhere? (I do not have backup)

till 18th November 2008 11:47

ISPConfig is not taking a backup of databases, so if you dont have a backup i fear that the data is lost.

sojic 18th November 2008 12:04

How ISPConfig delete databases?

When it delete database it go in RecicleBin (but where is it in real)? Is database dumped and ready for restore (from recycle bin), or it is renamed.... or...???

till 18th November 2008 12:08

Please take a look at my post above. As I described there, ispconfig is not taking a backup of the database content. the database is deleted with the drop database command in mysql. In the recycle bin there is the database itself without content and the indormation about the database user.

sojic 18th November 2008 13:35

So....

There is DB in ISPConfig Recycle bin. I am connected as root to mysql, and database is not in mysql.

My question is: Where is DB when it is in ISPConfig Recycle bin? When I will click Restore in ISPConfig Recycle bin, what will happen (from where ISPConfig will restore it?)

till 18th November 2008 13:43

Please read my post above. It contains all available information:

Quote:

ispconfig is not taking a backup of the database content. the database is deleted with the drop database command in mysql. In the recycle bin there is the database itself without content and the indormation about the database user.
Quote:

Where is DB when it is in ISPConfig Recycle bin?
the db is nowhere it is deleted. Just the name of the databse is kept.

Quote:

When I will click Restore in ISPConfig Recycle bin, what will happen (from where ISPConfig will restore it?)
ISPConfig creates a new empty database with the same login details.

sojic 18th November 2008 13:53

OK, thanks.

Sorry, for duplicating. Now it is clear.


All times are GMT +2. The time now is 07:08.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.