Concurrent insert/select with BDB

Hi I'm using MySQL 3.23.32 on Linux. I try to run concurrent insert/select requests on BDB tables, but it doesn't work. I started mysqld with --bdb-shared-data option. I run mysql on 2 clients (on the same computer). The first one runs a select request and the second one runs an insert

INSERT...SELECT

Hallo to all! I have troubles with one particular INSERT...SELECT. I have found no example in the manual and other -general- advices on the net do not work with MySQL. Could anyone help me with this: I have four tables. I would like to insert specific records from table1 to table 2 in

SV: HOW DO I CAN DO THIS... you CANT!

Hiya Tonu You seem to have big problem - not of how a database works, but of what a database and webpage can actually do. I'm not trying to sound like a smart-ass, but I suggest you go and take a look at this URL : http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html It

SV: Simple datatype question

Hiya Joel You're right, but have a look at ENUM (and SET later on!). The ENUM-type can be defined as being either 'yes'/'no', '1'/'0' or even 'Techek'/'Joel' *hehe* Happy coding! Yours sincerly Jacob "Techek" Kamp Hansen - webmonkey at Portaltjenesten A/S - developer at Amante.dk

BACKUP command external script.

I am wondering, if it is possible to use MySQL and create a shell script to backup tables from a database on a cron? If anyone has an idea if this is possible, and how I might go about it, it would be much appreciated! Thank You - Tim -- Tim Dachtera -

MySQL error 2002

I am getting this error ERROR 2002: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111) I am running redhat 7, apache, and PHP on this machine. It is preventing me from starting the sql server, however, I'm able to bypass this with safe_mysqld

How I can delete date from tables concerned with indexes?

Hello! How I can delete date from tables concerned with indexes? For example: DELETE FROM table1,table2 WHERE table1.table1_id = table2.table1_id and table2.status = 'example'; or DELETE FROM table1 WHERE table1.table1_id = table2.table1_id and table2.status =

Threads

Hi, our problem is that we are having more and more threads of mysqld (on Linux), so that we get a "too many connections" error. Are the threads terminated automatically? How are the threads generated? Ghaleb - Before

Re: How many tables in a database?

