#1  
Old 26th January 2012, 16:27
dynamind dynamind is offline
Member
 
Join Date: Mar 2011
Location: Mdling bei Wien
Posts: 61
Thanks: 21
Thanked 6 Times in 4 Posts
Send a message via Skype™ to dynamind
Default Databases backup & restore

Hello,

I wanna move to a new x64 installation.

The server is prepared with ISPconfig3.

Now I dumped all databases on the old webserver and restored all databases on the new x64 webserver succesfully.
In the database panel none of the restored mysql-databases shows up. Is there a way to re-index all available databases into ISPConfig?

regards, dynamind
Reply With Quote
Sponsored Links
  #2  
Old 26th January 2012, 17:07
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Quote:
Is there a way to re-index all available databases into ISPConfig?
No. But you can move the ispconfig database from the old system which contains the details for all databases to the new sysstem as well.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 26th January 2012, 17:20
dynamind dynamind is offline
Member
 
Join Date: Mar 2011
Location: Mdling bei Wien
Posts: 61
Thanks: 21
Thanked 6 Times in 4 Posts
Send a message via Skype™ to dynamind
Default mysql transfer

excluding

root, debian-sys-maint, and ispconfig from mysql/user and
ispconfig from mysql/db

right? Does the innodbs get transferred this way also?

I had a curious problem (#1054) cause on my x86 server was mysql-server-5.5 ... on the x64 machine was the mysql-server-5.1 so I could not transfer the users. Now I upgraded to MySQL 5.5 and now the users got imported.

thanks a lot.

regards, dynamind
Reply With Quote
  #4  
Old 26th January 2012, 17:28
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

I'am talking about the ispconfig database "dbispconfig", not the mysql.mysql database.
Everything that you see in the ispconfig interface is in the ispconfig database.

Quote:
excluding

root, debian-sys-maint, and ispconfig from mysql/user and
ispconfig from mysql/db
Thats right, but not related to the problem that databases were not displayed in ispconfig.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 26th January 2012, 17:32
dynamind dynamind is offline
Member
 
Join Date: Mar 2011
Location: Mdling bei Wien
Posts: 61
Thanks: 21
Thanked 6 Times in 4 Posts
Send a message via Skype™ to dynamind
Default mysql transfer

ok, Till, should I exclude anything or transfer the whole dbispconfig?
Reply With Quote
  #6  
Old 26th January 2012, 17:37
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Exclude the server and server_ip and sys_datalog tables if the server setup on the new server is not identical to the old system (linux distribution and version and ip addresses). If its the same, then you can copy the whole database. And make a backup of the current database, in case something goes wrong.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 26th January 2012, 18:40
dynamind dynamind is offline
Member
 
Join Date: Mar 2011
Location: Mdling bei Wien
Posts: 61
Thanks: 21
Thanked 6 Times in 4 Posts
Send a message via Skype™ to dynamind
Default error starting apache2

[Thu Jan 26 18:34:35 2012] [warn] The Alias directive in /etc/apache2/sites-enabled/ispconfig.conf at line 51 will probably never match because it overlaps an earlier Alias.
[Thu Jan 26 18:34:35 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:80 has no VirtualHosts
[Thu Jan 26 18:34:35 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:443 has no VirtualHosts
[Thu Jan 26 18:34:35 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:80 has no VirtualHosts
[Thu Jan 26 18:34:35 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:443 has no VirtualHosts
[Thu Jan 26 18:34:35 2012] [warn] NameVirtualHost *:2340 has no VirtualHosts
[Thu Jan 26 18:34:35 2012] [warn] The Alias directive in /etc/apache2/sites-enabled/ispconfig.conf at line 51 will probably never match because it overlaps an earlier Alias.
[Thu Jan 26 18:34:35 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:80 has no VirtualHosts
[Thu Jan 26 18:34:35 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:443 has no VirtualHosts
[Thu Jan 26 18:34:35 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:80 has no VirtualHosts
[Thu Jan 26 18:34:35 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:443 has no VirtualHosts
[Thu Jan 26 18:34:35 2012] [warn] NameVirtualHost *:2340 has no VirtualHosts
(98)Address already in use: make_sock: could not bind to address 0.0.0.0:2340
no listening sockets available, shutting down
Unable to open logs
Action 'start' failed.
The Apache error log may have more information.
...fail!
Restarting ftp server: Running: /usr/sbin/pure-ftpd-mysql-virtualchroot -l mysql:/etc/pure-ftpd/db/mysql.conf -l pam -O clf:/var/log/pure-ftpd/transfer.log -8 UTF-8 -u 1000 -E -Y 1 -A -b -D -H -B

I did not overwrite apps.vhost, default, default-ssl, ispconfig.conf, ispconfig.vhost, only placed the additional domains/sites into /etc/apache27sites-available, and then enabled all sites with a2ensite > *

at the console it shows:


* Starting web server apache2 [Thu Jan 26 18:40:07 2012] [warn] The Alias directive in /etc/apache2/sites-enabled/ispconfig.conf at line 51 will probably never match because it overlaps an earlier Alias.
[Thu Jan 26 18:40:07 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:80 has no VirtualHosts
[Thu Jan 26 18:40:07 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:443 has no VirtualHosts
[Thu Jan 26 18:40:07 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:80 has no VirtualHosts
[Thu Jan 26 18:40:07 2012] [warn] NameVirtualHost xx.xx.xxx.xxx:443 has no VirtualHosts
[Thu Jan 26 18:40:07 2012] [warn] NameVirtualHost *:2340 has no VirtualHosts
(98)Address already in use: make_sock: could not bind to address 0.0.0.0:2340
no listening sockets available, shutting down
Unable to open logs
Action 'start' failed.
The Apache error log may have more information.

anyway it looks like I killed the logger. I'll reinstall.

Last edited by dynamind; 26th January 2012 at 22:15.
Reply With Quote
  #8  
Old 30th January 2012, 12:58
dynamind dynamind is offline
Member
 
Join Date: Mar 2011
Location: Mdling bei Wien
Posts: 61
Thanks: 21
Thanked 6 Times in 4 Posts
Send a message via Skype™ to dynamind
 
Default done

I did it, finally moved my debian x86 server succesfully
to a fresh debian x64 system.

All done with your help.

thanks a lot!

regards, juergen
Reply With Quote
Reply

Bookmarks

Tags
databases, mysql transfer, server transfer

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
Shell script for backup and restore inddeveloper Programming/Scripts 3 15th September 2010 08:59
Online Backup : What do you use and how do you setup it ? XZed Technical 5 4th January 2010 18:02
Restore deleted databases sojic Installation/Configuration 6 18th November 2008 12:53
[SHELL Script] - Backup WEB & DATABASES vaio1 Tips/Tricks/Mods 0 5th September 2007 14:48
Database Backup and Restore PoleCat Feature Requests 5 16th May 2007 15:36


All times are GMT +2. The time now is 06:01.


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