RE: Need help on mysql/php

2001-06-06 Thread Sommai Fongnamthip
split code for use username and password to connect to MySQL into other file and use include in every php program instead have username and password code. connect.inc.php ? // define database connect variable $hostname = localhost; $username = root; $password = password; $tblname =

Re: which the best

2001-06-06 Thread B. van Ouwerkerk
You're right.. wrong place to ask. I don't want to start a kind of religious war.. but I wouldn't go for M$ products. Further good reading on this is presented in this lists archive. Bye, B. I know this is not list for ask about OS, but I wonder to know that which OS you choose

MySQL with perl

2001-06-06 Thread Dawn H
I've written a couple of scripts and have a thing that I haven't quite figured out. If anyone can shed light on this, I'd appreciate it. When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be

Building/installing MySQL under Mac OS X 10.03

2001-06-06 Thread Keith J. Schultz
Hi Everbody, Forgive if there is a fact somewhere for this. I have benn trying to install mysql 3.23.38 under Mac OS X 10.03 to no avail. The binary distrubution says I need pthreads ! the manual says I do not !?! The only binary arround is for the Mac OS

Re: PHP MySQL

2001-06-06 Thread Rolf Hopkins
How'd you put it into the database in the first place? I'm betting that, if you look at your database directly (not through a UI), you'll find the data is stored as lt;IMG Anyway, wouldn't it be easier just to store foo.gif in the database rather than the full line? - Original Message

Re: PHP MySQL

2001-06-06 Thread Zak Greant
Hi, PHP will only do this sort of translation if it is made to do so. Here are the parts of the language that are likely to relate to your problem: - The magic_quotes_gpc configuration directive - The addslashes() function - The htmlentities() or htmlspecialchars() function Now, while you

Re: which the best

2001-06-06 Thread PROVVISORIO
I'd go for Linux Red Hat 7.1. High reliability, wonderful stability. We did it, and it still works perfectly (Linux Red Hat 6.2 to 7.1 + MySQL 3.23.22 to 3.23.37). The right enviroment for MySQL based applications (and if You're thinking of web applications, go for Linux Red Hat 7.1 + MySQL

Re: MySQL with perl

2001-06-06 Thread Cindy
Dawn H writes: I've written a couple of scripts and have a thing that I haven't quite figured out. If anyone can shed light on this, I'd appreciate it. When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the

Re: Inserting 307,284 lines. Is this ok?

2001-06-06 Thread Simon Windsor
Hi In your lilo configuaration file add append=mem=256 to the linux kernel boot parameters, and then run lilo. When you reboot your server, you will find your missing memory ! MySql can handle large tables, up to 2GB, without any problems. Tables that result in files 2GB need the

From As400 to MySQL ...

2001-06-06 Thread PROVVISORIO
Good morning world. We are facing an interesting problem here. We are thinking of a MySQL-based datawharehousing application. The main ERP db is OS400/AS400. We have to sincronize it with MySQL datawharehousing db. Anybody out there did the same? TIA Corrado Bombardier Systems Consulting ha

Re: PHP MySQL

2001-06-06 Thread Michele Santucci
How'd you put it into the database in the first place? I'm betting that, if you look at your database directly (not through a UI), you'll find the data is stored as lt;IMG No the data was stored in the right way! The problem wasn't here but in some code lines around the one I was

Re: MAC OS X Server

2001-06-06 Thread Glenn A . Bookout
Howdy: On 06/05/2001 15:42 USA PT (-0800), [EMAIL PROTECTED] ( Angela Neff ), wrote... Below is a link and article sent to me by a Consultant stating that MySQL works with the brand new MAC OS X Server. Has this indeed been thoroughly tested by MySQL programmers? I don't want to get one unless

Re: PHP MySQL

