Importing sql database to new server

  • I’m trying to move my wordpress site to godaddy.com and am having problems importing the database into the new environment.

    I tried importing the SQL File into the MySQL Database Using phpMyAdmin but received the following error:

    ———————-
    #1044 – Access denied for user ‘myusername’@’%’ to database ‘information_schema’
    ———————-

    The support team advised the following:

    “You are most likely receiving this error due to the first line within the .SQL file. You do not need to include the CREATE DATABASE line in your MySQL database. If you do include it, your import might fail. We recommend removing the line before importing your database.”

    Unfortunately they could not clarify exactly what text I need to remove and I am not experienced in this area.

    I would really appreciate it if someone could advise which part of the following I need to remove:

    —
    — Database: information_schema

    —
    CREATE DATABASE information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    USE information_schema;

    — ——————————————————–

    I’ve tried several variations but end up receiving syntax errors

    Many thanks

    Neil

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

  • Have you tried removing the block completely?

    --
-- Database: information_schema

--
CREATE DATABASE information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE information_schema;

    If you take all of that out, it should work.

    Brandon is right – but ther’s more ot it then just that.

    The database information_schema is one of MySQL’s internal data stores and it should not be copied from host to host. You only need to copy the one database that holds your sites information. Nothing else needs to be transferred.

    Thread Starter neilorourke72

    (@neilorourke72)

    Thanks for getting back to me.

    I tried deleting the whole block but this also returned an error. I’ll try again tonight and make a note of the error message.

    Cheers

    Neil

    Catacaustic, good catch. Thanks for the backup! ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Importing sql database to new server’ is closed to new replies.

Tags