1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Link existing database to new domain.

Discussion in 'Plesk for Linux - 8.x and Older' started by Linux98, Apr 26, 2005.

  1. Linux98

    Linux98 Guest


    Is there a way to link an existing database to a new domain name?

    I installed sugarCRM on my server, but it made a new database on my system. I would like to attatch that database to a new domain name.

    Thank you.
  2. eWebtricity

    eWebtricity Guest

    I think you can just use the same DB userid/dbname/password in the new domain with SugarCRM. To make the DB show up in the new domain admincp you'll have to export/dump the database and import it into an empty DB under the new domain. So as long as you don't delete the old domain the DB will work for the new domain, otherwise you'll have to move it by hand. If it's not too big the phpMyAdmin gui should work pretty good in the admincp. If it's larger than 5MB then you might look into using the CLI to move it with mysqldump.
  3. Linux98

    Linux98 Guest

    Thanks, I think that is what I will have to do.

    I was hoping I could just point the admincp for that domain at the database. Or, find the PSA file that holds that info and manually adjust it. If I can find the file and make a change without causing more problems than it is worth I will come back and post how I did it.

    If not, I'll do it the long way :(
  4. Cranky

    Cranky Guest

    Check 'psa' mysql database. In the 'domains' table lookup the dom_id for the destination domain, then in the data_bases table adjust the entry for the database to use the new dom_id.
  5. Linux98

    Linux98 Guest

    That worked great, thanks!