We developed a site using PHP and MYSQL on an online shared server. We used
HEAP tables extensively and everything worked fine. When we moved the site
to our dedicated server prior to launching the site, the queries that
should create the HEAP tables return syntax errors (when submitting the
queries with phpMyAdmin). Also, other queries having to do with table
creation return syntax errors. Anyone have ideas? We've thought maybe
there are permission problems, or else our build of MySQL doesn't support
these queries? Or something is wrong in the server config, or in how the
host company compiled their MySQL build?
The version we developed with was 3.23.21 beta
and the version on the shared box is MySQL 3.22.30. Is it possible there
are version incompatibilities?
On the dedicated server, this query will create a table without errors:
CREATE TABLE test (test1 TINYINT (4) UNSIGNED not null )
However, this triggers a syntax error:
CREATE TABLE IF NOT EXISTS test (test1 TINYINT (4) UNSIGNED not null )
Here are some other examples of queries that result in errors.
2) This should create a table that is an exact copy of blocking table:
CREATE TABLE newtable2 SELECT * FROM blocking
Instead of creating the table, it reports a syntax error.
3) This also reports a syntax error:
CREATE TABLE test3 TYPE=HEAP MAX_ROWS = 30 SELECT * FROM blocking
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
