Help in Administration

Hi, Sorry to bother you people but I've just locked myself out of my own DB. I was installing some stupid program which required me to do some changes in the permissions and now I get this error Access Denied for user: 'root@localhost' (Using password: NO). I've tried several ways o get out of

Re: Help in Administration

On 05 August 2001 23:42 -0700 Schajee Achmad wrote, now I get this error Access Denied for user: 'root@localhost' (Using password: NO). I've tried several ways o get out of this mess, even the documentation of MySQL but there is no mention of this error. Run up mysql with the

Re: Help in Administration

On Sun, Aug 05, 2001 at 11:42:53PM -0700, Schajee Achmad wrote: Hi, Sorry to bother you people but I've just locked myself out of my own DB. I was installing some stupid program which required me to do some changes in the permissions and now I get this error Access Denied for user:

Re: libmysqlclient[_r].so + pthreads + gdb

It is gdb-5.0, Mandrake 8 version, with patch for threaded application under new glibc/kernel. On Sunday 05 August 2001 12:54, you wrote: Vladimir Zidar writes: Description: mysql refuses connection [local/unix-socket] when client is ran under GDB, and linked with pthread library.

mirroring of database

Greetings!! I want a solution for mirroring of database on two machines simultaneously. i.e at the same point of time i want to insert/update/delete on two machines having same database. any suggestion/solution to this problem? thanx and regards, Madan Rai

How to upgrade mysql version on linux

hi we are using two different servers for our operation. unfortunately they have installed two different version of mysql. on one server we are using 3.22.32 ( mysqldump 7.1 ) on another server we are using 3.23.23 ( mysqldump 8.8 ) i want to know how to update the two versions to the present

Re: perforamnce

Date |Sat, 4 Aug 2001 12:53:15 +0100 From |Tadej Guzej [EMAIL PROTECTED] Hello! TG What is better: TG CREATE INDEX ix1(field1, field2, field3); TG or TG CREATE INDEX ix1(field1), ix2(field2), ix3(field3); TG I have a large table of some 30,000,000 records and am wondering TG which indexing

Can't compile .40 on HPUX 11.00 - linker problem with innobase

Hi, I can't *link* MySql on my HP-UX box due a linkage problem: ../innobase/lock/liblock.a ../innobase/mtr/libmtr.a ../innobase/page/libpage.a ../innobase/rem/librem.a ../innobase/thr/libthr.a ../innobase/com/libcom.a ../innobase/sync/libsync.a ../innobase/data/libdata.a

Convert Outlook into MySQL

Hi, Does anybody knows if there is an easy and fast way to convert MS Outlook 2000 contacts database into a MySQL table? It's very important for for to have transferred into MySQL a 256 chars key that is being used from Outlook as the primary key for the contacts. Thanks in advance Sophokles

RE: Convert Outlook into MySQL

Hi, Does anybody knows if there is an easy and fast way to convert MS Outlook 2000 contacts database into a MySQL table? It should be very easy for you to export your Contacts folder to MySQL. Simply choose the 'Import and Export...' menu command and tell Outlook to export to a tab-seperated

Borland MySQL client

Hi there guys, Hope things are well with you, and you are managing to get some holiday this season! We are considering to use your product for our on-line metering applicatons. I don't know whether you can help me, but I haven't been able to compile the Borland Win32 MySQL client -

reading error

