Hello list,
I apologize if I somehow highjack the thread. I just want to tell the list
for further references
one way (my way) of doing mysql backup and to ask you if it's safe or not.
I have 2 server: one of which is the master (named for the sake of brevity
with M) in mysql terms and the
Hello,
Yes you're right but what I meant was something like this ;))
http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/
It's simple, safe and faster than mysqldump.
On 3 GB database it takes only 3-5 seconds.
Best regards,
Sebastian Tymkow
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Sebastian Tymków wrote:
| Hello,
|
| You can store whole db files too. It's faster to run database from scratch
| than use mysqldump and mysql source.
Um... no. In general you cannot do this, and it is exceedingly irresponsible to
suggest
Hi,
2008/10/1 John Almberg [EMAIL PROTECTED]:
First, I wanted to say how great this list is. I'm a newbie FreeBSD admin
and, besides the Handbook and Absolute FreeBSD (which never seems to leave
my desk), this list is the best resource I have.
I just had a huge scare today... One of the
So, I thought I would post my ruby script for doing this backup...
It's a little verbose for some tastes, but I like to be able to see
what's happening in a script, blow by blow.
This script rotates the backups according to the day of the month, so
you get roughly 30 days backup. It also
Hello,
You can store whole db files too. It's faster to run database from scratch
than use mysqldump and mysql source.
Best regards,
Shamrock
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To
On Tue, Sep 30, 2008, John Almberg wrote:
First, I wanted to say how great this list is. I'm a newbie FreeBSD
admin and, besides the Handbook and Absolute FreeBSD (which never
seems to leave my desk), this list is the best resource I have.
I just had a huge scare today... One of the
John Almberg [EMAIL PROTECTED] 09/30/08 3:18 PM
First, I wanted to say how great this list is. I'm a newbie FreeBSD
admin and, besides the Handbook and Absolute FreeBSD (which never
seems to leave my desk), this list is the best resource I have.
I just had a huge scare today... One of the
On Tue, Sep 30, 2008 at 06:18:35PM -0400, John Almberg wrote:
I just had a huge scare today... One of the websites on my server uses a
large Mysql database. Somehow, one of the tables got corrupted today.
Do you know if the table corruption was a result of 1) a MySQL bug (and
there are many),
I am just about to dive into Google in search of a solution, but
thought I would fire off a quick request, in case there is an
obvious solution that everyone uses. If there is, a name or URL
will do. I'll figure out the rest.
Any hints much appreciated. Not going home until this is
On Tue, Sep 30, 2008 at 06:18:35PM -0400, John Almberg wrote:
I just had a huge scare today... One of the websites on my server
uses a
large Mysql database. Somehow, one of the tables got corrupted today.
Do you know if the table corruption was a result of 1) a MySQL bug
(and
there are
DATE=`date +%a`
#
echo $DATE
#
echo Backup Mysql database
mysqldump -h localhost -u YOURSQLUSERID -pYOURPASSWORD YOURDATABASE
/usr/somedirectory/somefile_$DATE.backup
gzip -f /usr/somedirectory/somefile_$DATE.backup
/usr/bin/at -f /usr/somedirectory/mysqlbackup.sh midnight
Ah, a much
I run a script from root's crontab (not /etc/crontab) and keep the
login credentials in /root/.my.cnf so they don't have to be embedded
in the script. Not that $gzip is defined as /bin/cat because I move
copies offsite via rsync and disk space is abundant. This script keeps
30 daily
--On September 30, 2008 6:18:35 PM -0400 John Almberg
[EMAIL PROTECTED] wrote:
First, I wanted to say how great this list is. I'm a newbie FreeBSD
admin and, besides the Handbook and Absolute FreeBSD (which never
seems to leave my desk), this list is the best resource I have.
I just had a
14 matches
Mail list logo