Can't create MyISAM database under Windows

Dev Shed Forums Sponsor:

Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!

May 9th, 2008, 08:08 AM

cyphix

Contributing User

Join Date: Sep 2005

Posts: 159

Time spent in forums: 20 h 41 m 33 sec
Reputation Power: 3

Can't create MyISAM database under Windows

Hey guys....... I usually just use MySQL with phpmyadmin under my linux server; but I just installed it locally (WAMP); everything is working fine except when I make a database & select to make it a MyISAM database it doesn't work.... it just forces it to be a InnoDB.

Any ideas?

Thanks!

May 9th, 2008, 08:37 AM

r937

SQL Consultant

Dev Shed God 25th Plane (17000 - 17499 posts)

Join Date: Feb 2003

Location: Toronto Canada

Posts: 17,344

Time spent in forums: 1 Month 3 Weeks 5 Days 8 h 26 m 43 sec
Reputation Power: 891

the problem is your CREATE TABLE statement

__________________
r937.com | rudy.ca

May 9th, 2008, 08:41 AM

lnxgeek

I AM A GOLDEN GOD

Join Date: Apr 2003

Location: cannot find symbol: method showLocation()

Posts: 5,401

Time spent in forums: 1 Month 3 Days 11 h 54 m 39 sec
Reputation Power: 685

You're specifying MyISAM in the CREATE TABLE statement? e.g.

Code:

CREATE TABLE yourNewTable (
column INT ...,
) ENGINE=MyISAM;

Which version of MySQL and which package did you install?

Did you read through the MySQL manual section on 'Installing MySQL Community Server', especially as it pertains to Windows?

Did you copy over or create your own my.ini or my.cnf config file under C:\?

__________________
BookMooch.com : Give books away. Get books you want.

May 9th, 2008, 10:25 AM

cyphix

Contributing User

Join Date: Sep 2005

Posts: 159

Time spent in forums: 20 h 41 m 33 sec
Reputation Power: 3

Quote:

Originally Posted by lnxgeek

You're specifying MyISAM in the CREATE TABLE statement? e.g.

Code:

CREATE TABLE yourNewTable (
column INT ...,
) ENGINE=MyISAM;

Ok... it worked when using my own query rather than using phpmyadmin to do it (as the query that phpmyadmin used didn't specify the engine)...... however with the MySQL/phpmyadmin I use on linux if I don't specify a engine type it uses MyISAM by default...... is there a way to make it work like that on windows too?

I downloaded MySQL 5.0.51b binary I believe.... had a glance of the manual but don't see anything I haven't done.

As for the my.cnf file...... the documentation I was reading on how to setup mysql (was from a sitepoint book that's a few years old) told me to copy the my-small.cnf file from the mysql directory & rename it to "my.cnf" (or my.ini) & put it in C:\ & yep... I did that.

May 9th, 2008, 10:32 AM

Veamon

Blowing up trees with my mind.

Join Date: Feb 2005

Location: Neverland Ranch, minus the touching.

Posts: 2,712

Folding Points: 127259 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 3 Weeks 3 Days 23 h 43 m 24 sec
Reputation Power: 878

I would use a better tool than phpmyadmin, something like the mysql administrator, or even toad for mysql.

Comments on this post

pabloj disagrees: This specific problem is not due to phpmyadmin, but I agree that he can use better tools

__________________

Raid1 in XP Pro

My open source projects:
------------------------
Blobber - Add images as blobs to SQL Server
------------------------

May 9th, 2008, 11:29 AM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 6th Plane (7500 - 7999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 7,711

Time spent in forums: 2 Months 2 Weeks 6 Days 5 h 6 m 18 sec
Reputation Power: 259

Quote:

Originally Posted by cyphix

... if I don't specify a engine type it uses MyISAM by default...... is there a way to make it work like that on windows too?
...

shure, you'll have to set a specific parameter in the ini/cnf file or pass it at server startup, it's

Code:

 
[mysqld]
...
# The default storage engine that will be used when you create new tables
default-storage-engine=INNODB
#or MYISAM in your case, I use InnoDB

__________________
My blog about OpenSource Databases
PDF tutorials about OSS databases, DBMonster ...
Please contribute to Open Source Development, fill bug reports!!!
Developer Shed eSupport
Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins

May 9th, 2008, 11:33 AM

cyphix

Contributing User

Join Date: Sep 2005

Posts: 159

Time spent in forums: 20 h 41 m 33 sec
Reputation Power: 3

Thanks guys!

May 9th, 2008, 11:51 AM

cyphix

Contributing User

Join Date: Sep 2005

Posts: 159

Time spent in forums: 20 h 41 m 33 sec
Reputation Power: 3

Hmmmmmm added the below..

Code:

# The default storage engine that will be used when you create new tables
default-storage-engine=MyISAM

..but can't get it to work.... keeps creating InnoDB's.

May 9th, 2008, 12:08 PM

pabloj

Modding: Oracle MsSQL Firebird

Join Date: Jun 2001

Location: Outside US

Posts: 7,711

Time spent in forums: 2 Months 2 Weeks 6 Days 5 h 6 m 18 sec
Reputation Power: 259

Did you restart the server? Did you check the actual variable value?

#10

May 9th, 2008, 01:09 PM

cyphix

Contributing User

Join Date: Sep 2005

Posts: 159

Time spent in forums: 20 h 41 m 33 sec
Reputation Power: 3

Do you mean did I restart Apache or my PC? If Apache, then yes I did.

How do you check the actual variable value?

#11

May 9th, 2008, 02:17 PM

lnxgeek

I AM A GOLDEN GOD

Join Date: Apr 2003

Location: cannot find symbol: method showLocation()

Posts: 5,401

Time spent in forums: 1 Month 3 Days 11 h 54 m 39 sec
Reputation Power: 685

Quote:

Originally Posted by cyphix

Do you mean did I restart Apache or my PC? If Apache, then yes I did.

How do you check the actual variable value?

Apache has nothing to do with MySQL (with the exception of course that you may also be serving PHP scripts, and PHP can connect to MySQL, but I digress); MySQL is a stand-alone RDBMS server and will have to be restarted on it's own.

In Windows you can do this on the command line with the commands
NET STOP MySQL
and then issuing
NET START MySQL
Obviously where 'MySQL' is the service name the mysqld-nt daemon runs under.

The variable value in MySQL; when the daemon starts and reads in the proper config files, it stores those directives as variables, e.g.

Code:

SHOW VARIABLES LIKE 'storage_engine';

#12

May 9th, 2008, 05:02 PM

cyphix

Contributing User

Join Date: Sep 2005

Posts: 159

Time spent in forums: 20 h 41 m 33 sec
Reputation Power: 3

Great! Got it working now I restarted it....

Thanks!

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: