Erro na importação - mysql mariadb
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?
Discussão (3)
Carregando comentários...