Hello,
The size of some tables are more than 300Mb (myisam). If use mysqldump, I
cannot estimate the actual size of a table......
Joe
>From: Ed Carp <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: Re: Backup
>Date: Wed, 21 Feb 2001 22:27:27 -0600
>
>Li Joe ([EMAIL PROTECTED]) writes:
>
> > I would like to perform database backup while the server is running. I
> > don't want to use mysqldump as the tables are huge. So I consider to
use
> > BACKUP TABLE sql command to perform it. In addition, I find that this
> > command only backups the .MYD and .frm, i.e. no .MYI files will be
kept.
> > What can I perform a better approach to have all stuffs without stop
the
> > server.
>
>mysqldump.
>
>So, your tables are huge - would you rather have an incomplete backup of
your data? Besides, filtering the output of mysqldump through gzip reduces
the output quite a bit.
>--
>Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone
>http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager
>
>I sometimes wonder if the American people deserve to be free - they seem
>so unwilling to fight to preserve the few freedoms they have left.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
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