MySql Restore Backup Won't Work

Discussion in 'MySQL' started by . Jordan ., May 10, 2010.

  1. #1
    So my host recently moved servers or something so I was told to make a backup of all my files. Since I already had all the files on my local drive, I just made a mySQL backup using phpMyAdmin. However, when I come to import the backup, it gives me the following error.

    SQL query:
    --
    -- Database: `information_schema`
    --
    CREATE DATABASE  `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    
    
    MySQL said: 
    
    #1044 - Access denied for user 'jordan'@'localhost' to database 'information_schema'
    Code (markup):
    There is already one database in the mySQL called information_scheme which was there by default. I can't seem to delete that through phpMyAdmin or the cPanel.

    Any ideas?
     
    . Jordan ., May 10, 2010 IP
  2. . Jordan .

    . Jordan . Guest

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Bump. I need a fix.
     
    . Jordan ., May 10, 2010 IP
  3. graspit

    graspit Peon

    Messages:
    87
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    create a new MySQL database and try to import again your sql file to it.
     
    graspit, May 11, 2010 IP
  4. roopajyothi

    roopajyothi Active Member

    Messages:
    1,302
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    80
    #4
    Create a DB in panel if your using dreamhost else create one in phpmyadmin and have a try
    Don't need to overrid or modify information_schema
     
    roopajyothi, May 11, 2010 IP