I experience entries in hostname.err like 010806 11:05:48 Aborted connection 1780 to db: 'pferdezeitung' user: 'pferdezeitung' host: `localhost' (Got an error reading communication packets) The frequency of serious problems has dropped since we changed RAM modules. The ISP tells me that he

whats wrong here?

LOAD DATA LOCAL INFILE '/tmp/phpFBsb3v' REPLACE INTO TABLE agents FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''' LINES TERMINATED BY '\n' (agent_id,first_name,last_name,email_address,area_code,area,have_picture,abo ut) anybody see anything wrong in this ??? I've also tryed '\r' and '\r\n'

Re: problems with show tables

M Thanks for all the replies - it shows me to look a little harder M next time before I send a question to the mailing list. Thanks, but M ... M I did as it told but it still return an empty set. Here are the M results: M [..skip..] M You can see that I am attached to a database and that

Transaction safe tables for Mac OS X

Hi, Are there any transaction safe tables for Mac OS X you can use? Thanks, Willy Faes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: Borland MySQL client

Hi I having a little trouble with mysql, with the lack of sub-selects. Yes, I have read about joins, both the manual and from the MySQL book by Paul Dubois, but none of those provide any 'real' info about what to do. It's ok to do join on table1, table2 and table3 as long as they are limited

Re: Duplicate entry for SELECT query

Ivan Lulukyan writes: Hi All. Strange thing.The query below: select concat(domain,path,file) as url, title, '' as blank1, docdate, size, date as lastmod, 'keywords' as keyw, description as descr, a.ID, sum((word like 'acc')) as r, ( sum(word like 'acc')) as qu, f.ID, author,

Re: Compiling error in complete.c: filename_completion_function

Sebastian Kayser writes: Hi, i get the following error when trying to compile MYSQL 3.23.40 with only the --prefix option set: complete.c: In funtion `filename_completion_function´: complete.c:1467: syntax error before `*´ complete.c:1481: `directory´ undeclared (first use in this

Index length too long, but no index specified!

Hi, I cannot find my answer of this problem in the manual. When trying to add the table below to mysql (3.23.36) I get the error that says the index is too long. But how can it complain about a index in this table when no index is defined for this table? Do mysql create a pseudo primary key when

Re: Can't compile .40 on HPUX 11.00 - linker problem with innobase

Andre, I have not seen that problem before. Maybe you could try to add export CFLAGS=+Z to your configure lines. Look that it actually compiles InnoDB files with the +Z option, whatever it means. Actually it may be enough to do the configure only in mysql/innobase directory (InnoDB has its

Re: link errors when compiling the client

Caryl Rahn writes: I am getting link error when I try to compile with the mysqlclient library. I tried adding -lgz at the end of my link line as the documentation suggests. It cannot find -lgz What can I do to fix this? Thanks, Caryl Rahn Senior Operations Programmer Siemens Building

Re: (almost) unable to compile with gcc 3.0

[EMAIL PROTECTED] writes: Description: When compiling with gcc-3.0 there are problems with libstdc++, which is not linked to the executables There also seems to be a problem with libwrap, who is complaining about functions being called with wrong number of

Need help: workaround for sub-selects?

(sorry for the double-post, but I had wrong subcect on the previous one) Hi I having a little trouble with mysql, with the lack of sub-selects. Yes, I have read about joins, both the manual and from the MySQL book by Paul Dubois, but none of those provide any 'real' info about what to do.

Re: Borland MySQL client

I will forward your mail to the programmer that contributed Borland version. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca,

Re: libmysqlclient[_r].so + pthreads + gdb

Vladimir Zidar writes: It is gdb-5.0, Mandrake 8 version, with patch for threaded application under new glibc/kernel. That one is not very good for threaded apps. That is why we use gdb from snapshots. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa

Re: Index length too long, but no index specified!

I just tried with your definition and it worked fine. Johan Andersson schrieb am Montag, 6. August 2001, 14:03:42: Hi, I cannot find my answer of this problem in the manual. When trying to add the table below to mysql (3.23.36) I get the error that says the index is too long. But how can

MySQL to Oracle schema conversion utility

Here's a MySQL to Oracle schema conversion utility that I've written. It's rather more functional than the m2o one posted recently. Tim. p.s. I could have implemented the SQL 'create table' parser using Parse::YAPP and the yacc syntax in the mysql source code but I wanted to use this as an

Re: Borland MySQL client

Erlend Stromsvik writes: Hi I having a little trouble with mysql, with the lack of sub-selects. Yes, I have read about joins, both the manual and from the MySQL book by Paul Dubois, but none of those provide any 'real' info about what to do. It's ok to do join on table1, table2 and

Re: Borland MySQL client

I can't comment on whatever Borland client you're talking about but MySQL supports multiple table joins. It's all in your sql coding. I built a yellow pages directory using MySQL that consists of several tables. One has 500,000 records another has 2,000,000 records, others are smaller having

Re: Transaction safe tables for Mac OS X

Willy, people have written quite a lot of compiling MySQL on OS X. It should be possible. Below is an ad of a CD which contains the OS X version. Obviously the producers of the CD have been able to compile. Regards, Heikki http://www.innodb.com Copied message: Hi, Are there

test SQL statement? ie Parse but do not execute SQL statement?

Hey all; I'm Trying to parse an SQL statement using the database without actually running it. For example, I have a tool that generates my SQL for me to accommodate changes in schema. I want to be able to test the generated SQL statements by putting pre-defined dummy values in, and sending the

mysql-3.23.40 - Compiler errors with Sun WorkShop 6

Description: mysqld.cc will not compile with Sun Workshop 6 CC: Sun WorkShop 6 2000/08/30 C++ 5.1 Patch 109490-01 Failing with the following errors: -- make[3]: Entering directory

Truncated User List

Hi, Wondering if anyone can here can help, We've got a small selection of MySQL databases used by our customers (for websites). Until now we've used the Debian package of MySQL (latest deb. version), however the systems are being updated we're starting to use source builds, (this

Re: Borland MySQL client

I'm new to the list,though I've been using MySQL in relatively simple modes for some time now. If you want to join three tables, t1, t2, t3. If you want to select from t1 where t1.c2 has a value in t2.c12 AND where t1.c3 has a value in t3.c13, then first make sure that t1.c2 and t2.c12 have

LOAD DATA INFILE performance testing

I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( value CHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time performance of inserting X unique

Help Slow Query

Hi there, I have a query that is taking 19 - 23 sec's to complete, it used to take 5 sec or less to complete, the only thing we have added are a new database unrelated to this on. The system is a Sun Ultra 10s running Solaris 2.7 with 256mb and 333mhz processor. Mysql version is 3.22.27. Any

Win32 SSH connection to Linux MySql db

All, I have read everywhere of people getting this to work in loads of newsgroups, but I can't seem to find the actuall answer! I have downloaded ssh32 and SecureCRT, both apparently can do the job. I have a RedHat 6.2 install and want to talk to MySql (latest version) over MyODBC using SSH

Search results are differant on console and in webmin

I sometimes access mysql through webmin and sometimes via the console (using telnet from a remote machine). I have a table of users (name,password,login) and when I view it on the console I see a few fields appear to be missing a few characters. When I view it via webmin those same fields show

FW:

hi, is it possible to use queris of SQL at MySql? dikla sharvit fls-dba 65513, 65486 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

mass data load

Not very familiar with the features of MySQL regarding data loading. Does MySQL has some tool like SQL*Loader in Oracle? Can I use some control file to help load a bunch of data in a mass mode from some text input file into MySQL database? Any ideas or pointers to on-line help resouce are

Re: LOAD DATA INFILE performance testing

Jeff Tanner writes: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY ) The test is simple: a) clear table b) time

