MySQL Views

2002-09-19 Thread Art Fore
Since MySQL does not have views or queries that can be within the database, is there a way to make tables which are subtables of the main table? For example, I have an ID that goes from 0010-10010 to 7000-. I want a table that will show only those items with LIKE '0080-%'. This table should be

RE: MySQL vs. Oracle (not speed)

2002-08-15 Thread Art Fore
A few things I can say from experience, Oracle support is quite expensive as is their software and it is as much bloatware at M$ if not more. Art -Original Message- From: Elizabeth Bogner [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 7:25 PM To: [EMAIL PROTECTED] Subject: M

RE: email marketing software

2002-08-15 Thread Art Fore
There is an ODBC driver for MySQL for both Windows and Linux. Art -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 6:02 PM To: [EMAIL PROTECTED] Subject: email marketing software My bad about the subject line . MS - Original Me

RE: Setting root password in mysql for windows

2002-08-15 Thread Art Fore
Still could not get it to work so I uninstealled and reinstalled. Will use the anonymous login etc util I figure out this security system. Is there a document that explains the password system in laymans terms? Art -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]

Setting root password in mysql for windows

2002-08-14 Thread Art Fore
Having a hard time coming to grips with the password setup for mysql in windows. I follow the instructions below from the documentation. C:\> C:\mysql\bin\mysql mysql mysql> DELETE FROM user WHERE Host='localhost' AND User=''; mysql> QUIT C:\> C:\mysql\bin\mysqladmin reload C:\> C:\mysql\bin\mysq

Import Oracle tables into mysql

2002-03-31 Thread Art Fore
Does anyone know how or where there is a howto to import tables from an Oracle Database into Mysql and then to keep the Mysql syncronized with the Oracle database? Art - Before posting, please check: http://www.mysql.com/ma

RE: mysql.sock

2002-03-18 Thread Art Fore
I done the chown, now using MySQL Navigator, I get Access denied for user: afore@localhost (using passowrd: YES). I get the same for user mysql and root using both my password and root password. mysql is a group as shown in Yast2 login manager also. Permissions now shows drwxr-xr-x mysqlmy

RE: mysql.sock

2002-03-17 Thread Art Fore
rectory? And what are the permissions? Do an 'ls -la /var/lib/' You should have something like: 'drwxrwxr-x 25 mysqlroot 3072 Mar 16 23:00 mysql' or even 'drwxrwxr-x 25 rootmysql 3072 Mar 16 23:00 mysql' -Original Message- From: Art Fore [m

RE: mysql.sock

2002-03-17 Thread Art Fore
is. If you can't find it do a find / -name "mysql.sock" Hope that helps, ~mark. http://www.workzoo.com/ Art Fore wrote: > When I try to run the mysqld or safe_mysql, I get "connot connect to local > MySQL server through socket '/var/lib/mysql/mysql.sock'

mysql.sock

2002-03-17 Thread Art Fore
When I try to run the mysqld or safe_mysql, I get "connot connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'. Check that mysql is running and that the socket : '/var/lib/mysql/mysql.sock' exists! This file does not exist. Where does it come from or how do you create i