Title: Problem importing SQL Database file to remote server
Last modified: August 21, 2016

---

# Problem importing SQL Database file to remote server

 *  Resolved [Paul](https://wordpress.org/support/users/pchild1/)
 * (@pchild1)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/problem-importing-sql-database-file-to-remote-server/)
 * Hi everyone,
 * I’m trying to migrate a WordPress site I’ve designed on a local server (MAMP),
   to my cPanel on a remote server. I’ve followed the instructions I was given to
   the note, but when I tried to import the SQL file to my remote server using MyPHPAdmin,
   it came up with an error saying:
 * Error
 * SQL query:
 * Database: ‘information_schema’
 * CREATE DATABASE ‘information schema’ DEFAULT CHARACTER SET utf8 COLLATE utf_general_ci;
 * My SQL said:
 * #1044 – Access denied for user ‘x’ @ ‘localhost’ to database ‘information_schema’
 * If this makes sense to anyone, please help!
 * Thanks in advance,
 * Paul

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [2ninerniner2](https://wordpress.org/support/users/2ninerniner2/)
 * (@2ninerniner2)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/problem-importing-sql-database-file-to-remote-server/#post-3851476)
 * You are trying to import your file to one of the phpMyAdmin databases! 🙂
 * You need to create a NEW, EMPTY database into which you import your SQL file.
 * If you are using cPanel, then you should use either the MySQL Database Wizard
   or click on MySQL Databases and create it there … first 🙂
 * Then, once it has been created, open phpMyAdmin and select THAT database to import
   your file into 🙂
 *  Thread Starter [Paul](https://wordpress.org/support/users/pchild1/)
 * (@pchild1)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/problem-importing-sql-database-file-to-remote-server/#post-3851727)
 * That’s solved my problem, thanks much appreciated. 🙂

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Problem importing SQL Database file to remote server’ is closed to new
replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [local](https://wordpress.org/support/topic-tag/local/)
 * [MAMP](https://wordpress.org/support/topic-tag/mamp/)
 * [server](https://wordpress.org/support/topic-tag/server/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/)
 * 2 replies
 * 2 participants
 * Last reply from: [Paul](https://wordpress.org/support/users/pchild1/)
 * Last activity: [12 years, 11 months ago](https://wordpress.org/support/topic/problem-importing-sql-database-file-to-remote-server/#post-3851727)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics