Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » RADICORE Installation Issues » mysql scripts do not create databases
mysql scripts do not create databases [message #88] Tue, 20 June 2006 14:16 Go to next message
David Lee is currently offline  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.

Re: mysql scripts do not create databases [message #90 is a reply to message #88] Wed, 21 June 2006 04:51 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2347
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.


Re: mysql scripts do not create databases [message #94 is a reply to message #88] Wed, 21 June 2006 14:56 Go to previous messageGo to next message
David Lee is currently offline  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?
Re: mysql scripts do not create databases [message #96 is a reply to message #94] Wed, 21 June 2006 16:31 Go to previous message
AJM is currently offline  AJM
Messages: 2347
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.


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


Current Time: Thu Mar 28 09:50:12 EDT 2024

Total time taken to generate the page: 0.00944 seconds