zpcastaneda

127.0.0.1 media-match.com
127.0.0.1 adclick.g.doublecklick.net
127.0.0.1 www.googleadservices.com
127.0.0.1 open.spotify.com
127.0.0.1 pagead2.googlesyndication.com
127.0.0.1 desktop.spotify.com
127.0.0.1 googleads.g.doubleclick.net
127.0.0.1 pubads.g.doubleclick.net
127.0.0.1 audio2.spotify.com
127.0.0.1 www.omaze.com

zpcastaneda

SET @database_current = '<production>';
SET @database_dev = '<development>';
-- column and datatype comparison
SELECT a.TABLE_NAME, a.COLUMN_NAME, a.DATA_TYPE, a.CHARACTER_MAXIMUM_LENGTH,
	b.COLUMN_NAME, b.DATA_TYPE, b.CHARACTER_MAXIMUM_LENGTH
FROM information_schema.COLUMNS a
	LEFT JOIN information_schema.COLUMNS b ON b.COLUMN_NAME = a.COLUMN_NAME
		AND b.TABLE_NAME = a.TABLE_NAME
		AND b.TABLE_SCHEMA = @database_current
WHERE a.TABLE_SCHEMA = @database_dev

zpcastaneda

-- set isolation for processing
SET SESSION tx_isolation = 'READ-COMMITTED';
-- set config for processing
SET SQL_SAFE_UPDATES = 0;
SET AUTOCOMMIT = 0;
START TRANSACTION;

-- save and apply
COMMIT;
SET AUTOCOMMIT = 1;

zpcastaneda

[mysqld]

basedir = "/mysql"
datadir = "/mysql/data"
port = 3306
server_id = 1
log_error = "mysql_error.log"
pid_file = "mysql.pid"
socket = "/mysql/mysql.sock"