Re: MySQL on NFS?

2001-07-01 Thread Jeremy Zawodny
On Sun, Jul 01, 2001 at 08:25:01PM -0700, Kelsey Cummings wrote: > > > > > > I wondered about that too. I managed to find the list archives > > > so I answered my own questions. > > > > Great. I was just about to answer you. :-) > > Well, just to be clear then, lots of people are using NetApp

Re: Replication

2001-07-01 Thread Jeremy Zawodny
On Sat, Jun 30, 2001 at 03:40:53PM -0400, Jason Brunk wrote: > > i was wondering if anyone could help out with some replication > stuff. i went through the instructions from mysql.com and when i > restarted the slave, it said that it was not configured correctly. We're gonna need more details th

MySQL error code list

2001-07-01 Thread Lee, John
Hi all, I am a newbie in MySQL and would like to know if there is a list of error codes for accessing MySQL database. What I am asking is something like "What is the return error code for record (or row) not found?" or "What is the return error code if table doesn't exist, etc?" Thanks in advanc

MySQL Problem

2001-07-01 Thread Anoop K Gupta
Hi Everybody, 1. I am unable to login on my remote Mysql Server installed on Linux.. Perhaps I forgot the password or something else.. How can I solve this problem. 2. My Second problem earlier I use to login successful and when trying to create or use database it gives authontication prob

Does mysqlgui depend on DNS?

2001-07-01 Thread John Griffin-Wiesner
I am trying to connect to my database with mysqlgui as root. I have gone into "options" and entered the port number and the path to the socket. I have "ask for password" checked on and am using the same password that works when I do "mysql -u root -p". I have tried accessing the mysql db and a

Re: MySQL on NFS?

2001-07-01 Thread Kelsey Cummings
On Sun, Jul 01, 2001 at 08:21:39PM -0700, Jeremy Zawodny wrote: > On Sun, Jul 01, 2001 at 08:12:37PM -0700, Kelsey Cummings wrote: > > On Sun, Jul 01, 2001 at 08:04:41PM -0700, Jeremy Zawodny wrote: > > > On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote: > > > > Hi, everybody here,

Re: MySQL on NFS?

2001-07-01 Thread Jeremy Zawodny
On Sun, Jul 01, 2001 at 08:12:37PM -0700, Kelsey Cummings wrote: > On Sun, Jul 01, 2001 at 08:04:41PM -0700, Jeremy Zawodny wrote: > > On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote: > > > Hi, everybody here, > > > > > > Anybody can help with telnet to Linux and login to mySQL,

Re: MySQL on NFS?

2001-07-01 Thread Kelsey Cummings
On Sun, Jul 01, 2001 at 08:04:41PM -0700, Jeremy Zawodny wrote: > On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote: > > Hi, everybody here, > > > > Anybody can help with telnet to Linux and login to mySQL, show > > information about current mysql setting, create new DB, and table?

Re: MySQL on NFS?

2001-07-01 Thread Jeremy Zawodny
On Fri, Jun 29, 2001 at 03:33:16PM -0400, Web Mailing List wrote: > Hi, everybody here, > > Anybody can help with telnet to Linux and login to mySQL, show > information about current mysql setting, create new DB, and table? What on earth does this have to do with MySQL on NFS? -- Jeremy D. Zawo

URGENT! Hard Disk Space limition and Symbolic link

2001-07-01 Thread tpchan
Hi all, I try the solution from David but seem it didn't work. Here is my steps: 1) Stop the mysql services. 2) Move the ecom database directory from '/var/lib/mysql/ecom' to '/home/ecom' 3) Make symbolic link in '/var/lib/mysql' using 'ln -sf /home/ecom ecom' 4) Start the mysql services. 5) my

updating tables

2001-07-01 Thread Radius Newbies
Hello All! I am just starting to learn mysql so forgive if i sound so beginner here. I have 2 tables, table1 and table2. At table1, i have username and consumed field_names. at table2, i have username and duration fieldname. I need to put the value of duration to consumed. How will I do that?

RE: Mysql error (Index page)

