Re: InnoDB per-table-space backup and move

2006-02-11 Thread Heikki Tuuri
: mailing.database.myodbc Sent: Saturday, February 11, 2006 3:10 AM Subject: InnoDB per-table-space backup and move Hi, We'd like to be able to move certain innodb databases between machines (some, but not all). This would help greatly with resyncing slaves and for fast backups. I know that we can create table-spaces

InnoDB per-table-space backup and move

2006-02-10 Thread HOTorNOT Tech
Hi, We'd like to be able to move certain innodb databases between machines (some, but not all). This would help greatly with resyncing slaves and for fast backups. I know that we can create table-spaces on a per-table basis as described here.

InnoDB per-table table spaces

2006-01-10 Thread Marvin Wright
Hi, My innodb installation is using per-table table spaces for every table on the system. I originally configured 4Gig for the shared table space. However when I do a show table status I see the following. Comment: InnoDB free: 6144 kB So 6Meg free, I assumed this was 6Meg free in the

Re: InnoDB per-table table spaces

2006-01-10 Thread Paul DuBois
At 23:44 + 1/10/06, Marvin Wright wrote: Hi, My innodb installation is using per-table table spaces for every table on the system. I originally configured 4Gig for the shared table space. However when I do a show table status I see the following. Comment: InnoDB free: 6144 kB So

Recovering from a drop table with the Innodb per table setting

2005-01-14 Thread Duhaime Johanne
Hello I look throught the documentation but could not find what I was looking for (at least I could read between lines). I have mysql 4.1.7 on solaris and I have 3 differents databanks (let-s D1, D2, D3). Each of those databases are a mix of innob and MyIsam. If by mistake a table is dropped

Re: innodb per table

2004-08-04 Thread Egor Egorov
Carlos Proal [EMAIL PROTECTED] wrote: How stable is this feature? , i have been using it for a few time and works fine, but im thinking to move my current productive enviroment this way and i dont know if its a good choice. Any advise is appreciated. It is stable. :) -- For

innodb per table

2004-08-02 Thread Carlos Proal
How stable is this feature? , i have been using it for a few time and works fine, but im thinking to move my current productive enviroment this way and i dont know if its a good choice. Any advise is appreciated. Carlos _ Tired of