I have 6500 tables under one database there is no problem i hope that helps :) -- Kissandrakis S. George [[EMAIL PROTECTED]] Network and System Administrator [http://www.phaistosnetworks.gr/] Tel/Fax: (+30 892) 24450/23206 Phaistos Networks S.A. - A DOL Digital Company

Re: Client library - Exception handling?

Chris Hundley writes: Are you suggesting that I look at the mysql++ code as an example, or actually use the mysql++ code instead of the "mysql.h" included libraries? Chris HI! You can not look at mysql++ code and code like that with C API. You should either use C API (therefore no

Re: how do I contribute a binary distribution?

Eric Sven Ristad writes: How do I post a new binary distribution for inclusion in the page http://www.mysql.com/downloads/mysql-3.23.html ? I would like to contribute a standard binary distribution for DEC OSF 4.0D (Alpha) [mysql-3.23.32-dec-osf4.0d-alphaev56]. Compiling mysql

Re: Please help with mysql++...I'm very frustrated.

Mike W. Baranski writes: All of the examples from teh mysql++ docs show hte connection as: Connection con("mysql_cpp_data"); whenever I run this statement, I get a seg fault. What is the problem? My permissions are okay, I don't need any for mysql. Someone please help, I'm stuck here

Re: Crashing in win2000

Jamie writes: I'm finding that msql 32-bit is somehow crashing when ever I play audio - either from a CD in my CDrom or m3ps via Creative player II and winamp respectivly. Does anyone else know of this or experienced this? Jamie Hi! This is a list for MySQL, not MSQL. Regards,

RE: BDB

When using the BDB tables and RedHat 6.2 or 7.0, should --skip-locking be used or not? I know it was recommended for earlier versions of RedHat, like version 5.x. Thanks in advance, Rick - / Rick Mehalick Senior Consultant / Shell Services

Need help with Install of MySQL

I am new to MySQL and have just installed the MySQL rpm files to my Linux box. I have run "mysql_install_db" with no problems and I have then run "safe_mysqld " this comes up with the messsage "starting mysql daemon with databses from /var/lib/mysql mysqld daemon ended" I assumed that this

Re: How to create table in this case

Hi, Thanks for your comments. In this table the entries would look like this: student_id hour_of_day day_of_week week_of_course 1 1 1 1 6 1 1 1 14 1

Re: BACKUP command external script.

My script backuping up alla databases which is in my datadir. It's works for me. #!/bin/sh USER=root PASSWORD=somepassword BACKUPTYPE=daily if [ -x $BACKUPTYPE ] then echo "$0 Backup typ" exit 0 fi for i in `ls /var/mysql|grep -E -v ".pid|.err"` ; do DB=$i ;

Re: Help with SQL statement please.

I hope somebody may of come across this sort of problem before dealing with counting total records in subcategories. I have two tables sslinks which contains links (URL) information and sslinkcats which contains category information. The category table "sslinkcats" has a field called "lcat_id"

libz.so.1 error

Greetings, I get this error msg:: Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or directory Killed Installation of grant tables failed! however /usr/local/lib/lib.z.so.1 does exists...and I did NOT create the mysql:mysql user... Any

Re: Need help with Install of MySQL

Matt, I'm fairly new to MySQL myself, but it sounds like your mysqld is not starting up when you issue safe_mysqld. Instead of invoking safe_mysqld directly, find the "mysql.server" file that got installed with mysql, and start mysqld with that by doing something like: cd

Antwort: Re: How many tables in a database?

On 09.02.2001 12:01:01 Kissandrakis S. George wrote: I have 6500 tables under one database there is no problem Pardon me, but how do you keep track of that many tables? I mean, I've a hard time with 10 or 20 tables - but 6500???

Re: Space problem?

Wyatt James wrote: I am getting a misleading error message saying "duplicate key 127 at key 1" when trying to add an item to a table. There is no duplicate (I downloaded then uploaded to a new table and get the same error). The unique key is a smallint(4) with auto-increment. Is there some

Re: libz.so.1 error

On Fri, 9 Feb 2001, del wrote: Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or directory Killed Installation of grant tables failed! however /usr/local/lib/lib.z.so.1 does exists...and I did NOT create the mysql:mysql user... Any

Re: How to create table in this case

Hi, On Fri, Feb 09, 2001 at 05:51:08PM +0530, Suresh Kumar R wrote: In this table the entries would look like this: student_idhour_of_day day_of_week week_of_course 1 1 1 1 6 1 1

Persistant Connection

Good Morning: We have a system of databases (in the plural) which number in the hundreds on individual servers. I want to open a persistant connection on the server and switch databases without closing the handle in DBI and reopening it. Is this possible without getting a rollback warning

[Fwd: Re: Rotating the BINLogs]

I'm not the only one confused. Any ideas? Original Message Subject: Re: Rotating the BINLogs Date: 9 Feb 2001 12:37:03 -0300 From: "Rodolfo Sikora" [EMAIL PROTECTED] To: Leonardo Dias [EMAIL PROTECTED] I'm really confused like you. I've been using flush logs on master... I

What is involved in running ASP scripts, MySQL SERVER on Cobalt Raq3

Just what the subject said. What is this going to take to get ASP talking to a mysql database on a Cobalt Raq 3 Server(A flavor of Linux). Is it costly? What is it going to take? Thanks BK - Before posting, please check:

FULLTEXT

I have a query that works : $sql = "SELECT questions.qid, questions.title, MATCH questions.title, questions.question AGAINST ('support') as relavance FROM questions ORDER BY relavance DESC LIMIT 0, 50"; I would like this query to also match results from the field respons in the table respons. I

rpm files and source distribution

Hi, I am trying to install the MySql rpms or source distribution to my RedHat 6.2, when I install the rpms, I always get an error "Query of MySQL-3.22.32-1.i386.rpm failed.", if I download the source packages, I can not unzip it because it is not complete. Have you met this error before?

How do tables break?

I'm had the exact same problem. I believe it happened becuase my the drive was full when I tried to make an insert. But now I can't seem to access that table at all. I've been able to get in the actual file, mine is call Elemenets.MYD but I can't do anything with it. ANy help would be great. I

RedHat 6.2 (re) installation failure

Hi I am running RedHat 6.2 and notice that there are serious problems running MySQL on it. There are lots of posts on the email lists about the the installation hanging at 'Installing all prepared tables'. Users normally manage to do one install, the db runs for a while, then it's impossible

Load question

We are currently running Blackboard 5 level 1 (an online course management package) which utilizes MySQL v3.22.32. Our previous semesters saw a course load of approximately 85 courses under which, MySQL performed extremely well. This semester, we have skyrocketed to 768 courses. Now, our

SQL_SLAVE_SKIP_COUNTER not working

I've been trying a lot and the SET SQL_SLAVE_SKIP_COUNTER didn't work... what should I do then? -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - Before posting, please check:

load data infile question

I have a one time load of an extremely large file. It's a tab delimited file, the problem I'm getting is importing the following field. C:\Borland\server\bin\gbak.exe- The field how it looks on the import file (it's delimited by tabs) C:Borlandserver ingbak.exe - How it looks

Re: Load question

Saying your up to 768 courses doesn't give us much information. How many queries/second is the server handling right now? My machine, which is considerably slower than yours handles 10 queries/second without blinking an eye. When we were experiences an extreme slow down before, we found three

Re: RedHat 6.2 (re) installation failure

David Vender wrote: Hi I am running RedHat 6.2 and notice that there are serious problems running MySQL on it. There are lots of posts on the email lists about the the installation hanging at 'Installing all prepared tables'. Users normally manage to do one install, the db runs for a

Re: lockup in test suite on SGI

On Friday 09 February 2001 09:19, Robert Marchand wrote: Hi, this is a follow up to my problem with the test suite on an SGI O2 with Irix 6.5.8f I manage to pass through all the tests without problems but a very long 'select' test: select 0,209 0,336 239,115

Error Codes for MySQL

Hi all. I have a problem with one of my tables. I can get a count of records, or simple selects, but if I go any more complex, I get an error "ERROR 1030: Got error 127 from table handler". I can't seem to find any documentation that further explains these types of errors. Is there anywhere I

VBScript and mySQL

Hello, I am having trouble connecting to a mySQL server through VB Script via myODBC... When I used to use Access I used this script to connect: Qt = Chr(34) Set caldb = Server.CreateObject("ADODB.Connection") caldb.Open "caldb" Which returned an error: Microsoft OLE DB Provider for

Re: Error Codes for MySQL

"Bass, Benjamin" wrote: Hi all. I have a problem with one of my tables. I can get a count of records, or simple selects, but if I go any more complex, I get an error "ERROR 1030: Got error 127 from table handler". I can't seem to find any documentation that further explains these types

Switching SQL Databases

Hello, I'm delurking to ask if any of you are willing to share your SQL database expertise with me. I'm a features writer working on a story about the issues and problems encountered while switching SQL databases. If anyone would like to share your experience, or find out more about the

Queries

Hello, When you create a query, how do you save it? Is there a special command to save a query? Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: lockup in test suite on SGI

Hi, the thing is if I start mysql as root with '--user mysql' I get the 'cannot create new thread' thing which is why you put the CAP_SCHED_MGT thing in the manual I suppose. But if I do an 'su' it works just alright without any need of this privilege, and it is only in this context that

Re: Queries

[EMAIL PROTECTED] wrote: Hello, When you create a query, how do you save it? Is there a special command to save a query? Thanks Mark Query is just text... if you are in unix under mysql monitor you can do \e on any line after you run the query (and before you type a new one)

Testing my Eudora Filtering

Sorry to clutter up the list, whici is quiet right now, but i want to test my Eudora filter. Thank you. Dave Anderson Software Engineer Library Management Systems Northwestern University Library Voice:(847)491-8305 Fax:(847)491-8306 Email: [EMAIL PROTECTED]

Newbie Questions

Just got mysql running (Ithink) on Redhat Linux 7. The version is mysqladmin Ver 8.8 Distrib 3.23.22-beta, for redhat-linux-gnu on i386 TCX Datakonsult AB, by Monty Server version 3.23.22-beta-log Protocol version10 Connection Localhost via UNIX socket UNIX

Please HELP easy ANSWER

Hi Everyone, I have a big problem, that I bet could be solved pretty simply but I am new to mysql so its killing me and my database. Ok heres the problem, suddenly out of no where when my php script tries to (or manually) do a insert it says: ERROR 1062: Duplicate entry '127' for

Re: amazingly slow

Hi. You may want to try a combined index (RecordNumber, WordNumber) on wordindex, because the indexes you have can only restrict on field (RecordNumber in the EXPLAIN below) e.g. ALTER TABLE wordindex ADD UNIQUE(RecordNumber, WordNumber); I presume that the RecordNumber/WordNumber pairs are

Re: Performance issues.

Hi. On Wed, Feb 07, 2001 at 03:01:28PM -0500, [EMAIL PROTECTED] wrote: [...] We have one table with all the defintions on it's own row. Then we have built off of that table another table that is only the distinct words, no definitions. This is because if a word has 10 definitions, it makes

Weird - Was: Problems compiling MySQL

Problem: see below. For some reason mysql doesn't like db to be outside of the directory. It compiled fine when I moved the db directory in to the mysql source directory and reconfiged so that it saw the berkeley db library. Has anyone else had this problem? Jamie -Original Message-

HELP!!!

Help! I just installed the most recent release and the only thing I'm getting is... mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | +--+ 6 rows in set (0.00 sec) (The output should be mysql and

Re: Please HELP easy ANSWER

Try this instead: CREATE TABLE custinfo ( id int(11) DEFAULT '0' NOT NULL AUTO_INCREMENT, date date, name varchar(50), card varchar(22), exp_date varchar(7), authcode varchar(8), amount double(4,2), tax double(3,2), pnref varchar(16), address text, city tinytext, state varchar( 3), zip

HELP!!!

Hello, I updated to 3.23.32 and now this happens: mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

help on mysql and cold fusion setup (urgent)

hi i have setup a mysql database foo_db and when i goto admininstrator of coldfusion to setup the odbc, the databsourse is foo_db and i select merant mysql drive, then click add. the verify is fail can anyone tell me what am i does wrong ? i using linux 6.2, coldfusion pro 4.5 thanks Wong

ISAM and MYISAM

Hi, I've read some people talking about ISAM and MYISAM table. I dont understand what are those tables and can anyone explain to me and the difference of each table. and also which one has better performance? thanks Teddy -

MySQL dies, fails to restart (address already in use)

Description: After running for a variable amount of time, our server will just die. We have run myisamchk several times, with -r and with -o. We even checked the actual file system for corruption. This is a real problem when the server doesn't automatically restart. This is what the log

Re: Nuevo! Postales reales por la web

tengo una caja roja de lapices! Jay [EMAIL PROTECTED] wrote: Lanzamiento para San Valentn! Hola! http://www.postalesreales.com Te imprimimos, franqueamos y enviamos tu postal fsica personalizada desde Espaa a cualquier parte del mundo, incluyendo dentro de la peninsula Ibrica. Si

Re: a bug during tar .........

go and get gtar (GNU tar) donnie At 10:28 AM 2/10/2001 +0800, 163 wrote: Dear sir: I downed mysql-3.23.32.tar.gz, first i extrat mysql-3.23.32.tar from gz file,then I use command "tar -xvf mysql-3.23.32.tar ", an error occured, I copy the last 3 line to you! My OS platform is UnixWare 7.11.

Re: BDB

Hello Michael, Friday, February 09, 2001, 3:48:53 AM, you wrote: Peter as you see here one thread is doing repear as this happened after Peter mysqld crash, but note first insert query in system lock state (I've Peter saw several queries at this place, but all of them spent in system Peter