Performed a bad import to my WordPress install and decided to restore from the mqSQL backup (full export) I had made minutes earlier.
Dropped all tables in the database and then did an import from my .sql file.
I encounter the error below in PHPmyAdmin and find that only 22 of my 44 tables were imported, so I assume the import was aborted.
Was my MySQL db backup corrupt or something? The export/download seemed to go smoothly.
My error is #1064, You have an error in your SQL syntax, check the manual… (see image)
Charset appears to be UTF-8 and I’m importing in UTF-8
-- Host: localhost
-- Generation Time: Apr 15, 2013 at 07:01 PM
-- Server version: 5.5.23
-- PHP Version: 5.2.17
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
2 Answers
Figured it out upon examining my SQL file. It begins as SQL, and near the end changes to PHP. For some reason the download got messed up and the SQL export began outputting the PHP of the PHPmyAdmin page I was on! (not even just the client side HTML, it was spitting out server side PHP).
Anyways, my backup is corrupt. I had to restore from another database backup and now I need to puzzle piece content together from the last couple of days.
Here’s the code from the bottom of my SQL file, just for reference (preceding lines are regular SQL output, 19 MB of text content).
...
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="icon" href="https://wordpress.stackexchange.com/questions/95964/./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="https://wordpress.stackexchange.com/questions/95964/./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?server=1&token=6a3930a6cce9b6bf3d9810d8f65e3f1c&js_frame=right&nocache=5412529155" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui-1.8.custom.css" />
<meta name="robots" content="noindex,nofollow" />
<script src="./js/cross_framing_protection.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/jquery/jquery-1.4.4.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/update-location.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/config.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/functions.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/jquery/jquery.qtip-1.0.0.min.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/messages.php?lang=en&db=advdly_adaily&token=6a3930a6cce9b6bf3d9810d8f65e3f1c" type="text/javascript"></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="www.advocatedaily.com / localhost / advdly_adaily / wp_rg_form | phpMyAdmin 3.4.11.1";
}
// ]]>
</script>
<meta name="OBGZip" content="true" />
<!--[if IE 6]>
<style type="text/css">
/* <![CDATA[ */
html {
overflow-y: scroll;
}
/* ]]> */
</style>
<![endif]-->
</head>
<body>
<div id="prefs_autoload" class="notice" style="display:none">
<form action="prefs_manage.php" method="post">
<input type="hidden" name="token" value="6a3930a6cce9b6bf3d9810d8f65e3f1c" />
<input type="hidden" name="json" value="" />
<input type="hidden" name="submit_import" value="1" />
<input type="hidden" name="return_url" value="export.php?" />
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session? <br />
<a href="#yes">Yes</a> / <a href="#no">No</a>
</form>
</div>
<div id="serverinfo">
<a href="main.php?token=6a3930a6cce9b6bf3d9810d8f65e3f1c" class="item"> <img class="icon" src="./themes/pmahomme/img/s_host.png" width="16" height="16" alt="" />
localhost</a>
<span class="separator"><img class="icon" src="./themes/pmahomme/img/item_ltr.png" width="5" height="9" alt="-" /></span>
<a href="db_structure.php?db=advdly_adaily&token=6a3930a6cce9b6bf3d9810d8f65e3f1c" class="item"> <img class="icon" src="./themes/pmahomme/img/s_db.png" width="16" height="16" alt="" />
advdly_adaily</a>
<span class="separator"><img class="icon" src="./themes/pmahomme/img/item_ltr.png" width="5" height="9" alt="-" /></span>
<a href="sql.php?db=advdly_adaily&table=wp_rg_form&token=6a3930a6cce9b6bf3d9810d8f65e3f1c" class="item"> <img class="icon" src="./themes/pmahomme/img/s_tbl.png" width="16" height="16" alt="" />
wp_rg_form</a>
</div>
<!-- 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+%60advdly_adaily%60+LIKE+%27wp_rg_form%27&show_query=1&db=advdly_adaily&table=wp_rg_form&token=6a3930a6cce9b6bf3d9810d8f65e3f1c"><span class="nowrap"><img src="./themes/pmahomme/img/b_edit.png" title="Edit" alt="Edit" class="icon" width="16" height="16" /> 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.5%2Fen%2Fshow.html&token=6a3930a6cce9b6bf3d9810d8f65e3f1c" 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">`advdly_adaily`</span> <span class="syntax_alpha syntax_alpha_reservedWord">LIKE</span> <span class="syntax_quote syntax_quote_single">'wp_rg_form'</span></span></span>
</p>
<p>
<strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html&token=6a3930a6cce9b6bf3d9810d8f65e3f1c" target="mysql_doc"><img class="icon" src="./themes/pmahomme/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
</p>
<code>
#2006 - MySQL server has gone away
</code><br />
</div><script type="text/javascript">
//<![CDATA[
$(document).ready(function(){
// updates current settings
if (window.parent.setAll) {
window.parent.setAll('en', 'utf8_general_ci', '1', 'advdly_adaily', 'wp_rg_form', '6a3930a6cce9b6bf3d9810d8f65e3f1c');
}
// set current db, table and sql query in the querywindow
if (window.parent.reload_querywindow) {
window.parent.reload_querywindow(
'advdly_adaily',
'wp_rg_form',
'');
}
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>
