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 10:06:22 AM
List:	com.mysql.lists.win32

-----Original Message----- From: Bruce Whealton, Jr. MSW [mailto:bruc...@earthlink.net] Sent: Wednesday, March 26, 2003 6:41 PM To: Armin Schöffmann; win...@lists.mysql.com Subject: Re: Help with running WinmySQL on XP Pro.

I think some files got corrupted. I did a reinstall and then went under control panel and selected services, which was under Administrative tools. I then selected mysql and did start service and it worked. I had a file that I found in a tutorial that is called mysql_up.php and it should show a long table if the server is up, which it did. Please explain this for me:

[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

Will the tmpdir allow one to have the database in a directory outside of the mysql directory?

the tmp-dir not, but the datadir to move the database to another drive/dir 1. stop the mysql service (net stop mysql) 2. move the contents of the existing datatree incl. all subdirectories (in your
case c:\mysql\data\*.*) to a new folder e.g. f:\mysql\databases 3. update the my.ini key "datadir=" e.g. datadir=f:\mysql\databases 4. start the service (net start mysql)

Currently, mysql is installed

in c:\mysql So, should I substitute that for the e:\programme in the above? Please explain the other lines, if you don't mind.

"basedir=" points to the location where mysql is installed (the parentdir of the
'bin' folder), in your case c:\mysql

for the rest take a look at the mysql-manual http://www.mysql.com/documentation/index.html

I'm wondering if I can tell it to put the databases in

a different partition and in a different directory... as in mysql is here c:\mysql and I'd like to have a database directory on my f: partition say, f:\mysql\databases Can that be done?

Secondly, can I use the winmysqladmin.exe when it is running as a service or will it create errors. Oh, for the password and userid. I need to specify the host correctly for this to work. I can use my IP address or the address the host name that shows up in winmysqladmin.exe or my server is setup to recognize wordsalad.no-ip.org and map that to the root directory for the server with my IP. It's a service through no-ip.com that helps with test environments like this when one doesn't have a static ip. I use earthlink cable internet and am trying to learn from home. Thanks so much, in advance, ++++++++++++++++++++++++++++++++ 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/ ++++++++++++++++++++++++++++++++

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.

-----Original Message----- From: Bruce Whealton, Jr. MSW [mailto:bruc...@earthlink.net] Sent: Wednesday, March 26, 2003 5:24 PM To: Patrick Ouellet; win...@lists.mysql.com Subject: Re: Help with running WinmySQL on XP Pro.

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/ ++++++++++++++++++++++++++++++++

----- Original Message ----- From: "Patrick Ouellet" <poue...@microtecsecurite.com> To: <win...@lists.mysql.com> Sent: Wednesday, March 26, 2003 10:36 AM Subject: RE: Help with running WinmySQL on XP Pro.

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/ ++++++++++++++++++++++++++++++++