Retore Fails

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jimjam
    Senior Member
    • Jul 2007
    • 217
    • 3.6.x

    Retore Fails

    After dumping my database exactly as described in the VB manual
    PHP Code:
    mysqldump --opt --u dbusername -p databasename backupname.sql 
    I have a problem restoring it to a new empty database.

    The error I am getting is this

    PHP Code:
    ERROR 1146 (42S02at line 267571Table 'mydata.games_savedGames' doesn't exist 
    I have checked this particular table for errors and everything is OK. Can anyone help, I really need to get my forum back. Thanks.
    Last edited by jimjam; Fri 30 Oct '09, 5:26am.
  • cellarius
    Senior Member
    • Aug 2005
    • 4586
    • 3.8.x

    #2
    As the error states: The table given in red does not exist. This is not a stock table from vB, but from a modification.

    Comment

    • jimjam
      Senior Member
      • Jul 2007
      • 217
      • 3.6.x

      #3
      Thank Cellarius, The table exists in the database when the dump is made. The restore is being made to a new database with no tables. The sql file is restoring every other table but says this one does not exist. Any idea what might be wrong? Thanks

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      😀
      😂
      🥰
      😘
      🤢
      😎
      😞
      😡
      👍
      👎