SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2012
    Location
    Pabna, Bangladesh
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Move wp from localhost to server

    Hi,

    Good day! I like to inform you that I like to move my new WP site from localhost to online server (000webhost.com). So, I went to the 000webhost.com and uploaded/backup my all files there. Then I created a new database and I tried to import my localhost database (wp.sql) there. But I got the following error massage:

    “Error

    SQL query:

    --
    -- Database: `wp`
    --
    CREATE DATABASE IF NOT EXISTS `wp` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

    MySQL said: Documentation
    #1044 - Access denied for user 'a8864920_root'@'localhost' to database 'wp'”

    So, please help me to solve this problem as well. No more, I am waiting for your kind response.

    Thank you.

  2. #2
    SitePoint Mentor silver trophy
    Rubble's Avatar
    Join Date
    Dec 2005
    Location
    Cambridge, England
    Posts
    2,435
    Mentioned
    82 Post(s)
    Tagged
    3 Thread(s)
    It looks as though your database login details are incorrect.

    I have never created a wordpress site but I would install wordpress on my server and then overwrite the files and database with my local content.

  3. #3
    SitePoint Addict
    Join Date
    Aug 2013
    Location
    New Zealand
    Posts
    302
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)
    There is a duplicator plugin I use for replicating wordpress sites.

    http://wordpress.org/plugins/duplicator/installation/

    The problem you are getting may be with 000webhosts restrictive policy on database creation but you may be able to get around that by reusing existing database credentials as wordpress prefixes all its table names with "wp_".

  4. #4
    SitePoint Enthusiast
    Join Date
    Jan 2012
    Location
    Pabna, Bangladesh
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Kiwiheretic View Post
    There is a duplicator plugin I use for replicating wordpress sites.

    http://wordpress.org/plugins/duplicator/installation/

    The problem you are getting may be with 000webhosts restrictive policy on database creation but you may be able to get around that by reusing existing database credentials as wordpress prefixes all its table names with "wp_".
    Thank you for your reply. Please let me try with this plugin. Be well.

  5. #5
    SitePoint Enthusiast stevenukas's Avatar
    Join Date
    Jul 2012
    Posts
    32
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    if above doesn't work, export your content as xml,upload same theme via ftp and that should do it.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •