Jump to content

[solved] Importing database error


Recommended Posts

I have developed a website locally under wamp.

And I tried to upload it to my host (bluehost)

 

I exported my local database named ' lingsmom_prestashopa'.

I uploaded all my website files to host via FTP.

And then I tried to import my database to host via Phpmyadmin.

but It replied with following error.

 

ps: I have created database account lingsmom_andrew both at local and at bluehost.

 

Anyone have the same problem before or how to solve this problem?

 

Thanks a lot.

 

 

Error

 

SQL quair:

--

-- Database: `lingsmom_prestashopa`

--

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

 

MySQL 返回:b_help.png

#1044 - Access denied for user 'lingsmom_andrew'@'localhost' to database 'lingsmom_prestashopa'

 

 

Update:

I solved this problem last night.

Instead of importing a database to my host, I imports all the tables in a database.

The way I have problems:

1.export a local prestashop database via phpmyadmin

2. import the database to bluehost via phpmyadmin

3. Error as above

 

The way works:

1. open the local database and export all tables.

2. create a database at bluehost, and add a user with all privileges to the database.

3. import the tables

4 success.

Link to comment
Share on other sites

  • 3 years later...

I have developed a website locally under wamp.

And I tried to upload it to my host (bluehost)

 

I exported my local database named ' lingsmom_prestashopa'.

I uploaded all my website files to host via FTP.

And then I tried to import my database to host via Phpmyadmin.

but It replied with following error.

 

ps: I have created database account lingsmom_andrew both at local and at bluehost.

 

Anyone have the same problem before or how to solve this problem?

 

Thanks a lot.

 

 

Error

 

SQL quair:

--

-- Database: `lingsmom_prestashopa`

--

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

 

MySQL 返回:b_help.png

#1044 - Access denied for user 'lingsmom_andrew'@'localhost' to database 'lingsmom_prestashopa'

 

 

Update:

I solved this problem last night.

Instead of importing a database to my host, I imports all the tables in a database.

The way I have problems:

1.export a local prestashop database via phpmyadmin

2. import the database to bluehost via phpmyadmin

3. Error as above

 

The way works:

1. open the local database and export all tables.

2. create a database at bluehost, and add a user with all privileges to the database.

3. import the tables

4 success.

 

Other Way you can fix it:

 

- Download your sql database to your pc

- Open with NOTE PAD or NOTE PAD ++

- Find this line and remove all; 

CREATE DATABASE `123456_yourdb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

USE `123456_yourdb`;

- After, save and close and upload to your new hosting area..

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...