Questions tagged [mydumper]

3 questions
1
vote
1 answer

What are the semantics of not using "FTWL to guarantee that the dump file is consistent with metadata"?

When migrating data from AWS RDS MySQL to TiDB using DM we got the following error: Couldn't acquire global lock, snapshots will not be consistent: Access denied for user 'root'@'%' (using password: YES) The TiDB documentation suggested the…
merlin2011
  • 71,677
  • 44
  • 195
  • 329
0
votes
0 answers

mydumper isn't generated replica metadata

I'm running mydumper to generate a dump of a MySQL and the metadata file only contains: $ cat metadata Started dump at: 2023-08-13 17:30:00 Finished dump at: 2023-08-13 17:45:08 while on the document it says it should look like this: Started dump…
Pablo Fernandez
  • 279,434
  • 135
  • 377
  • 622
0
votes
0 answers

mydumper export cause error:cannot create a JSON value from a string with CHARACTER SET 'binary'

my error was: export cause db error, not import cause error. MySQL version: 5.7.12 and my table defined as: CREATE TABLE `process_ext_info` ( `id` bigint(20) NOT NULL COMMENT 'key', `msg_info` longtext CHARACTER SET utf8 NOT NULL COMMENT 'task…
youbl
  • 134
  • 1
  • 11