2001-06-06 Thread Rolf Hopkins
- Original Message - From: Michele Santucci [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 15:33 Subject: Re: PHP MySQL How'd you put it into the database in the first place? I'm betting that, if you look at your database

Re: PHP MySQL

2001-06-06 Thread Ben Gollmer
I assume that you are using htmlspecialchars() or htmlentities() to encode characters that have special meanings under HTML. Don't - your data will be inserted into the database verbatim. You may have to use addslashes() on your data to escape the quotes before you insert it into the database

MySql Client

2001-06-06 Thread M Srinivas
HI, I am new to mySql and I want to set up MySql Client on different PC's and MySql server on one PC so that every one will access the same database. Is there a way to do this. Any one please help me. Thanks and Regards, Srinivas.M My Mail Id : [EMAIL PROTECTED] --- Outgoing mail is

Problem with Zeos Component and BLOB

2001-06-06 Thread Paolo Alzalamira
exists a limit of dimension for the blob in mysql? why I do not succeed to write of the blob with the zeos component with dimensions 6M? help excused my maccheronico English - Before posting, please check:

need help with cross table update

2001-06-06 Thread Jaime Teng
Hi, I have two tables on mysql: Table1: class char(10) usernamechar(50) etc. etc.. Table2: class char(10) usernamechar(50) timeint unsigned etc.. Table2's class column is a new column addition and therefore does not have any values on it. I

Re: Building/installing MySQL under Mac OS X 10.03

2001-06-06 Thread Jeroen Clarysse
I don't understand how yuo can have so much trouble building it ! I just downloaded the latest stable release, unzipped it, and did ./configure make make install mysql_install_db safe_mysqld and it went hoopla running ! (after almost half an hour compiling that is)

Re: Building/installing MySQL under Mac OS X 10.03

2001-06-06 Thread Jeroen Clarysse
PS : here's my versionnnumber : mysql SHOW VARIABLES LIKE version; +---+-+ | Variable_name | Value | +---+-+ | version | 3.23.37 | +---+-+ 1 row in set (0.00 sec)

Re: MySql Client

2001-06-06 Thread Rolf Hopkins
Yes there is. Just install the MySQL client in the normal way. When you add users, ensure they can access the server from a remote machine. See the GRANT and REVOKE statements. When they log in, they must specify the address of the MySQL server using the -h option. - Original Message

Problems with AUTO_INCREMENT

2001-06-06 Thread Conny Kreyßel
Hi, on my database I have create a table with an ID like this: CREATE TABLE test { id INT(10) unsigned NOT NULL default '0' AUTO_INCREMENT, another INT(10) }; and now I have inserted some values - the ID that would be inserted starts at 1, but I need a ID with 0. How can I set

RE: Replication out of sync

2001-06-06 Thread Warren van der Merwe
Hi Well, what I did was dump my structure to file, then I went an manually added a line to the end of each table saying AUTO_INCREMENT=1 for Site A, Site B was set to 2 and so on, obviously there is a chance one day of Site A's auto_increment reaching 2 but it won't

MySQL on OS/2 machine

2001-06-06 Thread Jan Waliszewski
Can you help me to set up an mySQL client on OS/2 machine? I have a mySQL/2 server (3.22.26a) which was successfully configured. I can communicate with the server from mySQLgui tool from Windows workstation, so I can proof that the server is set up correctly. The trouble is that I cannot

need help for a simple request

2001-06-06 Thread alexandre Roussel
Hi, I have some problems with the following SQL request that I process with phpMyAdmin : select * from TABLE2 where FIELD not in (select FIELD from TABLE1); This request identify all records in TABLE2 which are not in TABLE1 (depending on value of FIELD). TABLE1 and TABLE2 have exactly the

Size of the bin log

2001-06-06 Thread Rafal Jank
Hi, Is it possible to make MySQL create another bin log when current one grows to the specified size? Rafal -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237

RE: Replication out of sync

2001-06-06 Thread Warren van der Merwe
Okay, do not do this. When your replication takes place, Site A adjusts Site B autoincrement number. ANd so this principle does not work! I really think this replication could be very good if you could specify not to replicate a particular column, or some better way of handling auto

Re: need help for a simple request

2001-06-06 Thread Rafal Jank
alexandre Roussel wrote: Hi, I have some problems with the following SQL request that I process with phpMyAdmin : select * from TABLE2 where FIELD not in (select FIELD from TABLE1); This request identify all records in TABLE2 which are not in TABLE1 (depending on value of FIELD).

Log file size

2001-06-06 Thread Peter Billson
I'm running mySQL on Linux and was wondering is there a way to limit the maximum log file size? From time to time I have written a bad script that will query mySQL in a loop (BTW - mySQL can do *lots* of queries/second!) without me realizing my mistake until I run out of room on my log

FROM C to MYSQL

2001-06-06 Thread Alessandro Coppelli
Hi to all. I would write a C programm for write a lot of variables in MySQL database. There are examples ? I try to write a cgi with Boutell library and then write the form variable in a database Alessandro - Before posting,

Re: need help for a simple request

2001-06-06 Thread MikemickaloBlezien
On Wed, 6 Jun 2001 11:52:14 +0200, alexandre Roussel [EMAIL PROTECTED] wrote: subselects are not currently supported with MySQL. Hi, I have some problems with the following SQL request that I process with phpMyAdmin : select * from TABLE2 where FIELD not in (select FIELD from TABLE1); This

Databases not see with show database query...

2001-06-06 Thread Harish Gundecha
Hi All... I m running Mysql 3.23.36 on Redhat Linux 7.0... Installation and configuration has been finished... Mysql is working perfect on some systems but on some systems when i Say show databases it gives the following error... mysql show databases; +--+ | Database | +--+

Re: MySQL with perl

2001-06-06 Thread Peter Billson
When a person submits a form that inserts a record into the database, if they then refresh the page that comes up after the submit, the record will be submitted a second time. I suppose this is due to the fact that the subroutine that is called with the submit contains both the write to

Re: mysqld 3.23.36-log stop responding

2001-06-06 Thread Sinisa Milivojevic
Martin Bringe writes: Hi, I need som help on problems we encounter with mysql. I find nothing in manual nor this list, that gave me a hint where I can solve my problem: Environment: mysql run on an dedicated system with dual pIII-933 and 1 GB RAM. the mysql-server is used by a webserver

bug!

2001-06-06 Thread ran
To MySql Team. I am trying mysql version 3.23.38 for win 2000 and linux. I use VB and VC++ to develop. There are 2 major problem i have encounter. 1) If i ask for "describe [tablename]" into a Datagrid, I do not get the info back when the tables has an auto_increment field. 2) I use ODBC to

