2021-02-18 mysql调试环境搭建

此次使用的mysql版本为server-10.0-galera

初始化实例

./scripts/mysql_install_db.sh --srcdir=. --ldata=/data1/mycode/mysql_debug/server-10.0-galera/mysql_stuff/data --force

/data1/mycode/mysql_debug/server-10.0-galera/cmake-build-debug/sql/mysqld   --lc-messages-dir=/data1/mycode/mysql_debug/server-10.0-galera/cmake-build-debug/sql/share/english/.. --bootstrap --basedir=/data1/mycode/mysql_debug/server-10.0-galera/cmake-build-debug --datadir=/data1/mycode/mysql_debug/server-10.0-galera/mysql_stuff/data2 --log-warnings=0 --loose-skip-ndbcluster  --max_allowed_packet=8M --net_buffer_length=16K

启动

/data1/mycode/mysql_debug/server-10.0-galera/cmake-build-debug/sql/mysqld --defaults-file=/data1/mycode/mysql_debug/server-10.0-galera/mysql_stuff/etc/my3311.cnf --user=mysql --basedir=/data1/mycode/mysql_debug/server-10.0-galera/mysql_stuff/install --datadir=/data1/mycode/mysql_debug/server-10.0-galera/mysql_stuff/data

client

/data1/mycode/mysql_debug/server-10.0-galera/cmake-build-debug/client/mysql -uroot -S /data1/mycode/mysql_debug/server-10.0-galera/mysql_stuff/data/mysql.sock

备份

/data1/mycode/mysql_debug/server-10.0-galera/cmake-build-debug/client/mysqldump -uroot -S /data1/mycode/mysql_debug/server-10.0-galera/mysql_stuff/data2/mysql.sock djyv4_info_filling > /home/jzh/djyv4_info_filling.sql