transfering databases

[debrag]

I have exported my databases from my old host but how do I go about importing them to my new host?

I know in cpanel I create a database & in phpmyadmin I import the database there, but what about the parts of my sites that use the databases? do I need to go into each config file and amend the info as the databases will all have different names & users.

EDIT: I am currently transfering all files via ftp but will back-up my databases at work but will try at home tonight and use the restore fuction on cpanel.

[Goddess Dix]

Originally Posted by debrag

I have exported my databases from my old host but how do I go about importing them to my new host?

I know in cpanel I create a database & in phpmyadmin I import the database there, but what about the parts of my sites that use the databases? do I need to go into each config file and amend the info as the databases will all have different names & users.

EDIT: I am currently transfering all files via ftp but will back-up my databases at work but will try at home tonight and use the restore fuction on cpanel.

yes, you will need to do a little more work. in the mysql area of cpanel, you'll need to create the database and username, and attach the user to the database there. then import your database in phpmyadmin. and tweak your config files.

when naming your database here, remember hg automataically adds your username to the beginning of the db and user names, so if your cpanel login is mylogin, you set up your database to be named db1, then your database will REALLY be named mylogin_db1, and the same with the user. if you set up "myuser" then it gets named mylogin_myuser. tweak your config file accordingly and transfer the files.

[gwyneth]

There's an easier way...within the first 30 days of signing up, HG will transfer it for you.

[debrag]

I know that but they were having problems with it or something so i've been ftp-ing all the files myself.

[GatorDaveC]

Originally Posted by debrag

I know that but they were having problems with it or something so i've been ftp-ing all the files myself.

Create all of the dbs & DB users, and I'll import your Database backups for you. Please provide me with a ticket number with which database goes where.

[gwyneth]

Originally Posted by GatorDaveC

Create all of the dbs & DB users, and I'll import your Database backups for you. Please provide me with a ticket number with which database goes where.

That, debrag, is a great offer!