Проблема Импорт базы на денвер. Ошибка #1064

Discussion in 'Перенос Joomla на хостинг и проблемы с хостингом' started by ripe, Sep 25, 2014.

  1. Offline

    ripe Недавно здесь

    Joined:
    Sep 25, 2014
    Messages:
    7
    Likes Received:
    0
    Gender:
    Female
    Большая просьба помочь исправить ошибку, версия phpMyAdmin: 3.5.1
    Ошибка
    SQL-запрос:

    Код (CODE):
    1. <!DOCTYPE html>< html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ru" lang="ru" 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=54f04af079b16fe18c80eb4c21b14fd8&amp;js_frame=right&amp;nocache=5568919715" /> <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/jquery/jquery-1.6.2+fix-9521.js?ts=1375007690" type="text/javascript"></script>< script src="./js/jquery/jquery-ui-1.8.16.custom.js?ts=1375007690" type="text/javascript"></script>< script src="./js/update-location.js?ts=1375007690" typ[...]


    Ответ MySQL:

    Код (CODE):
    1. #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>
    2. < html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ru" lang="r' at line 1
     
    Last edited by a moderator: Nov 25, 2014
    ripe, Sep 25, 2014
    #1

  2. Ads Master

     
  3. OlegK
    Offline

    OlegK Russian Joomla! Team Staff Member ⇒ Профи ⇐

    Joined:
    Jan 17, 2011
    Messages:
    7,812
    Likes Received:
    771
    Gender:
    Male
    OlegK, Sep 25, 2014
    #2
  4. Offline

    ripe Недавно здесь

    Joined:
    Sep 25, 2014
    Messages:
    7
    Likes Received:
    0
    Gender:
    Female
    ripe, Sep 26, 2014
    #3
  5. OlegK
    Offline

    OlegK Russian Joomla! Team Staff Member ⇒ Профи ⇐

    Joined:
    Jan 17, 2011
    Messages:
    7,812
    Likes Received:
    771
    Gender:
    Male
    я провожу экспорт,импорт БДс настройками по дефолту. Я задал простой вопрос-какой формат файла экспортируемой БД.
     
    OlegK, Sep 27, 2014
    #4
  6. Offline

    ripe Недавно здесь

    Joined:
    Sep 25, 2014
    Messages:
    7
    Likes Received:
    0
    Gender:
    Female
    формат sql
     
    ripe, Sep 27, 2014
    #5
  7. OlegK
    Offline

    OlegK Russian Joomla! Team Staff Member ⇒ Профи ⇐

    Joined:
    Jan 17, 2011
    Messages:
    7,812
    Likes Received:
    771
    Gender:
    Male
    Попробуй отдельно таблицу импортировать. Может где таблица поврежденная в экспортируемой БД.
     
    OlegK, Sep 27, 2014
    #6
  8. Offline

    ripe Недавно здесь

    Joined:
    Sep 25, 2014
    Messages:
    7
    Likes Received:
    0
    Gender:
    Female
    А как это сделать?
     
    ripe, Sep 27, 2014
    #7
  9. OlegK
    Offline

    OlegK Russian Joomla! Team Staff Member ⇒ Профи ⇐

    Joined:
    Jan 17, 2011
    Messages:
    7,812
    Likes Received:
    771
    Gender:
    Male
    Аналогично- выбрать таблицу-Экспорт,на локалке в новой БД - импорт файла
     
    OlegK, Sep 27, 2014
    #8
  10. Offline

    ripe Недавно здесь

    Joined:
    Sep 25, 2014
    Messages:
    7
    Likes Received:
    0
    Gender:
    Female
    Попробую, спасибо.
     
    ripe, Sep 27, 2014
    #9
< Ошибка сессии при переносе сайта на хостинг | Ошибка 404 при переносе на хостинг >

Share This Page

Loading...