Support » Localhost Installs » Problem importing SQL Database file to remote server

  • Resolved Paul

    (@pchild1)


    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)
  • 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 🙂

    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.