[resolved] Problem importing SQL Database file to remote server (3 posts)

  1. Paul
    Posted 3 years ago #

    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:


    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,


  2. 2ninerniner2
    Posted 3 years ago #

    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 :)

  3. Paul
    Posted 3 years ago #

    That's solved my problem, thanks much appreciated. :)

Topic Closed

This topic has been closed to new replies.

About this Topic