RE: Help with running WinmySQL on XP Pro. - Armin Schöffmann - com.mysql.lists.win32

9 messages in com.mysql.lists.win32RE: Help with running WinmySQL on XP ...

From	Sent On	Attachments
Bruce Whealton, Jr. MSW	26 Mar 2003 00:08
Patrick Ouellet	26 Mar 2003 07:35
Bruce Whealton, Jr. MSW	26 Mar 2003 08:23
Armin Schöffmann	26 Mar 2003 08:36
Patrick Ouellet	26 Mar 2003 09:02
Armin Schöffmann	26 Mar 2003 09:05
Bruce Whealton, Jr. MSW	26 Mar 2003 09:41
Armin Schöffmann	26 Mar 2003 10:06
Patrick Ouellet	26 Mar 2003 10:23

Subject:	RE: Help with running WinmySQL on XP Pro.
From:	Armin Schöffmann (armi...@aegaeon.de)
Date:	03/26/2003 09:05:03 AM
List:	com.mysql.lists.win32

maybe both work...

-----Original Message----- From: Patrick Ouellet [mailto:poue...@microtecsecurite.com] Sent: Wednesday, March 26, 2003 6:02 PM To: win...@lists.mysql.com Subject: RE: Help with running WinmySQL on XP Pro.

Hmmm... I use forward slashes! Are you sure about using backslashes?

Anyway... Bruce No you don't need to reinstall MySQL to install the service.

If im not mistaken you can do it wia the command line. mysqld-nt.exe --install MySQL

This will install the service under NT/2K/XP

You can check the c:\mysql\data\mysql.err for error to see where the problem is.

-----Original Message----- From: Armin Schöffmann [mailto:armi...@aegaeon.de] Sent: 26 mars, 2003 11:37 To: Bruce Whealton, Jr. MSW; Patrick Ouellet; win...@lists.mysql.com Subject: RE: Help with running WinmySQL on XP Pro.

for windows, use backslashes in my.ini the official mysql setup for windows should have installed the service if you started it from an administrator account, but if your my.ini is not corretly set this may prevent the service from coming up. you can test for the service id to be known by entering 'net start mysql' in a cmd-line prompt: the error message will tell you wheater mysql is already running, starting up or unknown as a service.

take this as an example how your my.ini should/could look on a win32-system [mysqld] port=3306 skip-locking log-bin server-id = 1 tmpdir=E:\Programme\MySQL\data\ datadir=E:\Programme\MySQL\data\ basedir=E:\Programme\MySQL\ innodb_data_file_path=ibdata1:100M:autoextend

regards, armin.

Do I need to reinstall it to have it run as a service? I'm running in Windows XP Pro. I'm not sure if the my.ini file should have backslashes or forward slashes. Normally files directories in windows use backslashes as in c:\mySQL but in the my.ini it wanted to put them in as c:/mySQL and etc for each directory. I tried changing to backslashes but it only started for a second and then stopped. Perhaps I need to reinstall something. Bruce ++++++++++++++++++++++++++++++++ Bruce M. Whealton, Jr. Publisher/Webmaster Co-Editor of Word Salad - Literary Magazine at: http://wordsalad.net/ your gifts go with others, to save a life http://trianglesupport.no-ip.org/ http://durham-resources.no-ip.org/ http://savebruce.no-ip.org/ ++++++++++++++++++++++++++++++++

Hi there Bruce.

First of, I assume you are running in W32 environment? What version of Windows are you running on.

I hope its at least NT 4, and hope its 2K.

Installing it as a service would enable it to start automaticaly at boot time.

You can change the data directory in you my.ini file If im not mistaken it should look like that

[mysqld] datadir=d:\path\to\data

It will surely work as a web database, as you will configure PHP and Apache ( I make some assumtion here ) to make database request to your MySQL via IP adress and not hostname.

Here is what I can do for you with the time I have free. Hope it helps.

-----Original Message----- From: Bruce Whealton, Jr. MSW [mailto:bruc...@earthlink.net] Sent: 26 mars, 2003 03:09 To: win...@lists.mysql.com Subject: Help with running WinmySQL on XP Pro.

Hi all, I had a question and I was hoping to get some tips on what do. I installed mySQL and got it working after some effort. Then when I had to reboot the system, it would not run after rebooting. I select start the mySQL server and it starts and stops right away. I'm not sure where to go in the setup and so forth to get this working. I was reading that one needs to install mySQL first before installing PHP so that they will work together properly. I finally did get this to happen. I didn't install it as a service and I'm not sure if I should have

done so. It seems

like the directions didn't suggest that as the best way to do it. If I'm wrong please correct me. Also, if I need to reinstall mySQL will I need to reinstall PHP to make things work together?

A couple more questions that I wanted to separate out. One is that it appears that the databases will all be in the mySQL directory. I thought I could install on one drive partition and be able to have databases on a different partition. Secondly, will it work as a web based database if I keep the machine name as localhost? Check out the second to last two web sites to see what I'm trying to accomplish... helping the poor and homeless means I can't expect the most elegant solutions and web hosting services. I am checking out some services that offer free web hosting. Thanks in advance for any help, Bruce ++++++++++++++++++++++++++++++++ Bruce M. Whealton, Jr. Publisher/Webmaster Co-Editor of Word Salad - Literary Magazine at: http://wordsalad.net/ your gifts go with others, to save a life http://trianglesupport.no-ip.org/ http://durham-resources.no-ip.org/

http://savebruce.no-ip.org/

++++++++++++++++++++++++++++++++