Database error, help!

Discussion in 'MySQL' started by Emie., May 21, 2008.

  1. #1
    I'm moving my Joomla site to a new server. Everything seems fine so far except for the part where I tried to import my database.

    I get this error:

    
    There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
    
    ERROR: Unknown Punctuation String @ 6
    STR: />
    SQL: 
    <br />
    <b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in <b>/web/myadmin/p50/89/libraries/ob.lib.php</b> on line <b>61</b><br />
    <br />
    <b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in <b>/web/myadmin/p50/89/libraries/header_http.inc.php</b> on line <b>13</b><br />
    <br />
    <b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in <b>/web/myadmin/p50/89/libraries/header_http.inc.php</b> on line <b>14</b><br />
    <br />
    <b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in <b>/web/myadmin/p50/89/libraries/header_http.inc.php</b> on line <b>15</b><br />
    <br />
    <b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in <b>/web/myadmin/p50/89/libraries/header_http.inc.php</b> on line <b>16</b><br />
    <br />
    <b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in <b>/web/myadmin/p50/89/libraries/header_http.inc.php</b> on line <b>19</b><br />
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
    <head>
        <link rel="icon" href="./favicon.ico" type="image/x-icon" />
        <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
        <title>phpMyAdmin</title>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <link rel="stylesheet" type="text/css" href="./css/phpmyadmin.css.php?token=bc8498ad46e7029cc69bf6d104c612d8&amp;js_frame=right" />
        <link rel="stylesheet" type="text/css" href="./css/print.css?token=bc8498ad46e7029cc69bf6d104c612d8" media="print" />
        <script type="text/javascript" language="javascript">
        // <![CDATA[
        // Updates the title of the frameset if possible (ns4 does not allow this)
        if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
            && typeof(parent.document.title) == 'string') {
            parent.document.title = 'p3smysqladmin01.secureserver.net / 10.6.166.112 / brandon_cashjuke / jos_fb_messages_text | phpMyAdmin 2.9.1.1';
    
    
    SQL query:
    
    
    Warning: Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in /web/myadmin/p50/89/libraries/ob.lib.php on line 61
    
    Warning: Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in /web/myadmin/p50/89/libraries/header_http.inc.php on line 13
    
    Warning: Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in /web/myadmin/p50/89/libraries/header_http.inc.php on line 14
    
    Warning: Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in /web/myadmin/p50/89/libraries/header_http.inc.php on line 15
    
    Warning: Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in /web/myadmin/p50/89/libraries/header_http.inc.php on line 16
    
    Warning: Cannot modify header information - headers already sent by (output started at /web/myadmin/p50/89/export.php:150) in /web/myadmin/p50/89/libraries/header_http.inc.php on line 19
    
    Code (markup):

     
    Emie., May 21, 2008 IP
  2. bluecape

    bluecape Peon

    Messages:
    89
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    probably you have too much data? try to divide your sql database script into several pieces and import them one at a time.
     
    bluecape, May 21, 2008 IP