Re: Cannot create database in MySQL

Quoting Tom Hanlon <[email protected]>:

> If I understand correctly the goal is a package, deb or RPM that works
> with a dependency of MySQL as a package also and whatever version the
> package requires.
>
> Meaning..
>
> apt-get install refdb..
>
> leads to a MySQL dependency and then the apt-get installs MySQL and we
> are good to go ?
>

not quite. RefDB can use a variety of database engines by means of  
libdbi. So installing a refdb (or refdb-server, as Debian tends to  
split client/server programs into its components) package should pull  
in libdbi, which may or may not be available in a reasonable version.

> Do you use Stored procedure or user created functions ?

no

> Does your DB script that creates the Refdb Database have any
> "create procedure, create function, statements ? "

no

> Are you using foreign keys or transactions ?

no and yes. RefDB uses a wrapper function which is a no-op for  
database engines without transaction support. With MySQL, RefDB always  
uses transactions as these seem to be silently ignored if the table  
engine does not support them.

> If you are are you specifying the table engine = innodb in you create
> table statements.
>

not at this time. RefDB uses whichever engine is set as default in  
MySQL and does not rely on any features not supported by the simplest  
one (MyISAM) as of 5.0.

> Are you using timestamp fields. No big deal here, just the defaults for
> that datatype have been switched around a bit, so the definition of the
> column is _not_ backward compatible, but the funtionality usually is.
>

The t_meta table uses a datetime field which is filled with  
UTC_TIMESTAMP at the time of creation and with a strftime() generated  
string whenever the table is updated. I'm not sure whether your  
concerns about timestamp apply here.

> I have not installed refdb in a couple of years, but I have been
> working with MySQL quite a bit, so I can help out with understanding
> MySQL changes over the years.
>

Your help will be much appreciated. As far as I know the changes in  
the 5.x series have been quite substantial, and it is quite hard to  
keep track if you're not working with MySQL directly. Of course, the  
best way to find out is to install and test-drive a recent RefDB  
version...

regards,
Markus

-- 
Markus Hoenicka
[email protected]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword