Re: innodb - in usage

[Gleb Paharenko]

Hello.

I think, you should recreate an InnoDB tablespace on a new
server and import the data exported with mysqldump. If you
remove the database directory and InnoDB files, on startup
server recreates InnoDB tablespace and then you should be able
to import the data from the old server.


marcin lewandowski <lists@stripped> wrote:
> Hi,
> 
> I had got webserver with mysql 4.0.20 (if I remember well) compiled from 
> sources on slackware 9. Now, I've bought new machine, and I've installed 
> gentoo with mysql 4.0.22.
> 
> I've copied (in shell) datadir to new machine, preserving attributes. 
> Now, every of my innodb table in phpmyadmin is not browsable and there 
> are text "in usage" near name of them.
> 
> I exported using mysqldump data from old mysql, and tried to do
> 
> drop dababase `name`;
> 
> in new one, to delete invalid db, and there was an error like these: 
> "unknown table table1,table2,table3" where table1 etc. stands for names 
> of my tables in `name` database.
> 
> What I should do?
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com