{"id":2184,"date":"2024-05-28T17:44:56","date_gmt":"2024-05-28T15:44:56","guid":{"rendered":"https:\/\/alessandromasciadri.com\/?p=2184"},"modified":"2024-05-28T17:50:03","modified_gmt":"2024-05-28T15:50:03","slug":"come-eseguire-il-backup-di-mysql-con-automysqlbackup","status":"publish","type":"post","link":"https:\/\/alessandromasciadri.com\/come-eseguire-il-backup-di-mysql-con-automysqlbackup\/","title":{"rendered":"Come eseguire il backup di MySQL con AutoMySQLBackup"},"content":{"rendered":"\t\t<div data-akihiro-type=\"ama-post\" data-akihiro-id=\"2184\" class=\"akihiro akihiro-2184\" data-akihiro-post-type=\"post\">\n\t\t\t\t<div class=\"akihiro-element akihiro-element-f643d32 e-flex e-con-boxed e-con e-parent\" data-id=\"f643d32\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"akihiro-element akihiro-element-f0faff9 akihiro-widget akihiro-widget-text-editor\" data-id=\"f0faff9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\tMySQL fornisce la command line utility <code>mysqldump<\/code> per l&#8217;esportazione di database in raw SQL. Invece di eseguire <code>mysqldump<\/code> manualmente, \u00e8 possibile installare uno script che lo esegua in automatico giornalmente, settimanalmente e mensilmente, esportando cos\u00ec i propri database. Uno dei pi\u00f9 popolari di questi script si chiama <code>automysqlbackup<\/code> e in questo articolo vediamo come installarlo ed utilizzarlo.\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-b3e9a96 akihiro-widget akihiro-widget-heading\" data-id=\"b3e9a96\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Installare AutoMySQLBackup<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-a3656a9 akihiro-widget akihiro-widget-text-editor\" data-id=\"a3656a9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>\u00c8 possibile installare AutoMySQLBackup direttamente dal repository Ubuntu lanciando il seguente comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-fd2391b akihiro-widget akihiro-widget-code-highlight\" data-id=\"fd2391b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo apt install automysqlbackup<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-9a7b7bc akihiro-widget akihiro-widget-heading\" data-id=\"9a7b7bc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Configurare AutoMySQLBackup<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-0c461a9 akihiro-widget akihiro-widget-text-editor\" data-id=\"0c461a9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\tLa configurazione di AutoMySQLBackup avviene mediante il file <code>\/etc\/default\/automysqlbackup<\/code> il quale si presenta con i seguenti parametri:\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-ce28d20 akihiro-widget akihiro-widget-code-highlight\" data-id=\"ce28d20\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language- \">\n\t\t\t\t<code readonly=\"true\" class=\"language-\">\n\t\t\t\t\t<xmp>USERNAME=dbuser\n    Username to access the MySQL server e.g. dbuser\n\nPASSWORD=\"password\"\n    Username to access the MySQL server e.g. password\n\nDBHOST=localhost\n    Host name (or IP address) of MySQL server e.g localhost\n\nDBNAMES=\"DB1 DB2 DB3\"\n    List of DBNAMES for Daily\/Weekly Backup e.g. \"DB1 DB2 DB3\"\n\nBACKUPDIR=\"\/backups\"\n    Backup directory location e.g \/backups\n\nMAILCONTENT=\"stdout\"\n    Mail setup What would you like to be mailed to you?\n    - log   : send only log file\n    - files : send log file and sql files as attachments (see docs)\n    - stdout : will simply output the log to the screen if run manually.\n    - quiet : Only send logs if an error occurs to the MAILADDR.\n\nMAXATTSIZE=\"4000\"\n    Set the maximum allowed email size in k. (4000 = approx 5MB email [see docs])\n\nMAILADDR=\"user@domain.com\"\n    Email Address to send mail to? (user@domain.com)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-17b9276 akihiro-widget akihiro-widget-text-editor\" data-id=\"17b9276\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Sono inoltre presenti molte altre opzioni avanzate, per le quali si rimanda alla man page ufficiale: <a href=\"https:\/\/manpages.ubuntu.com\/manpages\/jammy\/man8\/automysqlbackup.8.html\">https:\/\/manpages.ubuntu.com\/manpages\/jammy\/man8\/automysqlbackup.8.html<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-714c97b akihiro-widget akihiro-widget-heading\" data-id=\"714c97b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Eseguire AutoMySQLBackup<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-efcee53 akihiro-widget akihiro-widget-text-editor\" data-id=\"efcee53\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Per eseguire automysqlbackup \u00e8 necessario avere permessi di root, pertanto dobbiamo invocarlo utilizzando sudo:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-a8c34a4 akihiro-widget akihiro-widget-code-highlight\" data-id=\"a8c34a4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo automysqlbackup<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-2ad04bb akihiro-widget akihiro-widget-text-editor\" data-id=\"2ad04bb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Al termine dell&#8217;esecuzione possiamo controllare il contenuto della cartella <code>\/var\/lib\/automysqlbackup\/<\/code><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-7dee90e akihiro-widget akihiro-widget-code-highlight\" data-id=\"7dee90e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>ls -R \/var\/lib\/automysqlbackup\/<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-bf8abef akihiro-widget akihiro-widget-text-editor\" data-id=\"bf8abef\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ottenendo un output simile al seguente<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-7e0107c akihiro-widget akihiro-widget-code-highlight\" data-id=\"7e0107c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language- \">\n\t\t\t\t<code readonly=\"true\" class=\"language-\">\n\t\t\t\t\t<xmp>\/var\/lib\/automysqlbackup\/:\ndaily  monthly  weekly\n\n\/var\/lib\/automysqlbackup\/daily:\nexampledb  information_schema   performance_schema  test  wordpress\n\n\/var\/lib\/automysqlbackup\/daily\/exampledb:\nexampledb_2024-05-27_17h42m.Monday.sql.gz\n\n...<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-4f30284 akihiro-widget akihiro-widget-heading\" data-id=\"4f30284\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Schedulare l'esecuzione di AutoMySQLBackup<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-7919861 akihiro-widget akihiro-widget-text-editor\" data-id=\"7919861\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Per eseguire automysqlbackup automaticamente \u00e8 necessario impostarlo nella crontab dell&#8217;utente root. Lanciamo quindi il seguente comando per aprire l&#8217;editor della crontab:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-2e1d29b akihiro-widget akihiro-widget-code-highlight\" data-id=\"2e1d29b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo crontab -e<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-160d475 akihiro-widget akihiro-widget-text-editor\" data-id=\"160d475\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ipotizzando di voler eseguire il tool ogni giorno alle 21:00, aggiungiamo la seguente voce nella crontab:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-4717008 akihiro-widget akihiro-widget-code-highlight\" data-id=\"4717008\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>00 21 * * * \/usr\/sbin\/automysqlbackup<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>MySQL fornisce la command line utility mysqldump per l&#8217;esportazione di database in raw SQL. Invece di eseguire mysqldump manualmente, \u00e8 possibile installare uno script che lo esegua in automatico giornalmente, settimanalmente e mensilmente, esportando cos\u00ec i propri database. Uno dei pi\u00f9 popolari di questi script si chiama automysqlbackup e in questo articolo vediamo come installarlo [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[20,47,19],"class_list":["post-2184","post","type-post","status-publish","format-standard","hentry","category-sistemistica","tag-linux","tag-mysql","tag-ubuntu"],"_links":{"self":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/2184","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/comments?post=2184"}],"version-history":[{"count":10,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/2184\/revisions"}],"predecessor-version":[{"id":2194,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/2184\/revisions\/2194"}],"wp:attachment":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/media?parent=2184"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/categories?post=2184"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/tags?post=2184"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}