Move wp from localhost to server

CMS & WordPress
1

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

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

There is a duplicator plugin I use for replicating wordpress sites.

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

Thank you for your reply. Please let me try with this plugin. Be well.

5

if above doesn’t work, export your content as xml,upload same theme via ftp and that should do it.