problem with mysqldbcopy
Posted by: Pokraczny Pokrak
Date: November 14, 2017 02:22AM

mysqldbcopy --source=user:1qaZXsw2@localhost:3306:/var/run/mysqld/mysqld.sock --destination=user:1qaZXsw2@localhost:3306:/var/run/mysqld/mysqld.sock db1:db2
WARNING: Using a password on the command line interface can be insecure.
# Source on localhost: ... connected.
# Destination on localhost: ... connected.
# Copying database db1 renamed as db2
ERROR: Query failed. 1302 (HY000): Conflicting declarations: 'CHARACTER SET DEFAULT' and 'CHARACTER SET latin2'

This error shows me each time regardless of the encoding settings in the database. db1 is a single table base

+----------------+
| Tables_in_db1 |
+----------------+
| db1_table |
+----------------+

select * from db1_table;
+------+
| x |
+------+
| 1 |
+------+
1 row in set (0.00 sec)

SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin2 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

when i remove latin2 from config:

WARNING: Using a password on the command line interface can be insecure.
# Source on localhost: ... connected.
# Destination on localhost: ... connected.
# Copying database db1 renamed as db2
ERROR: Query failed. 1302 (HY000): Conflicting declarations: 'CHARACTER SET DEFAULT' and 'CHARACTER SET latin1'

SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+


How to fix this problem?

Options: ReplyQuote


Subject
Written By
Posted
problem with mysqldbcopy
November 14, 2017 02:22AM
November 14, 2017 10:07AM
November 15, 2017 01:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.