Ir para conteúdo

Arquivado

Este tópico foi arquivado e está fechado para novas respostas.

fabio.aurelio

Erro na importação - mysql mariadb

Recommended Posts

Pessoal, tudo bem?

 

Estou encontrando muitas dificuldade na importação de um banco de dados. Tentei alterar algumas config e versoes, mas sempre esbarra no mesmo erro.

 

Minha config do mysql é a seguinte:

innodb_version: 5.6.28-76.1
version: 10.1.13-MariaDB
version_comment: mariadb.org binary distribution
version_compile_machine:32
version_compile_os: Win32
YaSSL 2.3.9

Estou tentando importar o script abaixo:

-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 23-fev-2016 às 21:47
-- Versão do servidor: 5.6.26
-- PHP Version: 5.6.12

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `pacientes`
--
-- Extraindo dados da tabela `cadastropacientes`
--
INSERT INTO `cadastropacientes` (`id`, `codigopaciente`, `nomepaciente`, `cpfpaciente`, `rgpaciente`, `enderecopaciente`, `numeroendpaciente`, `ceppaciente`, `bairropaciente`, `servicopaciente`, `valorpaciente`, `telefonepaciente`, `vcpaciente`, `datavpaciente`, `emailpaciente`, `enderecocopaciente`, `numeroendcopaciente`, `cepcopaciente`, `bairrocopaciente`, `cidadecopaciente`, `situacaopaciente`, `obspaciente`, `tre`) VALUES
(1, 303361, ' Priscila alonso000000000000', '0x3631382e3737322e3535382d3135000000000', '0x333936373738350000', '0x5255412f41563a2053414e544120544552455a494e48410000000000000', 211, '0x313134363330383000', '0x534954494f205041454341524120564300000', 'TV', '0x302e30300000000000', '0x28313329333335322d3131363100000000000', 7, 20, 'teste@teste.com00\0', '0x5255412f41563a2053414e544120544552455a494e48410000000000000', 211, '0x313134363330383000', '0x534954494f205041454341524120564300000', '0x47554152554a410000', 'devolvidook00000\0', '0x2e0000000000000000000000', '0x00'),
(2, 291447, ' Luciana  Silveira00000000000\0', '0x3134392e3432342e3533382d3837000000000', '0x313932333632393300', '0x5255412f41563a204d4152494f2053494c5645495241000000000000000', 523, '0x313134373230323000', '0x4a415244494d20434f4e43454943414f5a494e480000000000000000000', 'TV000000000', '0x302e30300000000000', '0x28313329333335352d3635343900000000000', 16, 10, NULL, '0x5255412f41563a204d4152494f2053494c5645495241000000000000000', 523, '0x313134373230323000', '0x4a415244494d20434f4e43454943414f5a494e480000000000000000000', '0x47554152554a410000', 'devolvidook00000\0', NULL, '0x00',
(3, 348698, ' Osvaldo Pereira amancio 000000000\0', '0x3132312e3336302e3539382d3930000000000', '0x3233333230353530300000000000000000000', '0x41563a2041562052494f20414d415a4f4e4153200000000000000000000', 453, '0x313134343631333100', '0x42414c4e454152494f20505241494120444f20500000000000000000000', 'TV000000000', '0x35302e303000000000', '0x283133293838343231333633202f2028313329392d383835312d34343737000000000000000000', 91, 10, NULL, '0x41563a2041562052494f20414d415a4f4e4153200000000000000000000', 453, '0x313134343631333100', '0x42414c4e454152494f20505241494120444f20500000000000000000000', '0x47554152554a410000', 'devolvidook00000\0', NULL, '0x00',
(4, 354044, ' Leonardo marthei souza000000000000\0', '0x3339372e3338392e3232322d3931000000000', '0x3332363135363635330000000000000000000', '0x5255412f41563a2049534155444f204d415254494e53000000000000000', 380, '0x313134323531303000', '0x53414e5441204352555a20444f53204e415645470000000000000000000', 'TV000000000', '0x35302e303000000000', '0x2831332939383139392d39303036202f2028313329333335342d323832391a1a00000000000000', 69, 20, NULL, '0x5255412f41563a2049534155444f204d415254494e53000000000000000', 380, '0x313134323531303000', '0x53414e5441204352555a20444f53204e415645470000000000000000000', '0x47554152554a410000', 'devolvidook00000\0', NULL, '0x00',
(5, 322976, ' Marco stevao fernandes000000000', '0x3238352e3835302e3138382d3238000000000', '0x333236373735343800', '0x5255412f41563a2054484941474f2044412053494c56410000000000000', 349, '0x313134323131323000', '0x475541495542410000', 'TV000000000', '0x302e30300000000000', '0x283133293937333536383239202f2028313329373830392d34313432000', 31, 20, NULL, '0x5255412f41563a2054484941474f2044412053494c56410000000000000', 349, '0x313134323131323000', '0x475541495542410000', '0x47554152554a410000', 'devolvidook00000\0', NULL, '0x00',

O problema é que toda hora que tento importar, aparece este erro:

Unexpected character. (near "" at position 4)
Unexpected character. (near "" at position 5)
Unexpected character. (near "" at position 6)
Unexpected character. (near "" at position 9)
Unexpected character. (near "" at position 10)

Voces tem ideia do que seja?

Compartilhar este post


Link para o post
Compartilhar em outros sites

×

Informação importante

Ao usar o fórum, você concorda com nossos Termos e condições.