RE: basics!!

Hi Mac, You should not be typing DOS commands within the mysql.exe utility, do the following exactly: Get yourself here: C:\> Type: cd mysql\bin Result: c:\mysql\bin Type: mysqld-nt --install Result: c:\mysql\bin Type: net start mysql Result: MySQL Service has started successfully Type: mysql R

Re: basics!!

Oh, thank you so much. That does help, but now I'm stuck again for some reason... I am at the 'mysql>' prompt, and type in: C:\mysql\bin; ...to get to the bin directory...and i got an error in syntaxwhy? i also tried typing: mysqladmin -uroot -password **; and got another error.. any h

Re: Sizing HEAP table using .MYD/MYI

>Hi all > >I have a large table (20 million records) that I want to load into RAM to >improve selects. I understand (from previous posts) that I must create a >HEAP table. Please correct me if I'm wrong on this. My question is - how >much RAM do I need if the MYI and MYD files are as follows :- >

RE: basics!!

Hi Mac, This is actually quite easy (although you've not supplied your Operating System (OS)) win95,win98,winnt,win2000 is presumed: 1. Install MySQL 2. Go to the mysql\bin directory command line (DOS Box) 3. If you want to install on NT or 2000 do A) else do B) A) mysqld-nt --install net s

Troubles installing MySQL-3.22.32

Hi everybody, I'm trying to install the RPM on a RH 7.0 everything looks normal but the server dies sending this message mysqld: Can't find file: 'host.ISM' (errno: 2) How do I fix this, where can I get this file? or how can I build it? Thax __

Back up procedure for Mysql

Sir, As i am using mysql on my linux server and want to shift it to other linux box, so regarding this matter i want the information regarding this and how to go forword in this situation. thank you Imran Get free email an

How to query and return nearest value...

Hi, I have a range of decimal numbers (Prices) in a table column that I'd like to run a query against. I'd like to run a query with a value that returns the closest price to that value if it can't find a match. Is there some function that I can use in my query that will allow me to do this? Than

write problems via MS Access 97 in table with timestamp and primary key

One of our users is getting the message "another user has changed this database..etc save changes to clipboard or drop changes... etc", when he tries to update certain fields in the table. The table has a timestamp and a primary key. In fact, this user can change certain fileds without diffi

basics!!

allright, so i am a beginner with some very basic questions... I installed and set up mysql, but everything i read, talks about using ms-dos or something to use it. It looks the interface i have for mysql has all those options, or no??? Is whatever I will want to do not possible within that in

Can't compile on Solaris 2.7

I am getting this error trying to compile mysql 3.23.28: checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling The documentation says the compiler is not installed correctly. I tried the gcc2.8.1 and 2.9.5 packages from su

Get C++ api demo

Hi: I use 3.22 and KDevelop 1.0 beta 4. Please send to me if you have C++ api demo. Thank you!

Re: sum/count problem

>Hi, > >I try to use 2 COUNT's and a SUM in query from 2 tables, but am not able >to get the results I want. > >The 2 tables are batches and testresults, and have the following fields >and relation: > > batches: testresults: > - batch_nr <---+ - id > - date | - st

Re: Replication issues

On Tue, Jan 23, 2001 at 04:01:00PM -0500, Jeremy Wilson wrote: > I tested replication recently and found it extremely lacking. Even > the most minor of errors causes the daemon to stop replicating, > effectively rendering the ability useless to me, as I use mysql for > authentication. What sort

RE: mysqld won't start and stay running

Hi, It won't be to do with the network, it'll be to do with which libraries are available where. You need to track down libstdc++.so, and make sure that the mysqld can see it when it loads, either by linking it to a 'normal' location (/usr/lib?) or setting LD_LIBRARY_PATH in the environment. Ho

Re: newbie question re: manual tutorial

try; select rticle, dealer, price from shop where price = '19.95'; notice the "'" around the value? :) Hope that does it for you. Atle On Tue, 23 Jan 2001, John Wallace wrote: > mysql> SELECT article, dealer, price > -> FROM shop > -> WHERE price=19.95; > Empty set (0.00 sec) >

mysqld won't start and stay running

Hello, I recently moved my system to a new location where it now has all new network connection settings. When I went ot start MySQL up for the first time after the change I got this error: # ./safe_mysqld & 1416 # Starting mysqld daemon with databases from /usr/local/mysql/var Killed mysqld dae

RE: question on select

Off the top of my head: (so it may not work) SELECT Inventory.*, P1.name, P2.name FROM Inventory, People P1, People P2 WHERE Inventory.in_possession = P1.person_id and inventory.returned_to = P2.person_id Cal http://www.calevans.com -Original M

newbie question re: manual tutorial

OK, I've checked the archives and read msgs for two days, now I have to ask ... I've installed mySQL from Redhat 7.0 distribution and got it running to my eyes ok: Ver 8.8 Distrib 3.23.22-beta, for redhat-linux-gnu on i386 Server version 3.23.22-beta-log Linux 2.2.16-22 #1 Tue Aug 22 16:16:55 ED

RE: MySQL manual

Pak: No problem from here. I downloaded from http://www.mysql.com/documentation/mysql/alternate.html -Martin Martin Haase HSIM Group [EMAIL PROTECTED] -Original Message- From: Pak Tse [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 5:10 PM To: [EMAIL PROTECTED] Subj

where can get C++ API DEMO

Hi : I am new user ,can you tell me where can get c++ api demo Please e-mail go me if you have. Thank you!

RE: question on select

