3 {{ upvoteCount | shortNum }}
3 {{ upvoteCount | shortNum }}

Please guide me to import my wordpress database to Hostgator! Its Urgent!

by Pradeep Bhagwat
2 replies
Hi, all

I have setup my new Hostgator account and want to transfer my website from Hostinzoom to Hostgator. I have problem while importing my wordpress database through phpmyadmin.

I am getting error like below:

-- Database: `hower_wrdp1`
--
CREATE DATABASE `hower_wrdp1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL said: Documentation
#1044 - Access denied for user 'mukta68'@'localhost' to database 'hower_wrdp1'

----
I had live chat with customer care three times but it can't solve the problem. They give me guide which suggest like below:

#1044 - Access denied for user 'username1'@'localhost' to database 'user2_wrdp9'
The problem here is your import file contains an SQL query that attempts to create a database for the wrong username. Notice the user2 in 'user2_wrdp9' does not match the username1 in 'username1'@'localhost'. Someone must edit the import file and change the old user2 to your new username1. (If you do not feel comfortable editing your import file, we will be glad to help you do that.) Here is an example of what it looks like (notice 3 places where the username is outdated):


---


But I am not able to understand the given solution. Please help me out in this problem. Is there any other method to import old wordpress database? Thanks in advance.


- Pradeep
#database #guide #hostgator #import #urgent #wordpress
  • Profile picture of the author sbucciarel
    Banned
    Well, I first create the database (empty). Then I create the user and jot down the user password. Then I add the user to the database and grant full permissions to the user. You'll need the database name, the user name and user password to edit the wp-config.php file to connect the database to your blog.

    Then I go to phpMyadmin and click on the database I just created. Then click on import and import the sql file. If there's any url changes, I make them in the wp-options table at that time.
    {{ DiscussionBoard.errors[7657685].message }}
  • Profile picture of the author Henry B
    Take a look at WP Twin.

    It allows you to easily clone your Wordpress website along with all your plugins and place it on your new hosting platform.

    Easy, Peasy, Lemon Squeezy
    {{ DiscussionBoard.errors[7660018].message }}

Trending Topics