Re: runnning my sql with windows98 and pws

2001-06-26 Thread Seung-woo Nam
emory on your system. If you want to run pws and MySQL on Win 98, I would recommend at least 128MB of RAM. Using ASP can be done through MyODBC. Seung-woo Nam - Before posting, please check: http://www.mysql.com/

Re: mysqldump on large database..

2001-06-14 Thread Seung-woo Nam
Wow! What kind of database would have 10,000 tables? Wouldn't you think the database design had a serious flaw in the first place? Seung-woo Nam SDiZ Cheng wrote: >When i use mysqldump, >seems that MySQL will open all the tables in the database. >But, what i have is: a data

Re: Procedures

2001-06-11 Thread Seung-woo Nam
Hi: There is a perl module for MySQL you can download from cpan. It provides the interface to MySQL database you can use to connect, execute SQL statements from perl programs. Seung-woo Nam John Tsangaris wrote: > > >From the docs, it doesn't look like too much has been done

Re: Query Copying to Temp Table

2001-04-24 Thread Seung-woo Nam
ce on a separate hard drive. Seung-woo Nam Scott wrote: > > >That ORDER by a calculated_field DESC is killing you. > >It needs to go to a temporary table for sorting. > > The problem, though, is that even if I leave the ORDER clause out, or > ORDER BY any other fiel

Re: RPM dependency on MySQL-DBI-perl-bin

2001-04-24 Thread Seung-woo Nam
MySQL-DBI-perl-bin' is somewhat misleading because DBI is not tied to any specific databse. DBI module provides general API for databse handling and for MySQL, you also need DBD-MySQL module. Anyway, unless you have a real need of benchmarking MySQL, why bother installing it? Seung-woo Nam Jaso

Re: Population a database

2001-04-20 Thread Seung-woo Nam
t the tables into a separate database, though. Seung-woo Nam Luis wrote: > > Hello all > > I have a simple question. I have a database in (ms) accesss that I would like to >transport into mysql database. > > First of all ,do i have to create the database plus tables. then

Re: starting MySql on redhat 7

2001-04-16 Thread Seung-woo Nam
bobit wrote: > > Hi - here's my prob and background info. Tried the fix - it didn't work. > > MySQL Connection Failed: Can't connect to local MySQL server through socket >'/var/lib/mysql/mysql.sock' (111) > > Any thoughts...? > Is MySQL actually running on your system? Even if you installed

Re: to upper case function

2001-03-27 Thread Seung-woo Nam
You can use either ucase() or upper() functions. ucase(str) or upper(str) Seung-woo Nam Zhu George-CZZ010 wrote: > There's a function in SQL to convert strings to upper case (sounds like to_upper()? >), I don't have the reference book at hand, does anyone know the syntax or

Re: howto: telnet shell

2001-03-22 Thread Seung-woo Nam
Why not just telnet into the server where mysql is running and log into mysql from there? That way, there is no need to install mysql client. It look like he already has a telnet client on the computer... Seung-woo Nam [EMAIL PROTECTED] wrote: > as someone else has mentioned, you would n

Re: reinstall mysql

2001-03-08 Thread Seung-woo Nam
Hi Have tried to start it manually instead of reinstalling it? Seung-woo Nam Rashid Zolqarnain wrote: > Hello, > I installed MySql serevr version 3.23.33 on Red Hat Linux 7.0. > Sometimes when I reboot the system, MySql do not work. I have to > uninstall and then reins

Re: Junk e-mails

2001-03-05 Thread Seung-woo Nam
Well, this is a public, international mailing list. I wouldn't be surprised if there were more. Seung-woo Nam Quentin Bennett wrote: > How come the list is receiving some today? (Raid de Himalaya, Summer of > 2001, African American History Minute). > > Normally we don't g

Re: A newbie question

2001-03-03 Thread Seung-woo Nam
atabase created by mysql by default when you install it so that you can test creating tables and running quieries on it. Seung-woo Nam anil kumar wrote: > hello All, > I am new to mysql database. I downloaded mysql and running on my > system. > For adminiatrative purpose the comm

Re: How to change the lib path ...

2001-03-02 Thread Seung-woo Nam
Hi The config file you are looking for is /etc/my.cnf, I believe. The paths for all mysql related files and dirs are there. Seung-woo Nam "Didier Desmet (RSCA)" wrote: > Hi guys, > > I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256 >

Re: Redhat 7 newbie.....

2001-02-25 Thread Seung-woo Nam
Hi: Make sure MySQL is started when your system boots up. Run 'setup' as root and go to 'System Services' and make sure mysqld is checked. If you want to start the daemon without restarting run '/etc/init.d/mysqld start' as root. Seung-woo Nam Thomas O'Neil