that fixed it!
thanks!!!
donnie
>This depends on your OS. On SCO OpenServer or UnixWare this is needed.
>
>LD_LIBRARY_PATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/local/mysql/lib/mysql:/usr/local/BerkeleyDB.3.2/lib
>LIBPATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:
>
>export LD_LIB
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
Pet
I'm having sometrouble getting MySQL running on our osxs. I've
downloaded the latest osxs binary from mysql.com.
When I try to run the mysql_install_db I get the following error:
dyld: ./bin/mysqld can't open library: /usr/lib/libpthread.A.dylib (No
such file or directory, errno = 2)
when I l
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.
tengo una caja roja de lapices!
Jay
[EMAIL PROTECTED] wrote:
> Lanzamiento para San Valentín!
>
> Hola!
>
> http://www.postalesreales.com
>
> Te imprimimos, franqueamos y enviamos tu postal física personalizada desde España a
>cualquier parte del mundo, incluyendo dentro de la peninsula Ibéric
>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 look
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
-
Be
1: Your no more of an idiot than the rest of us. You just weren't around to
see my newbie phase. Doesn't mean it didn't happen. :)
2: You need to select all your records into a temp table, drop your existing
table re-create it with the proper structure and then insert your records
back into it.
Lanzamiento para San Valentín!
Hola!
http://www.postalesreales.com
Te imprimimos, franqueamos y enviamos tu postal física personalizada desde España a
cualquier parte del mundo, incluyendo dentro de la peninsula Ibérica.
Si estas en Latin America, aproveche las tarifas de envío local para en
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
---
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.
.
.
x mysql-
>Hi there
>
>the case:
>- one table with users (tblUser)
>- one table with groups (tblgroups)
>- one table with user-group links (tbluserlink) - describes which groups one
>user belongs to, in a many-to-many relationship
>
>
>the question:
>I want to make a select where I get all the users, that a
I remember trying out a really nice Java GUI for mysql, had a yellow and
gray color scheme if I remember correctly, and was very nicely done. The
only thing I can find the the GUI clients page at mysql.com is one so-so
client that doesn't do what I need. Anyone maintaining a list of all the
availa
Sorry if this is a double posting.
Hello,
I updated to 3.23.32 and now this happens:
mysql> show databases;
+--+
| Database |
+--+
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|
Hi,
I was the idiot who had it set to tinyint. But now i want to change the
column id to int... so i typed this and got an error:
mysql> alter table custinfo change id id int NOT NULL AUTO_INCREMENT;
ERROR 1062: Duplicate entry '1' for key 1
What do i do to change it from tinyin
Hello,
I updated to 3.23.32 and now this happens:
mysql> show databases;
+--+
| Database |
+--+
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|
On Fri, 9 Feb 2001 13:46:45 -0800, [EMAIL PROTECTED]
([EMAIL PROTECTED]) wrote:
>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 tri
On Fri, 9 Feb 2001 13:46:45 -0800, [EMAIL PROTECTED]
([EMAIL PROTECTED]) wrote:
>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 tri
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 varchar(
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 tes
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-
Fro
Hi.
Well, of course, the RDBMS (here MySQL) is handling table locking (not
only with BDB tables).
But, because this seems rather obvious to me, maybe I misunderstood
your question?
Bye,
Benjamin.
On Thu, Feb 08, 2001 at 02:54:47PM -0800, [EMAIL PROTECTED] wrote:
> Hi,
>
> One thing I
- Original Message -
From: "Steven Fruchter" <[EMAIL PROTECTED]>
> 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
Benjamin Pflugmann wrote:
>
> Hi.
>
> On Thu, Feb 08, 2001 at 02:48:15PM -0700, [EMAIL PROTECTED] wrote:
> [...]
> > While we are (were) on the subject.. Any thoughts why like would not be
> > using an index in this case?
> >
> > mysql> explain select * from _data where datatime like '12:00:%';
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 m
CREATE TABLE custinfo
(
id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT,
);
1. Your primary key is on a TINYINT field.
If TINYINT is SIGNED,
possible values are... -127 to +127
If TINYINT is UNSIGNED
possible values are.
Thanks all,
All of your comments helped a lot and our site is running much smoother now.
The things that made the most improvement was getting rid of a join on
another page that was somewhat easy to replace with two mysql calls.
Also, my tables were all ISAM tables, I think changing them to MYI
How about
'Mel\\''nikova'
??
mvh:
Pål Wester, programmerer
never.no as, stortingsgt 30, 0161 Oslo
tlf: 22 01 66 20, fax: 22 01 66 21
direkte: 22 01 66 34, 906 900 62
http://never.no - icq:103476059
~ f u cn rd ts u prb a gk ~
> -Opprinnelig melding-
> Fra: Anna [mailto:[EMAIL PROTECTED]
Hi.
On Thu, Feb 08, 2001 at 02:48:15PM -0700, [EMAIL PROTECTED] wrote:
[...]
> While we are (were) on the subject.. Any thoughts why like would not be
> using an index in this case?
>
> mysql> explain select * from _data where datatime like '12:00:%';
> +---+--+---+--+---
Hi.
On Tue, Feb 06, 2001 at 05:14:39PM +0300, [EMAIL PROTECTED] wrote:
> Hello Pelle,
>
> Tuesday, February 06, 2001, 3:49:53 PM, you wrote:
>
> PE> Hi,
>
> PE> I think I have a problem with performance.
> PE> In my Mysql db I have two tables user (U) and service (S).
> PE> I want to read exe
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 uni
> I have a data item (stored as a varchar) that looks like this:
>
> Mel\'nikova
>
> fieldname='Mel\'nikova' doesn't match it. Neither does
> fieldname='Mel\\\'nikova'. fieldname='Mel%nikova' does produce a match,
> and so does fieldname='Mel__nikova' (which leads me to believe that
> mysql tr
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 key
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 socket
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 k
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]
-
[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
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
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/
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 artic
You must remember, though, that for every person who has a problem
posted to this list, there are probably hundreds who don't ;-) I'd
hazard that RH6.2 is the single most popular platform for running
MySQL.
If I learned anything while teaching myself linux a year ago, it was
to use source instal
"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
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 ODB
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
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
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 ru
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 i
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 onc
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:
http://www.mysql.com/manual
I've run in to a bit of a problem with compiling MySQL. It compiles fine
without the patched berkeley db. However when I add it in to the config,
either by --with-berkeley-db= or the other two. I get this error. Can
someone please tell me what's going on here and let me know how to get past
this p
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 server
Hi!
Is this code buggy?
...
mysql_res = mysql_store_result(mysql);
if (mysql_errno(mysql) == 0 && mysql_num_rows(mysql_res) > 2 &&
mysql_num_fields(mysql_res) > 2)
{
MYSQL_ROW row1 = mysql_fetch_row(mysql_res); // can i fetch several rows
and then work with them?
MYSQL_ROW row2 = mysql_
Hello,
In an earlier post I complained of performance problems with ODBC+MySQL
when running a server which makes many 'small' queries and writes. What is
the overhead? The benchmarks indicate that MySQL via ODBC is perhaps only
2x slower than MySQL alone, yet the performance we are experienc
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 t
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
don
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?
Thanks
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 [pass]
but thats another problem. The previous pr
I had a problem like this once with another product on Solaris. It turned
out to be an OS version issue. I had to re-install the OS and back rev it
to Solaris 2.7 instead of 2.8.
This may (or may not) help.
Brady...
Original Message Follows
From: del <[EMAIL PROTECTED]>
To: [EMAIL
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
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:
h
Hi, readers of the mailing list!
I promised to report to the mailing list every week how the interfacing of
MySQL and the Innobase engine progresses. Innobase will provide transactions,
rollback, row level locking, and Oracle-style non-locking consistent read
to MySQL. It currently runs on Intel
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
I was wondering if someone could help advise me on calculating
database size estimations. Assume the following table:
Field Type NullDefault
typeenum('user','group') No user
id smallint(6) No 0
action smallint(6) No 0
flagenum('
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 using
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
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...
>
Hi there
the case:
- one table with users (tblUser)
- one table with groups (tblgroups)
- one table with user-group links (tbluserlink) - describes which groups one
user belongs to, in a many-to-many relationship
the question:
I want to make a select where I get all the users, that are in the s
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 s
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???
---
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 /dir/to/mysql.serve
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 sugge
>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 "lca
>hi
>
>does mysql support any equivalent of DECODE in oracle?
>i have been looking all over for info on this, but
>cannot find any. i have several SQL scripts in our
>code that use the decode stmt, and now that some of
>our stuff is being ported to MySQL, i have hit a wall.
>
>
>will i have to get
Hiya Linsen
First off all I'm not sure if you can SELECT and DELETE at the same time, so
you might want to make a script (PHP?) that SELECT's the appropriate rows
and deletes the ones with duplicates. Yes, I normally work with MySQL/PHP
combined! *smile* On the other hand you could make a query u
On 09.02.2001 11:35:27 T. Stephen Dachtera wrote:
> 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!
Create a cron job
There'll be a .err file in your ~mysql/var directory - have a
look at it, and it should give you a pointer as to the precise problem.
regards,
P
On
Fri, 9 Feb 2001, Matt Davis wrote:
> I am new to MySQL and have just installed the MySQL rpm files to my Linux
> box.
>
> I have run "mysql_insta
Hi there,
we have two databases replicating perfectly now, though we have a big
doubt now: How should we rotate the binary logs without a problem?
I was checking out the PURGE MASTER LOGS command in the Manual. The text
below was taken from there:
"Available starting in Version 3.23.28. Delete
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 "
exit 0
fi
for i in `ls /var/mysql|grep -E -v ".pid|.err"` ; do
DB=$i ; DATE=$BACKUPTYPE ; r
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
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 wa
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 I
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,
David J. Potter writes:
> Hello,
> Until recently I have spent most of my time using the major databases such
> as Oracle, DB2, Sybase etc. I am new to MySQL. At first I was excited
> about such a low cost alternative such as MySQL, and I have found Mysql to
> be a great database for very s
Geoff Coffey writes:
> Has anybody successfully built 3.23 on Mac OS X Public Beta? Does anybody
> know if the version it supposedly builds under is a later beta? I still
> can't seem to get it to work properly.
>
> Thanks,
>
> Geoff
>
Hi!
You will find some binaries on the 3.23 page
Hanneke Kroon writes:
> See bugreport below.
>
> -Original Message-
> From:[EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent:Friday, 09 February, 2001 10:38
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: mysql-3.23.32-dec-osf5.1-alphaev6 dies on DECthrea
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
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 my
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 (therefor
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
---
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 posting,
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 =
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 --skip-grant-tabl
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 - [EMAIL
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
From: Suresh Kumar R <[EMAIL PROTECTED]>
> I want to have the absentee list of students per hour_of_day
per day for a week, done for the entire course.
>
> One possibility I thought was to create a table with date and
each hour of the day as columns, then each cell would have to
have variable num
Hiya rookie
Take a look at this URL :
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html
It helped me getting started with PHP and MySQL. And let me know if you need
some more "rookie"-help!
Yours sincerly
Jacob "Techek" Kamp Hansen
- webmonkey at Portaltjenesten
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
-Op
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 h
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 column1
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 request
100 matches
Mail list logo
