DB engines that have their own data dictionary (Innodb, etc) in addition to
what is in the .frm could easily be messed up.
On Sat, Nov 21, 2009 at 10:38 AM, Robinson, Eric <eric.robinson@stripped>wrote:
> I used a simple procedure to rename my MySQL 4.1.22 database, which has
> only My-ISAM tables:
> 1. Stopped MySQL
> 2. Renamed the database directory from olddbname to newdbname
> 3. Started mysql
> At this point, I grepped for 'olddbname' and found that many of the old
> .MYI files still had references to 'olddbname'. So I...
> 4. Did mysqlcheck -o newdbname
> Then all the references to 'olddbname' were removed from the index
> I then started our application and everything seems to be working fine
> using the new database name. Yet I'm still worried because when I Google
> it, I see people talking about lots of different ways to do a database
> rename, and people are making it sound like a complicated, dangerous
> Why would my simple approach not work? Should I be watching for
> potential problems down the road because I did it this way?
> Eric Robinson
> Director of Information Technology
> Physician Select Management, LLC
> 775.885.2211 x 111