Re: Access denied on use mysql;

2002-03-21 Thread Colin Faber
alan, Given the large amount of postings you've made to this list, I suggest that you may be bettered helped via live chat. You can do so by using the mysqldeveloper.com Live Chat system: http://www.mysqldeveloper.com/chat/ which connects you to the #mysql support channel on the EFnet IRC

file not found error when trying to import CSV to database table

2002-03-21 Thread Timothy J. Luoma
Hello, I am painfully new to mySQL (I'm working on my first database), so my apologies if I ask something stupid. I am using phpMyAdmin 2.2.0 to connect to MySQL 3.23.36 I have a database named aro with a table specialdays I have a CSV that I want to import to the 'specialdays' I went

Web interface and backup

2002-03-21 Thread Kory Wheatley
I have two questions. (If you would be so kind to respond I would appreciate it) 1. What is the best way, or correct way to backup the MYSQL databases. I thought shutting the server then perform the backup, so that there are no connections to the databases? 2. What's the best command graphic

Extra return in last field in LOAD DATA INFILE?

2002-03-21 Thread Nick Arnett
I have something odd happening with a bulk insert file and haven't been able to find anything in docs or archives that gives me a clue what's going on. I'm creating a bulk insert file programmatically with Python. Everything seems to work fine, except that in the last field of each record, a

installing mod_auth_mysql , please help.

2002-03-21 Thread jun qin
I need to install mod_auth_mysql now, but got error , wondering if you could help me out. after i install mod_auth_mysql, then i try to config the apache. ./configure --prefix=/usr/local/etc/httpd --sysconfdir=/www/conf \ --activate-module=src/modules/php4/libphp4.a --enabl e-module=status \

installing mod_auth_mysql , please help.

2002-03-21 Thread jun qin
I need to install mod_auth_mysql now, but got error , wondering if you could help me out. after i install mod_auth_mysql, then i try to config the apache. ./configure --prefix=/usr/local/etc/httpd --sysconfdir=/www/conf \ --activate-module=src/modules/php4/libphp4.a --enabl e-module=status \

RE: Web interface and backup

2002-03-21 Thread Matthew Walker
As to your second question, I'd /highly/ recommend http://phpwizard.net/projects/phpMyAdmin/. I use it to manage all the databases where I work, and have had very few problems with it. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Kory Wheatley

Re: still no umlauts in mysql --experts help needed

2002-03-21 Thread sascha mantscheff
Egor: Thanks for the hint. I browsed the manual for readline(3) and for /etc/inputrc, but found nothing wrong with it. I can enter umlauts in all other programs and from the bash command-line - only in mysql they don't work. Where else might I look for the source of the problem? s.m. Am

RE: Extra return in last field in LOAD DATA INFILE?

2002-03-21 Thread Roger Baklund
* Nick Arnett I have something odd happening with a bulk insert file and haven't been able to find anything in docs or archives that gives me a clue what's going on. I'm creating a bulk insert file programmatically with Python. Everything seems to work fine, except that in the last field of

Backtrace for (Re: 4.0.x memory bug on FreeBSD...?)

2002-03-21 Thread Michael Widenius
Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Tue, Mar 19, 2002 at 04:02:46PM -0800, Jeremy Zawodny wrote: Jeremy [snip] Here's the relevant entry from the error log, repeated over and over: 020319 15:57:33 /home/mysql-4-bk/libexec/mysqld: Out of memory at line 100,

Problem with current user set as ODBC@localhost i think

2002-03-21 Thread kuma
Hi , im fairly up to speed with Mysql as i currently program in Postgresql on my linux box and Ms Access on my Win 98 box. Nevertheless i am currently working with Mysql and i have downloaded gone thru examples and read the doc's. I have somehow made a mistake regarding MySql administration.

RE: Extra return in last field in LOAD DATA INFILE?

2002-03-21 Thread Nick Arnett
-Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 4:03 PM [snip] It looks like you have the CRLF problem... Python on win platform outputs CRLF for '\n', because that is normally the wanted line ending on windows systems... open

Re: Extra return in last field in LOAD DATA INFILE?

2002-03-21 Thread Paul DuBois
At 15:21 -0800 3/21/02, Nick Arnett wrote: I have something odd happening with a bulk insert file and haven't been able to find anything in docs or archives that gives me a clue what's going on. I'm creating a bulk insert file programmatically with Python. Everything seems to work fine, except

Re: Can you Change Nulls in the MySQLDump from \N?

2002-03-21 Thread Paul DuBois
At 12:11 -0800 3/21/02, David M. Peak wrote: Is there a way to tell MySQL to put a blank space instead of \N in the tab-delimited files when it does a dump? Nope. You'll have to postprocess the files somehow. I'm working on a MySQL to SQL Server migration and having problems with the output

Re: Backtrace for (Re: 4.0.x memory bug on FreeBSD...?)

2002-03-21 Thread Jeremy Zawodny
On Fri, Mar 22, 2002 at 01:26:42AM +0200, Michael Widenius wrote: Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Tue, Mar 19, 2002 at 04:02:46PM -0800, Jeremy Zawodny wrote: Jeremy [snip] Here's the relevant entry from the error log, repeated over and over:

Re: Task manager

2002-03-21 Thread Arjen Lentz
Hi, On Thu, 2002-03-21 at 16:58, [EMAIL PROTECTED] wrote: I am using the MySQL server version 3.23.44 running on Windows 98 machine, I just found out that as you view the task manage...mysqld is not alone...I mean, about 6 of them...I am confuse whos running...so, all I want to know is...is

Re: Can you Change Nulls in the MySQLDump from \N?

2002-03-21 Thread sascha mantscheff
can't you filter the output with sed? s.m. Am Donnerstag, 21. März 2002 21:11 schrieben Sie: Is there a way to tell MySQL to put a blank space instead of \N in the tab-delimited files when it does a dump? I'm working on a MySQL to SQL Server migration and having problems with the output

mysql 3.23.26 + freebsd 4.4 stable cpu pinned

2002-03-21 Thread Lance Uyehara
Does anyone have any documentation about a problem where the cpu gets pinned in the high 90% after running for a while. While it was in this state I tried mysqladmin processlist and saw 7 threads all in sleep (persistent dbi connection). There was minimal load on this as people weren't really

RE: exanging vars between form/php/javascript

2002-03-21 Thread Doug Thompson
I think these articles might help you solve your problem. They don't address javascript, but do show how to get information to and from mysql using php and forms. http://www.webmasterbase.com/article/627 http://phpbuilder.com/columns/laflamme20001016.php3 Regards, Doug On Thu, 21 Mar 2002

Re: Access denied on use mysql;

2002-03-21 Thread alan4100
mysql Hi Colin, I wish I can be able to live chat with you, but because of my hearing impaired...it would not be possible..But what is the real problem? A few days ago I got assistance from others on my Mysql problem. It has been fixed and everything works fine. But I am still having

Re: Rotation of binary logs on replication master?

2002-03-21 Thread James Housley
Guy Davis wrote: Just wondering if any Linux users of MySQL out there had written a logrotate configuration file for dealing with MySQL binary logs on a replication Master. I want to rotate these logs (6.5 GB now) as some are over a month old. However, I don't want to confuse any of the

Compiling DLL on windows: undefined reference errors during linking?

2002-03-21 Thread Peter Campbell
I am trying to compile a file on windows and build a DLL, this has worked before using MSVC5.0 but now I'm using cygwin/mingw environment. Does anyone know the problem/solution? I have also tried building with mysqlclient.lib but get different error messages. I have checked various

mySQL compilation error on SPARC Solaris 8

2002-03-21 Thread bobey
*This message was transferred with a trial version of CommuniGate(tm) Pro* Hello, Tried compiling mySQL on a Soloris 8 SPARC machine but get the following make error: c++ -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -mcpu= v8 -Wa,-xarch=v8plusa

mySQL Compilation error SPARC Sol 8

2002-03-21 Thread trader
*This message was transferred with a trial version of CommuniGate(tm) Pro* Sorry if this post appears more than once... having some probs ;)! - Hello, Tried compiling mySQL on a Soloris 8 SPARC machine but get the following make error: c++ -O3 -DDBUG_OFF -O3

