CODEWITHSUNDEEP
phpmyadminmysql-backup
Saeed Afzal
Saeed Afzal

Reputation: 368

MySQL backup file includes HTML tags

I'm trying to download the Drupal 7 database from production server. Unfortunately, It's showing HTML tags in last of the file. 

    <!-- PMA-SQL-ERROR -->
        <div class="error"><h1>Error</h1>
    <p><strong>SQL query:</strong>
    <a href="tbl_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60i2819657_drup1%60+LIKE+%27login_destination%27&amp;show_query=1&amp;db=i2819657_drup1&amp;table=login_destination&amp;token=98a3c2701c0cfec8e0843f05dc044f9e"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a>    </p>
    <p>
    <span class="syntax"><span class="inner_sql"><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fshow.html&amp;token=98a3c2701c0cfec8e0843f05dc044f9e" target="mysql_doc"><span class="syntax_alpha syntax_alpha_reservedWord">SHOW</span></a>  <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">FROM</span>  <span class="syntax_quote syntax_quote_backtick">`i2819657_drup1`</span>  <a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Fstring-comparison-functions.html%23operator_like&amp;token=98a3c2701c0cfec8e0843f05dc044f9e" target="mysql_doc"><span class="syntax_alpha syntax_alpha_reservedWord">LIKE</span></a>  <span class="syntax_quote syntax_quote_single">'login_destination'</span></span></span>
    </p>
    <p>
        <strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Ferror-messages-server.html&amp;token=98a3c2701c0cfec8e0843f05dc044f9e" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>
    </p>
    <code>
    #2006 - MySQL server has gone away
    </code><br />
    </div>

Can anyone please hep me on it?

Upvotes: -1

Views: 124

Answers (1)

Saeed Afzal
Saeed Afzal

Reputation: 368

I found the solution by myself.

  1. Create php5.ini file in root of your web hosting cPanel account.

  2. Put this line in that file.

    mysql.connect_timeout = 120

  3. Now logout your cPanel account and login again.

  4. Go to PhpMyAdmin to export the backup file and download.
  5. Once downloaded. Open this file in any text editor and page down to end to verify if there are not HTML tags. It means problem fixed.

Thanks

Upvotes: 0

Related Questions