Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

Quick Question About Changing Db Server

This topic is locked: you cannot edit posts or make replies.

 

Vortex
Quote
Posts: 412 Location: Prato, Italy
Thu 25 Jan, 2007 20:01
Subject: Quick Question About Changing Db Server
I have to move my database to a different database server. It is enough to change infos in config.php and config_xs.php, right?

Profile PM   Website MSN Skype
brandsrus
Quote
Posts: 297 Location: Leeuwarden, The Netherlands
Thu 25 Jan, 2007 20:14
Subject: Re: Quick Question About Changing Db Server
Yes, you must changes the files what you have said no more ;)

Profile PM   Website
Vortex
Quote
Posts: 412 Location: Prato, Italy
Thu 25 Jan, 2007 20:24
Subject: Re: Quick Question About Changing Db Server
Just wanted to be sure... :D



Thanks a lot ;)

Profile PM   Website MSN Skype
Vortex
Quote
Posts: 412 Location: Prato, Italy
Tue 30 Jan, 2007 13:33
Subject: Re: Quick Question About Changing Db Server
Uhm...



Quote:
Critical Error

Error: Seek Help

DEBUG MODE

SQL Error : 1048 Column 'login_id' cannot be null

INSERT INTO phpbb_logins (login_id, login_userid, login_ip, login_user_agent, login_time) VALUES (NULL, -1, '97254ab6', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; it; rv:1.8.0.9) Gecko/20061206 Firefox/1.5.0.9', 1170160267)

Line : 227
File : sessions.php




How could this be related to? I imported the new database, than changed config e and config_xs ...

Profile PM   Website MSN Skype
Mighty Gorgon
Quote
Posts: 7192 Location: Borgo San Michele
Wed 31 Jan, 2007 03:05
Subject: Re: Quick Question About Changing Db Server
If you are moving only the DB you have to change only config.php... nothing else.

The error is not related to config... try to empty sessions table.

Profile PM   Website
Vortex
Quote
Posts: 412 Location: Prato, Italy
Mon 05 Feb, 2007 13:48
Subject: Re: Quick Question About Changing Db Server
Ok, clearing sessions table wasn't necessary... it was a corrupted backup ;)


Can you please explain to me why it is not necessary to change config_xs.php? I don't understand... I changed db address, doesn't it become useless if don't don't update it? :shock:

Profile PM   Website MSN Skype
Mighty Gorgon
Quote
Posts: 7192 Location: Borgo San Michele
Mon 12 Feb, 2007 02:27
Subject: Re: Quick Question About Changing Db Server
Vortex wrote: [View Post]
Can you please explain to me why it is not necessary to change config_xs.php? I don't understand... I changed db address, doesn't it become useless if don't don't update it? :shock:

config_xs.php is not part of XS... I don't know why you have that file... :roll:

Profile PM   Website
Vortex
Quote
Posts: 412 Location: Prato, Italy
Mon 12 Feb, 2007 08:31
Subject: Re: Quick Question About Changing Db Server
Ah... interesting :mrgreen:


Well, thanks for help anyway :wink:

Profile PM   Website MSN Skype
This topic is locked: you cannot edit posts or make replies.
 

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 1.1962s (PHP: 2% SQL: 98%)
SQL queries: 31 - Debug Off - GZIP Enabled