Make: Doesn't exist?

2001-06-06 Thread Richard Kimberley
Hi, I'm trying to install MySQL 3.23.38 from the source distribution onto RedHat Linux 6.2 (fresh installation). After unpacking the tarball into /usr/local/mysql-3.23.38 I run ./configure etc. but when I type in make from the mysql-3.23.38 directoiry all i get is: bash: make: command not found

score in search - problem

2001-06-06 Thread Nessi
Hi I got my fulltext search going and its all fine except for one little thing that has been bugging me. In the mysql manual it says that using MATCH col AGAINST ('something') as x will output a percent value in x, such as 0.56 i.e. However, for some reason I keep getting values such as

How to convert MS Access mdb to Mysql

2001-06-06 Thread Tomas Norre
Hello.. is it possible to convert a whole ms access database (mdb) to a mysql database if so.. howto ? from Milpoer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Break 31 tables in a join limitation with MySql

2001-06-06 Thread SixK
Hello , I would like to know how to break the 31 tables in a join limitation, In documentation I found that table cache should be at least equal to n*max_connections where n is the maximum tables in a join, so I don't know if modifying table_cache value will help or if there is another way ...

convert an ms access database file

2001-06-06 Thread Terrell Johnson
I need to convert an ms access database file to a mysql compatible pipe delimited database file. I downloaded a program to convert the database, but it needs to connect to the mysql server on my dedicated server. When I try to connect it says 'ipaddress.internetprovider' is not allowed to

