Stack Overflow
Stack Overflow

Questions tagged [mysqldbcompare]

a MySQL utility for comparing databases

mysqldbcompare is a MySQL utility for comparing databases.

https://dev.mysql.com/doc/mysql-utilities/1.5/en/mysqldbcompare.html

13 questions
5
votes
2 answers

mysqldbcompare access denied but mysql command works

I'm trying to use the mysqldbcompare tool but getting a connection error: $ mysqldbcompare --server1=client --skip-data-check db1:db2 # server1 on : ... ERROR: Access denied for user 'root'@'' (using password: YES) I can use mysql and…
user1274635
4
votes
1 answer

mysqldbcompare fails with schemas with a '-' in their name

The following command fails mysqldbcompare --server1=un:pw@server1 --server2=un:pw@server2 --difftype=sql store-staging:store-beta with the following error: mysqldbcompare: error: Cannot parse the specified database(s): 'store-staging:store-beta'.…
Clarkie
  • 7,490
  • 9
  • 39
  • 53
2
votes
2 answers

How do I get pylint to recognize MySQLdb members?

import MySQLdb try: dbcon = MySQLdb.connect(host=host_name, user=user_name, passwd=password, db=db_name) except MySQLdb.Error: pass getting this pylint warning Module 'MySQLdb' has no 'Error' member…
Prashant
  • 21
  • 5
1
vote
0 answers

mysqldbcompare fails to ignore database name differences

I am trying to use mysqldbcompare (version 1.6.5) to automatically generate SQL commands to synchronize the schemas of a development and production database on the same server. I am using the following command: mysqldbcompare --server1=client:3306…
wrm
  • 11
  • 2
0
votes
1 answer

MYSQL: How to update unique random number to existing rows

It's been my first question to this website, I'm sorry if I used any wrong keywords. I have been with one problem from quite a few days. The Problem is, I have a MYSQL table named property where I wanted to add a ref number which will be a unique 6…
Piyush
  • 1
0
votes
0 answers

How to compare two MARIADB schemas via command line

I tried some commands from (https://docs.oracle.com/cd/E17952_01/mysql-utilities-1.4-en/mysqldbcompare.html) But the comparison does not create tables and foreign keys... What is the best command to compare two mariadb schemas creating columns,…
Sérgio Thiago Mendonça
  • 1,161
  • 2
  • 13
  • 23
0
votes
1 answer

How to compare two large database using mysql utilities

I have two database servers those are replicated in Master to Master replication process. For some reason replication got stopped. Now I want to compare same database, EXAMPLE on both server for data consistency. But the problem is the database has…
Hasanuzzaman Sattar
  • 592
  • 1
  • 5
  • 20
0
votes
2 answers

Getting SQL database parameters as dict for comparison

So, I'm able to get the information from MySQL database. However, I'm trying to import the database as a dictionary so that I can compare "username" to the "level" of that user. However, it appears to be pulling it as a list. Here is my…
Nickolas Kent
  • 61
  • 1
  • 1
  • 5
0
votes
2 answers

mysql-python won't install on MacOS

So I have tried multiple ways to install mysql-python and MYSQLdb. I have tried downloading through this link: https://sourceforge.net/projects/mysql-python/ and then when I run python setup.py install I get the following errors: Downloading…
jsteele
  • 325
  • 1
  • 4
  • 13
0
votes
0 answers

msqldbcompare failed because of special characters

I'm trying to compare master and slave using mysqldbcompare utility, but observed that it's getting failed and in compare result its not showing difference rows.so I manually compared tables and observed that there is some special character in…
Saikumar A
  • 213
  • 1
  • 2
  • 12
0
votes
1 answer

How to merge Two queries into one and result in one row

SELECT lp.lead_bucket_no , case when p.product = 'S-400' then qty end as 'S400' , case when p.product = 'Dish Antenna' then qty end as 'DishAntenna' FROM lead_products lp INNER JOIN products p ON p.product_id = lp.product_id WHERE type = 'stock'…
Dinesh Patil
  • 104
  • 2
  • 8
0
votes
1 answer

Can mysqldbcompare utility be used on AIX?

I'm Trying to compare Data between two databases on different servers. The mysql database are located on 2 AIX boxes. Im using mysqldbcompare utility to compare the data. I get the following error: Server1 connected.... server1 is incompatible .…
Saradob
  • 3
  • 1
0
votes
2 answers

Redirecting output of mysqldbcompare utility into a text file

I am running a command on mysqlulc> prompt on CMD. The command is as below:- mysqluc> mysqldbcompare --server1=root:Password1!@host1 --server2=root:Password1!@host2 teststore:teststore --run-all-tests --changes-for=server2 --difftype=sql I want to…
Arun
  • 31
  • 6