Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2011
    Posts
    3

    Red face Unanswered: SQL Table is empty

    Hi,

    I am using old version of coppermine gallery for wallpaper section of my website,

    When I logged into PhpMyAdmin and went to the datebase of this script, I found that the user table which has admin username and password is empty,

    Seems like someone has hacked and empty it so I am unable to login into admin panel of that script but luckily the front end is working fine and data is still exist,

    I don't even have the backup

    How can I resolve this issue?

    Regards
    NetBug

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    revert to a backup
    or
    get someone with admin rights to insert the relevant data
    or
    write soem code that recreates the user permissions
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2011
    Posts
    3
    A friend suggested me to install the same script on other account or location, export the user table and import on your current database,

    Will it work? or upgrading to latest version of that script will recreate the table or not?

  4. #4
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    That sounds like good advise. Recreate a new database and export the users from the newly installed database into the old one.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •