Community Forums

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.

Go Back   HostNine Community Forums > H9 General Forums > Lounge / Off Topic > Web Hosting

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 07-26-2009, 03:40 PM
jacquita jacquita is offline
Newbie
 
Join Date: Apr 2007
Posts: 3
Default MySQL InnoDB problems

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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT -5. The time now is 05:36 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.

Host Nine

Our mission began in 2006. Thousands of awesome clients later, we are now one of the most popular hosters in the world.
Most of this is because of our fantastic support. Join us, you'll be glad you did - that's a given.