473,394 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Debian - MySql3.23 - innodb issue...help.

Yo
My users want to create innodb tables. This was a basic default
installation of mysql3.23 using apt-get install mysql-server. They attempt
the below..

USE test;
CREATE TABLE testTable (i INT) TYPE = INNODB;
SHOW CREATE TABLE testTable;
typie is displayed as "MyISAM" ... seems to be defaulting.

Im assuming this is happing because innodb is not enabled / configured. The
question is how can I enable my users to create innodb tables?

I did notice that when I do a mysqladmin variables ..
The variable have_innodb | DISABLED

Im assuming I have to recompile the entire installation somehow
targeting --with-innodb. I prefer using Debian sources .. so apt-get
update/upgrade is still capable of performing updates. Ive downloaded the
source.. noticed the debian/rules section seems to have innodb on by
default. Im a newbie when it comes to compiling .deb sources ..
Ive looked all over debian.org on how to compile .deb sources with configure
options with no luck.
Maybe someone can atleast point me to detailed documention on how to
install.deb sources with options.

... all the help would be great.

Thanks alot ..

Jul 20 '05 #1
1 1914
Yo
I solved the problem.. if anyone is interested in the solution let me know.

"Yo" <no******@sorry.com> wrote in message
news:yw******************@fe05.usenetserver.com...
My users want to create innodb tables. This was a basic default
installation of mysql3.23 using apt-get install mysql-server. They attempt the below..

USE test;
CREATE TABLE testTable (i INT) TYPE = INNODB;
SHOW CREATE TABLE testTable;
typie is displayed as "MyISAM" ... seems to be defaulting.

Im assuming this is happing because innodb is not enabled / configured. The question is how can I enable my users to create innodb tables?

I did notice that when I do a mysqladmin variables ..
The variable have_innodb | DISABLED

Im assuming I have to recompile the entire installation somehow
targeting --with-innodb. I prefer using Debian sources .. so apt-get
update/upgrade is still capable of performing updates. Ive downloaded the
source.. noticed the debian/rules section seems to have innodb on by
default. Im a newbie when it comes to compiling .deb sources ..
Ive looked all over debian.org on how to compile .deb sources with configure options with no luck.
Maybe someone can atleast point me to detailed documention on how to
install.deb sources with options.

.. all the help would be great.

Thanks alot ..


Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Mark Depenbrock | last post by:
--Apple-Mail-2--68472726 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; format=flowed Can not make mysql connection - error log: 030708 08:53:48 mysqld started
0
by: Maciej Wiznerowicz | last post by:
Dear Sirs, I can not start MySQL server. More specifically, MySQL was running fine all the time since installation. It stopped working after I used FmPro Migrator to convert some File Maker...
3
by: Andy Tran | last post by:
I built a system using mysql innodb to archive SMS messages but the innodb databases are not keeping up with the number of SMS messages coming in. I'm looking for performance of 200 msgs/sec where...
2
by: Jan | last post by:
I am using Apache2triad 1.2 as local development environment. It is working fine, but I cannot create InnoDB tables with the phpMyAdmin 2.5.6 included in this package. According to the my.ini...
2
by: Morten | last post by:
Hi. Creating the below to tables give errno 150, any idea why? CREATE TABLE categories ( id int(11) unsigned NOT NULL auto_increment, name varchar(64) NOT NULL, PRIMARY KEY ...
5
by: Eddie | last post by:
I have a MySQL-server running Innodb. We have installed ~ 2GB of memory in the server. In spite of this MySQL keeps crashing due to out-of-memory errors. The server is a dual xeon i686 running...
2
by: Alex | last post by:
I was hoping someone could confirm my understanding of how InnoDB handles deadlocks (error 1213) and timeouts (error 1206). The way I understand it, with AUTOCOMMIT=0, if I issue 3 SQL statements...
4
by: Good Man | last post by:
Hi there I have a database with about 20 or so tables, maybe a few thousand rows in each. I am starting to do more complex things with my insertions etc, and I want to start to use...
0
by: shakahshakah | last post by:
Just started investigating InnoDB after having used MyISAM tables in the 4.0.12 version, almost immediately ran into a locking issue with INSERTs, DELETEs, and transactions. Given the following...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.