How can I run MySQL in standalone mode?

Answer!
Add to 'Watch list'
Send to a friend E-mail

Asked by: stenton
Published on: 11:34/21.11.2007
Status: OPEN

Is it possible to run MySQL in standalone mode? I have installed MySQL Server 4.1 on windows and I don't want to use mysql service. Is it possible to start the database from bat file and to have it on USB, so I can copy to any machine and just run it?
If I distribute application i want to make installation easier - copy and paste.

Answers: 1

Sort by: /\ date | rating

Send to a friend E-mail

Answer by: xpert
Posted on: 11:34/21.11.2007
Rating: 1.2 from possible 5 with 5 votes

On windows, the mysql process is bin\mysqld-nt.exe. You can copy DATA folder wherever you like. You can give command line parameters to mysql-nt. Here is how you start standalone mysql server in utf:

mysqld-nt --default-character-set=utf8 --datadir="c:/MySQL Server 4.1/data"

Vote:

Please vote! Your opinion matters!

If you haven't found what you've looking for, post a question