Showing Posts From
Mysql
Mysql Quick Export Command
Command Template {mysqldump_bin} --opt --hex-blob --skip-lock-tables --single-transaction --routines --events --skip-triggers --default-character-set='{db_charset}' --force --host='{db_host}' --port={db_port} --user='{db_user}' --password='{db_password}' '{db_name}'Parameter Explanation{mysqldump_bin} # mysqldump executable path (e.g., /usr/bin/mysqldump) --opt # Enables a series of optimization options (--add-drop-table, --add-locks, --create-options, --quick, etc.) --hex-blob # Exports binary fields (BLOB) in hexadecimal to prevent garbled text --skip-lock-tables # Skip table locking (avoid blocking other queries) --single-transaction # Export using single transaction (lock-free for InnoDB with good consistency) --routines # Export stored procedures and functions --events # Export event scheduler (EVENT) --skip-triggers # Skip trigger export --default-character-set='{db_charset}' # Specify character set, e.g., utf8mb4 --force # Continue execution even if errors occur --host='{db_host}' # Database host --port={db_port} # Database port --user='{db_user}' # Username --password='{db_password}' # Password '{db_name}' # Database name to exportUsage Example Export a database named mydb, MySQL running on localhost port 3306, character set utf8mb4, user root with password 123456: mysqldump --opt --hex-blob --skip-lock-tables --single-transaction --routines --events --skip-triggers \ --default-character-set='utf8mb4' --force \ --host='127.0.0.1' --port=3306 --user='root' --password='123456' 'mydb' > mydb.sql
Spring MVC Configuration File Transaction Rollback Failed (Mysql8.0+)
Problem Description In Mysql8.0+ environment, when using Spring MVC configuration file to configure transactions, transaction rollback fails. Solution In Mysql8.0, you need to inject SqlSessionTemplate: <!-- Mysql8.0 transaction rollback requires this injection--> <bean class="org.mybatis.spring.SqlSessionTemplate" id="sessionTemplate"> <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"/> <constructor-arg name="executorType" value="BATCH"/> </bean>Key Point You must inject SqlSessionTemplate and set executorType to BATCH mode.