If DB name is changed, what needs to be modified??

[northwest]

Hi eSyndicators!

We are in a situation where we may have to change the name of the database. I have seen in the config file where we have to change the db name, user and password. Is there any modification we have to make to the links program files?

Also, we are going to create SQLs of the entire database and run it in the new database. Has anyone done this? do you forsee any issues??

Thanks!

[echopulse]

First of all, it would help to know what version you are using. You cannot use an old version's database in a new version. You must upgrade it first. The config file is the only place you have to change the database name though.

[Simon Gooffin]

Hi,
echopulse is right :) you should make changes in your config.inc.php file. Find there the following lines:

$gDirConfig['dbhost'] = 'your_host';
$gDirConfig['dbuser'] = 'your_username';
$gDirConfig['dbpwd'] = 'your_password';
$gDirConfig['dbname'] = 'your_database_name';
$gDirConfig['prefix'] = 'your_prefix';

Also please modify your tables via phpMyAdmin. configs table

[northwest]

Thanks. we are using the same version with which it was created. So there a version compatibilty. I did notice that the config table has an insert statement that inserts the database name, user and password. so we changed it.

Everything works fine now! Thanks! :yahoo:

[Simon Gooffin]

I'm glad to advise ;)