2001-07-01 Thread Mike
Take a look at http://www.devshed.com/Server_Side/PHP/PHP101_4/ there are also some other good reference material there on this. Cheers -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 01, 2001 7:54 PM To: help; [EMAIL PROTECTED] Subject: Re: Mysql er

Re: Mysql error (Index page)

2001-07-01 Thread Rolf Hopkins
- Original Message - From: "help" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 02, 2001 3:55 Subject: Mysql error (Index page) > > I am getting a few errors on the index page of > my site. I am running the page on a windwos 2000 adv > server with Mysql and PHP. I

Re: Mysql error (Index page)

2001-07-01 Thread David Robley
On Mon, 2 Jul 2001 05:25, help wrote: > I am getting a few errors on the index page of > my site. I am running the page on a windwos 2000 adv > server with Mysql and PHP. I have also installed the > ODBC module. The errors I am getting are as follows: > Warning: MySQL Connection Failed: A

Re: problems with root password - can anyone help me?

2001-07-01 Thread Rolf Hopkins
You could try skip grants and fix it that way. And yes, it's in the manual. If not, you'll probably need to run mysql_install_db again. - Original Message - From: "Mihai Marinescu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 02, 2001 3:42 Subject: problems with root pa

Re: Strange pseudo-coded query

2001-07-01 Thread Rolf Hopkins
- Original Message - From: "Thomas J Keller" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, July 02, 2001 2:49 Subject: Re: Strange pseudo-coded query > Rolf Hopkins wrote: > > This is way off topic and you should seek an MS Access help lis

RE: configure error

2001-07-01 Thread Don Read
On 01-Jul-01 Tim wrote: > I'm running mysql on a lan with out a connection so I just copied the report > here. > > When I run ./configure /usr/local/mysql it ends with the error > ./configure ends with error: checking for termcap functions library... > configure: error: No curses/termcap librar

Re: Strange pseudo-coded query

2001-07-01 Thread Bob Hall
>Rolf Hopkins wrote: > > This is way off topic and you should seek an MS Access help list. > >Excuse me. I am working in MySQL. I see no reference whatever >to MS Access >in my message. How do you >figure this is "off topic?" Sir, Rolf had no way of knowing that you didn't know that you

Re: linking columns

2001-07-01 Thread Bob Hall
>Hi everyone! > >I'm starting with mysql! >I wish to know if it is possible to make a table that has to columns linked by >a mathematic expression. For example: >My table is "my_tbl"; >And it has three colums: column_1, column_2 and column_3; >Every column have int or float values; >And for exampl

Re: Challenging SQL Problem

2001-07-01 Thread Bob Hall
>Hello, > >I am having a lot of trouble trying to find the best >way to write the SQL to do the following: > >I have a table called "referrals." In this table I >have a column called "ref." The data in the ref column > >are of the form "p/$promo_id/$date". An example would >be "p/26/20010629" whic

configure error

2001-07-01 Thread Tim
I'm running mysql on a lan with out a connection so I just copied the report here. When I run ./configure /usr/local/mysql it ends with the error ./configure ends with error: checking for termcap functions library... configure: error: No curses/termcap library found I sure it's just a library

Re: Storing Credit Cards

2001-07-01 Thread Luis
well the one that hold the credit cards. what company do you work for ? - Original Message - From: "Luis" <[EMAIL PROTECTED]> To: "Derick Dorner" <[EMAIL PROTECTED]>; "Chris Cameron" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, July 01, 2001 3:51 PM Subject: Re: Storing Credit Ca

Re: Storing Credit Cards

2001-07-01 Thread Luis
for what company do you work if you dont mind me asking? - Original Message - From: "Derick Dorner" <[EMAIL PROTECTED]> To: "Chris Cameron" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, July 01, 2001 3:23 PM Subject: Re: Storing Credit Cards > I am running a website that user

Re: Storing Credit Cards

2001-07-01 Thread Derick Dorner
I am running a website that users enter a credit card # (we have several hundred thous users and this works fine) and they are stored in the database, and their membership is renewed monthly. I keep the credit card #'s in a seperate database with strict permissions, and ALL data is encrypted using

