S
S
Stanislav Smirnov2017-01-12 21:54:27
MySQL
Stanislav Smirnov, 2017-01-12 21:54:27

Uploading dapm to mysql, what's the problem?

When loading a thick base of 1500mb, an error occurred, when reloading the error in the same place, judging by the volume of 866mb.

ERROR 1300 (HY000) at line 1404: Invalid utf8 character string: '1\x85'

Server version: 5.5.53-0+deb8u1 (Debian) the server I'm uploading to.
The bases are quite old, they were lying around for 2 years but were in the archive, no one climbed into them.
Dump Information
-- MySQL dump 10.14 Distrib 5.3.6-MariaDB, for pc-linux-gnu (x86_64)
--
-- Host: localhost Database: auth
-- ----------------- --------------------------------------
-- Server version 5.3.6-MariaDB

Guys, help me out, you need to hand over the project :( And I'm generally an oak in this matter.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2017-01-12
@squard72

Invalid utf8 character string The
databases are quite old
. However, first check the encodings of the database, tables, columns, server and client.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question