GRANT

2002-03-21 Thread Loretta
Hi. I am the only user of MySQL in a Win98 environment. I am developing an ASP front end to access the database to add, update and delete records in the database for a Church. I am having problems with the connection to the database. I am able to connect to the database and print out the

Re: GRANT

2002-03-21 Thread Bruce A. Flinn
Loretta wrote: Hi. I am the only user of MySQL in a Win98 environment. I am developing an ASP front end to access the database to add, update and delete records in the database for a Church. I am having problems with the connection to the database. I am able to connect to the database

What is the minimum memory used per connection?

2002-03-21 Thread BD
I'm planning to use MySQL on a PHP webserver and I like to know how the minimum memory required for each web connection. Is there any way to estimate this? Or test for this on my development machine? TIA Brent _ Do You Yahoo!? Get

RE: GRANT

2002-03-21 Thread Steven Gearhart
If I understand correctly, you can achieve your goal in either of 2 ways. The first, is to copy sql.exe to one of your path directories (i.e. Windows or Windows\System) or include MySQL\bin in your DOS path statement. This will allow you to run mysql from a DOS prompt. The second method is to

Complex query

2002-03-21 Thread Bill Easton
The following will do the trick: select * from book_hold group by tcc_cn having updated=min(updated) and max(status='NOTIFIED')=0; We use the fact that (status='NOTIFIED') will be 0 when false and 1 when true, so this gives a way to select rows for which another row with the same

load data local - strange message. ERROR 1148

2002-03-21 Thread Art Loder
Hey- I ran into the same problem you did. After some searching on the web, this is what I came up with: First save the text file in the directory corresponding to the database you are currently using (menagerie). So the file will be be c:\mysql\data\menagerie\pet.txt I then typed: mysql

Where can I get max backlog?

2002-03-21 Thread
I've set backlog of mysql to 100. And now I need to increase it. But I don't know how many backlog my OS can support. Where can I get that information and how can improve it. Although I use Red Hat 7.2, other OS's informations are also Okay. Any replys would be welcome.

Re: unable to start mysql daemon

2002-03-21 Thread Arjen Lentz
Hi, (please reply to the mailing list, no to me directly.) On Thu, 2002-03-21 at 19:17, Leecher wrote: Thanks, Yes, I logged in as Administrator. Just a question, why would running it as a service do any good, if I can't even manually start the daemon? The daemon insists that all ports

group by timestamp field

2002-03-21 Thread cristian ditoiu
I have MySql database containing a table mad by several fields among wich : Field1 (varchar) , Field 2 (timestamp) . I want to do : select count(*) , field1 , group by field1 . That's ok , but i'd like to get results like : 2002-01-01 3 2002-01-02 4 . How can i do that considering the

MySQL, MyODBC and MS Access

2002-03-21 Thread Mark Stringham
I have a project where I may need to connect an MS ACCESS db and MySQL. I have read some pretty good documentation and know that is possible to take an existing Access db and export it to MYSQL. I have a few questions and wondered if someone might offer some insight. 1. Where must the Access db

<    1   2