Database error

  • anilorangeit

    (@anilorangeit)


    10 years, 3 months ago

    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

    (@geoffreyshilling)

    Volunteer Moderator

    10 years, 3 months ago

    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

    (@anilorangeit)

    10 years, 3 months ago

    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

    (@geoffreyshilling)

    Volunteer Moderator

    10 years, 3 months ago

    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.