https://www.icyphoenix.com/viewtopic.php?f=35&t=1008
-----------------------------------
Vortex
Thu 25 Jan, 2007 20:01

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?


-----------------------------------
brandsrus
Thu 25 Jan, 2007 20:14

Re: Quick Question About Changing Db Server
-----------------------------------
Yes, you must changes the files what you have said no more ;)


-----------------------------------
Vortex
Thu 25 Jan, 2007 20:24

Re: Quick Question About Changing Db Server
-----------------------------------
Just wanted to be sure... :D 



Thanks a lot ;)


-----------------------------------
Vortex
Tue 30 Jan, 2007 13:33

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[/quote]



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


-----------------------------------
Mighty Gorgon
Wed 31 Jan, 2007 03:05

Re: Quick Question About Changing Db Server
-----------------------------------
If you are moving only the DB you have to change only [b]config.php[/b]... nothing else.

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


-----------------------------------
Vortex
Mon 05 Feb, 2007 13:48

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:


-----------------------------------
Mighty Gorgon
Mon 12 Feb, 2007 02:27

Re: Quick Question About Changing Db Server
-----------------------------------
[quote user="Vortex" post="8517"]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:[/quote]
[b]config_xs.php[/b] is not part of XS... I don't know why you have that file... :roll:


-----------------------------------
Vortex
Mon 12 Feb, 2007 08:31

Re: Quick Question About Changing Db Server
-----------------------------------
Ah... interesting  :mrgreen: 


Well, thanks for help anyway  :wink:


