I've this script which takes backup of mysqldb through mysqldump. I need to send an automated email after success/failure mysqldump. How can add this feature in the script? Here's the script:
Code:
#!/bin/sh
BACKUP=/data/backup/sql2/new_backup/daily
cd $BACKUP
mkdir `date '+%d-%m-%Y'`
NOW=$(date +"%d-%m-%Y")
code....
I have a LAMP website with mysql backend with InnoDb engine for tables.I would like to be able to use mysqldump to take periodic dumps of the database - WITHOUT having to stop the mysql server (i.e. shutting down the website) for the duration of the backup. not even in the mySQL documentation. A lot of mention is made about mysqlhotcopy, but that only works for IMSAM tables - and is therefore of no interest/use to me.Does anyone know if (how?) I can use mysqldump to take a copy/dump of a database that is still being used?.A link to the official documentation would be very useful, since I want to make sure that I get this absolutely right.I am running on Ubuntu 10.0.4 LTS
View 4 Replies View RelatedIs it possible to compress the mysqldump output into say db_backup.sql.tgz. Then add that to an existing archive e.g. backup.tgz in one command or on the fly to save space and deleting it?
View 3 Replies View Relatedi use linux ubuntu..i try to copy db and type some mysqldump command..but at terminal show: The program 'mysqldump' can be found in the following packages:
* mysql-client-5.0
* mysql-client-5.1
Try: sudo apt-get install <selected package> bash: mysqldump: command not found
how to get mysqldump for my pc? i've tried to follow the instruction,but show like below:
Err http://ubuntu-ashisuto.ubuntulinux.jp jaunty/main libnet-daemon-perl 0.43-1 Could not connect to ubuntu-ashisuto.ubuntulinux.jp:80 (122.216.218.146), connection timed out
My cron job is executing the below mysqldump command but it produces an empty sql file. However, when I run from the command line, it works as expected.
Code:
15 6 * * * root mysqldump -uroot -pXXXXXXX mydbname | gzip > /home/dbbackup/db_`/bin/date +\%Y\%m\%d\%H\%M`.sql.gz
I'm on CentOS 5.4 and use "env EDITOR=nano crontab -e" edit my cron (then paste the above command.
if I run mysqldump from crontab and error occurs, I would like to have email send to me (reporting that backup is not working).
View 2 Replies View RelatedI don't understand why after a successful installation of RHEL 5.3 in my PC (dual-boot with Windows XP x64), the hard disk just reads continously and my monitor.just went blackout. This happens (3x) everytime I setup it for the first time, re:detection of hardware,network, creation of a new user, etc. Although my GRUB is working perfectly.
View 1 Replies View RelatedIn my Windows environment, I use email client such as Microsoft Outlook to connect to our email server to send email with the following configuration:
Incoming server (POP3): 995 - (requires with SSL)
Outgoing server (SMTP): 465 - (use encrypted connection SSL)
[code]....
And the mail server requires user ID login and password.how do I setup a text command based email client in my Linux (Centos 5.1) to send out email through the existing email server above, which is in another machine? The email client has to be text command based because I need to use command line to send notification email from anothar application installed in my Linux (Centos 5.1) Since the email client will only be used to send email notification, I don't require setting up of an email server in my linux.
Using CentOS. I have a cron setup to run this command: Code: /var/test.sh | mail -s "Test Cron" mr182@somewhere.com The email is sent but the output of the script is not in the email body, it's just blank. I know there is some output because there are some echo statements in the script.I don't want to get an email for all cronjobs, just this one.
View 1 Replies View RelatedI have an email setup where all of the emails from our email host is downloaded to our Linux server using Fetchmail. Then some of the incoming emails are sent to an MS exchange server (server1.domain.com) using Postfix. What i want to do is to send a copy of all emails to Another server (server2.domain.com) for redundancy.Can postfix be configured to send copies out to both?
View 1 Replies View RelatedI would like to have my backup script that I am writing to create a sql dump of my database and go directly into a tar file. Does anyone know how I could do this with one command?
To be more clear I would like to go from
mysqldump -u xxxx -pXXXXX tablename> currentbackup.sql
tar -czvf backup-XXXXXXXX.tgz currentbackup.sql
rm currentbackup.sql
To a single command somehow. Does anyone know how I could accomplish something like this?
I have one doubt, is copying /var/lib/mysql is a good alterntive to mysqldump?.
Because i use rsync to copy /var/lib/mysql for back up without dumping the database. I use rsync to do differential backup up so that it copies /var/lib/mysql to /var/tmp every one minute.
We are running an adserver with mysql as the database. We backup the database every hour and lately noticed that ads doesn't get delivered at the time of backup. The database size is 1.2 GB in which a single table ifself is 1.1 GB. Googling around the problem says this may be due to lock table feature in mysqldump and disabling it might solve the issue but i'm afraid whether this would be a problem. Can anyone please explain what lock table means and will it be a problem if i disable it or may be any other alternative solutions/assitance (other than master/slave or replication since we cannot afford it at this time) would be really helpful.
View 1 Replies View RelatedWhen I execute the command below, does mysqldump lock all tables while the backup is in process? I want to make sure this is the appropriate type of backup command for MyISAM database.
mysqldump -h myhostname --default-character-set=utf8 -u root --password=mypassword --opt --single-transaction DBname > /root/backup.sql
Let's say we have a file tables listing all the tables of a database.Can I use grep and mysqldump to dump only tables with certain prefix? I tried
grep prefix_ tables | mysqldump -u root -p databasename > db.sql
but this takes all the tables..
I have some tables that contain special characters from different languages like German, Italian, Russian, Spanish etc. They are stored and displayed correctly.
When want to backup my DB like "mysqldump -h localhost-u root -p dbname > dbname.sql" the special characters are lost, they are not correctly stored nor displayed in the sql file. This means there is no possible restoration.
I just backup my mysql db using mysqldump. I run it around 6pm of the evening but I just notice that on the last part of the dump file, it says "Dump completed on 2010-01-14 11:30:01". The time is "Jan 14 19:30" when I run mysqldump. Though the content is corrent, I still want to know why the dump reported it was completed but wrong time. I don't have my.cnf on my /etc so it means all was default by mysql. If I'm not mistaken, timezone by default in mysql is gmt.
My /etc/sysconfig/clock is
ZONE="Asia/Manila"
UTC=true
ARC=false
When I do "select now();" on mysql shell, it was the same with my system. I want to prove my backup was right but this thing confuse me a bit.
I noticed in phpmyadmin that we can export a database in type update. Indeed we have update... in place of insert.... is there anyone know if it possible by a command line or by a simple PHP code ?
View 1 Replies View RelatedDear Experts,
I am having a 1 gb of mysqldump. When i try to restore this dump file, it is giving error " ERROR 1153 (08S01) at line 289: Got a packet bigger than 'max_allowed_packet' bytes". And with this i am not able to restore the database. mysqld version is 5.0.77.
I'm attempting to send email with a PHP application I got from a textbook. Do I need to start an email server in order to get the application to work?Using SuSE 11.2
View 5 Replies View Relatedis there a way to allow unsubscribed email address to send emails to mailman list without having to manually set a filter for that email address?
View 1 Replies View RelatedDebian 5, apache 2.2 I've got Apache up and hosting multiple sites. Each site will have a php contact me page that will simply dump an email to a fixed address. What program should i be using to accomplish this? I've used nullmailer before but that assumes you have a fixed smarthost somewhere which I don't.
View 6 Replies View RelatedI'm having a strange issue with a RHEL 5.2 system with SE Linux. I can scp files to it, but I always have to hit ctrl+c to end the scp process. The file transfers 100% and everything, but scp just hangs there for a long time, or until I kill it. If I wait until it dies on its own, its exit value is 1. I'm not sure if it'll help, but here is the output when I add the verbose option. $ scp -v create_users.sh rhel5.2-server: Executing: program /usr/bin/ssh host rhel5.2-server, user (unspecified), command scp -v -p -t .
OpenSSH_4.7p1 Debian-8ubuntu1, OpenSSL 0.9.8g 19 Oct 2007
debug1: Reading configuration data /etc/ssh/ssh_config
debug1: Applying options for *
[code]...
I'm attempting to send email used a textbook PHP application. The application fails to send an email.Do I need to setup an email server to get the ap to work?Right now, I'm getting email through Kontact via my web host, Yahoo mail and Google mail.
View 2 Replies View RelatedI use 'quoted' style for reply emails. I want to be able to intersperse my replies within a quoted reply i.e. if the email had three paragraphs, I'd like to be able to have my replies between each of the paragraphs. At the moment, I don't seem to be able to do anything other than delete from the quoted section - I try to simulate my requirements by cutting and then 'paste quotation', but this doesn't always work as sometimes Evolution adds too many levels of '> ' .
View 5 Replies View Relatedwe had a server with Hostway, and it was running ubuntu. The server also had Plesk installed, which did some funny things. We had several websites on that server, and many email addresses. Then we changed servers. Now we have a server through Rackspace and it is also running Ubuntu. It also has Virtualmin installed, which generally does not impose as many unconventional changes on Ubuntu as Plesk did.
Rather than using Thunderbird to download my email (which is what I used to do) I've decided I'll start reading my email on the server. So I will ssh to the server and then use some email client, such as Alpine, to read the email. So I installed Alpine. I have an email account for "lawrence". The email address is lawrence @ krubner. Currently, when mail arrives for that account, it is stored here:
/home/krubner/homes/lawrence/Maildir/new
and then it is transferred to hear:
/home/krubner/homes/lawrence/Maildir/cur
When I start Alpine, while logged in as lawrence, Alpine automatically sets up an inbox for me here:
/home/lawrence/mail/
How do I get Alpine (or any other client) to read from the correct folder? I'm fairly sure the email package (the MTA) at work on this new server is Postfix. As near as I can tell, my email is held for 24 hours in this folder:
/home/krubner/homes/lawrence/Maildir/new
and then it gets transferred here:
/home/krubner/homes/lawrence/Maildir/cur
Alpine only lets me set one path for my Inbox, so I'm not sure what path I should set. If I use "cur" I will see all email 1 day late, but if I use "new" then I will miss email if I go a day without checking.
Is there a way of allowing only certain domain to send e-mails to certain specific e-mail address. I am using Sendmail, and I have an alias which translate to certain members of staff within my organization. I don't expect e-mails from outside our domain to be sent to this alias e-mail address.
View 1 Replies View RelatedI have recently setup a new mail server and have simulated sending and receiving on the new email server. The new email server will replace the primary one.I would like to setup the new email server in parallel with the existing one.This way i can observe issues that might occur and be aware of what could go wrong. I want to received mail to be delivered to both mail servers at the same time.I would like to use postfix, exim i find a bit to difficult to understand.I have thought of using transport maps, the only problem is that you can only forward mail to one server at a time using transport maps.I think recipient_bcc_maps and sender_bcc_maps could work, i would just like ideas of how i can do this.
View 5 Replies View RelatedI have had lots of problems with dual boot. Hardly never making success with first boot. I have to try 3,4,5 even 6 times until reach the X. Some kernels make it better (hardly never succesful boot with first try). This 2.6.34.7-56.fc13.i686.PAE seems to be one of the worst.
Boot hangs on starting atd. Xorg.conf:
I have to use nvidia proprietary driver. With nv the screen will freezy quite soon.
Graphic card: Nvidia 9500 GT
I am trying to run VirtualBox on Ubuntu 11.04 Natty, and when I make a virtual machine it says it is successful. However when I try to run the machine I get this error box. What did I do wrong? What can I do to fix this? I've deleted the virtual machine and made a new one. I've uninstalled and reinstalled virtualbox but nothing I've tried works.
View 9 Replies View Related