Is there an error suppression command I can add to the upgrade script?
Here is what my hosting company has to say about the use of the ALTER Command:
Detail: Our implementation of MySQL keeps a cached version of the database in system memory when a connection to the database is made, so that queries on the database can be executed much more quickly. When the ALTER command is executed, it modifies the actual MySQL database that you instruct it to modify, but the cached version of the database is not updated. Therefore, after the ALTER command modifies the database, MySQL compares the cached version to the actual database, realizes that they do not match, and breaks the connection to the database. This destroys the cached version in memory, and therefore removes any inconsistencies between the two.
Solution: The ALTER command does make the proper modifications to the MySQL database, and the error produced by MySQL about the connection being lost to the database can be ignored. For further database interaction, the connection to the database must be re-established.
For scripts that use the ALTER command, error suppression must be used to catch the 'lost connection error', so that the script does not exit on the error it receives.
_______________
Thanks ahead of time?
Here is what my hosting company has to say about the use of the ALTER Command:
Detail: Our implementation of MySQL keeps a cached version of the database in system memory when a connection to the database is made, so that queries on the database can be executed much more quickly. When the ALTER command is executed, it modifies the actual MySQL database that you instruct it to modify, but the cached version of the database is not updated. Therefore, after the ALTER command modifies the database, MySQL compares the cached version to the actual database, realizes that they do not match, and breaks the connection to the database. This destroys the cached version in memory, and therefore removes any inconsistencies between the two.
Solution: The ALTER command does make the proper modifications to the MySQL database, and the error produced by MySQL about the connection being lost to the database can be ignored. For further database interaction, the connection to the database must be re-established.
For scripts that use the ALTER command, error suppression must be used to catch the 'lost connection error', so that the script does not exit on the error it receives.
_______________
Thanks ahead of time?
Comment