installation

Hi, I installed the mysql-3.22.26a version on my linux machine and executed the following commands Untar it and change into the source directory tree: tar -xvzf mysql-3.22.26a.tar.gz cd mysql-3.22.26a Configure the package; I used following options: ./configure --prefix=/opt/mysql

slow and fast query problem

Hi (I hope I'm not asking to many 'stupid' questions... :) This query runs very fast (time 0.01 seconds): SELECT * from DB_GNIST.varer WHERE kategori = 24010 ORDER BY utgivelses_aar DESC LIMIT 10; This one is slow (time 0.73seconds): SELECT * from DB_GNIST.varer WHERE kategori = '24010' ORDER

Re: LOAD DATA INFILE performance testing

DELAY_KEY_WRITE=1 Tim. On Mon, Aug 06, 2001 at 07:36:17AM -0700, Jeff Tanner wrote: I running a test on mysql to test its performance of doing a bulk insert into a table using LOAD DATA INFILE. The table is simple: CREAT TABLE test ( valueCHAR(32) NOT NULL PRIMARY KEY )

RE: LOAD DATA INFILE performance testing

Thanks Tim for your reply But I am unfamiliar with DELAY_KEY_WRITE. I looked at both Tuning Server Parameters and LOAD DATA INFILE sections. Jeff Tanner Viathan Seattle, WA -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 9:00 AM To: Jeff

RE: LOAD DATA INFILE performance testing

Thanks Sinisa for your reply, Interesting alterative. I tried: a) ALTER TABLE foo DROP PRIMARY KEY b) LOAD DATA INFILE file INTO TABLE foo c) ALTER TABLE foo ADD PRIMARY KEY (value) However, there was no noticable improvement in performance. Even though loading the

RE: LOAD DATA INFILE performance testing

DELAY_KEY_WRITE=ON by default Jeff -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 9:00 AM To: Jeff Tanner Cc: '[EMAIL PROTECTED]' Subject: Re: LOAD DATA INFILE performance testing DELAY_KEY_WRITE=1 Tim. On Mon, Aug 06, 2001 at 07:36:17AM

Re: mysql-3.23.40 - Compiler errors with Sun WorkShop 6

