Announcement

Collapse
No announcement yet.

sql error when doing import

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • sql error when doing import

    I get this error when I try to import my database back up through either phpmyadmin or through bigdump

    Code:
    Query: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html>
    <head>
    <title>ãäÊÏíÇÊ Èäí ÈßÑ Database Error</title>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
    <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
    <style type="text/css">
    <!--
    body { background-color: white; color: black; }
    #container { width: 400px; }
    #message { width: 400px; color: black; background-color: #FFFFCC; }
    #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
    .bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
    a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
    a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
    -->
    </style>
    </head>
    <body>
    <table cellpadding="3" cellspacing="5" id="container">
    <tr>
    <td><img src="http://banibkr.com/forum/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
    <td id="bodytitle" width="100%">Database error</td>
    </tr>
    <tr>
    <td class="bodytext" colspan="2">The ãäÊÏíÇÊ Èäí ÈßÑ database has encountered a problem.</td>
    </tr>
    <tr>
    <td colspan="2"><hr /></td>
    </tr>
    <tr>
    <td class="bodytext" colspan="2">
    Please try the following:
    <ul>
    <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
    <li>Open the <a href="/">www.banibkr.com</a> home page, then try to open another page.</li>
    <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
    </ul>
    </td>
    </tr>
    <tr>
    <td class="bodytext" colspan="2">The www.banibkr.com forum technical staff have been notified of the error, though you may <a href="mailto:[email protected]">contact them</a> if the problem persists.</td>
    </tr>
    <tr>
    <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
    </tr>
    </table>
    <form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.8.1:
    Invalid SQL:
    SHOW CREATE TABLE postedithistory;
    
    MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
    Does anyone know what could cause it?

  • #2
    anyone? it's really important. I did the back up through admincp. Please help.

    Comment


    • #3
      It has to do with show creat table maybe?

      Comment


      • #4
        If you have a large database, backing up through AdminCP or phpMyAdmin may not back it up fully. The most reliable way is to use SSH/Telnet. See the manual for more information on this and restoring via the same method:

        http://www.vbulletin.com/docs/html/m...nce_ssh_backup

        http://www.vbulletin.com/docs/html/m...ce_ssh_restore
        Vote for:

        - *Admin Settable Paid Subscription Reminder Timeframe*
        -
        *PM - Add ability to reply to originator only*
        - Add Admin ability to auto-subscribe users to specific channel(s)
        - "Quick Route" Interface...

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X