Awesome, I guess that's the best alternative. In fact, I was logging on to ask you that very question. Thanks,
Scott. On Sun, 13 Mar 2005 20:03:15 +0200, Amr Mostafa <[EMAIL PROTECTED]> wrote: > You can copy mysql tables files directly from /var/lib/mysql/data > directory (or wherever your path/to/mysql is :) > For more details/information, read this : > http://dev.mysql.com/doc/mysql/en/disaster-prevention.html > > - Amr > > Scott Klarenbach wrote: > > >Ya, all my tables are InnoDB unfortunately, and they need to stay that way > >;-). > > > > > >On Sun, 13 Mar 2005 13:48:26 +0200, Amr Mostafa <[EMAIL PROTECTED]> wrote: > > > > > >>There is the mysqlhotcopy, it's faster too. > >>However, It will only work if all your tables are MyIsam. > >> > >> > >>Scott Klarenbach wrote: > >> > >> > >> > >>>I'm using Mysql 5.0.2 w/ Windows 2003 server, and there is a bug with > >>>the mysqldump utility. The bug is actually with the Describe table > >>>statement, or Show fields from table statement... > >>> > >>>It's been documented on mysql.com, so I'm wondering if there is a > >>>simple alternative to mysqldump that I can use to backup the database, > >>>until this bug is resolved in a future release? > >>> > >>>Thanks, > >>>Scott > >>> > >>> > >>> > >>> > >>> > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
