A Flexible Approach to MySQL Backup Creation – flexmysqlbackup
DOI:
https://doi.org/10.70862/CSIR.2025.0201-10Keywords:
database backup, database recovery, storage system, MySQL, flexmysqlbackupAbstract
Creating backups in MySQL is an integral part of database management, particularly crucial in environments with large data volumes and critical information. Data recovery in the event of a system crash, data loss, or migration requirements is made possible by timely and accurate backups. MySQL is one of the most popular databases, utilized by numerous companies and projects. Mysqldump is a standard tool for backup and recovery. While effective for standard backups, mysqldump encounters several challenges in more complex scenarios, particularly when compatibility across different MySQL versions is required. This paper proposes a new approach, flexmysqlbackup, which provides more flexible backup options and rapid recovery without the limitations imposed by MySQL versions. Implementation scripts are presented, along with experiments demonstrating and proving its effectiveness.
References
Reese, G. (2007). MySQL pocket reference: SQL functions and utilities (pp. 37–41). O'Reilly Media, Inc.
Norman, M. (2004). Changing data. In Database design manual: Using MySQL for Windows (pp. 87-101). Springer. https://doi.org/10.1007/1-85233-859-8_8
Schwartz, B., Zaitsev, P., & Tkachenko, V. (2012). High performance MySQL: Optimization, backups, and replication (pp. 622–623). O'Reilly Media, Inc.
Kofler, M. (2005). mysql, mysqladmin, and mysqldump. In The Definitive Guide to MySQL 5 (pp. 61–70). https://doi.org/10.1007/978-1-4302-0071-0_4
MySQL Documentation. (n.d.). Backup and recovery. MySQL 8.0 Reference Manual. Retrieved March 20, 2025, from https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
Reese, G. (2003). MySQL pocket reference (pp. 3, 61). O'Reilly Media, Inc.
Kromann, F. M. (2018). MySQL views. In Beginning PHP and MySQL (pp. 733-750). Apress. https://doi.org/10.1007/978-1-4302-6044-8_31
MySQL Documentation. (n.d.). mysqldump — A database backup program. MySQL 8.0 Reference Manual. Retrieved from https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
MySQL. (n.d.). Upgrading to MySQL 8.0? Here is what you need to know... Retrieved from https://dev.mysql.com/blog-archive/upgrading-to-mysql-8-0-here-is-what-you-need-to-know/
Christudas, B. (2019). MySQL (pp. 877–884). Apress. https://doi.org/10.1007/978-1-4842-4501-9_27
Dyer, R. (2008). MySQL in a nutshell (pp. 68, 105–109, 235, 315–317, 323, 362–363). O'Reilly Media, Inc.
DuBois, P. (2013). MySQL (pp. 212–213, 684–685, 1005, 1078, 1110, 1148). Addison-Wesley. ISBN 9780321833877.
Schwartz, B., Zaitsev, P., & Tkachenko, V. (2012). High performance MySQL: Optimization, backups, and replication. O'Reilly Media, pp. 298–305.
Bell, C., Kindahl, M., & Thalmann, L. (2014). MySQL high availability: Tools for building robust data centers. O'Reilly Media.
Tahaghoghi, S. M. M., & Williams, H. E. (2006). Learning MySQL. O’Reilly Media, Inc. ISBN 9780596008642.
Krogh, J. W. (2020). MySQL 8 query performance tuning: A systematic method for improving execution speeds (pp. 111–131). Apress. https://doi.org/10.1007/978-1-4842-5584-1
Harrison, G., & Feuerstein, S. (2006). MySQL Stored Procedure Programming: Building High-Performance Web Applications in MySQL. O'Reilly Media.
Newham, C. (2005). Learning the bash shell: Unix shell programming (p. 16). O'Reilly Media.
Richardson, L. (2005). Text manipulation with sed. Linux Journal, Slashdot Media.
Natarajan R. (2007). Sed and awk 101 hacks. Publ. The Geek Stuff.
Dougherty, D., & Robbins, A. (1997). sed & awk: UNIX power tools. O'Reilly Media, Inc.
Shotts, W. (2012). The Linux command line: A complete introduction (pp. 81–87). No Starch Press.
Nemeth, E., Snyder, G., Hein, T. R., Whaley, B., & Mackin, D. (2018). UNIX and Linux system administration handbook (pp. 156–158). USENIX Open Access Policy, 59.
MySQL Documentation. (n.d.). Sakila sample database. Retrieved April 1, 2025, from https://dev.mysql.com/doc/sakila/en/
Blum, R. (2008). Linux command line and shell scripting bible (p. 228). Wiley Publishing, Inc. ISBN 978-0-470-25128-7.
MySQL. (n.d.). MySQL 8.0 Reference Manual: MySQL data dictionary. Retrieved from https://dev.mysql.com/doc/refman/8.0/en/data-dictionary.html
Downloads
Published
License
Copyright (c) 2025 Dimitar Todorov (Author)
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
