Jump to content
Sign in to follow this  
Haer

Ошибка при восстановлении базы

Recommended Posts

Распаковал сайт из бэкапа, создал пустую базу, пытаюсь залить старую базу через пхп му админ, пишет вот что, кто может помочь был бы признателен.

#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 'default-character-set=utf8 default-collation=utf8_general_ci' at line 1
DEFAULT - CHARACTER - SET = utf8DEFAULT - COLLATION = utf8_general_ci
Это при попытке восстановить старую базу на новом двежке ( с дефолтной базой )

Notice: Error: 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 'PK' at line 1
Error No: 1064
PK in /var/www/site/site.com/system/database/mysql.php on line 50
Warning: fopen(/var/www/contetights/conte-tights.com/system/logs/error.txt): failed to open stream: Permission denied in /var/www/site/site.com/system/library/log.php on line 12

Warning: fwrite() expects parameter 1 to be resource, boolean given in /var/www/site/site.com/system/library/log.php on line 14

Warning: fclose() expects parameter 1 to be resource, boolean given in /var/www/site/site.com/system/library/log.php on line 16
Edited by afwollis

Share this post


Link to post
Share on other sites

Скопировать дамп, удалить строку

DEFAULT - CHARACTER - SET = utf8DEFAULT - COLLATION = utf8_general_ci

и попробовать залить заново

Edited by afwollis

Share this post


Link to post
Share on other sites

тогда импортирует 0 , хотя и пишет что все ок. ( успешный импорт )

Edited by afwollis

Share this post


Link to post
Share on other sites

Дамп базы как делали, что выбирали?

 

у меня при дампе в phpMyadmin (через update) в самом файле идет:

 

-- phpMyAdmin SQL Dump
-- version 3.4.10.1
-- http://www.phpmyadmin.net
--
-- Хост: 127.0.0.1
-- Время создания: Июн 20 2013 г., 14:27
-- Версия сервера: 5.2.14
-- Версия PHP: 5.3.23

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */;
/*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */;
/*!40101 SET @[email protected]@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- База данных: `xxxxx`
--
-- --------------------------------------------------------

--
-- Структура таблицы `oc_address`
--

CREATE TABLE IF NOT EXISTS `oc_address` (
`address_id` int(11) NOT NULL AUTO_INCREMENT,

и тд

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.