Rob McMahon writes: Description: mysqld.cc will not compile with Sun Workshop 6 CC: Sun WorkShop 6 2000/08/30 C++ 5.1 Patch 109490-01 Failing with the following errors: cut mysqld.cc, line 1484: Error: Cannot use const char* to initialize char*. char* p = strrchr(opt_name,

1054 error

I'm new to MySQL and I get a 1054 error on this SQL query sent by a PHP 4 script: 1054: Unknown column 'pricerange' in 'field list' $sql is INSERT INTO CCC_reviews (restname, type, specialties, address, phone, hours, pricerange, creditcards, reservations, rating, miscinfo, area, wheelchair,

Fw: UDF parameters

Hello, Is there a way to get parameters list for compiled UDF without its source available? If there, how can I get this parameters list? Best regards, Igor Brynskich Database - Before posting, please check:

editor

is there any editor available (eg vi on UNIX) that runs on MS-DOS to make writing queries easier in MYSQL. I am a newbie. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: slow and fast query problem

IF kategori is an integer then the first one is the proper way to query it. The second one is forcing MySQL to convert a string to an int before comparing. (At least I THINK that's the problem.) Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message -

Re: mass data load

Dear Bing, control file to help load a bunch of data in a mass mode from some text Use LOAD DATE [LOCAL] INFILE, check the MySQL manual chapter 7 for this! Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de #

Re:

Dear Dikla, is it possible to use queris of SQL at MySql? I don't exactly get what you mean, but well ... MySQL is an SQL database system, if that's your question. It is quite ANSI SQL92 compatible, and knows alot of Oracle extensions as well. So, if your question is, if you can use SQL

Installing multiple versions of mysql

I am currently trying to install mysql on a linux machine that already has mysql running. I went into the safe_mysqld script and modified the tcp port to point to 3308 and the mysql.sock file to point to /tmp/tmp/mysql.sock. I was able to get this to work with one of the newer versions of mysql

SQLException Error Before start of result set

Hi My Java servlet (on ApacheTomcat) with database connection to MySQL keeps reporting same error from a Resultset via a PreparedStatement. It's catching an SQLException sqle error: Before start of result set. and showing a blank screen instead of showing printed messages having checked

Re: editor

Dear Naintara, what about Notepad (the windows standard editor)? Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 -

Re: editor

Yes, have a look at urSQL (http://www.urbanresearch.com/ursql). You may also want to have a look at MyODBC and the various clients available from mysql.com, including mysqlgui. On Mon, 6 Aug 2001, Naintara Jain wrote: is there any editor available (eg vi on UNIX) that runs on MS-DOS to make

Error with RPM upgrading from 3.22.23 to 3.23.40

Hi I'm receiving the following error when trying to upgrade from 3.22.32 to 3.23.40 OS: RedHat Linux 6.1 Hardware: HP Netserver E60 After closing down the MySQL daemon, then issue: rpm -Uvh MySQL-3.23.40-1.i386.rpm I get errors, saying that there is a conflict with mysqldump. Any ideas

Re: editor

Ick !!! This question had come up on the list about 2 weeks ago... I like: WinVI (I know that the Emacs lovers will respond soon) at: http://www.winvi.de/en/ For other versions and 'ports' of VI, see The VI Lovers Homepage at:

Localization..

I have a table which contain data of some different charsets, some of them are multi-byte character.. They are currently stored in raw, binary format.. In order to make % match those multi-byte characters correctly, I am planning to convect the table format to correct charset. However, i cannot

Re: Just wondering....

I have been considering a database backend for a new website I am creating. If this site becomes successful I may be looking at several hundred concurrent users. Can MySQL handle this? Is there a limit to the number of connections?? Any info would be greatly appreciated. Check this lists

Re: mass data load

Stefan, Hrmm...which manual did you refer to? I found some LOAD DATA info in the on-line manual http://www.mysql.com/documentation/mysql/bychapter/. But its chapter 7 is about 'MySQL Full-text Search'. Bing Bing Du [EMAIL PROTECTED], 979-845-9577 Texas AM University, CIS, Operating

Import data question

I have a table I want to import some records into. The table has 4 columns - user_id, name, account, password. The file I have to be imported has 3 columns - password,name,account. I have been trying to use load data infile and keep ending up with a lot of junk in the database. The file is of

WANTED: Utility to reverse engineer existing database

I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin

RE: Help in Administration

Hi, Sorry to bother you people but I've just locked myself out of my own DB. I was installing some stupid program which required me to do some changes in the permissions and now I get this error Access Denied for user: 'root@localhost' (Using password: NO).

Re: WANTED: Utility to reverse engineer existing database

On Mon, Aug 06, 2001 at 04:57:41PM -0400, Kevin wrote: I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Tried

Re: WANTED: Utility to reverse engineer existing database

For mysql you can use mysqldump Kevin wrote: I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin

Data load

I'm trying to import data (approx. 2000 records), but am unable due to the following circumstances; My host doesn't allow access into the mysqldb directory for security purposes (shared server). This is the directory where MySQL is looking for the import file. I then tried to use LOCAL but

Re: WANTED: Utility to reverse engineer existing database

mysqldump It comes with MySQL. - Original Message - From: Kevin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 06, 2001 3:57 PM Subject: WANTED: Utility to reverse engineer existing database I need a utility that will probe my existing mysql database, analyze the 90+

Re: WANTED: Utility to reverse engineer existing database

Yup. You can use mysqldump (comes with the MySQL distribution). See the MySQL manual for details: http://www.mysql.com/doc/m/y/mysqldump.html You can also use a graphical tool such as urSQL (MS Windows + MyODBC) to accomplish the scripting if you wish (http://www.urbanresearch.com/ursql).

C API Compile Error

Good Afternoon - I receive the following error when attempting to compile an application to use the C API. gcc -oclient1 client1.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress':

RE: WANTED: Utility to reverse engineer existing database

Got it! Thanks. -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 5:11 PM To: Kevin Cc: [EMAIL PROTECTED] Subject: Re: WANTED: Utility to reverse engineer existing database For mysql you can use mysqldump Kevin wrote: I

Re[2]: WANTED: Utility to reverse engineer existing database

Check out CaseStudio at www.casestudio.com. Mark Chalkley On Monday, August 06, 2001, 5:40:15 PM, you wrote: I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate

Out of memory

Title: Blank I'm getting this error Out of memory (Needed 8164 bytes) I thinking this is a squid issue and not a mysql issue but I seem to run across alot of ? about it with Mysql database. I just need to be pointed in the right directions Vien HuynhleClearsail Communications

Out of memory

Title: Blank Also I getting this error when I am unable to do my selects I'm getting this error Out of memory (Needed 8164 bytes) I thinking this is a squid issue and not a mysql issue but I seem to run across alot of ? about it with Mysql database. I just need to be pointed in the right

Fwd: Error with RPM upgrading from 3.22.23 to 3.23.40

Well, I answered by own question. The trick is to install the client utilities first! Then the server. ie: rpm -Uvh MySQL-client-3.23.40-1.i386.rpm rpm -Uvh MySQL-3.23.40-1.i386.rpm Peter Date: Mon, 06 Aug 2001 15:27:14 -0400 To: [EMAIL PROTECTED] From: Peter Fleming [EMAIL PROTECTED]

./configure error

Hi, I am attempting to compile mysql but when running ./configure it errors out when Checking for termcap functions library... configure: error: No curses/termcap library found And it returns me to the command prompt. I can't seem to find this library that it is asking me for. Any ideas.

MySQL++ API under Mac OS X

I was able to compile and install the MySQL++ API on my Mac OS X system, however, whenever I try to run a program linked against the library, I get undefined symbol errors. dyld: bin/wopsql Undefined symbols: __t12basic_string3ZcZt18string_char_traits1ZcZt23__malloc_alloc_template1i0. nilRep

how to delete a database table?

how can i delete a database table? ty louie miranda --- (axishift.ath.cx) PGPID: 0xDABA60C7 - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: how to delete a database table?

DROP TABLE table_name; On Tue, 7 Aug 2001 10:15:43 +0800, louie miranda [EMAIL PROTECTED] wrote: how can i delete a database table? ty louie miranda --- (axishift.ath.cx) PGPID: 0xDABA60C7

Re: how to delete a database table?

To remove rows from a table: mysql delete from your_table_name; See: http://www.mysql.com/doc/D/E/DELETE.html To completely remove the table from the database: mysql drop table your_table_name; See: http://www.mysql.com/doc/D/R/DROP_TABLE.html On Tue, 7 Aug 2001, louie miranda wrote:

Re: solairs 8 x86 get signal 11 with bdb support

Greetings, I appologize for not responding sooner, as I have had ISP problems, and work has been killing me...so to speak. :) I attempted running some of the programs under the bdb/build_unix directory, but none of them would run either. I ended up giving up and going with InnoDB, which works

Nested Queries in MySQl

Hi all, I have not been using MySQL for too long but have been using SQL7.0 for a while now, so I am generally familiar with the structure. My basic problem right now is trying to figure out how to get MySQL to do nested queries such as ... select count(*) from (select count(*) as A,

Question about users

I created a perl script that opens that database like this: my $dbh = DBI-connect( 'DBI:mysql:devjournal:username=mjohnson:host=morpheus' ); This works great if I run the script from another machine, but if i run in on morpheus it says that [EMAIL PROTECTED] does not have access. If I leave off

Can't start MYSQL on Linux

I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was installed together with the Redhat Linux. I can not start the mysql server by executing /usr/bin/safe_mysqld . It always ends immediately. When I look at the /var/log/mysql.log, the message says: mysql started

Re: Can't start MYSQL on Linux

Ling Wang [EMAIL PROTECTED] writes: I have a fresh installed Linux 7.1 from Redhat. The mysal 3.23.36 was installed together with the Redhat Linux. I can not start the mysql server by executing /usr/bin/safe_mysqld . You're not supposed to. To start mysql, as any service, do service mysqld

Re: Nested Queries in MySQl

Date |6 Aug 2001 19:59:46 -0700 From |Steven Robillard [EMAIL PROTECTED] Hello! SR Hi all, I have not been using MySQL for too long but have been using SQL7.0 for a while now, so I am generally familiar with the structure. SR My basic problem right now is trying to figure out how to get

Re: C API Compile Error

Date |Mon, 6 Aug 2001 14:46:13 -0700 (PDT) From |Rob Doornbos [EMAIL PROTECTED] Hello! RD Good Afternoon - RD I receive the following error when attempting to RD compile an application to use the C API. RD gcc -oclient1 client1.c -I/usr/local/mysql/include RD -L/usr/local/mysql/lib

Re: ./configure error

Date |Mon, 6 Aug 2001 19:14:09 -0600 From |Michael Blood [EMAIL PROTECTED] Hello! MB Hi, MB I am attempting to compile mysql but when running ./configure it errors out MB when Checking for termcap functions library... configure: error: No MB curses/termcap library found MB And it returns me

Re: Import data question

Date |Mon, 6 Aug 2001 13:48:41 -0700 From |[EMAIL PROTECTED] Hello! C I have a table I want to import some records into. The table has 4 columns C - C user_id, name, account, password. C The file I have to be imported has 3 columns - C password,name,account. C I have been trying to use load

Re: Localization..

Date |Tue, 7 Aug 2001 04:01:17 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have a table which contain data of some different charsets, SC some of them are multi-byte character.. SC They are currently stored in raw, binary format.. SC In order to make % match those multi-byte characters

INET_ATON

hey folks, i just tried using INET_ATON() and INET_NTOA() and i keep getting syntax errors near '(100.100.100.100)' at line 1 no manner of quoting that i can think of solves this. i tried the examples at the bottom of http://www.mysql.com/doc/M/i/Miscellaneous_functions.html and they got the

Re: installation

Date |Mon, 6 Aug 2001 08:37:06 -0700 (PDT) From |Venkat Nipun Gajjala [EMAIL PROTECTED] Hello! VNG Hi, VNG I installed the mysql-3.22.26a version on my VNG linux machine and executed the following commands VNG Untar it and change into the source directory tree: VNG tar -xvzf

Re: Help Slow Query

Date |Mon, 6 Aug 2001 09:59:04 -0500 From |Patrick J. Militzer [EMAIL PROTECTED] Hello! PJM Hi there, PJM I have a query that is taking 19 - 23 sec's to complete, it used to take 5 sec PJM or less to complete, the only thing we have added are a new database unrelated PJM to this on. PJM The

Re: Truncated User List

Date |Mon, 6 Aug 2001 13:51:09 +0100 From |Steve Wright [EMAIL PROTECTED] Hello! SW Hi, SW Wondering if anyone can here can help, SW We've got a small selection of MySQL databases used by our customers (for SW websites). SW Until now we've used the Debian package of MySQL (latest deb.

Re: Transaction safe tables for Mac OS X

Date |Mon, 6 Aug 2001 13:44:28 +0200 From |Willy Faes [EMAIL PROTECTED] Hello! WF Hi, WF Are there any transaction safe tables for Mac OS X you can use? WF Thanks, WF Willy Faes You must use innodb or bdb tables for transaction safe. Both may normaly compilled on Mac OS