Activity for AutoMySQLBackup
-
Todor Kostadinov posted a comment on discussion Help
Found! It was in /etc/crontab.
-
Hi, I have configured this script more than 10 years ago, and of course I don't remember anything. It is not in the cron, and i can't find a way to stop it from execution every night. These are all files I have found with locate \automysqlbackup /etc/automysqlbackup /etc/automysqlbackup/LICENSE /etc/automysqlbackup/README /etc/automysqlbackup/automysqlbackup.conf /etc/automysqlbackup/myserver.conf /home/username/automysqlbackup-v3.0_rc6.tar.gz /home/username/automysqlbackup /home/username/automysqlbackup.conf...
-
Berturion created ticket #58
mysql mysqldump Deprecated program name. It will be removed in a future release, use mariadb mariadb-dump
-
slv slv created ticket #72
skip-lock-tables
-
Shawn Heisey created ticket #57
script is exiting with code 1 when the output does not indicate an error
-
Heiner Mertens posted a comment on discussion Help
Yes, although my config syntax looks different: # Which day of the month to execute the monthly backup (00 = no monthly backup) # Two digit required DOMONTHLY=01
-
Cannot figure out how to specify arbitrary mysqldump options
-
Belgotux posted a comment on discussion Help
Do you set the CONFIG_do_monthly="01" ?
-
The script runs fine every day since October with the only flaw of the missing monthly backups. Nope, not the first one :-)
-
Hello, I've fix the warning error here Use CONFIG_mysql_mycnf_file variable to put credentials file, exemple here : https://github.com/belgotux/automysqlbackup/blob/main/my.cnf
-
Hello, I've fix some issues for the modern linux because I've got these problems : - fix deprecated --ssl - fix access denied tablespaces - feature add my.cnf usage and deprecated username/password usage https://github.com/belgotux/automysqlbackup Use CONFIG_mysql_mycnf_file variable to put credentials file, exemple here : https://github.com/belgotux/automysqlbackup/blob/main/my.cnf
-
Maybe it's your first backup for this DB ? Normally you need one daily backup to begin and an entire weekly I think
-
I use the same (except for db names) automysqlbackup (version 2.5) config on different servers but on my new server (ubuntu 22.04 LTS) the monthly backups don't work. Daily and Weekly are working fine though. If I start a backup today (1st of December) I only get a daily backup and no monthly backup is created (the log also only shows stuff for daily creation). The script runs fine every day since October with the only flaw of the missing monthly backups. Relevant part of my config: DBNAMES=my_db...
-
Bob M posted a comment on ticket #73
Yes, this fixed the problem. However on CentOS it's a different package. yum install gnupg2-smime Got it going for me!
-
Cyrille Haudebault posted a comment on ticket #73
Do you have gpgsm packet installed, Mutt (the system used by automysqlbackup to send email) need this packet ? Try this to see: dpkg -l | grep gpgsm You may have this kind of response: ii gpgsm 2.1.18-8~deb9u4 amd64 GNU privacy guard - S/MIME version If you don't have gpgsm, install it: sudo apt-get install gpgsm sudo yum install gpgsm (for CentOS)
-
Razor7 created ticket #55
Set --default-character-set=utf8mb4 on mysqldump selected DB's
-
Patricia Ann Bulosan created ticket #54
Backup Failed
-
Edmund Padilla posted a comment on ticket #7
Thank you for you reply. Can backupninja perform per table backup also? Can you provide some links to help me do this? Thank you very much! Ed
-
Dmitry T. posted a comment on ticket #7
I don't think so. This patch is too old. I did it more than 10 years ago. You can try backupninja insted of this one.
-
Hello Sir, Is your patch working? How do I put this to the current version? Thank you. Ed
-
Me too! OS: CentOS release 6.10 (Final) mysql: mysql Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL) (Runing Virtualmin as well) I don't see a way to set debug flags, etc. but I'm happy to help if asked to try things. I confirmed my mailserver is working; mail to root from cron jobs, etc. get delivered normally.
-
Bill Groomber posted a comment on discussion Help
My website is hosted on a shared hosting plan, in a Linux environment. I have SSH access but am locked into a directory (/home2/billglo/). They will not install this script for me. Would it be possible, while running "install.sh" to point it to directories located within (/home2/billglo/), and for AutoMySQLBackup to still operate normally? I am referring specifically to the part of the installation where it asks: Select the global configuration directory [/etc/automysqlbackup]: Select directory for...
-
Alex Brown posted a comment on ticket #51
I have the same question which wasn't resolved with the above mentioned solution . My configuration is attached below. Thanks for any help!
-
Nic posted a comment on ticket #53
Also tried: CONFIGtableexclude=('performanceschema.' 'informationschema.' 'mysql.') Didn't work either*
-
Exclude Databases
-
Gunther Stammwitz posted a comment on ticket #32
Great patch, thank you. I applied it to automysqlbackup-v3.0_rc6. I had to set the password for "--login-path=client" instead of local, as mentioned in automysqlbackup.conf's example, to get it working. Without this patch one would see annoying messages like "mysql: [Warning] Using a password on the command line interface can be insecure. or mysqldump: [Warning] Using a password on the command line interface can be insecure.
-
Dan Willging posted a comment on discussion Help
I'm new to MySQL and AutoMySQLBackup. Is there a way it can give you a drop database and a create database statement in its SQL file? Please advise and thank you. Dan
-
Mohamed posted a comment on discussion Help
please can some one help me how to let the script working WARNING Errors reported during AutoMySQLBackup execution.. Backup failed Error log below.. mysql: [Warning] Using a password on the command line interface can be insecure.
-
Using a password on the command line interface can be insecure.
-
check line 61 CONFIG_db_month_names=('xxxxxxxxxx')
-
js290 created ticket #32
Patch to fix backup_local_files and use --login-path
-
Alessandro Belli posted a comment on discussion Help
to me is still not working, I have the limit to about 100mb and the file size is around 40.
-
Orakler posted a comment on ticket #41
Soluce from Mike Bobbitt works, the code must be added to the automysqlbackup script in my case in /usr/local/bin/automysqlbackup Thanks for the solution Mike :-)
-
equimax created ticket #51
no databases found.
-
Nathan posted a comment on discussion Help
I wanted to run the script again with a different config. Doesn't seem possible with the source but I found this fork, https://github.com/mattanja/automysqlbackup
-
Mark Grennan posted a comment on discussion Help
Are you having any issues with autoMySQLBackup? On Thu, Feb 7, 2019 at 1:02 AM Nathan lionslair@users.sourceforge.net wrote: Did you work this out? Load different config files for multiple hosts https://sourceforge.net/p/automysqlbackup/discussion/350022/thread/c0054191/?limit=25#6f99 Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/automysqlbackup/discussion/350022/ To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/...
-
Did you work this out?
-
Kavit Patel posted a comment on discussion Open Discussion
Hello, I had configured AutoMySQLBackup in to Centos 7 to take backup of Maria-DB. its working fine with tables but not getting backup of the stored procedure in FULLDB Backup. Can you please suggestion for the same? Thanks,
-
Hello, I had configured AutoMySQLBackup in to Centos 7 to take backup of Maria-DB. its working fine with tables but not getting backup of the stored procedure in FULLDB Backup. Can you please suggestion for the same? Thanks,
-
rackwadi posted a comment on discussion Help
We have two servers namely serverA and serverB. I need to take mysql database backup of serverA staying at serverB. The tool I need to use is "AutoMySQLBackup". I got the link for downloading it: https://sourceforge.net/projects/automysqlbackup/ Extracted the tar and changed the config file in /etc/automysqlbackup/automysqlbackup.conf as per my need. As I run automysqlbackup, I get the backups on daily basis though there are warnings: WARNING Errors reported during AutoMySQLBackup execution.. Backup...
-
zax wong created ticket #50
WARNING! - MySQL Backup exceeds set maximum attachment size
-
Koos147 posted a comment on ticket #32
tried to add the --events option to the OPT variable but that gave me even more errors. backup is working but got an error now every day.
-
Jerry Zhang posted a comment on discussion Help
Hi, Does the mail function of AutoMySQLBackup support ssl connection? It seems that it only supports TSL. Also, I only see the TSL settings in ssmtp.conf. Do I miss anything? Thanks
-
SSL email connection
-
David Moreau posted a comment on discussion Open Discussion
Hi, I created this script for hourly backups : https://github.com/dm0reau/automysqlbackup_hourly It works on Ubuntu and Debian. I can watch to make it work on CentOS if needed. Hope this helps!
-
Mike Bobbitt posted a comment on ticket #41
Update as follows: [[ "${CONFIG_mysql_dump_usessl}" = "yes" ]] && { opt=( "${opt[@]}" '--ssl-mode=REQUIRED' ) mysql_opt=( "${mysql_opt[@]}" '--ssl-mode=REQUIRED' ) opt_fullschema=( "${opt_fullschema[@]}" '--ssl-mode=REQUIRED' ) opt_dbstatus=( "${opt_dbstatus[@]}" '--ssl-mode=REQUIRED' ) }
-
voytek eymont posted a comment on discussion Open Discussion
long time user of this script on my 'old' server, with v 2.51 NOW, setting a new server with Centos 7 and rh-mariadb102-mariadb set server, tec, etc, copied my old files, tried running, got succession of errors, AND MariaDB stopped working after a brief panic, restarted MariaDB, then, searched for an uptodate version, found it here, installed ver 3, tried, same problems: it starts OK as so: # automysqlbackup /etc/automysqlbackup/myserver.conf Parsed config file "/etc/automysqlbackup/automysqlbackup.conf"...
-
solaceten posted a comment on discussion Open Discussion
Is hourly backups supported in the script now? If so how?
-
Herman van Dellen posted a comment on discussion Help
Sometimes the mysqldump pgm fails because of an incorrect view. However I do want to have the backup and want to use the --force option in mysqldump. Anyone knows how to do that? Thanks! Herman.
-
larsen255 posted a comment on ticket #31
You seem to think that others should present a solution to your problem on a silver platter. Gotta do your homework first! Would have been much quicker, too.
-
Nganine Muchanga posted a comment on ticket #31
So laconic... Thank you anyway. I got there. Never applied a pach to a script before.
-
https://www.google.de/search?q=manpage+patch
-
Sorry, didn't find any manpage.
-
See the manpage of patch please
-
Please explain how to use the patch. TIA
-
Samuel Thiombiano created ticket #31
dump user privileges
-
Pavel Dvorak created ticket #87
WARNING: --ssl is deprecated
-
TommyB modified a comment on discussion Open Discussion
I hope you can be the new maintainer. Most new code is maintained on GitHub but you can stay here if you wish. Go to https://github.com/ and sign-up. automysqlbackup is covered by the GNU General Public License version 2, so you can just copy the code and make it your own.
-
I hope you can be the new maintainer. Most new code is maintained on GitHub but you canstay here if you wish. Go to https://github.com/ and sign-up. automysqlbackup is covered by the GNU General Public License version 2, so you can just copy the code and make it your own.
-
Paul modified a comment on ticket #41
also gives warning: WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead
-
disabling SSL also gives warning: WARNING: --ssl is deprecated and will be removed in a future version. Use --ssl-mode instead
-
Jean-Philippe Pialasse posted a comment on ticket #86
bad milestone this is actually against 3.0
-
mysql 5.6 and mysql 5.7 error with full schema
-
Joël Schmid created ticket #48
Interruption during automysqlbackup
-
PittaGurneyi posted a comment on ticket #43
Two options, which I have NOT tested or even verified, if the dependencies can be installed - I just know they exist and MIGHT possibly lead to a working environment: Cygwin - just search online for it, but you need at least some knowledge of what the script depends on and what a basic linux system consists of, to get it working - Windows 10 Linux subsystem - dunno how far along that is and what is available. I myself however won't help anyone in this endeavor since I suspect it will be a bumpy ...
-
source expects a shell file with commands in it. Just create backup-before.sh with your command "php /var/www/log/backup.before.php" in it. The same with backup-after.sh ... And point CONFIG_prebackup="/path/to/backup-before.sh" in the right direction. It is probably a good idea to add a comment or two in the config file to make this more clear.
-
Doug E Fresh posted a comment on ticket #42
For anyone that runs across this in the future, the solution is to not put a command directly into these configuration options like the example in this question. automysqlbackup uses "source" to run whatever you put here. so if it won't run with source, you can't run it. Here's the code from automysqlbackup that executes whatever you put there: # -> preback commands if [[ "${CONFIG_prebackup}" ]]; then echo "======================================================================" echo "Prebackup command...
-
Jürgen created ticket #47
How to backup by ignoring some tables but getting their schema?
-
We are using AutoMySQLBackup on a lot of web servers hosting Drupal sites and for...
-
Patch confirmed to be working with Ubuntu Xenial and MySQL 5.7.17. Thanks a lot,...
-
Patch confirmed to be working with Ubuntu Xenial and MySQL 5.7.17. Thanks a lot,...
-
Jeff C posted a comment on discussion Help
On the Debian install, the config file is way different. Is there no rotation settings?...
-
Martin Nyffenegger posted a comment on ticket #46
</dict> <key>WatchPaths</key> <array/> <key>UserName</key> <string>root</string>
-
launchd not working properly
-
Ajay Raghuraj created ticket #45
daily backup rotation not working with differential backups enabled
-
ramonchis posted a comment on discussion Help
I found the same issue and solved it by adding the following privileges to the user...
-
Gert-Jan created ticket #71
Add support for GPG-encryption
-
Undefined Variable?
-
Thomas posted a comment on ticket #41
Change config file: /etc/automysqlbackup/automysqlbackup.conf Use ssl encryption...
-
Got the same Error. Does anyone have a solution yet?
-
Pawel S posted a comment on ticket #42
Seriously, no one knows how to run php file before and after the auto backup?
-
DARLINGTON ADUSEI posted a comment on ticket #43
Thanks On Dec 21, 2016 10:41 PM, "Karl-Koenig Koenigsson" karlkoenig@users.sf.net...
-
Karl-Koenig Koenigsson posted a comment on ticket #43
No. It is a shell script, written for bash and relies heavily on the Unix filesystem....
-
Please I just want to know if automysql be used to backup mysql on windows
-
Can automysql be used to backup mysql on windows
-
cannot execute binary file
-
Mark Moep posted a comment on ticket #21
For several years now xz is a standard compression tool delivered as core utility...
-
I never said it was a solution. I clearly stated this to be a workaround. Tabs vs....
-
Anthony posted a comment on ticket #31
The patch is only a supression of the warning. That is not a good solution. While...
-
Same problem here. Attached is a patch with a workaround.
-
Saju A P created ticket #41
Can't configure. It shows SSL errors.
-
Pedro Souza created ticket #40
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
-
Manuele Polverini created ticket #39
How can i update from 2.6 to 3?
-
darkpollo posted a comment on ticket #24
Kind of. Now I am using hourly backups from my server and for 24hours I use dumps...
-
Brooke Smith posted a comment on ticket #24
I asked a maintainer if they'd truly open source the project and put it on somewhere...
-
Hey! I wrote this post in 2014 and I gave up on using this after a couple of months...
-
(I just posted this a minute ago but it didn't appear - I don't know if moderation...
-
Ellen Allhatatlan posted a comment on discussion Open Discussion
How can I go about this?
-
icon42 modified a comment on discussion Help
Same problem. Hosted on A2hosting.com. Any solution yet? Meanwhile the solution from...
-
Same problem. Hosted on A2hosting.com. Any solution yet?
1 >
