Issues moving database to new hosting acct

[John_C]

I am not an IT guy. What does this mean and how do I fix it?

[Colonel_mortis]

You shouldn't need to import the information_schema table to your new host. It looks like you backed up all of your databases, not just the IPS one, but it's only the IPS one that you need to transfer.

[John_C]

Now I get this error:

Quote

 

Error

SQL query:

--
-- Database: `Forum_1`
--
CREATE DATABASE `Forum_1` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
 

MySQL said: 

#1044 - Access denied for user 'user_name'@'localhost' to database 'forum_1' 

 

That @localhost ... not sure what it is. Godaddy backup acct? 

[John_C]

I've googled and tried everything. This isn't working. What a PITA having to upgrade the hosting acct to get a compatible php version to run this forum on.  

[Colonel_mortis]

1 hour ago, John_C said:

Now I get this error:

That @localhost ... not sure what it is. Godaddy backup acct? 

@localhost is just an identifier for the account to say that it belongs to the current computer, and not a remote one - it's always there, but normally defaults to localhost.

It looks like your database account probably doesn't have permission to access that database, either because it can't create DBs, or because you haven't granted it access to that DB. Edit the backup file to remove the CREATE DATABASE line, and create the database manually, then import using the rest of the file. Make sure that your account has full permissions for that database.

[John_C]

27 minutes ago, Colonel_mortis said:

@localhost is just an identifier for the account to say that it belongs to the current computer, and not a remote one - it's always there, but normally defaults to localhost.

It looks like your database account probably doesn't have permission to access that database, either because it can't create DBs, or because you haven't granted it access to that DB. Edit the backup file to remove the CREATE DATABASE line, and create the database manually, then import using the rest of the file. Make sure that your account has full permissions for that database.

That worked! You rock! Thanks!

Now to upload the backup of my forum to the ftp and try to get it connected.

[TDBF]

21 minutes ago, John_C said:

That worked! You rock! Thanks!

Now to upload the backup of my forum to the ftp and try to get it connected.

 

Can I make a suggestion to you regarding moving Databases etc, don't use MyPHPadmin, it is slow and depending on the size of your database you will either time out or there will be errors.

If you are not the CMD type of person and prefer to use a GUI, then I would suggest that you use HeidiSQL over What you are using. The main reason is that it simplifies a lot of tasks and does them a lot faster. With HeidiSQL you can copy the whole database/tables straight over into another database without having to do any downloads/uploads in the process.

Other features I find handy is the ability to search and replace on mass, change database storage types or encoding.

Check their website, there is plenty of info on how to copy a database from one server to another.