Transfer database to new host

[artstyle]

I am working on transferring my existing site to a new host. I still have the old site until the new one is up and running smoothly.

I am at the stage of uploading the database file. I saved it from the old site and I am trying to upload it to the new site's database.

I get a

 

Error

SQL query:

 

--

-- Database: `*****_web`

--

CREATE DATABASE `*****` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

 

 

 

MySQL said:

 

#1044 - Access denied for user 'l*****t'@'%' to database '*****_web'

 

Can anyone help?

 

Thanks in advance

[arietis]

#1044 - Access denied for user 'l*****t'@'%' to database '*****_web'

 

Can anyone help?

 

Thanks in advance

 

the user name that you are using doesn't have permission to create a database. you will need to use your host's mysql control panel to make sure that it has proper permissions.

 

sometimes admins set up multiple database accounts -- an admin that has create database/table privileges an a 'user' that does not. the 'user' account is then set as the account name for applications to use. since most applications only need to create databases and/or tables on install this is generally viewed as safer so the higher privileged account can't be compromised.

[artstyle]

Hello,

Thanks.

You've put me on the right track but I am new at this and therefore still stuck.

It seems I cannot create a database because it says one has already been created.

the user name that you are using doesn't have permission to create a database. you will need to use your host's mysql control panel to make sure that it has proper permissions.

 

sometimes admins set up multiple database accounts -- an admin that has create database/table privileges an a 'user' that does not. the 'user' account is then set as the account name for applications to use. since most applications only need to create databases and/or tables on install this is generally viewed as safer so the higher privileged account can't be compromised.

[arietis]

Hello,

Thanks.

You've put me on the right track but I am new at this and therefore still stuck.

It seems I cannot create a database because it says one has already been created.

 

drop table if exists <<table name>>

 

if you do a backup on your old site, it will create an sql script with all the appropriate drop table, create table and inserts to make a clone of your database.

[artstyle]

Hi,

Thank you very much. It worked like a charm!

Regards,

Alexandra

 

drop table if exists <<table name>>

 

if you do a backup on your old site, it will create an sql script with all the appropriate drop table, create table and inserts to make a clone of your database.