Problem with adding some functions into MySQL

2001-06-06 Thread Ji krabal
Hi all, I'm currently working on project, where I need implement some functions to formate SQL queries. It's necessary to add these functions into MySQL. I read about UDF (user def. functions) and I mean, that it is almost what I want. For examlple, QUERY() ... UDF function, whitch returns

RE: Make: Doesn't exist?

2001-06-06 Thread Gilfether, Ryan
sounds like you either dont have make installed on your machine, or it is not in your PATH environment variable do 'find / -name make -print' and see if it is on your machine, if not you will have to get your redhat CD and install it -Original Message- From: Richard Kimberley

Importing spreadsheet data into MySQL

2001-06-06 Thread Chris L. Gray
Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. Thanks, Chris Gray --- Outgoing mail is certified Virus Free. Checked by AVG

Stored procedures (really sorry for bringing this up)

2001-06-06 Thread John N S Gill
The company I work for has been considering moving a key database from MS Access to a proper database. We use linux for a lot of the number crunching we do and I was keen for us to choose MySQL. I happen to think it would be ideal for our applications. Unfortunately, those with the task of

Re: Replication out of sync

2001-06-06 Thread Michael Eklund
Actually, in my humble opinion, autoincrements need to have a host component, so each autoincrement is unique on each machine. Also you could have the master negotiate discrepencies, but this is far more complicated. Mike On Wed, 6 Jun 2001 12:25:16 +0200 Warren van der Merwe [EMAIL

Re: CGI/Perl and MySQL (OT?)

2001-06-06 Thread Chris Thompson
Trying to get text from a CGI textarea box to go into MySQL with the br line breaks instead on generic \n breaks. Is there an easy way to parse the var and make the necessary change? You can use a Perl regular expression. The following seems to work for me: # replace line breaks with HTML

My sql database and faster queries

2001-06-06 Thread VVM Ravikumar Sarma Chengalvala
Hi, I wonder to know which of the following is better in performance and faster . Using table joins for queries. OR Multiple queries without joins using MySql C API Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk

Re: convert an ms access database file

2001-06-06 Thread Ansgar Becker
Have a look at MySQL-Front: http://www.mysqlfront.de/ it will do extactly what you want. Please be careful: the ODBC/Access-Importing has beta-quality. Ansgar -Ursprüngliche Nachricht- Von: Terrell Johnson [EMAIL PROTECTED] An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Gesendet:

Connecting from Sever to Server

2001-06-06 Thread Markwalder Philip
Hi I wanted to do some sort of database connection. In the way that I can handle db's from multiple server as I'm doing from one. Let's give you an example DB1 on host asterix DB2 on host obelix DB3 on host miraculix Wenn I connect to db1 on asterix by mysql I want to make

Re: convert an ms access database file

2001-06-06 Thread Gerald Jensen
We haven't had a chance to test it yet, but the documentation for MySQL-Front (http://www.anse.de/mysqlfront/download.php) mentions a new feature which permits import of Access databases. MySQL-Front is a beta / free product at this point ... which we have foudn to very stable and very useful!

Re: bug!

2001-06-06 Thread Miguel Angel Solórzano
At 14:37 06/06/2001 +0200, ran wrote: Hi, When you have an issue involving: client_application MyODBC MySQL The best thing to do is to test the MyODBC and MySQL isolating the client application. For example in your case of describe table_name, I create a small table with the following

Re: Make: Doesn't exist?

2001-06-06 Thread Heather Wagamon
I had the same problem with make trying to install mysql last night. It said there was no target. I was already frustrated and gave up. make works on all of my other installs, though. - Original Message - From: Gilfether, Ryan [EMAIL PROTECTED] To: 'Richard Kimberley' [EMAIL

RE: Importing spreadsheet data into MySQL

2001-06-06 Thread Simon Green
Save as .csv file and then use http://www.mysql.com/doc/L/O/LOAD_DATA.html Hope this helps Simon -Original Message- From: Chris L. Gray [mailto:[EMAIL PROTECTED]] Sent: 06 June 2001 14:15 To: [EMAIL PROTECTED] Subject: Importing spreadsheet data into MySQL Is it possible to import

Re: MySQL Port numbe r

2001-06-06 Thread Neil Zanella
telnet your.mysql.server 3306 On Tue, 5 Jun 2001, sanborn wrote: How is MySQL used over a network? I assume there is a port involved, and some kind of transaction server built into mysql? How do I configure, test this? In the several documents I have read so far, I haven't found much on

Re: Importing spreadsheet data into MySQL

2001-06-06 Thread Chris L. Gray
Thanks for the response... let's say that I save the CSV as list.csv in my computer as C:/programs/list.csv. What would the full syntax be? I have tried some variations and they do not work. Also, and this may be the king of newbie questions, will MySQL create tables based on my information or do

FW: MySQL 3.23.38 on HP UX 10.20

2001-06-06 Thread Tomasz Szymczyk
mysql, sql, database I'm trying to post you directly, because of stupid filter on mysql-list which avoid belowed e-mail from posting to list could you help us or redirect it to correct person ? thanks, TOMASZ -Original Message- From: Tomasz Szymczyk

RE: Importing spreadsheet data into MySQL

2001-06-06 Thread Roger Karnouk
You will have to create the table first make sure you have the same number of fields in your table as in your file Otherwise specify the column names in brackets at the end of the LOAD DATA statement then LOAD DATA INFILE 'list.csv' INTO TABLE yourtable FIELDS TERMINATED BY ',' OPTIONALLY

RE: Need help on mysql/php

2001-06-06 Thread Paul DuBois
At 7:49 AM -0700 6/6/01, Ed Peddycoart wrote: It is a shared server Ed Then you're vulnerable, unless the ISP can demonstrate otherwise. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 6:02 PM To: Jorge Oliveira; Ed Peddycoart Cc:

RE: Importing spreadsheet data into MySQL

2001-06-06 Thread Crercio Osmaildo da Silva
Hi, Yes, you can DBTools for Windows (http://dbtools.vila.bol.com.br) that imports from MsAccess, Clipper, Dbase, FoxPro, Paradox, MSExcel and ODBC databases. []'s Crercio O. Silva -Original Message- From: Chris L. Gray [mailto:[EMAIL PROTECTED]] Sent: quarta-feira, 6 de junho de 2001

SELECT DISTINCT

2001-06-06 Thread procadas
Hi. I need to do a search like this SELECT DISTINCT namep,namef FROM printers,fax WHERE namep LIKE 'Xerox%' AND nomef LIKE 'Xerox%'; I had in the database data like Xerox N-2125 or Xerox N17. I think I must use a subselect or something like because i get duplicate results. Any help will be

Re: Importing spreadsheet data into MySQL

2001-06-06 Thread Artem Koutchine
There is a module for Perl which can read Excel. Then there is DBI for accessing MySQL. Use both to transfer data. If under Windows, you coudl also use ODBC and some ActiveX control under Visual Basic for quick and dirty transfer scripting. - Original Message - From: Chris L. Gray

MySQL tool

2001-06-06 Thread Muhammad Asif
Is there any tool available for managing graphically databases,tables as well as user and their rights for MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual)

LOAD DATA INFILE Question

2001-06-06 Thread Chris L. Gray
Ok, the company I work for does not host its own websites, etc.. we pay a company for space on their servers. They use Unix boxes and the database they support is MySQL with a PHPMyAdmin GUI. Here is my dillema.. I need to move some of our existing Microsoft (Excel and Access) databases to

Re: CGI/Perl and MySQL (OT?)

2001-06-06 Thread Colin Faber
A better solution would be to use the DBI quote() function, see the DBI perldoc for more information. and FYI 99% of web clients pass CRLF not just LF so you'd need \r\n Chris Thompson wrote: Trying to get text from a CGI textarea box to go into MySQL with the br line breaks instead on

Error in Logs

2001-06-06 Thread Mike Jimenez
Once I upgrade to RPM version how do I import my current user information and passwords without corrupting the new install? I already tried this once bye copying my old Data dir in the new Data dir. I used the same passwords for the root user but it did not seem to like that very much and Denied

What is the for in ' safe_mysqld --log '

2001-06-06 Thread mysql list
I lost track of the tutorial where I saw the command safe_mysqld --log What is the for? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

Re: Need Japanese character set files

2001-06-06 Thread Timothy Smith
On 2001 Jun 06, Anatole [EMAIL PROTECTED] wrote: I brought down mysqld and restarted as before with safe_mysqld --default-character-set=sjis and get the following error message when php tries to connect: Can't initialize character set 13 (path: default) in

Re: Importing spreadsheet data into MySQL

2001-06-06 Thread Duncan Hill
On Wed, 6 Jun 2001, Chris L. Gray wrote: Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. One way: Save as CSV file. Parse CSV file

does show create table work?

2001-06-06 Thread Rob Agar
hi! Does SHOW CREATE TABLE x actually work? When I try it I just get error 1064 (you have an error in your sql syntax near 'CREATE TABLE x') (version 3.22.32 on linux) ta, Rob Agar - Before posting, please check:

Compiling in 64-bit Solaris environment

2001-06-06 Thread McCaffity, Ray
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [Compiling in 64-bit Solaris environment] Description: checking return type of sprintf... configure: error: can not run test program while cross compiling How-To-Repeat: Compile any version of mysql using any version of gcc on

Chroot problems

2001-06-06 Thread dariofg
Hello, I'm trying to run mysql in a chroot jail, but the server errors out. I've modified safe_mysqld so it would call MySQL with the following command: nice --5 nohup /usr/local/mysql/libexec/mysqld -- basedir=/ --datadir=/var --user=mysql --pid- file=/var/hayek.pid --skip-locking --

Re[2]: Importing spreadsheet data into MySQL

2001-06-06 Thread dpatnaude
It is actually a little tricky. You need to build the table in mysql yourself, then use some utility to import it. I would use perl. The problem with Excel is that when it exports csv, it does not quote empty fields (I think), So, you can't use Text::ParseWords (AFAIK). Here is a regexp which

mysqlbug

2001-06-06 Thread Simon Lambert
I am trying to install MYSQL 3.23.38 on an SGI machine running IRIX 6.5 I can gunzip the tar.gz file and tar it aswell, however then when I run the scripts/mysql_install_db it fails saying ' ./bin/mysqld: Program not supported by architecture Installation of grant tables failed! I therefore

RE: SELECT DISTINCT

2001-06-06 Thread Roger Karnouk
There are no duplicates in your results Distinct is on the whole record not on the individual Items for example: | Xerox N-2125 | Xerox DC255 | is not the same as | Xerox N40| Xerox DC255 | because the first field is different and | Xerox N-2125 | Xerox DC255 | is not the same as |

Re: MySQL tool

2001-06-06 Thread Brian Warn
I've had good success with DB Tools: http://dbtools.vila.bol.com.br - Original Message - From: Muhammad Asif [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 8:11 AM Subject: MySQL tool Is there any tool available for managing graphically databases,tables as

RE: My sql database and faster queries

2001-06-06 Thread VVM Ravikumar Sarma Chengalvala
Hi, THe maximum number of table joins I ned is not more than three.Most of the search criteria is based on Unique or Primary keys and hence I did not opt for indexing.I am using the default myISAM table types of mysql and mysql C_API. Previously someone suggested using C_API functions over joins

Re: MySQL tool

2001-06-06 Thread Jay Brushett
MySqlfront (www.mysqlfront.de) Jay At 08:11 PM 6/6/2001 +0500, you wrote: Is there any tool available for managing graphically databases,tables as well as user and their rights for MySQL - Before posting, please

RE: Inserting 307,284 lines. Is this ok?

2001-06-06 Thread Kenneth Kopelson
If I'm not mistaken, MySQL can handle millions or even billions of rows, and there is no real limit to the number that reside in a single table. So Mike Mike relax, you are using a serious database here, not a little toy :) -Ken At 01:20 PM 6/5/01 -0500, Johnny Withers wrote: At boot time

Telnet to MySQL (Was port number)

2001-06-06 Thread sanborn
Thanks for your many answers. (mysql port default = 3306) . I can't seem to telnet to port 3306 however, I get a message saying '... not allowed to connect to this mysql server'. I am telneting from a windows machine if this makes a difference. Gene Sanborn

Re: events that i can trigger on intervals.

2001-06-06 Thread Kenneth Kopelson
Sure, that is easy. Just add a column to your room assignment table called something like RELEASE_TIME, and put into that column the time you want the room to be released. Then, whenever you want to release rooms, execute something like DELETE FROM ROOM_ASSIGN WHERE RELEASE_TIME NOW() or

RE: MYSQL++: List of databases, then tables in each database

2001-06-06 Thread David Ayliffe
Using the MySQL++ library is their any call to 1) Get a list of the databases on the Server 2) List tables in a database given a database name. The best I could find was show databases show tables; or show tables from database name; Does anyone have any examples of how to implement these

