Hi there,
This is a bit of a complicated one... and I really need your help with it! Okay, so I needed to move a website from one reseller hosting account, to another. Both accounts are with Heart Internet. So I backed up the files via FTP, and the database through SQL Dump - so I have all the data right? So now all I have to do is upload the FTP data onto the hosting account on the second reseller account, then restore the database?
This is where the problems start. Heart Internet add a prefix to the database name, which you can't change. So my original database name was web132-a-drupa-8 but now my new one (currently blank) is called n-web181-a-drupa. As far as I know, all I need to do is find/replace any reference to the old database name with the new one in the SQL Dump file, and the settings.php file?
After doing this I imported the SQL file via MyPHPAdmin > Import > Choose File. However I keep getting an error message:
SQL query:
--
-- Table structure for table `drupal_access`
--
DROP TABLE IF EXISTS `drupal_access` ;
MySQL said:
#1046 - No database selected
Why is this? What can I do to get this website back online again? I'm out of ideas and need your help badly!
Yours in desperation,
Paul
