V
V
vism2017-11-20 15:05:06
MySQL
vism, 2017-11-20 15:05:06

Why mysql dump is not imported and shows no errors?

I'm trying to import a MySql dump, version 5.7.20.
There is a line of this type, I give its beginning.

INSERT INTO `VerfuegungsDetails` VALUES (219,201,'gesundheit','O:10:\"Gesundheit\":20:{s:10:\"\0*\0hatArzt\";b:1;s:9:\"\0*\0anre ...

the line breaks on the \0 character...
that's what happens in the database
O:10:"Gesundheit":20:{s:10:"
. Also, if you just manually execute a request for an insert, it breaks on this character.
All in UTF-8
Errors are not displayed...
What could be wrong?
UPDATE
The reason was not in the import
my SQLyog didn't display everything after that Nil. Made select in the console, the line is imported correctly. I will pick SQLyog

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Bonce, 2019-08-31
@dimastik1986

Yes we can.
To do this, you need to find the latest zero and select all ones after zero.
Those.

SELECT * FROM table_name
WHERE date_column > (SELECT MAX(date_column) FROM table_name WHERE counter = 0)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question