Getting mysql error while trying to restore the DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fking
    Senior Member
    • Nov 2002
    • 152

    Getting mysql error while trying to restore the DB

    Hello
    My VB 3.0.1 got hacked, for some reason those hackers actually did a DB backup before messing it up.

    Well, unfortunately i get the following error when restoring (restoring according the manual)

    ERROR 1170 (42000) at line 31938: BLOB/TEXT column 'caption' used in key specification without a key length'


    i get the same one when trying one of my own backups, so its not that the backup file is messed up by the hackers as well.


    so i would like an advise how to restore the db properly

    thank you!

    p.s.
    going to search for some patches now, if u have something in mind feel free to post about that too
    Arcade Games - Some free fun for the free time!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...