mysql migrate_MySQL(Migrate)

mysql to mysql: mysql workbench(schema transfer)

mysql to oracle: sqldeveloper

oracle/otherodbc to mysql: mysql workbench(migrate)

oracle/otherjdbc to oracle: sqldeveloper

mysql disk/dir migrate

sudo service mysql stop

cd /var/lib/

sudo mv mysql /mnt/hd/data/mysql3306

sudo ln -s /mnt/hd/data/mysql3306/mysql mysql

sudo chown mysql:mysql mysql

sudo nano

# Allow data dir access

/mnt/hd/data/mysql3306/mysql/ r,

/mnt/hd/data/mysql3306/mysql/** rwk,

sudo service mysql restart

mysql data backup(old tool)

mysqldump(flush tables with read lock; mysqldump --all-databases --lock-all-tables>dbdump.db;unlock tables)

mysqldump --host=192.168.1.210 --protocol=tcp --user=zming --password=xxxx --port=11011 --default-character-set=utf8 --skip-triggers cmt_member>cmt_data.sql

mysql -h localhost -uzming -pzming cmt < /home/cuikexi/data1/dump/CMT/cmt_data.sql

mysqldump -u zming -p xxxxx --default-character-set=utf8 xxx_db xx_table yy_table> xxxxxxx.sql

mysql -h 192.168.1.210 -p3306 -uzming -pzming xxx_db< xxxxxxx.sql

mysqldump --opt --all-databases > total-db-dump-file.sql

mysql -h localhost -u root -p database-name < text-file-with-sql-statements.sql

mysql data backup(new tool)

(dump sql)mysqlpump --host=192.168.1.210 --port=11011 --user=zming --password=xxxx --default-parallelism=4 --watch-progress >testpump.txt

(dump sql)mysqlpump --host=192.168.1.210 --port=11011 --user=zming --password=xxxx --users --compress-output=ZLIB>testpump.zlib

(zlib)zlib_decompress testpump.zlib testpump.txt

mysql -h localhost -uzming -pzming test < testpump.txt

oracle data backup

create directory SEED_DATA_DIR as 'C:/ade/aime_v/oracle/admin/seeddata/dpdump';

grant write,read on directory SEED_DATA_DIR to xx_user;

impdp xx_user/xx_passwd@pdbseeddata  directory=SEED_DATA_DIR dumpfile=trade_gnnt20170222.dmp  logfile=trade_impdp.log

expdp xx_user/xx_passwd@pdbseeddata directory=SEED_DATA_DIR file=trade_exp.dmp logfile=trade_expdp.log