What the required files to include in order to run mysql
Hi We've put together an installation of our tool together with MySQL The question is now what files are required (must be included) to run MySQL? I've included: Bin/ mysql.exe mysqladmin.exe mysqld-nt.exe mysqldump.exe mysqlimport.exe libmySQL.dll Data/ mysql/ * db/ * Language/ * Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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: How to file a bug: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command.
Hi, I have now been able to solve this problem. I used MySQL 3.23, but when I installed MySQL 4.0.3 it worked fine. Great Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] Hi How do I file a bug for mysql for Windows NT/2000/XP. Problem: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command. e.g. mysqld-nt --datadir=c:\Program Files\mysql\data Is not possible, nor is mysqld-nt --datadir=c:\Program Files\mysql\data Using the ~1 yielding c:\Progra~1\mysql\data is not an option, nor is using the my.ini file. The reason is that I am installing mysql db for my application only, and if there are other mysql db's installed then it will be ambiguos on how to use the my.ini file, as it is shared by all installations of mysql. I can not use the ~1, ~2 ... Cause I will not on before hand, at installation time, know which one to choose. Lets say there are two directories c:\Program Files Old\ and c:\Program Files\ then these would be translated into c:\Program~1 and c:\Program~2, how could an installer know which one to choose? It can't therefore this solution is not an option either. Please help me out here. Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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
How to file a bug: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command.
Hi How do I file a bug for mysql for Windows NT/2000/XP. Problem: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command. e.g. mysqld-nt --datadir=c:\Program Files\mysql\data Is not possible, nor is mysqld-nt --datadir=c:\Program Files\mysql\data Using the ~1 yielding c:\Progra~1\mysql\data is not an option, nor is using the my.ini file. The reason is that I am installing mysql db for my application only, and if there are other mysql db's installed then it will be ambiguos on how to use the my.ini file, as it is shared by all installations of mysql. I can not use the ~1, ~2 ... Cause I will not on before hand, at installation time, know which one to choose. Lets say there are two directories c:\Program Files Old\ and c:\Program Files\ then these would be translated into c:\Program~1 and c:\Program~2, how could an installer know which one to choose? It can't therefore this solution is not an option either. Please help me out here. Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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: Start mysqld-nt from command line with SPACES in the path, how?
But here you do not specify the --data c:\Program Files\ option. The space couldn't be handled by the mysqld-nt exe, I believe it could have something to do with the fact that it interprets the arguments as 3 strings instead of 2. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: 16 September 2002 15:59 To: [EMAIL PROTECTED] Subject: re: Start mysqld-nt from command line with SPACES in the path, how? Tobias, Monday, September 16, 2002, 2:33:10 PM, you wrote: TE I am trying to start up the database, mysql, on a windows machine. TE I installed it into a dir under c:\Program Files\ComOpt\CellOpt TE AFP\database\. As you can see there are SPACEs here, if I am using TE the config file; c:\winnt\my.ini everything is working just fine, TE however when I try to start the server from the command line it TE breaks. It can not work with spaces on the command line. The problem TE is you see that I have to get it wokring this way, as I would like TE to use, start up, mysql on the machine without beeing dependent on TE any other previous or current installations (no old my.ini for TE example). All the config files are located in any of three places, TE unfortunately that is rather difficult to handle with several mysql TE database running at the same time. So what I want is to be able to TE run several mysql servers completely independet from one another. TE Has anyone started the server without using the config files, TE straight from the command line using SPACES in the path to the main TE mysql directory. Yes, and it worked well: E:\ E:\Program Files\MySQL4.0.3\bin\mysqld-max-nt.exe --standalone --console 020916 15:57:47 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get better performance if you configure a bigger InnoDB: value in the MySQL my.cnf file for InnoDB: innodb_additional_mem_pool_size. 020916 15:57:47 InnoDB: Started E:\Program Files\MySQL4.0.3\bin\mysqld-max-nt.exe: ready for connections -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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 - 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: How to run multiple mysql servers
Hi Okan, Well, the only solution I know of, to diffrentiate the two servers are to provide different argument on the command line. The server will allways read any of the files; my.ini or my.cnf first, and there set the parameters, after that it will take the command line arguments. This means that you should make sure that you override any properties in the files with the command line args, if necessary. There are couple of pages of this information in the manul; Running Multiple MySQL Server on the same Machine. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] -Original Message- From: Okan CIMEN [mailto:[EMAIL PROTECTED]] Sent: 01 September 2002 11:40 To: Tobias Eriksson Subject: Re: How to run multiple mysql servers Hi Tobias, I am planning to run two servers at the same machine which are also replicating each other. But I want these servers to have different variables/my.ini files. I just wonder about the initial parameters of the second MySQL server. Does it also read the c:/winnt/my.ini values or do you refer it to some other parameter file? If so, how? Thanks for your help Regards Okan - Original Message - From: Tobias Eriksson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 30, 2002 3:47 PM Subject: RE: How to run multiple mysql servers I got it! Sorry, ohh... So simple The reason for the problem was ofcourse that I did not provide a --datadir=c:\\mysql\\data parameter, this superseeded the parameter set in the config file. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] -Original Message- From: Tobias Eriksson Sent: 30 August 2002 14:41 To: [EMAIL PROTECTED] Subject: How to run multiple mysql servers I would like to run 2 mysqld-nt at the same time. This is because we are shipping mysql with our product and then we would like to have the database installed within our product. And also run separate from any other MySQL database that might be installed on the system. When I try to run the command: C:\mysql\binmysqld-nt --basedir=c:\\mysql --port=3321 --standalone mysqld-nt: Can't change dir to 'C:\Program Files\ComOpt\mysql\data\' (Errcode: 2) 020830 14:27:37 Aborting 020830 14:27:37 mysqld-nt: Shutdown Complete This seems to have to do with the file my.ini located in c:\winnt, because if I remove it, it will work. But according to the manual the command line arguments should have higher priority than the config files, or environment varibales. My question is thus, how do I come around this problem and make it possible to run multiple installations of MySQL ? Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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 - 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
How to run multiple mysql servers
I would like to run 2 mysqld-nt at the same time. This is because we are shipping mysql with our product and then we would like to have the database installed within our product. And also run separate from any other MySQL database that might be installed on the system. When I try to run the command: C:\mysql\binmysqld-nt --basedir=c:\\mysql --port=3321 --standalone mysqld-nt: Can't change dir to 'C:\Program Files\ComOpt\mysql\data\' (Errcode: 2) 020830 14:27:37 Aborting 020830 14:27:37 mysqld-nt: Shutdown Complete This seems to have to do with the file my.ini located in c:\winnt, because if I remove it, it will work. But according to the manual the command line arguments should have higher priority than the config files, or environment varibales. My question is thus, how do I come around this problem and make it possible to run multiple installations of MySQL ? Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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: How to run multiple mysql servers
I got it! Sorry, ohh... So simple The reason for the problem was ofcourse that I did not provide a --datadir=c:\\mysql\\data parameter, this superseeded the parameter set in the config file. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] -Original Message- From: Tobias Eriksson Sent: 30 August 2002 14:41 To: [EMAIL PROTECTED] Subject: How to run multiple mysql servers I would like to run 2 mysqld-nt at the same time. This is because we are shipping mysql with our product and then we would like to have the database installed within our product. And also run separate from any other MySQL database that might be installed on the system. When I try to run the command: C:\mysql\binmysqld-nt --basedir=c:\\mysql --port=3321 --standalone mysqld-nt: Can't change dir to 'C:\Program Files\ComOpt\mysql\data\' (Errcode: 2) 020830 14:27:37 Aborting 020830 14:27:37 mysqld-nt: Shutdown Complete This seems to have to do with the file my.ini located in c:\winnt, because if I remove it, it will work. But according to the manual the command line arguments should have higher priority than the config files, or environment varibales. My question is thus, how do I come around this problem and make it possible to run multiple installations of MySQL ? Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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 - 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
How to compile embedded MySQL on Windows
Hi I am trying to figure out how to compile embedded MySQL on Windows. I read that one should configure using the --with-embedded-server flag, but I should also use some script called mysql_config. But I couldn't find that script, I have downloaded the source for version 4.0, so I should have all the necessary things. Please, if someone you lead me in the right directions I would really appriciate it. What I am trying to accomplish is to build the libmysql to also enable the SOCKET PORT facility in an embedded server. Thus I want to run my application with MySQL embedded and then also allow for connections to the database from the outside. If you've done something similar please let me know. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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
Where is mysql_server_init defined ?
Hi, I'm trying to figure out how to implement an embedded mySQL database in my application, but seems to have stumbled on something strange. The documentation and on the web everyone seems to refer to a method/function called 'mysql_server_init()' however, my compiler complained about that it does not exists, I then searched through all the files that comes with mysql normal install, and realized that there is no such method/function. What am I doing wrong, is there a particular package I would have to download in order to get it working or ... ? Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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
How to integrate MySQL into my application?
Hi I heard that one can instead of having the mysql database running as a server (separate process), one can integrate it as part of the application through a shared lib (DLL or so lib). Anyone who's got a reference to a document describing this? Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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
What is needed to redistribute MySQL with my software?
Hi I am putting together a software which is based on MySQL, now I would like to redistribute MySQL with my installation package, what do I need to comply with? Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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
make my own installer, what needs to be included
Hi I am about to either create my own installer for MySQL or use the allready made one. Reason is that I would like to have an unattended installation of the database, which can be sent as an SMS package (MSI). I need to know the following; 1) What is the bare minimum to include for an installation of MySQL ? I would imagine; 1) the data dir, 2) the bin dir, 3) the lib dir. So far there does not seem to be any windows registry entries (actually) beeing used. The ones that does exist, does not seem to have any meaning... 2) Can I specify another name of the MySQL service on Windows through the command line; mysqld-nt --install ... or do I have to make my own service installer, the thing is that I would like all exe's included work with the service installed even if it has another name. 3) Has anyone made an installer, based on MSI, that one could get from somewhere. 4) Has anyone made an installer which is unattended. Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] mailto:[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