Why is there PHP/HTML code at the end of my .sql file?

Question

I'm trying to move a website from one host to another. Everything is going great except there is HTML code at the end of every db dump I do (via phpmyadmin. The site is leaving GoDaddy.) As a result, I cannot import the .sql file to a database on DigitalOcean. If I remove the code, the dump works but the site doesn't. Also, I did not create the site. I'm just moving it.

Here's what's at the end of the .sql file:

    <!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="phpmyadmin.css.php?token=a265dc411b059a3932a26eeefe2fc8f0&amp;js_frame=right&amp;nocache=4099247312" />
    <link rel="stylesheet" type="text/css" href="print.css" media="print" />
    <script type="text/javascript">
    try {
        // can't access this if on a different domain
        var topdomain = top.document.domain;
        // double-check just for sure
        if (topdomain != self.document.domain) {
            alert("Redirecting...");
            top.location.replace(self.document.URL.substring(0, self.document.URL.lastIndexOf("/")+1));
        }
    }
    catch(e) {
            alert("Redirecting... (error: " + e);
            top.location.replace(self.document.URL.substring(0, self.document.URL.lastIndexOf("/")+1));
    }

    </script>
        <script type="text/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 = '68.178.217.9 / newdbgcf / merchant';
    }

    // ]]>
    </script>

    <script src="./js/tooltip.js" type="text/javascript"></script>
    <meta name="OBGZip" content="true" />
        <!--[if IE 6]>
    <style type="text/css">
    /* <![CDATA[ */
    html {
        overflow-y: scroll;
    }
    /* ]]> */
    </style>
    <![endif]-->
</head>

<body>
<div id="TooltipContainer" onmouseover="holdTooltip();" onmouseout="swapTooltip('default');"></div>
    <div id="serverinfo">
<a href="main.php?token=a265dc411b059a3932a26eeefe2fc8f0" class="item">        <img class="icon" src="./themes/original/img/s_host.png" width="16" height="16" alt="" /> 
Server: 68.178.217.9</a>
        <span class="separator"><img class="icon" src="./themes/original/img/item_ltr.png" width="5" height="9" alt="-" /></span>
<a href="db_structure.php?db=newdbgcf&amp;token=a265dc411b059a3932a26eeefe2fc8f0" class="item">        <img class="icon" src="./themes/original/img/s_db.png" width="16" height="16" alt="" /> 
Database: newdbgcf</a>

<!-- PMA-SQL-ERROR -->
    <div class="error"><h1>Error</h1>
    <p><strong>SQL query:</strong>
<a href="tbl_sql.php?db=newdbgcf&amp;table=merchant&amp;token=a265dc411b059a3932a26eeefe2fc8f0&amp;sql_query=SHOW+TABLE+STATUS+LIKE+%27merchant%27%3B&amp;show_query=1"><img class="icon" src=" ./themes/original/img/b_edit.png" width="16" height="16" alt="Edit" /></a>    </p>
    <p>
        <span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">SHOW</span>  <span class="syntax_alpha syntax_alpha_reservedWord">TABLE</span>  <span class="syntax_alpha syntax_alpha_reservedWord">STATUS</span>  <span class="syntax_alpha syntax_alpha_reservedWord">LIKE</span>  <span class="syntax_quote syntax_quote_single">'merchant'</span><span class="syntax_punct syntax_punct_queryend">;</span><br /><br /></span>
    </p>
<p>
    <strong>MySQL said: </strong><a href="http://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html" target="mysql_doc"><img class="icon" src="./themes/original/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
</p>
<code>
#2006 - MySQL server has gone away
</code><br />
</div><fieldset class="tblFooters">    </fieldset>

<script type="text/javascript">
//<![CDATA[
// updates current settings
if (window.parent.setAll) {
    window.parent.setAll('en-utf-8', 'utf8_unicode_ci', '1', 'newdbgcf', 'merchant', 'a265dc411b059a3932a26eeefe2fc8f0');
}
    // set current db, table and sql query in the querywindow
if (window.parent.reload_querywindow) {
    window.parent.reload_querywindow(
        'newdbgcf',
        'merchant',
        '');
}

if (window.parent.frame_content) {
    // reset content frame name, as querywindow needs to set a unique name
    // before submitting form data, and navigation frame needs the original name
    if (typeof(window.parent.frame_content.name) != 'undefined'
     && window.parent.frame_content.name != 'frame_content') {
        window.parent.frame_content.name = 'frame_content';
    }
    if (typeof(window.parent.frame_content.id) != 'undefined'
     && window.parent.frame_content.id != 'frame_content') {
        window.parent.frame_content.id = 'frame_content';
    }
    //window.parent.frame_content.setAttribute('name', 'frame_content');
    //window.parent.frame_content.setAttribute('id', 'frame_content');
}
//]]>
</script>
</body>
</html>

This comes after a very number of "INSERT INTO" commands. The last of which is no different than the rest.

`
MySQL said:
#2006 - MySQL server has gone away` Did you see this in your CODE — Umair Ayub, Oct 31 '14 at 07:12

score 1 · Answer 1 · edited May 23 '17 at 10:25

There is probably an error that occured while exporting the database. You can either put that HTML-Code into a text file (.html) and open it with your browser to see what it contains or just go through the code.

You will find these lines in the code:

<strong>MySQL said: </strong><a href="http://dev.mysql.com/doc/refman/5.5/en/error-messages-server.html" target="mysql_doc"><img class="icon" src="./themes/original/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
</p>
<code>
#2006 - MySQL server has gone away
</code>

You now have your error message. Google it, search for it on stackoverflow, etc.

Maybe this helps as well:
MySQL Server has gone away when importing large sql file
It's about importing not exporting, but it should be the same problem...

Why is there PHP/HTML code at the end of my .sql file?

1 Answers1