1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

WordPress DataBase Importing Error

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

0
  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.