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 pat
Check this one too:
http://dev.mysql.com/doc/mysql/en/backing-up.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 to
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
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:
>
>
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 tabl
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 u
