Jannie, > /etc/my.cnf. But there is no my.cnf file at that directory. > So my question is:How to generate my.cnf based on existing configuration?
You can see the server options for the MySQL server by issuing mysqld --print-defaults The output is pretty ugly, but it will show you all settings for the server. Next step, you can put those options into /etc/my.cnf, somehow like this: Let's say, the output starts like this: mysqld would have been started with the following arguments: --basedir=c:/mysql --datadir=c:/mysql/data --tmpdir=c:/mysql/temp Then you put this in my.cnf: [mysqld] basedir=c:/mysql datadir=c:/mysql/data tmpdir=c:/mysql/temp Restarting the MySQL server, it will start with exactly the options as before. Next step, you can experiment with different settings ... Read more: http://www.mysql.com/doc/en/Command-line_options.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Jannie Qu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 20, 2003 9:58 PM Subject: How to generate my.cnf based on existing configuration? > sql, query > > Hi, all, > > I started to support on an old mysql production database on SunOS 5.8 and > mysql version 3.23.47 with only MyISAM type of tables. > > I take a look on /etc/init.d/mysql file, and in this file, it will refer > /etc/my.cnf. But there is no my.cnf file at that directory. > > I cannot shutdown the database right now in order to test the > /etc/init.d/mysql and I am afraid without my.cnf in the specified directory > will eventually cause this mysql scrip fail. > > So my question is:How to generate my.cnf based on existing configuration? > > Thank you and regards, > Jannie > > > > > > _________________________________________________________________ > Protect your PC - get McAfee.com VirusScan Online > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php