[SOLVED] How to change the database location in 1.5.4

[hill37588]

I can't find the location to change the database address. Also, is there anything special I need to edit when moving my site to another server/provider - The domain name will remain the same...

 

There is nothing in the /config/settings.inc.php file I can change, so where is it?

 

I believe I'm looking for something like this:

 

1

2

3

4

define('_DB_SERVER_', 'your.sqlhost.name.com');

define('_DB_NAME_', 'database_name');

define('_DB_USER_', 'database_user');

define('_DB_PASSWD_', 'database_pswd');

 

[Dh42]

Are you currently hosted on a cpanel server and are moving to another cpanel server? If so ask the host to move it and nothing will have to be changed. 

 

If not, you can change it in the file you were already looking it. You had the correct file. 

[vekia]

 

 

There is nothing in the /config/settings.inc.php file I can change, so where is it?

so what you've got in settings.inc.php file? by default there should be definition of all important variables in the store

 

by default this file looks like:

<?php
define('_DB_SERVER_', 'localhost');
define('_DB_NAME_', '1550b');
define('_DB_USER_', 'root');
define('_DB_PASSWD_', '');
define('_DB_PREFIX_', 'ps_');
define('_MYSQL_ENGINE_', 'InnoDB');
define('_PS_CACHING_SYSTEM_', 'CacheMemcache');
define('_PS_CACHE_ENABLED_', '0');
define('_MEDIA_SERVER_1_', '');
define('_MEDIA_SERVER_2_', '');
define('_MEDIA_SERVER_3_', '');
define('_COOKIE_KEY_', 'w0zP6kUw4bxEttyCasd34Xddfx3BQd4FOTvEvROr7kPNJyrG41n1ee71246RvXue2');
define('_COOKIE_IV_', 'JWM468sNm');
define('_PS_CREATION_DATE_', '2013-10-04');
define('_PS_VERSION_', '1.5.5.0');
define('_RIJNDAEL_KEY_', 'SIHPOwrr33dRn7VfG46OYWh3HNLAu3KuQRrmQ');
define('_RIJNDAEL_IV_', 'J3O2UfshDeTpf21+pJslrMSdA==');

(of course you will see different values in own file)

[hill37588]

I fixed it - I had to clear the history, etc from my web browser to get all the details to show in my file manager.

[vekia]

hello

 

thank you for information that you solved it and of course for information about how you solved it

it will be helpful knowledge for community and other merchants here 

 

topic marked as solved

best regards