MyBB Community Forums

Full Version: [Error Message]Database Import Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
(I backup file from other site and import it in my site)
mysite url= http://manojworlds.t15.org
when t want to upload/import backuped database file through phpmyadmin then appear the error below


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 @ 249
STR: </
SQL: <!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" lang="en">
<head profile="http://gmpg.org/xfn/1">
<title>MyBB Control Panel - Login</title>
<meta name="author" content="MyBB Group" />
<meta name="copyright" content="Copyright 2012 MyBB Group." />
<link rel="stylesheet" href="./styles/default/login.css" type="text/css" />
<script type="text/javascript" src="../jscripts/prototype.js"></script>
<script type="text/javascript" src="../jscripts/general.js"></script>
<script type="text/javascript" src="./jscripts/admincp.js"></script>
<script type="text/javascript">
//<![CDATA[
loading_text = 'Loading<br />Please wait...';


SQL query:

<!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" lang="en"> <head profile="http://gmpg.org/xfn/1"> <title>MyBB Control Panel - Login</title> <meta name="author" content="MyBB Group" /> <meta name="copyright" content="Copyright 2012 MyBB Group." /> <link rel="stylesheet" href="./styles/default/login.css" type="text/css" /> <script type="text/javascript" src="../jscripts/prototype.js"></script> <script type="text/javascript" src="../jscripts/general.js"></script> <script type="text/javascript" src="./jscripts/admincp.js"></script> <script type="text/javascript"> //<![CDATA[ loading_text = 'Loading<br />Please wait...';

MySQL said:
#1064 - 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 '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.or' at line 1


I allready try by selecting all tables but the same above problem
Sounds to me like whatever you're uploading is not a database backup.
the backup file is gz compressed
It looks like a HTML file and not like a database backup.