Phil, since InnoDB has its own internal data dictionary, simply renaming a directory of the .frm files does not rename a database inside InnoDB, like it does for MyISAM.
To move InnoDB tables to another database you have to do mysql> USE olddatabasename; mysql> RENAME yourtable TO newdatabasename.yourtable; for each of your tables. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ----- Original Message ----- From: "Phil Chetcuti" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, June 28, 2002 2:08 AM Subject: Refreshing Innodb databases > Hi all, first of all thanks very much for the group, I've been able to > establish a mysql server in far less time than I'd expected just by reading > the posts here. > > Started with mysql on NT 4.0 but based on some posts in the group it seemed > a native linux server would be best, that turned out to be true and it > improved things for me immediately (don't want to get in to a flame *nix vs > ms but it worked well for me). > > Next issue was table type, innodb seemed to be what I needed (row level > locking). Once again, simply by reading posts I found all I needed to > accomplish this. > > Just today I decided to spend a bit more money on a faster processor, more > memory and two drives. I wanted to dedicate one drive completely to > mysql/innodb files. I've managed to get it working but there was something > that caused me some concern for a little while. > > I moved all the mysql (but not the Innodb) data directories over to the new > drive and all seemed to go well. Just for proof of concept I renamed one of > the database directores just so I could see in MySQL-Front that the > mysql --datadir parameter had taken place properly. It did, but the renamed > database would give me Innodb errors, couldn't view the table data, couldn't > even view the field properties. I checked and sure enough I hadn't created > the directories that I'd told Inno to use in my.cnf for its data. > I then created the directories and restarted mysql. Same problem existed, > even though the startup for mysql seemed to take longer than usual, I > figured Inno was recreating its database. > So finally I copied the original Inno databases over to the new location and > renamed the "table" back to its original name and all was fine. > > So, after all that my question is, should I be worried about a sync problem > with Inno? And if so is there a command or procedure I can run to tell Inno > to "refresh" its view of the data system? > > Thanks to All. > > While a posting benefits all, direct email is completely acceptable as well. > > > > for filter sql, query > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
