List:General Discussion« Previous MessageNext Message »
From:Feris Thia Date:January 31 2008 2:40pm
Subject:Re: Data folder copying problem
View as plain text  
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@stripped> 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=1
>
>
Thread
Data folder copying problemFeris Thia31 Jan
  • Re: Data folder copying problemMartijn Tonies31 Jan
    • Re: Data folder copying problemFeris Thia31 Jan
  • Re: Data folder copying problemMartijn Tonies31 Jan
    • Re: Data folder copying problemFeris Thia31 Jan
Re: Data folder copying problemFeris Thia31 Jan