How can I run MySQL in standalone mode?
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.
If I distribute application i want to make installation easier - copy and paste.
Do you know someone who could answer? Ask him for help
Answers: 1
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"
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
Ask question
Related questions:
Insert multiple rows into MySQL
how can we use lucene indexing in mysql
How Jboss CMP Engine create MySQL tables as InnoDB?
MySql data types INTEGER, SMALLINT, DECIMAL, and NUMERIC ?
How to open enormous text files?
Import large SQL dump gives 'MySQL server has gone away'?
How can I enable built in user 'Administrator' on Vista
How to disable windows Defender?