WordPress DataBase Importing Error

Discussion in 'MySQL' started by Jalpari, Mar 8, 2009.

  1. #1
    I am getting this error while importing .sql file in my wordpress blog database.

     
    Jalpari, Mar 8, 2009 IP
  2. qazu

    qazu Well-Known Member

    Messages:
    1,834
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    165
    #2
    It looks like the database already exists and you didn't use IF NOT EXISTS. you can run show databases; to see if it is already there. If you want to create a new database with the same name, you'd need to delete the existing database with drop database 'beauty_wrdp2'; and then create the new database.
     
    qazu, Mar 8, 2009 IP
    Jalpari likes this.
  3. mg1313

    mg1313 Peon

    Messages:
    532
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #3
    When you export a database try to tell to the program which helps you (phpMyAdmin or something like that) to automatically add Drop table if exists to the SQL queries...
     
    mg1313, Mar 8, 2009 IP
    Jalpari likes this.