Default Data Folder

[JoeSavi]

I installed the Enterprise version in C:mysql. When I create a database it stores it in C:mysqldata. I would like to change the default data folder to my D: drive. Can anyone help find where I can change that in the program? Is it possible ?? or Do I have to reinstall the wholw program on my D: drive ??

Thanks,

Joe

[peterlaursen]

You are mismatching what the MySQL Server does and what SQLyog does, I think!  SQLyog does not interfere in where MySQL stores itis data.

To change the location of MySQL data storage you will need to specify the datadir in the MySQL configuration file (my.ini) and restart the server.

in the [mysqld] section of my.ini just insert:

datadir: X:/the/place/i/want/my/data/to/be

(or use the fre program 'MySQL Administrator' to from http://dev.mysql.com to change the configuration.  MA is part of the 'MySQL GUI Tools' package.

BTW: Installing SQLyog into the MySQL program folder is not a pretty good idea.  i am not sure what will happen wonce you u[grade mysql.  Like any program SQLyog would normally be installed in /program files/it's own folder

[JoeSavi]

JoeSavi wrote on Jan 7 2007, 10:42 AM:

I installed the Enterprise version in C:mysql. When I create a database it stores it in C:mysqldata. I would like to change the default data folder to my D: drive. Can anyone help find where I can change that in the program? Is it possible ?? or Do I have to reinstall the wholw program on my D: drive ??

Thanks,

Joe

[JoeSavi]

peterlaursen wrote on Jan 7 2007, 09:00 PM:

You are mismatching what the MySQL Server does and what SQLyog does, I think!  SQLyog does not interfere in where MySQL stores itis data.

To change the location of MySQL data storage you will need to specify the datadir in the MySQL configuration file (my.ini) and restart the server.

in the [mysqld] section of my.ini just insert:

datadir: X:/the/place/i/want/my/data/to/be

(or use the fre program 'MySQL Administrator' to from http://dev.mysql.com to change the configuration.  MA is part of the 'MySQL GUI Tools' package.

BTW: Installing SQLyog into the MySQL program folder is not a pretty good idea.  i am not sure what will happen wonce you u[grade mysql.  Like any program SQLyog would normally be installed in /program files/it's own folder

[peterlaursen]

Do you have problems with the Interface of this Forum .. ??

quoting two previous post does not add any new content to the discussion, I think!

[Author]

Posts