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 seco
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 su
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
T
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 mo
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
--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
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 backups
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 simple
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 man
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 fixed.
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),
>>> 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 o
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
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 websites on my server
uses a large Mysql databa
15 matches
Mail list logo
