RE: backing up mySQL database ?
-Original Message- From: Neil Tompkins [mailto:[EMAIL PROTECTED]] Can anyone recommend a software app. I could buy to be able to dump data and table structures to a text file. Ideally as mentioned before I need to run this on a hourly basis. Backing up the entire database on an hourly basis could be time- and processor-intensive, if the database gets large. I'd recommend backing up the full database at longer intervals (say, nightly) with mysqldump and then using the update log to fill in any gaps. If getting the backups onto a different machine is important you can always just copy the log. A backup plus all the update log entries since the backup was taken is sufficient to recover the database. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
Hi Thanks for that information. But I think I want to purchase a software application, due to my lack of knowledge for mySQL. In addition to this, my ISP doesn't allow that much control over the operating system. Can anyone recommend a software app. I could buy to be able to dump data and table structures to a text file. Ideally as mentioned before I need to run this on a hourly basis. Rgds, Neil From: Gerald R. Jensen [EMAIL PROTECTED] Reply-To: Gerald R. Jensen [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: backing up mySQL database ? Date: Sat, 30 Nov 2002 14:17:52 -0600 OK ... but you newed to work this out with you ISP. Create a shell script, and place it in the server's path: # #!/bin/sh # Create /dbbakup directory # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then mkdir /dbbakup chmod 777 /dbbakup -R fi # The following is a single line: mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases databasename/dbbakup/databasename.sql # Add the following to your crontab: # Make backups of databases at 4am daily 0 4 * * * /usr/local/bin/mydbbak.sh - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:11 PM Subject: Re: backing up mySQL database ? I rent my mySQL database from my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks Neil From: Gerald R. Jensen [EMAIL PROTECTED] Reply-To: Gerald R. Jensen [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: backing up mySQL database ? Date: Sat, 30 Nov 2002 10:23:22 -0600 You don't have to develop or buy anything. You can use mysqldump in conjunction with a shell script to do what you want, and automate it with either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 9:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Neil, et al -- ...and then Neil Tompkins said... % % Hi Hi! % % Thanks for that information. But I think I want to purchase a software % application, due to my lack of knowledge for mySQL. In addition to this, % my ISP doesn't allow that much control over the operating system. Sure, I can recommend some. It's called, um, David's Fabulous Backup Software, and for the monthly license fee of, uh, let's say $1000 you get a custom installation and configuration. It's very closely modeled after mysqldump and uses only open-source software (primarily mysqldump). OK, all kidding aside, that's what mysqldump is for and it does its job well. I'm no mysql greybeard but other than a system backup tool (Veritas NetBackup, Legato Networker, tar, BRU, whatever) I don't know of anything that fits your bill (does not involve mysql as I understand it). % % Can anyone recommend a software app. I could buy to be able to dump data % and table structures to a text file. Ideally as mentioned before I need to % run this on a hourly basis. You must be doing something very important to have to back up your data multiple times per day. I'm not being at all facetious when I say that; most people back up their data once a night or even once a week. To what do you plan to write your backups? Tape? Another directory on the same server? Your home hard drive over the 'net? Backing up your database ten to twenty times per day will chew up a lot of space even if the instance is small, and if it's not separate from your server then you've gained nothing if the disk head crashes (same disk) or the server gets hacked or goes wacko (different disk or RAID or whatnot) or the place burns down. You say your ISP doesn't allow that much control over the operating system. Do they not offer backups as part of your package, or as a part that you could buy? I don't know what you're doing or where you're hosting or how much data is involved, but if you really have something important enough that you have to back it up hourly then I would 1) look into other ISPs/ASPs and 2) check out having one or more slave servers, which can replicate the data in real time and then go offline to allow backups. Oh, yeah; let me know which tape company you'll use so that I can buy some stock! Usually I'd recommend myself to someone who needs individual services such as the ability to back up his database, but I won't touch this one; anything that really needs to be backed up that frequently needs serious, industrial-strength work. I can design and implement it, though, at my usual consulting rates; you might want to sit down with me (or anyone else, but *someone*) and see what you really need and what it's going to cost you. % % Rgds, % Neil HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE96pOCGb7uCXufRwARAhQtAKDkE9P8ZNUV1E6aISM/X2f7274J0ACgonbn H+Ws5zJmRHs1h0TKjd4vyPo= =Kixn -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
backing up mySQL database ?
Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
I might be totally off track here, but a simple shell script works fine for me. /bin/sh, tar, and cron are a powerful team. --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 10:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
You don't have to develop or buy anything. You can use mysqldump in conjunction with a shell script to do what you want, and automate it with either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 9:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
I rent my mySQL database from my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks Neil From: Gerald R. Jensen [EMAIL PROTECTED] Reply-To: Gerald R. Jensen [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: backing up mySQL database ? Date: Sat, 30 Nov 2002 10:23:22 -0600 You don't have to develop or buy anything. You can use mysqldump in conjunction with a shell script to do what you want, and automate it with either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 9:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: backing up mySQL database ?
OK ... but you newed to work this out with you ISP. Create a shell script, and place it in the server's path: # #!/bin/sh # Create /dbbakup directory # $1 = Unix/MySQL Username # $2 = Unix/MySQL Password if [ ! -e /dbbakup ] then mkdir /dbbakup chmod 777 /dbbakup -R fi # The following is a single line: mysqldump -u$1 -p$2 -c --add-drop-table --add-locks --flush-logs --databases databasename/dbbakup/databasename.sql # Add the following to your crontab: # Make backups of databases at 4am daily 0 4 * * * /usr/local/bin/mydbbak.sh - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:11 PM Subject: Re: backing up mySQL database ? I rent my mySQL database from my ISP would this be a problem ? Maybe you provide me with a simple example ? Since I'm very new to mySQL and have no knowledge of unix. Thanks Neil From: Gerald R. Jensen [EMAIL PROTECTED] Reply-To: Gerald R. Jensen [EMAIL PROTECTED] To: Neil Tompkins [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: backing up mySQL database ? Date: Sat, 30 Nov 2002 10:23:22 -0600 You don't have to develop or buy anything. You can use mysqldump in conjunction with a shell script to do what you want, and automate it with either the Windows Scheduler (on Win32) or a cronjob (Linux, *nix). - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 9:33 AM Subject: backing up mySQL database ? Hello, I'm looking to either development a software application that will allow me to automatically at scheduled intervals backup my mySQL databases. I would like to save the table structures and data. I;ve used mySQL Front that allows you to backup these, but I need it to be automated e.g every 2 hours... Can someone point me in the right direction. I will look to develop the software is Delphi 6 or C++ Builder 5. The other option I have is to purchase some software that will allow me to do this. Any suggestions or recommendations ? Thanks for any help and advice. Neil _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php