Radicore Forum: RADICORE Installation Issues » mysql scripts do not create databases

Home » RADICORE » RADICORE Installation Issues » mysql scripts do not create databases

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

mysql scripts do not create databases [message #88]

Tue, 20 June 2006 14:16

David Lee
Messages: 44
Registered: June 2006

Member

The mysql scripts in version 1.9.0 do not create the databases, so all the tables are created in whatever database is open when
they are run.
Easy enough to solve if you know, but it slowed me done a little!

Current problem is I can not log in, but still need to investigate more, and there is a separate thread on that subject,
which I will read and add to if needed.

Report message to a moderator

Re: mysql scripts do not create databases [message #90 is a reply to message #88]

Wed, 21 June 2006 04:51

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

All the scripts are created using the 'export' function within phpMyAdmin which, as you should know, does not include the code to create the database, just the tables. The database name is included as a comment at the start of each script. This means that each database must be created manually, then you must switch to the right database before running each of the scripts.

This is normal practice. If you are running on a shared web server the "create database" instruction needs to be separate as the database name may need to be prefixed with your account name, and phpMyAdmin takes care of this automatically.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: mysql scripts do not create databases [message #94 is a reply to message #88]

Wed, 21 June 2006 14:56

David Lee
Messages: 44
Registered: June 2006

Member

Re-reading the installation instructions, I find it does say create the databases first, so this one is me not reading the instructions, and RADICORE doing what it says on the box!

However, it would be more user-friendly if the scripts could create the required database if needed, and ensure that the tables could only be created in the correct database. I realise that
1) This does allow a simple dump from phpmyadmin
2) Installation occurs a single time, so is not very important in the overall use of the RADICORE system
3) There are other priorities
However, could improving this be put on the "nice to have" section of possible future developments, please?

Report message to a moderator

Re: mysql scripts do not create databases [message #96 is a reply to message #94]

Wed, 21 June 2006 16:31

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Unfortunately MySQL does not have a CREATE DATABASE IF NOT EXISTS ... so all I can do is insert the following lines at the top of each script:

CREATE DATABASE xxx ;
USE xxx ;

This really is such a trivial issue that most people do not seem to have a problem with, so trying to automate it or make it even simpler just for a few novices would not seem that important in the great scheme of things. Anyone who struggles to create a few databases is probably too much of a newbie to really appreciate the numerous features in a product such as Radicore.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Radicore installation problem
Next Topic:	Steps for installation of radicore in Fedora Core 4

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jul 04 19:41:00 EDT 2025

Total time taken to generate the page: 0.01221 seconds