PDA

View Full Version : Error while importing database phpmyadmin


ebp123
01-21-2012, 01:05 AM
Question - I recently created 3 backups of my mysql databse in cpanel and each one was a different size (12mb 44mb 54mb) while the size of the database in cpanel said 100mb. Is this normal, and are the databases still good?

Also, the following error comes up every time I try to upload the 54mb database backup into myphpadmin and im not sure what to do to fix it.

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" xml:lang="en" lang="en" dir="ltr"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <title>phpMyAdmin</title> <link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?server=1&amp;token=61ad642f45d844e2 d0661c8c7f3b94fb&amp;js_frame=right&amp;nocache=5290608639" /> <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=1320934491" type="text/javascript"></script> <script src="./js/jquery/jquery-1.4.4.js?ts=1320934[...]

MySQL said: Documentation
#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.w' at line 1