Re: Network drive for datadir
Thanks for doing the test Miguel - yes my drive is mapped correctly. Does not want to work though :( Miguel Angel Solorzano wrote: At 16:00 04/02/2002 +, Neil Freeman wrote: Hi! I did the test in my small network and works. The only care I did is to mapped the network drive, assign a letter (in my case F). Please take a look if effectively you had mapped the drive X (trying to access the X drive with an DOS prompt). Regards, Miguel Hi, Ideally I wish to keep all of my database files on a network drive (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which resides in my WINNT directory. my.ini contents... [mysqld] basedir=C:/mysql #bind-address=127.0.0.1 datadir=X:/Shared/MyData/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=guest password=guest Upon starting the MySQL service though I receive the error message Could not start the Mysql service on \\DELL02. Error 1067: The process terminated unexpectedly. I have copied the databases to a local drive (D:\) and altered the my.ini file and all works well. Does anyone know why I cannot use MySQL to access databases on a networked drive??? Neil Email: [EMAIL PROTECTED] [EMAIL PROTECTED] - 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 *** This message was virus checked with: SAVI 3.53 Jan 2002 last updated 30th January 2002 *** -- Email: [EMAIL PROTECTED] [EMAIL PROTECTED] - 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
Re: Network drive for datadir
Neil Freeman writes: Thanks for doing the test Miguel - yes my drive is mapped correctly. Does not want to work though :( Hi! Try putting both basedir and datadir on X: ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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
Re: Network drive for datadir
That's a bit of a pain :) Any idea if this will be supported at some point? Cheers, Neil Victoria Reznichenko wrote: Neil, Monday, February 04, 2002, 6:00:18 PM, you wrote: NF Hi, NF Ideally I wish to keep all of my database files on a network drive NF (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which NF resides in my WINNT directory. NF my.ini contents... NF [mysqld] NF basedir=C:/mysql NF #bind-address=127.0.0.1 NF datadir=X:/Shared/MyData/data NF #language=C:/mysql/share/your language directory NF #slow query log#= NF #tmpdir#= NF #port=3306 NF #set-variable=key_buffer=16M NF [WinMySQLadmin] NF Server=C:/mysql/bin/mysqld-nt.exe NF user=guest NF password=guest NF Upon starting the MySQL service though I receive the error message NF Could not start the Mysql service on \\DELL02. Error 1067: The process NF terminated unexpectedly. I have copied the databases to a local drive NF (D:\) and altered the my.ini file and all works well. NF Does anyone know why I cannot use MySQL to access databases on a NF networked drive??? MySQL doesnt support loading files from Windows/samba shares. NF Neil -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 *** This message was virus checked with: SAVI 3.53 Jan 2002 last updated 30th January 2002 *** -- Email: [EMAIL PROTECTED] [EMAIL PROTECTED] - 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
Re: Network drive for datadir
Neil, Tuesday, February 05, 2002, 11:19:35 AM, you wrote: NF That's a bit of a pain :) Any idea if this will be supported at some point? Apparently it will not be supported. Disk file system differs from networking file system. MySQL will not work via networking file system. NF Cheers, Neil NF Victoria Reznichenko wrote: Neil, Monday, February 04, 2002, 6:00:18 PM, you wrote: NF Hi, NF Ideally I wish to keep all of my database files on a network drive NF (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which NF resides in my WINNT directory. NF Upon starting the MySQL service though I receive the error message NF Could not start the Mysql service on \\DELL02. Error 1067: The process NF terminated unexpectedly. I have copied the databases to a local drive NF (D:\) and altered the my.ini file and all works well. NF Does anyone know why I cannot use MySQL to access databases on a NF networked drive??? MySQL doesnt support loading files from Windows/samba shares. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Re: Network drive for datadir
At 16:00 04/02/2002 +, Neil Freeman wrote: Hi! I did the test in my small network and works. The only care I did is to mapped the network drive, assign a letter (in my case F). Please take a look if effectively you had mapped the drive X (trying to access the X drive with an DOS prompt). Regards, Miguel Hi, Ideally I wish to keep all of my database files on a network drive (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which resides in my WINNT directory. my.ini contents... [mysqld] basedir=C:/mysql #bind-address=127.0.0.1 datadir=X:/Shared/MyData/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=guest password=guest Upon starting the MySQL service though I receive the error message Could not start the Mysql service on \\DELL02. Error 1067: The process terminated unexpectedly. I have copied the databases to a local drive (D:\) and altered the my.ini file and all works well. Does anyone know why I cannot use MySQL to access databases on a networked drive??? Neil Email: [EMAIL PROTECTED] [EMAIL PROTECTED] - 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