up vote -4 down vote favorite
share [g+] share [fb]

please, can somebody give advise on installing the log, data and other files for MySQL. I am actually a MS SQL Server DBA and have no ideas about MySQL.

Thank you!

link|improve this question
25% accept rate
Have you even tried to read the documentation about installing and configuring MySQL? – John Gardeniers Jul 2 '09 at 22:08
3  
apt-get install mysql-server too difficult? – ceejayoz Jul 3 '09 at 0:54
Windows or Linux? – SpaceManSpiff Nov 13 '09 at 12:16
feedback

3 Answers

up vote 4 down vote

Microsoft SQL Server lets you specify a location for each file (data or log) in each database.

MySQL has a single configuration parameter named 'datadir', and all data and log files for databases in a MySQL installation are stored in there. If you want to store files somewhere different, the standard UNIX answer is to move the files somewhere else, and create symbolic links back to them.

You really need to clarify your question if you want any more information than that.

link|improve this answer
it's not just datadir – pQd Nov 13 '09 at 8:49
feedback
up vote 0 down vote

it partially depends on your storage engine [ eg myisam vs innodb ]

parameters in my.cnf that you might want to check for innodb:

general parameters:

just take default distribution of mysql for your platform [ windows or unix-like distro ], install it, and take a look at my.cnf.

link|improve this answer
feedback
up vote 0 down vote

It is easy:

  1. Download and install a linux dist (maybe debian stable)
  2. apt-get install mysql-server

Done, have fun.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.