Getting more than 256 connections with MySQL/Linux

2001-06-06 Thread Alex Coke-Smyth
Hi, I am receiving errors when setting max_connections=300 basically anything over 256 ends up giving the error : Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug after 256 connections are open. There

Rookie admin needs install help

2001-06-06 Thread Patrick Malone
This is probably a silly question, but I'm a new administrator and could use some help. I'm running a Slackware Linux 2.2.16 and am having difficulty installing MySQL 3.23.38. I have downloaded the following rpm files from www.mysql.com: MySQL-3.23.38-1.i386.rpm

Re: MAC OS X Server

2001-06-06 Thread Kenneth Kopelson
Apple has tested MySQL on MAC OS X to the best of my knowledge. Given that MAC OS X is essentially FreeBSD Unix with a pretty wrapping, it makes sense that MySQL would work easily. If someone said MySQL worked on MAC OS 9, or older, I would be more cautious. At 02:42 PM 6/5/01 -0800, Angela

Re: What's the best os?

2001-06-06 Thread Matthew Reimer
Jeremy Zawodny wrote: On Fri, Jun 01, 2001 at 12:28:17PM +0400, Ilya Martynov wrote: JZ On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote: JZ Assuming you'll use Apache 2.x one day, I'd lean away from FreeBSD JZ until the threading issues are resolved. I could envision

