Mailinglist Archive: opensuse (3996 mails)

[George Stoianov <gstoyanoff@xxxxxxxxx>]

Hello everyone,

I am having the following problem:
I am trying to create a database in MySQL ( I run SuSE
9.1 Pro) that would support foreign keys i.e. using
the InnoDB storage format/engine. First I installed
only MySQL with Yast and loaded the db using a dump
from my production db, but when I went into control
center I saw that all my tables where stired in the
MyISAM format, and have no foreign key constaints.
So I decided to install the Max version with the
BerkleyDB engine thinking that this would allow me to
use InnoDB, but when I try to start mysql through the
Run Level editor I get an error:
" failed to start code 1"
In mysql control center I get:
"could not connect using /var/lib/mysql/mysql.sock"

I get these errors only when mysql Max is installed
with the default install I have no problems starting
and connecting, but I cannot use foreign keys.....

Thanks in advance!
George

=====
..: G. Stoianov :..

"Zwei Dinge sind unendlich, das Universum und die menschliche Dummheit,
aber bei dem Universum bin ich mir noch nicht ganz sicher"

Albert Einstein
1879-1955 dt.-am. Wissenschaftler

______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca