-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi All,
Just needing a little advice really, we have a (now) very large mysql
database thats keeping track of gas/electrical safety inpection data.
Since it was meant to just report on this data to produce very complex
safety certificates and reports we chose the MyISAM table type.
Unfortunately things never stay the same for long and the company
decided to bolt in a bunch of other stuff ;-)
Now we have a lot of reads and a lot of writes to the database and i'm
seriously considering moving to InnoDB tables. Question is, will this
require any SQL code changes to our application? We make heavy use of
features like temporary tables, autoincrement columns etc. Would if be
as simple as dumping the database and restoring it to InnoDB tables?
If anyone has any experiance of doing this and/or knows of any issues i
may run into id be pleased to hear from you! ;-)
Many thanks and best regards,
Danny
- --
Danny Haworth
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Ge2 System Administrator
Gas~Elec Safety Systems
Tel : 01895 422 997
Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE9kCxpUKf+497XC3QRAk9KAJ400Uot3GLyzf4yMV0V+ybE1BvL/QCfXeTS
FOQfHoCMPqTSOKIdfPkdZ8E=
=w6Se
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
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