Hi, Does using an alias achieve what you want? SELECT Inventory.*, p1.name, p2.name FROM Inventory, People as p1, People as p2 where Inventory.in_possession = p1.person_id and Inventory.returned_to = p2.person_id; Regards Quentin -Original Message- From: Cindy [mailto:[EMAIL PROTECTE

MySQL manual

I cannot download the PDF format of the manual from the website. Any help ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request thi

question on select

OK, let's say I have two tables. The first is a table full of people -- their names, address, phone numbers. The second table is an inventory, which among other things, has a pointer to the first table for who currently has possession of the item. so I select from the two tables to print out a

RE: newbie grant problems

Normally when you log in you would type: ->mysql -u username -p [Enter] It would then prompt you for a password if you have one. (By the way, substitute "username" with your username.) It shouldn't matter what prompt you're in, root, etc. John Halladay -Original Message- From: John-M

Sizing HEAP table using .MYD/MYI

Hi all I have a large table (20 million records) that I want to load into RAM to improve selects. I understand (from previous posts) that I must create a HEAP table. Please correct me if I'm wrong on this. My question is - how much RAM do I need if the MYI and MYD files are as follows :- 214M Ja

newbie grant problems

Hello all I am very new to this so please have patience with this question. I have recently installed mysql on debian potato and after installing I was able to get a mysql prompt by typing mysql at the normal; user prompt (not root) I thought that this was good. However I now get ERROR 1045: acces

Re: DB Structures

I think you'll find your answer in a book about database design. I don't know much about the book you're getting, but I am sure it will follow you through some simple examples which should lead you on the right track. I'm not sure if I am totally getting this right, but I think you'd be better o

How do I get optimal performance in this situation?

Thanks to everyone on this list in advance. Now, being that I don't know exactly how MySQL is implemented, I'm unsure of how to handle the following situation. I have a database foo, with: Table bar (every user would have a row... could be 100,000 rows): id, name, password (keyed on id and name

DB Structures

I'm trying to get a project going which is basically converting a price catalog into a database, however, going over the printed catalog, basically this is what it looks like: service_category_1 description (text) service_1 description (text) price

RE: fulltext search performance

I have spent quite some time trying to tune up fulltext indexing (coincidentally I am also working with the DMOZ data in my database). I too noticed how slow it goes when you order by relevancy... but there is no reason to order by the relevancy because it returns the results in descending order

Re: What proportion of sites use MySQL.

At 11:44 AM -0500 1/23/01, Vivek Khera wrote: > > "AS" == Andy Stowell <[EMAIL PROTECTED]> writes: > >AS> One of my clients has asked me to find out a rough idea as to what >AS> proportion of database enabled websites use the MySQL database. Along with the statistics below, you might try

fulltext search performance

Hi, Has anyone used the fulltext indexes in 3.23 and can share their experiences? I've only done limited testing, but was quite disapointed with performance. We have an import of DMoz data into a table with Title, URL and Description fields as a fulltext index. There are 2.5 million rows that ta

Re: question

At 7:34 PM + 1/23/01, suchin kannan wrote: >hi! > >i am suchindran kannan. i have started on a project with my prof on >mysql and PHP. > >im new to the mysql world. i have relation in which i would have to >include a multi valued attribute, can i do that in mysql. > >hope i can find an answe

Replication issues

I tested replication recently and found it extremely lacking. Even the most minor of errors causes the daemon to stop replicating, effectively rendering the ability useless to me, as I use mysql for authentication. Is there some configuration command to make it *ignore* errors and continue to re

RE: changing mysqld variables?

Hi, The syntax is: set-variable= max_connections=256 Regards Quentin -Original Message- From: Lars Andersson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 24 January 2001 09:47 To: [EMAIL PROTECTED] Subject: changing mysqld variables? I´ve got a problem. If I try to change max_con

changing mysqld variables?

I´ve got a problem. If I try to change max_connections in /etc/my.cnf the server refuses to start? Isnt I supposed to put startup variables to MySQL in this file? A file looking like this works [mysqld] #max_connections=200 log log-bin log-slow-queries server-id=1 but as soon as I remove the c

RE: aborted connections?

thanks for the reply. i found a followup on this problem from sasha ("Follow up on aborted connections bug in 3.23.31"), but wading through the archive searching for the original thread hasn't ended up being successful yet. anyone know offhand in which thread this was originally discussed? not

API

Having trouble getting to connect to anything but localhost... mysql_real_connect( dbh_ptr, "server.domain.org", "user", "password", "database", 0, NULL, 0 ); No matter what we put for the server name, it just tries to connect through the local socket. We're on 3.23.28

make errors building under AIX 4.3.3

Hi. I'm attempting to build mysql 3.23.32 on AIX 4.3.3, using egcs-2.91.66, and am running into errors on the make phase. When I try with the AIX 'make', I get errors ala the following: -- Making all in mit-pthreads "M

Problem on Installing a MySQL 3.23.32 Source Distribution on Sun Solaris 2.6 ???

I have done the source installation of MySQL 3.23.31 on Sun Solaris 2.6. I execute tests found in .../mysql-test directory using 'force' option to continue after aborted tests ( ./mysql-test-run --force). How can I do with those aborted cases, known that I have to install master-slave replica

Does mysql support Solaris2.8 ??

Hi, I am trying using mysql on Sun Solaris2.7 now, it is working well. But we are going to move to Solaris2.8 in the future. I am wondering if mysql supports Solaris2.8 or not. If so, where can I find downloading file. Best regards, :-) Jing Chen

Replication stalls....

Am I the only person experiencing these stalled slave machines as described in my pervious post to the list? Any help would be greatly appreciated. Thanks, Jon Here is my Prevoius Post: Hello all,

mysql compile error on solaris 2.5.1

Any ideas on this error? I'd love to use fulltext, but the last server that compiled for me was 3.23.14 :( c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/var/home/ap psweb/newmysql\"" -DDATADIR="\"/var/home/appsweb/newmysql/ var\"" -DSHARE

Re: Joins to one table form two columns

select a.id, status1, detail from history a, statusText b where a.id = b.id; rob anderson wrote: > I am new to MySQL so don't laugh! > > > I have a table 2 fields that relate to another table (that stores the > description) > > i.e > > history > id > status1 > status2 > > > statusText > id

Re: Problem with make test on Msql-Mysql-modules-1.2215 withMySQL-3.23

On Mon, 22 Jan 2001, Boyd Lynn Gerber wrote: > What is this symbol __llasgdivu that is referenced in libmysqlclient.so.10 > used or does it come from? Does any one else have this problem? I have traced this to a libc problem. The symbol is found in libc.so.1 I am not sure why it is not being f

question

hi! i am suchindran kannan. i have started on a project with my prof on mysql and PHP. im new to the mysql world. i have relation in which i would have to include a multi valued attribute, can i do that in mysql. hope i can find an answer to this. bye thanks Suchi Kannan

RE: Syntax error in my Update staement

Kill the final comma, i.e. ... SET SailPort = ?, SailDate = ?, Deleted = ? WHERE ... -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger > -Original Message- > From: Don [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 23, 2001 13:24 > T

MySQL 3.23.32 charset problem between big5/latin1

>Description: If it is compiled with --with-charset=big5 and without --with-extra-charsets, odd messages would be reported by php-4.0.4pl1, as the following: Warning: Can't initialize character set 1 (path: default) in /vhost/book.ljm.qqjane.net/htdocs

Syntax error in my Update staement

Hi all, The compiler is reporting a syntax error in mySQL statement near the WHERE clause. Help. Perl code is as such: $sqlCmd = $dbh->prepare (q{ UPDATE Sailings SET SailPort = ?, SailDate = ?, Deleted = ?, WHERE Vessel = ? AN

Re: INSTALLATION QUESTION on Cobalt Raq3

Don't use RPM. The RPMs for the Cobalt RaQ3 suck. I have 8 different Cobalt RaQ3's and here's the way I've used to install: I've installed it this way successfully each time. Sounds like a bit of a pain, but puts you in much better control of MySQL. INSTALLATION INSTRUCTIONS #1 - down

index question

Hi! I have a table "uudised": NewsID int(11) PRI auto_increment Pealkirivarchar(250)YES Uudis textYES DatedatetimeYES MUL EditorIDint(11) YES KategID int(11) YES MUL Autor varchar(50) YES AllikasID

Re: Connecting to MySQL with Visual Basic

for visual basic & mysql http://www.avukatpro.com/mysql.html - Original Message - From: Dwight Mowbray <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 19, 2001 4:18 AM Subject: Connecting to MySQL with Visual Basic Hi. Can anyone tell me how or refer me to any tuto

Re: jdbc driver

Couple of things 1) is the listening port number correct ? 2) If you are using windows, make sure the class path has 8.3 file name format instead of the long file name. other than that it should work fine kerry finn wrote: > Hi, > > What do I use to identify the default jdbc driver for mysql

Re: MySQL-Front

On Tue, 23 Jan 2001, Steve Ruby wrote: > Date: Tue, 23 Jan 2001 10:48:20 -0700 > From: Steve Ruby <[EMAIL PROTECTED]> > To: Jose Ostos <[EMAIL PROTECTED]>, [EMAIL PROTECTED], > [EMAIL PROTECTED] > Subject: Re: MySQL-Front > > > I thought I should send this to the regular mysql list as there

Joins to one table form two columns

I am new to MySQL so don't laugh! I have a table 2 fields that relate to another table (that stores the description) i.e history id status1 status2 statusText id details How can I join the history.status1 and history.status2 fields to the statusText table? in order that I can display id

HELP! Newbie can't get MySQL to start at boot time

> I'm trying to get MySQL running under NetBSD 1.5, and am having > problems getting mysqld running at boot time. It starts, but quits > almost right away. If I start mysqld using mysqld.server the log > file indicates that the table mysqld.host is not found. If I use > safe_mysqld the log f

Unable to see databases...

I have recently installed mysql and ran the mysql_install_db script, with no problems. I then proceeded to set the root password, which worked fine as well. Now, when I type in "show databases;" I end up 8 rows of nothing; I have 8 databases running, but no text shows up in the console box, it

jdbc driver

Hi, What do I use to identify the default jdbc driver for mysql (out of the box)? driver: org.git.mm.mysql.Driver url:jdbc:mysql://jasper:3306/mysql when i call Class.forName(driver) - null get returned? its a new ide and the classpath is defined (i think?). is this the correct driver cla

Direct use of MyISAM in applications.

Can anyone give me more information on directly using MyISAM directly in applications? I'd heard that it was possible, but haven't ever seen any information relating to the subject appear on this list. (I know there's a libmyisam, but I don't know what to do with it beyond that..) Is the API docu

FastCGI and closing connection

Hi: I wonder if anybody has experience using MySQL (or anoth db for that matter) in FastCGI environment. I open connection to database and want to make sure it is closed gracefully when application dies (for whatever reason, for example, killed by server because there is little demand and serve

Re: MySQL-Front

I thought I should send this to the regular mysql list as there are many mysql users who run DB on unix but must use windows for a workstation and remote administration. This is an excellent front-end.. It has the best UI of any of the other windows front-ends I've seen, it is very fast, this is

Re: A report generator MySQL

On Sat, 20 Jan 2001, Laurie Savage wrote: > I am writing a database to store student academic records at my local > high school. I wish to generate attractively published reports home to > parents. > > Does anybody know of a method or product that will produce elegantly > formatted reports from

RE: MySQL-Front

Yes, I've tried many as well and like MySQL Front the best. lee -Original Message- From: Jose Ostos [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 12:20 PM To: MySql List Subject: Re: MySQL-Front Of the diferent tools I have tried, I have found this one to be very complet

Re: SQL query problem

On Tue, Jan 23, 2001 at 05:39:47PM +0100, Sander Pilon wrote: > Okay, here's one for the guru's out there :) > > I have a list of entries with unique id numbers X, and a set of sort methods > (S1 ... S). > > Now, if I want to get an entry at position P (0...) in the list of > entries ordered by

Re: What proportion of sites use MySQL.

> "AS" == Andy Stowell <[EMAIL PROTECTED]> writes: AS> One of my clients has asked me to find out a rough idea as to what AS> proportion of database enabled websites use the MySQL database. Exactly 67.2341231123123% Now really, how on earth do you expect to come up with such a statistic? H

SQL query problem

Okay, here's one for the guru's out there :) I have a list of entries with unique id numbers X, and a set of sort methods (S1 ... S). Now, if I want to get an entry at position P (0...) in the list of entries ordered by method S1 then I'd make the following query: SELECT X FROM table WHERE

can't logout unless stop mysqld

I am running binary version mysql-3.22.32-sun-solaris2.5.1-sparc on Solaris 2.6 box. I do ssh onto the MySql server and issue ../support-files/mysql.server start. Everything is working okay. I can query data bases etc. The problem is I cannot log out of my ssh session unless I do ../support-fi

Re: Apache - MySQL - PHP (Auto-start Apache)

Just put /usr/local/apache/bin/apachectl start last in your /etc/rc.d/rc.local file.. rc.local will run at startup so apache will be started .. /Joakim Lemström, Sweden John Halladay wrote: > I'm currently running Apache 1.3.12, MySQL 3.22.32-1, and PHP 4.0.3 together > on RedHat 7.0 and every

VARIABLE ERROR

Hello, I am trying to port a program from Postgress to Mysql. This program works perfectly in Postgress. I am having some errors though with mysql. I get a use of uninitialized value after I execute the following command: $command = $query->param('command'); and then try to just access $comma

Re: 3.23.32 replication problem

I have also encountered this problem when upgrading master and slave from 3.23.31 to 32.23.32. The upgrade of the master went fine, and both servers remained in sync throughout the process. However, when I upgraded the slave and restarted, it gave the same error that it could not find first log. T

Re: 3.23.32 replication problem

On Tuesday 23 January 2001 07:28, Jean-Luc Fontaine wrote: >On Tuesday 23 January 2001 15:13, you wrote: >> >Just tried a 3.23.32 slave (on Linux, all rpms from www.mysql.com) against >> > a >> >> 3.23.30 server: >> >010123 09:38:05 mysqld started >> >> /usr/sbin/mysqld: ready for connections >>

Re: Cobalt .pkg scripting

I just saw something on freshmeat.net called EPM (ESP Package Manager) that purports to be able to assemble AT&T .pkg files for you (as well as other popular package formats, .bpkg, .rpm, etc). Haven't tried it, let me know if it works out for you. -Aaron On Tue, 23 Jan 2001, James Raff wrote:

Apache - MySQL - PHP (Auto-start Apache)

I'm currently running Apache 1.3.12, MySQL 3.22.32-1, and PHP 4.0.3 together on RedHat 7.0 and everything works fine, although every time I boot up I have to manually start the Web Server with command /usr/local/apache/bin/apachectl start. Does anyone know how to configure Apache so that it will

What proportion of sites use MySQL.

Hi I am new to this list so please accept my apologies if this has been discussed before! One of my clients has asked me to find out a rough idea as to what proportion of database enabled websites use the MySQL database. Any ideas? Thanks Andy http://www.freelancers.net http://andy.freelance

Cobalt .pkg scripting

Are there any facilities or gurus who could write a .pkg file to help us Linux newbies upgrade MySQL on a RaQ4 box? The most recent version from Cobalt is 3.22.32 and we would like to go to 3.23.30 but do not feel confident to write a .pkg for this machine. We are prepared to pay for the file a

Re: Key trouble

Andrei Zmievski wrote: > > On Tue, 23 Jan 2001, Gerald L. Clark wrote: > > > Why isn't it using index on the last query? > > > > > Because there isn't an index that contains both fields. > > So it can't use separate indexes? > > I guess the obvious solution would be to create an index on both o

Re: HP-UX 10.20 mysqld shutdown problem

On Thu, Dec 21, 2000 at 09:22:40PM +0200, Sinisa Milivojevic wrote: > Lutz Jaenicke writes: > > On Thu, Dec 21, 2000 at 07:30:23PM +0200, Sinisa Milivojevic wrote: > > > > 1. It doesn't help (no surprise, as this would have meant that HP's compiler > >and gcc having the same problem which

Re: installation MySQL

Christian Przybilla wrote: > > Dear Ladys and Gentleman, > > i do install packages MySQL-client-3.23.32-1.i386.rpm, > MySQL-3.23.32-1.i386.rpm and MySQL-devel-3.23.32-1.i386.rpm with yast on > Linux 6.3 - OS. > When i started mysql with "save_mysqld i receved follow messages: > mysql started > C

Re: Key trouble

* Andrei Zmievski <[EMAIL PROTECTED]> wrote on 23.01.01 16:54: > mysql> show keys from ARTICLES; >... [Andrei's mail trimmed down quite a bit]: > | ARTICLES | 1 | Publication_ID|1 | Publication_ID| A > |NULL | NULL | NULL | | >... > | ART

Replication Problem - Error 1016 - can't open file:

Hello ! We recently upgraded our Master (Live server) to mysql version 3.23.28 - gamma. And the same version upgrade for our Slave server. We tried replicating our main database, which has nearly 35 tables. We did everything as per the MySQL documentation to Replicate the database and have a m

Re: Key trouble

On Tue, 23 Jan 2001, Gerald L. Clark wrote: > > Why isn't it using index on the last query? > > > Because there isn't an index that contains both fields. So it can't use separate indexes? I guess the obvious solution would be to create an index on both of those fields, but I will also need to h

Re: Key trouble

Andrei Zmievski wrote: > > Just installed 3.23.29-gamma and played around with fulltext indexes and > some other stuff. Ran into a weird problem that I hope you can shed some > light on. > > Basically, a query's where clause has two parts joined by 'and': > > select count(*) from ARTICL

BDB rollback still not working in 3.23.32

>Description: Rollback still does not work with MySQL 3.23.32 and BDB 3.2.3h. This same problem has been encountered with earlier versions of MySQL as well. However, all hosts on which this has been noticed have been running Red Hat Linux 7.0, which could be the cu

installation MySQL

Dear Ladys and Gentleman, i do install packages MySQL-client-3.23.32-1.i386.rpm, MySQL-3.23.32-1.i386.rpm and MySQL-devel-3.23.32-1.i386.rpm with yast on Linux 6.3 - OS. When i started mysql with "save_mysqld i receved follow messages: mysql started Can't start server: Bind on unix socket: Perm

Key trouble

Just installed 3.23.29-gamma and played around with fulltext indexes and some other stuff. Ran into a weird problem that I hope you can shed some light on. Basically, a query's where clause has two parts joined by 'and': select count(*) from ARTICLES where Publication_ID = 9 and Status =

RE: mysqld crashes on FreeBSD 4.2

Typically, processes which die with either a signal 10 or 11 are due to hardware problems, such as bad memory or an overheating CPU. You might consider trying a memory tester or simply do a 'make world' in /usr/src (to heavily tax the CPU and memory). -Tilghman -- "There cannot be a crisis tod

Re: ERROR 1040: Too many connections

> Filippo> There must be a problem, then. > Filippo> It happens to me, often, that I cannot obtain a proc or ext with mysqladmin > Filippo> as root. > Filippo> All accesses are through an unpriv username, I have max_connections=1000 and > Filippo> a > Filippo> ps ax | grep mysqld | wc -l gives me

C API question

Hi, If this is not the appropriate list for this question, please accept my apolgies and kindly direct me to the correct list. I have attempted to install MySQL under CLOS 1.2 (Corel Linux), using the instructions found in Howard Schultens' "MySQL for dummies - part 1". I have worked through W.

3.23.32 replication problem

>Just tried a 3.23.32 slave (on Linux, all rpms from www.mysql.com) against a 3.23.30 server: >010123 09:38:05 mysqld started /usr/sbin/mysqld: ready for connections >010123 9:38:05 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'jfontain-bin.008 ' at positi

ERROR 1030: Got error 127 from table handler

ERROR 1030: Got error 127 from table handler I get this error when I try to execute SQL statements using any of my tables I'm terrified that I've lost all my data If you know how I can fix this up please email me [EMAIL PROTECTED] asap Thanks, Lido

Re: Win2K and MySQL

Is the error 1067-something? In that case there could be something wrong with the my.cnf file. can you see the extension .cnf in the windows explorer? If you do, remove it, the filename then is actually my.cnf.cnf. The problem I had was when I wanted to update from 3.22 to 3.23, but it could be th

Re: Lazy

On Thu, 11 Jan 2001, Tõnu Samuel wrote: > We still try to answer questions and value your time. Just some > questions are repeating up to 3 times per day, other people do not > provide any data with their questions and finally all MySQL > development goes slower because this. We are providing fre

Re: Problems Installing 3.23.31

Try compiling with the static switch set. Check the manual for exact syntax. Pat... - Original Message - From: "Robert Hough" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 23, 2001 8:10 AM Subject: Problems Installing 3.23.31 > I compilied 3.23.31 and I keep getti

Mysql vs. Oracle

Hi, Does anyone know of a good whitepaper comparing mysql with some of the other major databases such as oracle, db2, etc. We are using mysql for most of our internal work and are trying to push it for some of our project work with clients and would like to have a nice white paper that outlines

Problems Installing 3.23.31

I compilied 3.23.31 and I keep getting this error: Cannot open "../libmysql/.libs/libmysqlclient.so" This happens with every client binary, and I can't seem to figure out where this is coming from during compile time. -- Robert Hough ([EMAIL PROTECTED]) -

ALTER TABLE reverts to non-raid

>Description: Using RAID_CHUNKS=xxx alone will revert a RAID table into non-raid >How-To-Repeat: On a RAID table, if you run: ALTER TABLE tablename RAID_CHUNKS=6 It will revert to non-RAID file format. It should either: - apply what the user asked for.

Re: help with mysql++ please

Marten Svensson writes: > I'm currently creating a program where I'm accessing a database using > mysql++. I can't get the "DateTime" type to work, though. > My program works if I use the "Date" type instead, but it's not good > enough! > I can write to the database, but when I try to read

Re: Inheritance

Lee Martin wrote: > > I would like to know whether the latest version of MySQL supports OO > databse design and the Enhanced Entity Relationship Model in particular > Specialization and Generalization. As much as any (generalised) RDBMS. (i.e no). The (excellent) Manual (online) outline what it

help with mysql++ please

I'm currently creating a program where I'm accessing a database using mysql++. I can't get the "DateTime" type to work, though. My program works if I use the "Date" type instead, but it's not good enough! I can write to the database, but when I try to read out a "DateTime" my program hangs. Does

Re: Memory

Yes, read up on HEAP tables in the manual. You have read the manual? Here is a quick rundown. Create HEAP table and read all data into table on startup. When you do an update, do it on HEAP table and to the database on disk. Both should then be in sync. This assumes you don't do many updates.

  1   2   >