Hello.
One possible solution is to create a new database, and then RENAME TABLE each table from the original database into the new database. Then drop the original database. "Octavian Rasnita" <[EMAIL PROTECTED]> wrote: > Hi, > > Please tell me how to rename a database. I couldn't find this in the manual. > I have tried to rename manually the name of the directory that holds that > database, but some tables can't be accessed after that. (I have found that > they are InnoDB tables, even though I never specified that I want this type > of engine when creating the tables). > > Thank you. > > > Teddy > > > -- 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]