I know this isn't a MySQL list, but ... on 12/12/2010 7:52 AM Justin Dearing said the following:
On Sun, Dec 12, 2010 at 2:12 AM, Jerry B. Altzman <jba...@altzman.com <mailto:jba...@altzman.com>> wrote: I just encountered my first real one. It's on a MySQL on a Windows platform--someone from the MSSQL world, no doubt. Just got bitten hard by it, migrating from 5.0 to 5.1 has slightly different schemata in the mysql.mysql database, which made me need to be very careful about importing dumpfiles. Just out of curiosity, what if you copied over the binary database files (via LVM snapshot if your runnin LVM to prevent downtime) to a 5.1 machine? Will 5.1 import 5.0 binary files?
I actually tried that...but a) this was a Windows platform (so LVM doesn't exist) and b) the structure of the tables in the main MySQL changed from 5.0 -> 5.1 (extra columns in mysql.proc, mysql.db, etc) so a physical restoral (I tried just copying the innodb and myisam table files over) failed.
If there were NO sprocs, this would have been easy...but someone started using them so I got stuck with a logical dump/restore (and hand-editing the dump file to NOT try to recreate any tables in the MySQL mysql database).
There's a bit of confusion. MySQL runs a special database called 'mysql' that contains all manner of administrative information, and it's where things like stored procedure definitions live.
BTW, someone who uses a stored procedure in MySQL could be coming from the Oracle, Sybase, Microsft, or Postgres world. Either that, or they are new to RDBMSes and do not have prejudices against using certain features in MySQL since they weren't using it since 4.0 when you could not do these things.
I mentioned that this was a windows machine, running ASP code. My best guess is MSSQL. :-) Every large RDBMS (Oracle, DB2, Sybase, MSSQL) uses them a lot more.
Justin
//jbaltz -- jerry b. altzman | jba...@altzman.com | www.jbaltz.com | twitter:@lorvax thank you for contributing to the heat death of the universe. _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
