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 <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
