Possible drawbacks of suggested mysql install?

Hi there, I would like to know some professional opinions on the following: -Are there any drawbacks on installing Mysql on a windows server? Would it be possible to install it on the same server that hosts SQL server? Can they coexist properly? I do not expect too much usage of the Mysql

RE: Specs for a dedicated MySQL server

December 2003 7:32 a.m. To: Defryn, Guy Cc: [EMAIL PROTECTED] Subject: Re: Specs for a dedicated MySQL server There's actually a MySQL Database Appliance out there. Have you looked at that yet? http://pogolinux.com/mysql/index.html You could run MySQL on any number of different machines. Intel

RE: Specs for a dedicated MySQL server

There is one server that we have and that I can possible use Dual Pentium 1.2 ghz CPU 1 gig of Ram 18 gb SCSI 0+1 Raid What performance can I expect from this machine. What usage would it be able to handle? cheers -Original Message- From: Defryn, Guy Sent: Tuesday, 9 December 2003 9

Disk Configuration

I have another question regarding specs for a server. I have talked to a DBA who has no mySQL knowledge but did work with Oracle, etc He said I should do some more investigation on disk configuration and how mysql benefits from Separating log files, data files, etc. All feedback welcome!

Specs for a dedicated MySQL server

Hi there, I have been asked to investigate a solution to offer MySQL to our staff. I am not sure how many people will make use of it at this stage. Most people would most likely use it as a backend for message boards And to store information on whatever they are doing. I am sure it will be

Apache/PHP question

I have set apache 2.0 and PHP 4.3.1 as well as mysql. I was wondering how I can disable PHP per user directory?. At the moment everyone can put php scripts on their personal website. I want to limit it to a few users. Cheers Sql,query

startup and install issues

I have installed 4.0.9 from source. After compiling it I want to start it with /usr/local/mysql/bin/mysqld_safe --user=mysql and the message mysqld ended appears. When I move the startup script to the appropriate directory and reboot I get the following error Can't execute

Auto-completion

Is auto completion a feature that only works in Mysql4? Cheers Sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

RE: RE: Auto-completion

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 February 2003 11:03 a.m. To: Defryn, Guy Subject: Re: RE: Auto-completion Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter

Is it my English or does this sound bad?

I was just reading through the Mysql manual section 3.32 And came across a sentence that started like this Animal sex can be represented in a variety of ways My mother tongue is not English but doesn't it sound rude ? :-) mysql CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), -

Detecting Mysql servers on the network

Is it possible to detect mysql servers on the network without knowing the hostname? cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

data directory in 4.0.9

Where does mysql places the databases in 4.0.9 when installing from source? The var directory does not seem to be there anymore - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Unable to install 4.08 or 4.09

I have tried to install mysql 4.0.8 and 4.0.9 and I get the following error After running gunzip mysql-4.0.9-gamma.tar.gz (source install) Mysql-4.0.9-gamma/bdb/ Mysql-4.0.9-gamma/bdb/db/ Mysql-4.0.9-gamma/bdb/db/db_upg.c Mysql-4.0.9-gamma/bdb/db/db.c Mysql-4.0.9-gamma/bdb/db/tags Tar :

RE: Unable to install 4.08 or 4.09

Thanks Paul, It's working now. cheers -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 14 January 2003 3:41 p.m. To: Defryn, Guy; '[EMAIL PROTECTED]' Subject: Re: Unable to install 4.08 or 4.09 At 15:31 +1300 1/14/03, Defryn, Guy wrote: I have tried

mysock.sql problem

I have installed mysql from the ports collection on FreeBSD and it was working fine. I would like to move the /tmp/mysql.sock file ( or is it safe to leave it there?) so I Created a my.cnf file with the following options [mysqld] port=3306 socket=/usr/local/mysql/mysql.sock I take down the

Another one on lost connections( using web interface)

I also have a problem with lost connections. I have small mysql database (version 3.23.49 on FreeBSD 4.5) I have created a website interface to enter and retrieve data. I used ASP to do this. Sometimes when I go to the website I get the error can't connect or lost connection to server. The

Lost connection to mysql server

I have a build an ASP page to enter data in a mysql database. When I open the page I get the following error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [TCX][MyODBC]Lost connection to MySQL server during query /centraladmin/products.asp, line 88 When I refresh it

Lost connection to mysql server

I have a build an ASP page to enter data in a mysql database. When I open the page I get the following error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [TCX][MyODBC]Lost connection to MySQL server during query /centraladmin/products.asp, line 88 When I refresh it

Lost connection to mysql server

I have a build an ASP page to enter data in a mysql database. When I open the page I get the following error : Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [TCX][MyODBC]Lost connection to MySQL server during query /centraladmin/products.asp, line 88 When I refresh it

RE: Joins, ANSI 92 or the old way

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 17 July 2002 1:59 p.m. To: Defryn, Guy Subject: Re: Joins, ANSI 92 or the old way Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass

Calculations in mysql

Hi there, I am creating a tracking system for the consumables we give away to our staff. It is working but I need to know if there is a better practice than I what I did I need to print reports via a website so I used ASP It needs name,product, amount per item, price per item and total per

Calculations in mysql

Hi there, I am creating a tracking system for the consumables we give away to our staff. It is working but I need to know if there is a better practice than I what I did I need to print reports via a website so I used ASP It needs name,product, amount per item, price per item and total

Mysql certification

I was wondering if anybody heard about a possible release of books that help you prepare for the Mysql certification? Cheers - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Join problem in MYSQL

sql,query Can anyone have a look at my join. It returns errors Select O.name, O.amount , P.Productname, P.price From Orders AS O JOIN Products AS P ON O.product=P.Productid Where O.cluster= 'ANP'; It works fine when I use Select O.Name, O.amount, P.productname , P.price From Orders as O,

RE: find record using MYSQL command in ASP

Hi there, Try this % dim objconn, objrs dim sqltxt, criteriatxt, adopenkeyset, adlockoptimistic adopenkeyset=1 adlockoptimistic=3 set objconn = server.createobject(adodb.connection) set objrs = server.createobject(adodb.recordset)

Insert with ASP into mysql

Hi there, I want to insert data in a mysql database. When I submit I don't get any errors. It takes me to the page that processes everything However, when I check the database the records are not there. Selecting data from the website works fine. My code is below but I don't think anything is

Setting up a mysql server for the web

I hope someone can tell me a bit more on how to integrate a MYSQL server with a windows network. I have a web server that is running IIS5. The internet user account is IUSR_Machinename. I do not want to run the database on the web server. When I tried this with Access it did not work because

insert into multiple tables??

Is it possible to insert data into different tables with one insert statement. For example , I have one form on my web page and the data needs to go into different tables( first 5 entries to table A and the rest to table B)? Mysql

Insert dates with PHP

I am working with PHP for the first time and I need a form To insert some details and a date. When I check the mysql database the date is displayed as -00-00 Here is my php script: ? $query = Insert into computers(id,itnumber,hdd,processor,ram,monitor,os,invoice,datebought) values .

Re: Insert dates with PHP

I did forget to mention that I was using that format. So it must be something else?? Guy -Original Message- From: Uma Shankari T. [mailto:[EMAIL PROTECTED]] Sent: Thursday, 16 May 2002 4:09 p.m. To: Defryn, Guy Cc: [EMAIL PROTECTED] Subject: Re: Insert dates with PHP you have

relationships between databases

This is my first post to the list What is the best way of making a relationship between tables in Mysql. Do you set it up when you are creating the tables or is it done with the insert statement I am a newbie to Mysql, BTW Guy