RE: Need help on mysql/php

2001-06-06 Thread Kenneth Kopelson
Actually you are only exposed if you have not set up Apache to run with virtual hosts. It is not difficult to configure Apache so that a person can only see the scripts that are in his/her directory, and is prevented from seeing or modifying the scripts in other peoples directories. Also,

Compiling an PHP 4.0 module with MySQL

2001-06-06 Thread Keith Attfield
I need some help upgrading to PHP 4.0 (version 4.0.5) on my Linux web server running Apache containing a PHP module configured with MySQL. I am trying to install PHP from the source tar downloaded from www.php.net. I am following the installation instructions that say that I can get away

Re: MySQL Port number

2001-06-06 Thread Kenneth Kopelson
I would suggest you obtain a book on the subject, or visit mysql.com and read the documents under documentation. You are asking questions that have very large answers. To get you started, MySQL is accessed over the web by using a scripting language like PHP or Perl. -Ken At 07:35 PM 6/5/01

Re: which the best

2001-06-06 Thread Kenneth Kopelson
Hands down, your best bet is either Linux versions. You will get the best stability, speed, and cost effectiveness by using these databases. Stay away from Windows for this kind of thing. I have developed software for the Windows platform since it first came out, and have been a software

How to upgrade from source version to RPM version

2001-06-06 Thread Mike Jimenez
I'm rather new to Mysql. Here is the deal. I'm currently running mysql-3.23.33 from mysql-3.23.33.tar.gz. Now after reading through documentation. I now know that I should have used the RPM Version because I'm running Redhat Linux 6.2. So I then downloaded the new version MySQL-3.23.38-1.i386.rpm

