Welcome to dbFreaks.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Jumping the First Hurdle

  
   Database Help (Home) -> mySQL RSS
Next:  installaltion error  
Author Message
Jim Bunton

External


Since: Oct 04, 2004
Posts: 14



(Msg. 1) Posted: Mon Feb 07, 2005 9:40 am
Post subject: Jumping the First Hurdle
Archived from groups: mailing>database>mysql (more info?)
New to MySql:
I can't seem to get a grab on what is a schema and what is a database
So I have seen! the 'Mysql' Database and the Test Database
I'm runninng the database Administrator and thinking
"What I what to do now is create a new one of these to create my own tables
in."
The HELP seems rather opaque on this! So I'm thinking that perhaps I've got
hold of the wrong end of the proverbial stick!
[what's the difference between a database and a Schema in the MySql
context!]
[and how do I create new ones!]


--
Jim Bunton

 >> Stay informed about: Jumping the First Hurdle 
Back to top
Login to vote
Bill Karwin1

External


Since: Jun 17, 2004
Posts: 42



(Msg. 2) Posted: Mon Feb 07, 2005 12:02 pm
Post subject: Re: Jumping the First Hurdle [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Jim Bunton wrote:
 > New to MySql:
 > I can't seem to get a grab on what is a schema and what is a database
 > So I have seen! the 'Mysql' Database and the Test Database
 > I'm runninng the database Administrator and thinking
 > "What I what to do now is create a new one of these to create my own tables
 > in."

Strangely, I have found no way in the graphical front-end applications
provided by MySQL (MySQL Administrator, MySQL Query Browser), to create
a database.

As far as I know, only the command-line mysql utilities can do this.
Run 'mysql' at the command line. In the mysql shell, you can issue a
'CREATE DATABASE' command.

See:
<a style='text-decoration: underline;' href="http://dev.mysql.com/doc/mysql/en/mysql.html" target="_blank">http://dev.mysql.com/doc/mysql/en/mysql.html</a>
<a style='text-decoration: underline;' href="http://dev.mysql.com/doc/mysql/en/create-database.html" target="_blank">http://dev.mysql.com/doc/mysql/en/create-database.html</a>

After the database is created, you can use the same command-line
interface or else the MySQL Query Browser GUI application to do
virtually everything else you need to do.

Other GUI applications, such as phpMyAdmin, include a database creation
feature, but these are not interfaces provided by MySQL AB.

Regards,
Bill K.<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Jumping the First Hurdle 
Back to top
Login to vote
jnorth

External


Since: Jan 05, 2005
Posts: 3



(Msg. 3) Posted: Mon Feb 07, 2005 8:40 pm
Post subject: Re: Jumping the First Hurdle [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Mon, 07 Feb 2005 11:02:07 -0800, in mailing.database.mysql Bill
Karwin <bill.RemoveThis@karwin.com> wrote:

 >| Jim Bunton wrote:
 >| > New to MySql:
 >| > I can't seem to get a grab on what is a schema and what is a database
 >| > So I have seen! the 'Mysql' Database and the Test Database
 >| > I'm runninng the database Administrator and thinking
 >| > "What I what to do now is create a new one of these to create my own tables
 >| > in."
 >|
 >| Strangely, I have found no way in the graphical front-end applications
 >| provided by MySQL (MySQL Administrator, MySQL Query Browser), to create
 >| a database.

Try mySQL Control Center Smile
In mySQL Administrator
Click/ Select Catalogs
Right mouse click in the Schemata list and select Create New Schema,
type in the new schema/database name, press enter.
The right panel will show an empty table list for the newly created
schema. Click on the Create Table button at the bottom of the screen.
IMHO the Create Table window is a couple of steps backward from the
old Control Centre functionality.


 >| As far as I know, only the command-line mysql utilities can do this.
 >| Run 'mysql' at the command line. In the mysql shell, you can issue a
 >| 'CREATE DATABASE' command.
 >|
 >| See:
 >| <a style='text-decoration: underline;' href="http://dev.mysql.com/doc/mysql/en/mysql.html" target="_blank">http://dev.mysql.com/doc/mysql/en/mysql.html</a>
<font color=purple> >| <a style='text-decoration: underline;' href="http://dev.mysql.com/doc/mysql/en/create-database.html</font" target="_blank">http://dev.mysql.com/doc/mysql/en/create-database.html</font</a>>
 >|
 >| After the database is created, you can use the same command-line
 >| interface or else the MySQL Query Browser GUI application to do
 >| virtually everything else you need to do.
 >|
 >| Other GUI applications, such as phpMyAdmin, include a database creation
 >| feature, but these are not interfaces provided by MySQL AB.
 >|
 >| Regards,
 >| Bill K.

---------------------------------------------------------------
jnorthau.RemoveThis@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Jumping the First Hurdle 
Back to top
Login to vote
Mike A

External


Since: Feb 08, 2005
Posts: 1



(Msg. 4) Posted: Mon Feb 07, 2005 9:40 pm
Post subject: Re: Jumping the First Hurdle [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You can also create a new database in the MySQL Query Browser.
Right-click on the database list in the schemata window, and select
'Create New Schema'. Type a name for the database and click OK. Right
click on the new database, and select 'Set as default schema' (equivalent
to USE database_name). Right click once again and select 'Create Table'.

As far as I can tell, the terms 'schema' and 'database' are interchangeable in
MySQL.


--
Mike Argy
Custom Office solutions
and Windows/UNIX programs.
 >> Stay informed about: Jumping the First Hurdle 
Back to top
Login to vote
Bill Karwin1

External


Since: Jun 17, 2004
Posts: 42



(Msg. 5) Posted: Mon Feb 07, 2005 9:40 pm
Post subject: Re: Jumping the First Hurdle [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Mike A wrote:
 > You can also create a new database in the MySQL Query Browser.
 > Right-click on the database list in the schemata window, and select
 > 'Create New Schema'. Type a name for the database and click OK.

Thanks for that tip! I hadn't noticed that feature of Query Browser.

Regards,
Bill K.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Jumping the First Hurdle 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]