#1  
Old 17th November 2008, 23:57
sojic sojic is offline
Member
 
Join Date: Jul 2007
Posts: 92
Thanks: 7
Thanked 0 Times in 0 Posts
Default 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)
Reply With Quote
Sponsored Links
  #2  
Old 18th November 2008, 10:47
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,638
Thanks: 793
Thanked 4,998 Times in 3,909 Posts
Default

ISPConfig is not taking a backup of databases, so if you dont have a backup i fear that the data is lost.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 18th November 2008, 11:04
sojic sojic is offline
Member
 
Join Date: Jul 2007
Posts: 92
Thanks: 7
Thanked 0 Times in 0 Posts
Default

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...???
Reply With Quote
  #4  
Old 18th November 2008, 11:08
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,638
Thanks: 793
Thanked 4,998 Times in 3,909 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 18th November 2008, 12:35
sojic sojic is offline
Member
 
Join Date: Jul 2007
Posts: 92
Thanks: 7
Thanked 0 Times in 0 Posts
Default

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?)
Reply With Quote
  #6  
Old 18th November 2008, 12:43
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,638
Thanks: 793
Thanked 4,998 Times in 3,909 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
sojic (18th November 2008)
  #7  
Old 18th November 2008, 12:53
sojic sojic is offline
Member
 
Join Date: Jul 2007
Posts: 92
Thanks: 7
Thanked 0 Times in 0 Posts
 
Default

OK, thanks.

Sorry, for duplicating. Now it is clear.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Recycle Bin won't delete DataBases!!!? What do I do? sierradump General 1 24th October 2007 08:47
Restore deleted Logfiles TobiasTM Server Operation 3 15th October 2007 23:24
How to restore deleted apache2.conf file Dekalb HOWTO-Related Questions 1 2nd June 2007 15:01
Database Backup and Restore PoleCat Feature Requests 5 16th May 2007 15:36
Recovering unlinked mysql databases and users... Dave Lane Installation/Configuration 2 10th May 2006 19:45


All times are GMT +2. The time now is 13:23.


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