Import Database Error. Willing to pay if imported Successfully

Discussion in 'MySQL' started by khnfrhn, Oct 4, 2010.

  1. #1
    Hello readers,

    recently i took a backup of one database. the website was working fine, suddenly it the database disappeared from the MySQL list , i don't know the reason. I Then i tried to import the database of which i took the backup. It is showing this error (File Attached)

    Please Help. Its Very URGENT. If any one successfully imports it i am willing to pay!

    Regards,
     

    Attached Files:

    • db.jpg
      db.jpg
      File size:
      26.6 KB
      Views:
      84
    khnfrhn, Oct 4, 2010 IP
  2. mike30

    mike30 Well-Known Member

    Messages:
    887
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    140
    #2
    There are few scenarios that could be generating this error.


    • Someone had hacked into your account and changed the password or deleted the database
    • The backup file is trying to CREATE DATABASE withing your phpMyAdmin interface which is restricted in most cases.
    • other (must investigate at deeper level to discover what is wrong)

    ~Mike
     
    mike30, Oct 4, 2010 IP
  3. khnfrhn

    khnfrhn Well-Known Member

    Messages:
    706
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    110
    #3
    Thanks for the reply .

    But i don't think the 1st Option is correct, because when i created the database. i exported it. and suddenly there was this error by the hosting company so i deleted the DB from the website (I had backup in my hard disk) So when i tried to restore it showed me this ERROR!

    If you can give it a try by accessing into my CPanel, I don't mind at all. Let me know if you can do it mike.
     
    khnfrhn, Oct 5, 2010 IP
  4. khnfrhn

    khnfrhn Well-Known Member

    Messages:
    706
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    110
    #4
    Double Post ~ Sorry!
     
    Last edited: Oct 5, 2010
    khnfrhn, Oct 5, 2010 IP
  5. khnfrhn

    khnfrhn Well-Known Member

    Messages:
    706
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    110
    #5
    Thanks mike for the interest now o have solved it myself. :)

    If anyone has the same problem, PM me i am sure i can help you.
     
    khnfrhn, Oct 6, 2010 IP
  6. mike30

    mike30 Well-Known Member

    Messages:
    887
    Likes Received:
    37
    Best Answers:
    0
    Trophy Points:
    140
    #6
    No problem buddy, I am glad you could fix it yourself :) (I am sure that you had learned something new)

    Also, you could post here what was the problem, so other learn from your experience. ;)

    ~Mike
     
    mike30, Oct 6, 2010 IP