I received the following message while working while working with a pre-existing existing database and adding some new tables. I was specifying the table creating using this Mysql Manager.
The Manager itself was not at fault for the error and it appeared to be related to a table data corruption or disk space issue, but that turned out not to be the case as there was gigs of space left in the partition and a CHECK TABLE succeded without issue. A backup and restore did not solve the problem either. An inspection of the filesystem revealed that the database directories and permissions were correct, however, there appeared to be a few files missing per table with the tables that were not working. A careful re-examination of the table create statements revealed a difference in dbengine selection between the existing database tables and new database tables. A simple removeall of the storage engine specifier fixed the problem when the tables were re-created.
-
Recent Posts
Recent Comments
- admin on A JQuery Print Library that fixes the IE7 Shrink-to-Fit issue
- IT_Andy on A JQuery Print Library that fixes the IE7 Shrink-to-Fit issue
- Longchamp Medium Long Handle Price on Dot Net html editor to image
- How to: How many files can I put in a directory? | SevenNet on Listing Files in a directory with too many files for ftp
- Connie on Google Apps Settings vs Gmail Settings
Archives
- September 2013
- August 2013
- July 2013
- February 2013
- January 2013
- December 2012
- July 2012
- June 2012
- April 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- May 2010
- April 2010
- February 2010
- October 2009
- September 2009
- June 2009
Categories
- Applications Development
- ASP.net
- Bash Scripting
- C Programming
- C#.net
- Content Management Systems
- css
- Database
- Drupal Development
- Free Games
- Free Tools
- Html
- Javascript Development
- Joomla Development
- MYSQL
- Perl Scripting
- php development
- Projects
- Server Development
- Tech and How To
- Uncategorized
- VB.net
- Web Development
- Wordpress Development
Meta
-
Professional Developer and Operator of SwhistleSoft
This blog was… how do I say it? Relevant!! Finally I have found
something which helped me. Thanks a lot!