Important Notice:
Two sections of this forum are available only to registered customers. In order to receive access to the Customer Forums and ResellerCentral Forums, you must first register on these forums or login to your existing forum account. If you are an existing HostNine customer, be sure to register using the email address on file for your billing profile.
|
|||||||
![]() |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I'm trying to create an InnoDB table in a mySQL database on Corona and seem to be having some issues. Using phpMyAdmin, when I create a new, simple, one field table and select InnoDB for it's engine I receive this error:
================== Error SQL query: CREATE TABLE `jacqui_civ2`.`test5` ( `field1` VARCHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL , PRIMARY KEY ( `field1` ) ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci MySQL said: Documentation #2013 - Lost connection to MySQL server during query ==================== In the list of tables for the database I get this back: ==================== jacqui_civ2 (4) No tables found in database. ==================== In this case, I've made 3 other attempts at creating a table using various parameters. The table count for "jacqui_civ2" shows 4 tables, which includes the one created above, but the table list shows no tables. If I do a dump of this same database this is what I get: ==================== -- phpMyAdmin SQL Dump -- version 2.11.9.5 -- phpMyAdmin -- -- Host: localhost -- Generation Time: Jul 26, 2009 at 02:34 PM -- Server version: 5.0.81 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `jacqui_civ2` -- CREATE DATABASE `jacqui_civ2` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `jacqui_civ2`; -- -------------------------------------------------------- -- -- Table structure for table `aa` -- -- in use(#1146 - Table 'jacqui_civ2.aa' doesn't exist) -- -- Dumping data for table `aa` -- -- in use (#1146 - Table 'jacqui_civ2.aa' doesn't exist) -- -------------------------------------------------------- -- -- Table structure for table `ff` -- -- in use(#1146 - Table 'jacqui_civ2.ff' doesn't exist) -- -- Dumping data for table `ff` -- -- in use (#1146 - Table 'jacqui_civ2.ff' doesn't exist) -- -------------------------------------------------------- -- -- Table structure for table `tcttcctctctc` -- -- in use(#1146 - Table 'jacqui_civ2.tcttcctctctc' doesn't exist) -- -- Dumping data for table `tcttcctctctc` -- -- in use (#1146 - Table 'jacqui_civ2.tcttcctctctc' doesn't exist) -- -------------------------------------------------------- -- -- Table structure for table `test5` -- -- in use(#1146 - Table 'jacqui_civ2.test5' doesn't exist) -- -- Dumping data for table `test5` -- -- in use (#1146 - Table 'jacqui_civ2.test5' doesn't exist) =========================== At this point, I'm at a lose as to what the problem could be. The engine list for this server shows InnoDB as being configured and available, however, it does not seem to work. Any feedback or information on getting this resolved would be very much appreciated. Jacqui |
![]() |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Email problems | solcre | Reseller Hosting | 8 | 03-03-2010 07:08 PM |
| MySQL and web server problems | christian292 | Feedback & Suggestions | 1 | 11-17-2009 11:12 AM |
| How can I convert database from MySQL 5 to MySQL 4? | sacdeli | Reseller Hosting | 0 | 12-26-2008 05:48 AM |
| Node 35 and 21 problems | detoam | Reseller Hosting | 9 | 04-11-2008 12:48 AM |
| Server2 had some problems | Gene | Shared Web Hosting | 0 | 10-23-2007 12:41 PM |




Linear Mode