Re: MySQL with perl

2001-06-06 Thread Kenneth Kopelson
You need to have your script operate in different modes. You do this by passing an argument when you call your script to tell the script what it is supposed to do. So in this case, if the script is called with out any arguments, it will display the form, as follows:

Re: What is the for in ' safe_mysqld --log '

2001-06-06 Thread Andrew Schmidt
that's a unix shell command that basicly puts the process in the background. if you type that command at your console you'll notice you get a prompt right away. This allows safe_mysqld to run in the background (somewhat like a daemon) thanks, -- Andrew - Original Message - From:

Re: does show create table work?

2001-06-06 Thread Andrew Schmidt
I believe show ceate table was added in mysql 3.23 and subsequently 3.22 will not have it. thanks, -- Andrew - Original Message - From: Rob Agar [EMAIL PROTECTED] To: Mailinglist MySQL COM [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 11:48 AM Subject: does show create table work?

Re: MySQL with perl

2001-06-06 Thread Kenneth Kopelson
Cindy, read my reply to this. You are mistaken. There is actually a way to make a single script do all kinds of different operations. I have single scripts that show a list of records, add a new record, update a record, and delete a record, all in the same script. This is more efficient

Re: Log file size

2001-06-06 Thread Kenneth Kopelson
Look into the Linux logrotate daemon. It allows you to configure what happens with logs. At 06:44 AM 6/6/01 -0400, Peter Billson wrote: I'm running mySQL on Linux and was wondering is there a way to limit the maximum log file size? From time to time I have written a bad script that will

Browser Based Mailing List

2001-06-06 Thread Mazur
This has to have been asked before, but I can't find it in the database archives... Is there a web browser based version of this mailing list anywhere? Thanks, Rob - Before posting, please check:

RE: Recommended ISP (query,mysql)

2001-06-06 Thread Jorge Oliveira
Hi David, I recommend you AletiaHosting.com as they provide full service at a lower cost... If you wnat a cheaper service you may try Whizhost.com but they are known to have some problems here and there. I have two sites: webfroggie.com and desportoradical.com. The first at whizhost and the

Re: Recommended ISP

2001-06-06 Thread David Stubbings
Hi, Check out PHP4Hosting at : http://www.php4hosting.com They give what you want for about $10 including root access to Mysql. Regards, David Stubbings - Before posting, please check: http://www.mysql.com/manual.php

Fw: Rookie admin needs install help

2001-06-06 Thread Patrick Malone
Well today just isn't my day. My mail forwarding was broken till just now. If you responded to this question earlier, could you please send the response to [EMAIL PROTECTED] again? Thank you, patrick - Original Message - From: Patrick Malone [EMAIL PROTECTED] To: [EMAIL PROTECTED]

Re: does show create table work?

2001-06-06 Thread j.urban
I believe SHOW CREATE TABLE was added in 3.23.20... http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html http://www.mysql.com/doc/N/e/News-3.23.20.html On Wed, 6 Jun 2001, Rob Agar wrote: hi! Does SHOW CREATE TABLE x actually work? When I try it I just get error 1064 (you have an error

Re: Importing spreadsheet data into MySQL

2001-06-06 Thread Johannes Pretorius
Hi there Yes you can do this by going into Access and op[ening the XLS file from there then importing it into a table. This meaning you have a database from where you can move it over to mySQL's table via ODBC connection or how you like moving it from DB to DB. I hope this helps

  1   2   >