Re: Storing Credit Cards

2001-07-01 Thread Dennis Salguero
- Original Message - From: "Chris Cameron" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, July 01, 2001 2:27 PM Subject: Storing Credit Cards > One of the ideas was to have the users password encrypted as an md5 hash, > and then to encrypt the users CC with their password. So

Storing Credit Cards

2001-07-01 Thread Chris Cameron
A client has asked us to make him an application that requires us keeping Credit Card Numbers. I'm a bit concerned as it immediately remined me of egghead.com (having all their CC #'s stolen). One of the ideas was to have the users password encrypted as an md5 hash, and then to encrypt the users

Mysql error (Index page)

2001-07-01 Thread help
I am getting a few errors on the index page of my site. I am running the page on a windwos 2000 adv server with Mysql and PHP. I have also installed the ODBC module. The errors I am getting are as follows: Warning: MySQL Connection Failed: Access denied for user: 'mark@localhost' (Using pa

problems with root password - can anyone help me?

2001-07-01 Thread Mihai Marinescu
Dear friends, I have tried to access the tables in the mysql database (the user, host tables) so as to grant some privileges to a user and I think I accidentally deleted an entry for root - the one that granted me access to mysql and now I cannot get in anymore from any machine, it says "access

Re: Strange pseudo-coded query

2001-07-01 Thread Thomas J Keller
Rolf Hopkins wrote: > This is way off topic and you should seek an MS Access help list. Excuse me. I am working in MySQL. I see no reference whatever to MS Access in my message. How do you figure this is "off topic?" > [Zip Code Distance Extractor] could refer to any number of diff thi

Re: MYSQL database on BSDI UNIX 4.0

2001-07-01 Thread A. Chater
[EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query,table > > If you just reply to this message, and includ

Error 2003: Can't connect to MySQL server on 'localhost' (10061)

2001-07-01 Thread Robb Garrioch
Hi, Does anyone know how to fix the following error? "ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)" I get this by typing "mysql" at the shell prompt (ie C:\mysql\ mysql [return]) MySQL is installed in the default C:\mysql. I'm running NT 4.0 with SP4 & the Option Pack and versi

MSSQL to MySQL

2001-07-01 Thread Lok Woei Ming
hi.. is there any tool to convert MSSQL to Mysql? regard

mysqld starting problem

2001-07-01 Thread Ivan Lulukyan
Hi, Recently I tried to move mysql databases to another location where much more space. First I copied all databases to new location Then renamed /usr/local/var to /usr/local/var_old Then make a symbolic link: ln -s /mnt/1 /usr/local/var after that I reboot the system and it doesn't work : 010630

linking columns

2001-07-01 Thread Daniel Leal
Hi everyone! I'm starting with mysql! I wish to know if it is possible to make a table that has to columns linked by a mathematic expression. For example: My table is "my_tbl"; And it has three colums: column_1, column_2 and column_3; Every column have int or float values; And for example, I want

still struggling, still here! "owner vs. root"

2001-07-01 Thread trogers
MySQL. i installed a a package install of the latest MySQL -of the unix [Mac OS X] variety. here's what i did (after the package installed installed itself): - i did this logged in as an administrator (me) AND below wherever it says mysql (as username) i entered my own username... so on the c

Re: Strange pseudo-coded query

2001-07-01 Thread Rolf Hopkins
This is way off topic and you should seek an MS Access help list. [Zip Code Distance Extractor] could refer to any number of diff things such as a column in a table, a table name, a field on a form. The "!" also has several different meanings and you should be able to find it in help files. ---

Re: mysql/php query from 2 tables

2001-07-01 Thread Rolf Hopkins
- Original Message - From: "Felicia" <[EMAIL PROTECTED]> To: "mysql post" <[EMAIL PROTECTED]> Sent: Sunday, July 01, 2001 2:06 Subject: mysql/php query from 2 tables > im having problems getting results querying two tables but I am not sure of > the correct php syntax for the query stat