Title: Database error
Last modified: August 31, 2016

---

# Database error

 *  [anilorangeit](https://wordpress.org/support/users/anilorangeit/)
 * (@anilorangeit)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/database-error-211/)
 * sir..
    we are facing database error when we import database SQL file in localhost.
   and we also try to remove this error code from SQL file but we can’t set up this.
   Error message shown in below.
 *     ```
       <!DOCTYPE html> <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&token=86009cb1a105e218bcaebbf165510f37&js_frame=right&nocache=5610656106" /> <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.16.custom.css" /> <meta name="robots" content="noindex,nofollow" /> <script src="./js/cross_framing_protection.js?ts=1375007690" type="text/javascript"></script> <script src="./js/jquery/jquery-1.6.2fix-9521.js?ts=1402701221" type="text/javascript"></script> <script src="./js/jquery/jquery-ui-1.8.16.custom.js?ts=137500[...]
   
       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>
       <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="e' at line 1
       ```
   

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Geoffrey Shilling](https://wordpress.org/support/users/geoffreyshilling/)
 * (@geoffreyshilling)
 * Volunteer Moderator
 * [10 years, 3 months ago](https://wordpress.org/support/topic/database-error-211/#post-7169397)
 * Can you please verify you are trying to upload a file with an extension of `.
   sql` and not `.html` or `.htm`? This file should not have any HTML code if you
   view it in a text editor.
 *  Thread Starter [anilorangeit](https://wordpress.org/support/users/anilorangeit/)
 * (@anilorangeit)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/database-error-211/#post-7169443)
 * sir ,i am already trying to upload a file with an extension of .sql . when i 
   export database file from server and i check this file manually then i find some
   html code in end of sql file. I am wondering what happened or why. so what we
   do in this case.
 *  [Geoffrey Shilling](https://wordpress.org/support/users/geoffreyshilling/)
 * (@geoffreyshilling)
 * Volunteer Moderator
 * [10 years, 3 months ago](https://wordpress.org/support/topic/database-error-211/#post-7169521)
 * Where are you getting the .sql file you are importing? Is it from a local installation
   or from a web host? It looks like something may be corrupting it.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database error’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Geoffrey Shilling](https://wordpress.org/support/users/geoffreyshilling/)
 * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/database-error-211/#post-7169521)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics
