#
MySQL Cases
Share some best practices of MySQL/Oracle/PostgreSQL from time to time, I hope this writing is useful to you.
If you have any questions, please contact me through shurp12138@gmail.com.
Table of contents
[MySQL-001.Without binlog and backup, how to recover the mistakenly deleted database?](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/001.Without%20binlog%20and%20backup%2C%20how%20to%20recover%20the%20mistakenly%20deleted%20database.md)
[MySQL-002.How to import data from Excel table into MySQL](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/002.How%20to%20import%20data%20from%20Excel%20table%20into%20MySQL.md)
[MySQL-003.How to modify the MySQL UUID](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/003.How%20to%20modify%20the%20MySQL%20UUID.md)
[MySQL-004.Unleashing the Power of MySQL Discover the World of Numerical Types!](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/004.Unleashing%20the%20Power%20of%20MySQL%20Discover%20the%20World%20of%20Numerical%20Types!.md)
[MySQL-005.The problem encountered by autocommmit when initializing mysql 8](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/005.The%20problem%20encountered%20by%20autocommmit%20when%20initializing%20mysql%208.md)
[MySQL-006.About the application scenarios of limit M, N](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/006.About%20the%20application%20scenarios%20of%20limit%20M%2C%20N.md)
[MySQL-007.Too many binlog logs cause the database to fail to start](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/007.Too%20many%20binlog%20logs%20cause%20the%20database%20to%20fail%20to%20start.md)
[MySQL-008.Install MySQL on UNIXLinux using generic binaries with Ansible](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/008.Install%20MySQL%20on%20UNIXLinux%20using%20generic%20binaries%20with%20Ansible.md)
[MySQL-009.I/O threads can't connect during master-slave replication due to mysql 8 Authentication plugin.](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/009.IO%20threads%20can't%20connect%20during%20master-slave%20replication%20due%20to%20mysql%208%20Authentication%20plugin.md)
[MySQL-010.Version problems encountered in backup and recovery with xtrabackup](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/010.Version%20problems%20encountered%20in%20backup%20and%20recovery%20with%20xtrabackup.md)
[MySQL-011.MySQL CASE 1:MySQL Shell Command Line Integration](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/011.MySQL%20CASE%201%20MySQL%20Shell%20Command%20Line%20Integration.md)
[MySQL-012.MySQL Database Backup Script use MySQL Shell](https://github.com/Jerry-Freelancer/MySQL-Best_Practice/blob/main/012.MySQL%20Database%20Backup%20Script%20use%20MySQL%20Shell%20.md)
###### About the author
Have more than 9 years experience in database architecture, and have worked in the top three ICT and Internet of Things solution providers in the world. Familiar with project decision-making process and operation mode, rich experience in solution pre-sale, enterprise architecture design, project management, etc. And experience in large-scale projects; Have a good understanding of enterprise ICT infrastructure (computing, storage, network), Internet of Things related knowledge fields and database (MySQL, Oracle, PostgreSQL) technology fields, and can make full use of the acquired concepts and knowledge in the scheme; Have a keen business sense and independent decision-making ability, and can quickly find and respond to customer needs through communication with customers; Be able to organize the preparation of promotional documents for products and solutions in customer industry, and have strong document preparation and presentation skills.