At 16:51 14/02/2002 +0530, Asit Satpathy wrote: Hi! >Mysql pick up the database list from its default datadir C:/mysql/data >as it is mentioned in >my.ini file in window. >but i want to use my own directory which contains some database , if i >am setting the datadir into my >directory i am able to use my own directory to which i have to copy the >default mysql database; > >i want to use both data directory of mysql as well as my default >directory. if possible then please send a reply how >can i set both the directory to datadir. i am sending my.ini file which >is being used.
You only can use one basedir and one datadir in the my.ini file. However if you want to have others databases in another directory, you can use the symbolic-link feature (read the Manual, how to handle this on Windows). Regards, Miguel >#This File was made using the WinMySQLAdmin 1.3 Tool >#2/4/02 12:14:58 PM > >#Uncomment or Add only the keys that you know how works. >#Read the MySQL Manual for instructions > >[mysqld] >basedir=C:/mysql >#bind-address=164.100.20.26 >datadir=C:/mysql/data >datadir=C:/asitdatabase >#language=C:/mysql/share/your language directory >#slow query log#= >#tmpdir#= >#port=3306 >#set-variable=key_buffer=16M > >[WinMySQLadmin] >Server=C:/mysql/bin/mysqld-max-nt.exe >user=asit >password=asit >QueryInterval=10 > > Regards >Asit > > >--------------------------------------------------------------------- >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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ www.mysql.com --------------------------------------------------------------------- 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
