WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. Paul
    Member
    Posted 1 year 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:

    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

  2. 2ninerniner2
    Member
    Posted 1 year 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
    Member
    Posted 1 year ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic