Re: Cannot create database in MySQL

Here is a list of reserved words in MySQL 5.1

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

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 ?

Same goes for RedHat..

Yum install refdb ...
  dependency check and install of MySQL.

This seems reasonable.

Answer the following questions and I can try to help you to make sure  
your DB tables are backwards compatible.

Do you use Stored procedure or user created functions ?
Does your DB script that creates the Refdb Database have any
"create procedure, create function, statements ? "

Are you using foreign keys or transactions ?
If you are are you specifying the table engine = innodb in you create  
table statements.

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.

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.

Best regards,

Tom Hanlon

On 31 Jan 2009, at 11:50, Markus Hoenicka wrote:

> Torsten Bronger writes:
>> Secondly, the name "references" is bad for the database because it
>> seems to be a reserved word or something like that (unfortunately,
>> at the same time it's a good name for a references DB ;-).  With
>> "biblio", it worked.
>
> According to the MySQL manual "references" is a clause in the
> "alter table" syntax, so it is indeed a reserved word. I'll add this
> to the documentation as it is all too easy to get trapped here.
>
>>
>> However, I run into trouble here and there because "deb
>> http://refdb.sourceforge.net/debian/svn testing main" gives me an
>> outdated version (from March 2007 or so).  Is it feasible to update
>> this?  If not, I'm highly probably able to install the SVN version.
>> :)
>>
>
> Unfortunately RefDB has to make do without a Debian maintainer. We
> can't update the .debs unless someone "in the know"
> volunteers. However, the svn version or the latest prerelease should
> work fine. RefDB does not install stuff in weird places, and a "make
> uninstall" should remove most traces of it from your system if you
> ever want to get rid of it.
>
> 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
> _______________________________________________
> Refdb-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/refdb-users


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