A Flexible Approach to MySQL Backup Creation – flexmysqlbackup

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 on...

Full description

Saved in:
Bibliographic Details
Published inComputer Science and Interdisciplinary Research Journal Vol. 2; no. 1
Main Author Todorov, Dimitar
Format Journal Article
LanguageEnglish
Published 02.06.2025
Online AccessGet full text
ISSN3033-1218
3033-1218
DOI10.70862/CSIR.2025.0201-10

Cover

Abstract 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.
AbstractList 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.
Author Todorov, Dimitar
Author_xml – sequence: 1
  givenname: Dimitar
  surname: Todorov
  fullname: Todorov, Dimitar
BookMark eNplkEtOwzAQhi1UJErpBVj5Ain2uLYnO0rEo1IRgnYf2a4jItIk2K0gO-7ADTkJfbAAsZpfM_P9i--U9Oqm9oScczbSDBVcZPPp0wgYyBEDxhPOjkhfMCESDhx7v_IJGcZYWiY1T1Eh9MnlhN5U_r20laeTtg2Ncc903dD7bv44o1fGvWxamgVv1mVT06-PT1ps31ddfK3s_nhGjgtTRT_8mQOyuLleZHfJ7OF2mk1miUPNEo1oMDUFs85CoexYKQGgQDI-BokFiqW2Sykl84Bj7VO9lAoFcpE6I70TAyIOtZu6Nd2bqaq8DeXKhC7nLN9ryF0sQ77TkO80bPdbCg6UC02MwRf_oZ27v9A3JKlhXQ
ContentType Journal Article
DBID AAYXX
CITATION
ADTOC
UNPAY
DOI 10.70862/CSIR.2025.0201-10
DatabaseName CrossRef
Unpaywall for CDI: Periodical Content
Unpaywall
DatabaseTitle CrossRef
DatabaseTitleList CrossRef
Database_xml – sequence: 1
  dbid: UNPAY
  name: Unpaywall
  url: https://proxy.k.utb.cz/login?url=https://unpaywall.org/
  sourceTypes: Open Access Repository
DeliveryMethod fulltext_linktorsrc
EISSN 3033-1218
ExternalDocumentID 10.70862/csir.2025.0201-10
10_70862_CSIR_2025_0201_10
GroupedDBID AAYXX
CITATION
M~E
ADTOC
UNPAY
ID FETCH-LOGICAL-c870-788a89af0bcb2f6b466322625014258f83d7bd5550e2847e97d56838139ca5ec3
IEDL.DBID UNPAY
ISSN 3033-1218
IngestDate Wed Oct 01 15:50:10 EDT 2025
Wed Oct 01 05:52:55 EDT 2025
IsDoiOpenAccess false
IsOpenAccess true
IsPeerReviewed false
IsScholarly false
Issue 1
Language English
License https://creativecommons.org/licenses/by-nc-nd/4.0
cc-by-nc-nd
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-c870-788a89af0bcb2f6b466322625014258f83d7bd5550e2847e97d56838139ca5ec3
OpenAccessLink https://proxy.k.utb.cz/login?url=https://csirjournal.com/index.php/csir/article/download/20/13
ParticipantIDs unpaywall_primary_10_70862_csir_2025_0201_10
crossref_primary_10_70862_CSIR_2025_0201_10
ProviderPackageCode CITATION
AAYXX
PublicationCentury 2000
PublicationDate 2025-06-02
PublicationDateYYYYMMDD 2025-06-02
PublicationDate_xml – month: 06
  year: 2025
  text: 2025-06-02
  day: 02
PublicationDecade 2020
PublicationTitle Computer Science and Interdisciplinary Research Journal
PublicationYear 2025
SSID ssib057198682
Score 1.9135882
Snippet Creating backups in MySQL is an integral part of database management, particularly crucial in environments with large data volumes and critical information....
SourceID unpaywall
crossref
SourceType Open Access Repository
Index Database
Title A Flexible Approach to MySQL Backup Creation – flexmysqlbackup
URI https://csirjournal.com/index.php/csir/article/download/20/13
UnpaywallVersion publishedVersion
Volume 2
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
journalDatabaseRights – providerCode: PRVHPJ
  databaseName: ROAD: Directory of Open Access Scholarly Resources
  customDbUrl:
  eissn: 3033-1218
  dateEnd: 99991231
  omitProxy: true
  ssIdentifier: ssib057198682
  issn: 3033-1218
  databaseCode: M~E
  dateStart: 20240101
  isFulltext: true
  titleUrlDefault: https://road.issn.org
  providerName: ISSN International Centre
link http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwnV1LT8JAEN4oHDz5iBo1SvbgTQv0sX3crASCRogKJHhqdrfbC7WgtDF4MP4H_6G_xJm2GtGTXruTZjOz3fm-dOYbQo5N2dR5KAzNDB2hWawpNRGajmYJbFxmyhF5k1ivb3dH1uWYjcvaHOyFkUDWSy_m93SuGYhCEflKo3RnI0Ql-SkPgbs3cGZt1WYAxSukOupf-3c4mQxnlOmQv4pGGQeRe_4KoIQGqwNIwkqupWS0liUzvnjicfwtw3Q2ijGq81yYEAtLJvUsFXX5_EO28d-b3yTrJfakfmGwRVZUsk3OfNpBUUwRK-qXAuM0ndLeYnBzRc-5nGQz2iqhJX1_faMRmN8v5g-xyBd3yLDTHra6WjlWQZPwcWL5IHc9HjWFFEZkCwswB2AwA38wGsyNXIxayIC5KExdynNCZruQ2E1PcqakuUsqyTRRe4TqoeHouhJAEbmlHF1EShem5yqg646Mon1y8uneYFaIZwRAOvJgBK3BxW2AwQgwGPB8n5x-ReC3OXpwyfzgb-aHpJI-ZuoIIEQqamS199KulcflA8RYysQ
linkProvider Unpaywall
linkToUnpaywall http://utb.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwnV09T8MwELVQOzDxIUAUAfLABmmbD8fJRqioCqIV0FYqU2Q7zkJIC02EysR_4B_yS7hLAqIwwRqfIuvO8b2n3L0j5MhWbVNE0jLsiEvDYW1lyMjmhiOxcZlpLosmsf7A7Y2dywmbVLU52AujgKxXXizu6UIzEIUiipVW5c5WhEryUxEBd2_hzNq6ywCK10h9PLgO7nAyGc4oMyF_lY0yHJF78QqghBZrAkjCSq6lZLSapzOxeBZJ8i3DdNfLMarzQpgQC0vum3kmm-rlh2zjvze_QdYq7EmD0mCTrOh0i5wGtIuimDLRNKgExmk2pf3F8OaKngl1n89op4KW9P31jcZg_rCYPyayWNwmo-75qNMzqrEKhoKPE8sHheeLuC2VtGJXOoA5AINZ-IPRYl7sYdQiBsxFY-rSPo-Y60Fit30lmFb2Dqml01TvEmpGFjdNLYEiCkdzU8balLbvaaDrXMVxgxx_ujecleIZIZCOIhhhZ3hxG2IwQgwGPG-Qk68I_DZHDy6Z7_3NfJ_UsqdcHwCEyORhdVA-AAhayZM
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=A+Flexible+Approach+to+MySQL+Backup+Creation+%E2%80%93+flexmysqlbackup&rft.jtitle=Computer+Science+and+Interdisciplinary+Research+Journal&rft.au=Todorov%2C+Dimitar&rft.date=2025-06-02&rft.issn=3033-1218&rft.eissn=3033-1218&rft.volume=2&rft.issue=1&rft_id=info:doi/10.70862%2FCSIR.2025.0201-10&rft.externalDBID=n%2Fa&rft.externalDocID=10_70862_CSIR_2025_0201_10
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=3033-1218&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=3033-1218&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=3033-1218&client=summon