[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Data folder copying problem
From:       "Feris Thia" <cakephp () phi-integration ! com>
Date:       2008-01-31 14:40:31
Message-ID: f71ea0b0801310640h730678c4g12ffd6fa345973d1 () mail ! gmail ! com
[Download RAW message or body]

Hi Martin,

You are correct. That's the same error that I got.

Looks like this article is the solution =>
http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html

Thanks !

Feris

On 1/31/08, Martijn Tonies <m.tonies@upscene.com> wrote:
> Hi,
>
> > > By default, InnoDB tables aren't stored in the database folder, but
> rather
> > > in it's own table space files.
> > >
> >
> > In fact when I try to drop the database, the server "recognizes"
> > innodb tables. For example, T1 and T2 are INNODB tables in database
> > DB1. Then when I try to drop DB1, it issues error "Unknown tables (T1,
> > T2)".
>
> Why do you think it "recognizes" them? I have a database with only 1 table,
> but if I type this:
> drop table foo
>
> (foo doesn't exist) I get:
> #42S02Unknown table 'foo'
>
> Same error :-)
>
> > If InnoDb own its table space... where is it reside ?
>
> I believe directly under the \data folder.
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> MS SQL Server
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=cakephp@phi-integration.com
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]