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" <orasnita@stripped> wrote:
> 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.
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