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

Discussion in 'Installation and Updates' started by northwest, May 8, 2006.

  1. northwest

    northwest New Member

    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??

  2. echopulse

    echopulse Paid Customer

    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.
  3. Vasily B.

    Vasily B. Administrator Staff Member

    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
  4. northwest

    northwest New Member

    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:
  5. Vasily B.

    Vasily B. Administrator Staff Member

    I'm glad to advise ;)

Share This Page