- Decide which server you will use
mysqld, the standard server
mysqld-opt, a version for optimized performance
mysqld-nt, similar to mysqld except that more specific to the NT family of Windows
mysqld-max, like the mysqld-opt, but made to support the InnDB and DBD table types.
These other table types are more advance in every way possible.
Borland InterBase, uses the InnDB database type
- open a text editor or similar tools to create the my.ini configuration file
- or load the WinMySQLAdmin application to help you setup the my.ini
- make sure that the following do exist in the my.ini file and as follows;
[mysqld]
basedir=C:\mysql
datadir=C:\mysql/data
This is just the basis of a configuration file. These two(2) important pieces of information tell the MySQL server both wehre the MySQL files are located (basedir) and where the database files are (datadir).
- save the file as my.ini
- start the server, from the DOS prompt, enter the following lines:
ex.:
cd c:\mysql\bin
mysqld --standalone
IF you are not using an NT version of Windows, you can start MySQL with just the mysqld command
- Begin administering your databases from here on
|