MySQL noob question: Where can I find the database when I create one?

Rails
1

See my screenshot of the command here.
http://a.imagehost.org/0843/mysqladmin.png

When I type the following:
mysqladmin create <database_name> --user=root --password=xxxxxxxx

Is my command executed simply by pressing “Enter” after the command?
Am I missing some syntax?
If the command has been executed , what directory can I find this
database?

How does this relate to MySQL Administrator?
http://a.imagehost.org/0476/mysql_administrator.png

Sorry for such a stupid question.

  • Sinclair
2

On Aug 5, 4:32 am, Sinclair [email protected] wrote:

See my screenshot of the command here.http://a.imagehost.org/0843/mysqladmin.png

When I type the following:
mysqladmin create <database_name> --user=root --password=xxxxxxxx

Is my command executed simply by pressing “Enter” after the command?
Am I missing some syntax?

Sort of. mysqladmin is a command line utility, so you run it from your
shell / dos prompt, not from the mysql console (although you can
create databases from there too).

If the command has been executed , what directory can I find this
database?

don’t remember where databases go in windows. Probably somewhere
inside c:\program files\mysql or whatever the default installation
folder is.

How does this relate to MySQL Administrator?http://a.imagehost.org/0476/mysql_administrator.png

That’s a graphical tool for performing various tasks

Fred

3

Hi
If you installed in c drive then the location will be
C:\mysql\data\

And one more thing to create/drop your development,test,production

dbs need not go to mysql console There are rake tasks for that From your
project directory do

rake db:create #creates developmentdb you specified in database.yml
rake db:create RAILS_ENV=test creates testdb

or
rake db:create:all this creates all your dbs for 3 environments

similarly
rake db:drop and rake db:drop:all
Note: be careful while using There wont be anywarning

Sijo