No announcement yet.

sql error when doing import

  • 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

    Query: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
    <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; }
    <table cellpadding="3" cellspacing="5" id="container">
    <td><img src="" alt="Database Error" width="48" height="48" /></td>
    <td id="bodytitle" width="100%">Database error</td>
    <td class="bodytext" colspan="2">The ãäÊÏíÇÊ Èäí ÈßÑ database has encountered a problem.</td>
    <td colspan="2"><hr /></td>
    <td class="bodytext" colspan="2">
    Please try the following:
    <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="/"></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>
    <td class="bodytext" colspan="2">The 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>
    <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
    <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.


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


      • #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:
        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...


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