# mysqldiff

**Repository Path**: hcxiong/mysqldiff

## Basic Information

- **Project Name**: mysqldiff
- **Description**: 数据库表结构，存储过程，函数，视图，表数据对比工具，差异生成SQL，支持SSH连接。
- **Primary Language**: NodeJS
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 89
- **Forks**: 12
- **Created**: 2017-08-24
- **Last Updated**: 2024-10-31

## Categories & Tags

**Categories**: database-dev

**Tags**: None

## README

mysql 数据库表机构对比工具
=====

#centos7 安装nodejs
```
rpm -Uvh https://rpm.nodesource.com/pub_5.x/el/7/x86_64/nodesource-release-el7-1.noarch.rpm
yum install nodejs -y
```

#获取代码安装
```
git clone https://github.com/LiveXY/mysqldiff.git
cd mysqldiff/
npm install && npm link
```

#实例
```
#base
mysqldiff --db1=dbuser:dbpassword@dbhost~database --db2=dbuser:dbpassword@dbhost~database
mysqldiff -1 dbuser:dbpassword@dbhost~database -2 dbuser:dbpassword@dbhost~database
#reverse
mysqldiff --db1=dbuser:dbpassword@dbhost~database --db2=dbuser:dbpassword@dbhost~database --reverse
mysqldiff -1 dbuser:dbpassword@dbhost~database -2 dbuser:dbpassword@dbhost~database -r
#port
mysqldiff --db1=dbuser:dbpassword@dbhost~database#dbport --db2=dbuser:dbpassword@dbhost~database#dbport
mysqldiff -1 dbuser:dbpassword@dbhost~database#dbport -2 dbuser:dbpassword@dbhost~database#dbport
#ssh
mysqldiff --db1=dbuser:dbpassword@dbhost~database --db2=dbuser:dbpassword@dbhost~database:dbport+sshuser:sshpassword@sshhost#sshport
mysqldiff -1 dbuser:dbpassword@dbhost~database -2 dbuser:dbpassword@dbhost~database:dbport+sshuser:sshpassword@sshhost#sshport
#data
mysqldiff --db1=dbuser:dbpassword@dbhost~database --db2=dbuser:dbpassword@dbhost~database --diff=data --table=db1tablename:db2tablename
mysqldiff -1 dbuser:dbpassword@dbhost~database -2 dbuser:dbpassword@dbhost~database -d data -t db1tablename:db2tablename
```

#运行环境
支持linux、mac，ssh不支持windows