<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><br>
<br>
<br>
Hi,<br>
INNODB is a engine.<br>
So, the egine statement has to be on the create statement.<br>
So do,<br>
<br>
1.) show tables;<br>
<br>
<br>
For e.g table cache:<br>
(look at the last line with "ENGINE".)<br>
<br>
2.) show create table cache;<br>
<br>
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
| Table | Create
Table
|<br>
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
| cache | CREATE TABLE `cache` (<br>
`user_id` int(10) unsigned NOT NULL,<br>
`cache_key` varchar(128) CHARACTER SET ascii NOT NULL,<br>
`created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',<br>
`expires` datetime DEFAULT NULL,<br>
`data` longtext NOT NULL,<br>
KEY `expires_index` (`expires`),<br>
KEY `user_cache_index` (`user_id`,`cache_key`),<br>
CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) REFERENCES
`users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE<br>
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |<br>
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
<br>
<br>
And so on.<br>
<br>
Rgds.<br>
<br>
Franz<br>
<br>
1 row in set (0.03 sec)Am 19.11.14 um 01:27 schrieb Thomas
Spuhler:<br>
</div>
<blockquote cite="mid:2269856.8p9agQm10q@aargau.btspuhler.com"
type="cite">
<pre wrap="">On 11/18/2014 04:31 PM, Torsten Grote wrote:
</pre>
<blockquote type="cite">
<pre wrap="">mysql -h localhost -u roundcube -p
</pre>
</blockquote>
<pre wrap="">no problem
$ mysql -h localhost -u roundcube -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 52
Server version: 10.0.14-MariaDB Mageia MariaDB Server
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
MariaDB [(none)]>
Just a thought: The procedure refers to INNODB
How can I check for certain, if my mariadb uses the INNODB engine?
Thomas
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:users@lists.kolab.org">users@lists.kolab.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kolab.org/mailman/listinfo/users">https://lists.kolab.org/mailman/listinfo/users</a></pre>
</blockquote>
<br>
</body>
</html>