restore mysql database with phpmyadmin

Discussion in 'MySQL' started by Rasputin, Apr 12, 2008.

0
  1. #1
    Hi

    I need to restore a database, and am using phpmyadmin
    (It is a site-sift directory that just got hacked)

    When I try to restore it fails and says..#1050 - Table 'admin' already exists

    Does this mean I need to delete the existing tables before I start?
    If so do I use the 'drop' command on each table to do this?

    Thanks
     
    Rasputin, Apr 12, 2008 IP
  2. raymond222

    raymond222 Active Member

    Messages:
    287
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    60
    #2
    If you have the sql file with the table structure and data, then you have to delete the old data (including tables). But make sure you have all the data before proceeding.
    BTW you are missing one " in the link in your page's footer :D
     
    raymond222, Apr 12, 2008 IP