mysql_install_db

[Mark-E]

I have a question on this script. When you run this, does this create the mysql and information_schema databases?

I ran this in MySQL 5.0 on a Solaris box and it only created the information_schema database. I see a data/mysql folder and it put files under that but somehow it must not have created the mysql database properly.

I set the basedir and datadir in the script however when I ran it I had some issues with the my.cnf at that time so maybe it did not work properly becasue of that.

I see it on my windows installation but that was after I imported my dump from Bugzilla so not sure if that created the mysql database or not (don't think so).

Anyway if someone could let me know what this script creates, that would help me a lot.

Thanks!!

Mark

[saravanan-5]

Hi,

mysql_install_db is a script to create the mysql database which is the database we need all the time to run mysql server.

Information_schema is not a physical database. It will not come under the data folder. That database is to keep the details of the current status of existing databases in that server.

Saravanan

--- On Tue, 4/29/08, Mark-E <meramo@...> wrote:

> From: Mark-E <meramo@...>
> Subject: mysql_install_db
> To: mysql@...
> Date: Tuesday, April 29, 2008, 3:22 AM
> I have a question on this script. When you run this, does
> this create the
> mysql and information_schema databases?
>
> I ran this in MySQL 5.0 on a Solaris box and it only
> created the
> information_schema database. I see a data/mysql folder and
> it put files
> under that but somehow it must not have created the mysql
> database properly.
>
> I set the basedir and datadir in the script however when I
> ran it I had some
> issues with the my.cnf at that time so maybe it did not
> work properly
> becasue of that.
>
> I see it on my windows installation but that was after I
> imported my dump
> from Bugzilla so not sure if that created the mysql
> database or not (don't
> think so).
>
> Anyway if someone could let me know what this script
> creates, that would
> help me a lot.
>
> Thanks!!
>
> Mark
>
> --
> View this message in context:
> http://www.nabble.com/mysql_install_db-tp16945907p16945907.html
> Sent from the MySQL - General mailing list archive at
> Nabble.com.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:  
> http://lists.mysql.com/mysql?unsub=suzuki_babu@...

      ____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=lists@...