What does this have to do with ? (Trademark symbol) The mac line
ending is \r...
Ack, at 4/25/02, Gelu said:
>MySQL not encode characters.In your .txt file are NON-PRINTABLE characters
>which mark the end of line.If you have a HEX editor, you can see in the .txt
>file at the end of every line '
I am facing problem in compiling c++ program using mysql libraries. I am
doing this for the first time. I would appreciate if anyone of you help me
out.
thanks.
folowing is the code
___
#include
#include
#include
#include
#include
int main(void)
{
Hi,
Please ignore if this is not the right place.
I installed mysql on linux mandrake 7.2 over the weekend. However i
want to use it as part of my application and not as some sort of a server. I
wanted to install mysql in my own account. Also i installed using rpm's and
I've been asked to put together a very large (well, it's large to me)
database, and while mySQL is great for my current uses, I haven't had
experience with stuff of this scale.
The database will have about 88 tables, with up to 100 fields per table.
There is a _lot_ of interlinking among the tabl
On Fri, Apr 26, 2002 at 01:28:59PM -0600, Sasha Pachev wrote:
> On Friday 26 April 2002 10:11 am, Jeremy Zawodny wrote:
> >
> > I recently wiped my 4.0.2 slave clean and installed the latest 4.0.2,
> > built from the BK tree. Then I synced it up with a nearby slave
> > running 3.23.47 (using rsy
>Description:
After installing MySQL on my RedHat Linux 7.2 server with MySQL-3.23.49a-1.i386.rpm I
can't run mysqladmin. mysqladmin with any parameter results in a segmentation fault
and core dump. I can run mysql and connect to the test database just fine. Here is the
output from "strace mysq
Hi,
I am running mysql alpha 4.0.2 on solaris 8. I had the following problem:
- I have a table called "call_record" and it has 153501 records. The
call_record.MYD file is of size 72,605,973 bytes. I performed myisampack on
this table, which brings down the table size to 11,411,888. After
myis
Greetings
Mysql has not been used on my server before, and I am the only user who has
ssh access to the system, (any mysqld processes are mine) and have been
trying to get mysql set up and working properly.
Currenlty I have two mysqld processes idle on my system
5404 p2- I 0:00.00 (mysql
Are you using MySQL 4.x sumthing?
I thought that function was taken out and replaced with
mysql_real_connect()?
I may be wrong.
-Original Message-
From: Julie Meloni [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 10:35 AM
To: Tewfic Kidess
Cc: [EMAIL PROTECTED]
Subject: Re: u
Hello All
Many Thanks specialy goto Egor Egorov.
We changed the RAM in the Server .. MySQL has now been Running
(without Crash) for over 48 h .. Problem solved !
Thanks again for your Support !
Cheers
Gavin Woodhatch
NetZone Ltd.
---
I was able to start the mysql server using this suugested by Egor
Egor > safe_mysqld&
[1] 15476
user_obscured:/# Starting mysqld demon with databases from /usr/local/var
nohup
/nfs/usr/libexec/mysqld --basedir=/usr/local --datadir=/usr/local/var --port
=30100 &
but after this response, the ssh s
> Is there any chance at all that a field name is appearing in your
> WHERE clause? For example:
>
> UPDATE foo SET flag = 0 WHERE foo_id = foo_id;
>
> foo_id = foo_id of course matches all.
No, the query is hard coded to "WHERE Sent = 0".
> Not much room for that kind of error in this example
I have a table with a telephone number, rating period and minutes. I
want to run a query grouped by telephone number that will have as
columns:
Phone Number | Sum(where rating period =1) | Sum(where rating period
=2) | Sum(where rating period =3)
I have had very bad luck so far, seems I can o
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Nick Arnett
[snip]
> What seemed to be the obvious solution was to use
> MySQLdb.times.format_TIMESTAMP() or MySQLdb.times.format_DATE()-- but that
> doesn't work, it returns an error:
>
> File "C
Anna Fowles-Winkler wrote:
> Paul DuBois wrote:
>
> > >Paul DuBois wrote:
> > >
> > >> At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote:
> > >> >Well, the function is called like this:
> > >> >
> > >> >mysql_real_query( mysql_connection, query_string, strlen( query_string ));
> > >> >
> > >
On Fri, Apr 26, 2002 at 10:20:41PM +0100, Mike Hall wrote:
> SELECT MailID, MailBody, MailHeaders FROM Mail WHERE Sent = 0;
> UPDATE Mail SET Sent = 1 WHERE MailID = [whatever];
[..snip..]
> As I said, this script runs every five minutes - which means this query has
> been ran around 83,000 time
Paul DuBois wrote:
> >Paul DuBois wrote:
> >
> >> At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote:
> >> >Well, the function is called like this:
> >> >
> >> >mysql_real_query( mysql_connection, query_string, strlen( query_string ));
> >> >
> >> >Wouldn't that pass the correct length?
> >>
>Paul DuBois wrote:
>
>> At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote:
>> >Well, the function is called like this:
>> >
>> >mysql_real_query( mysql_connection, query_string, strlen( query_string ));
>> >
>> >Wouldn't that pass the correct length?
>>
>> Not necessarily.
>
>Uhm... why no
Okay, I am having some trouble with MySQL that could *potentially* be quite
serious. A little background first.
I'm running PHP 4.2.0 (Release) and MySQL 3.23.49a over five servers. One
server is a MySQL Master with PHP CGI version, two are MySQL slaves and the
other two are Apache webservers wit
Paul DuBois wrote:
> At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote:
> >Well, the function is called like this:
> >
> >mysql_real_query( mysql_connection, query_string, strlen( query_string ));
> >
> >Wouldn't that pass the correct length?
>
> Not necessarily.
Uhm... why not? Wouldn't strlen
At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote:
>Well, the function is called like this:
>
>mysql_real_query( mysql_connection, query_string, strlen( query_string ));
>
>Wouldn't that pass the correct length?
Not necessarily.
>
>--Anna
>
>Paul DuBois wrote:
>
>> At 14:03 -0600 4/26/02, Anna
Well, the function is called like this:
mysql_real_query( mysql_connection, query_string, strlen( query_string ));
Wouldn't that pass the correct length?
--Anna
Paul DuBois wrote:
> At 14:03 -0600 4/26/02, Anna Fowles-Winkler wrote:
> >Hi,
> >
> >I have an insert command that I'm executing th
At 14:03 -0600 4/26/02, Anna Fowles-Winkler wrote:
>Hi,
>
>I have an insert command that I'm executing through the C API function
>mysql_real_query. One of my values is a string like this:
>'1;'
>
>When mysql_real_query sees the ;, it thinks it's the end of the
>statement.
That's unlikely. I'd
I'm writing to you about a potential bug.
I am using (trying) the gui for managing the dbs, and it freezes if i
hit a keystroke while looking at a query result.
thanks,
Mike Benson
Web Development
Children's Safety Village of Windsor and Essex County
http://www.rotarysafetyvillage.com
-
I'm have a bit of trouble figuring out how to use a date field retrieved
from MySQL when updating a record in another table. Rather than a date
string, MySQLdb returns a DateTime object. At first, imagining that since
it came out of a field, the date object would also then match the field in a
s
Incident Information:-
Originator:[EMAIL PROTECTED]
Recipients:[EMAIL PROTECTED]
Subject: mysql Digest 26 Apr 2002 19:59:31 - Issue 1870
Message from [EMAIL PROTECTED] was quarantined because it
contained banned content.
Hi,
I have an insert command that I'm executing through the C API function
mysql_real_query. One of my values is a string like this:
'1;'
When mysql_real_query sees the ;, it thinks it's the end of the
statement. How can I prevent that from happening? Is there a way to
escape it?
Thanks very
On Friday 26 April 2002 10:11 am, Jeremy Zawodny wrote:
> Hey Sasha,
>
> I recently wiped my 4.0.2 slave clean and installed the latest 4.0.2,
> built from the BK tree. Then I synced it up with a nearby slave
> running 3.23.47 (using rsync after I had flushed the tables on the
> other slave and
mysqldump does not preserve table name case when dumping tables on my
Windows platform.
Distribution file name: mysql-3.23.49-win.zip
C:\mysql\bin>mysqladmin version
mysqladmin Ver 8.23 Distrib 3.23.49, for Win95/Win98 on i32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
There are couple of ways you can do it.
1) You can use the following sql to find out duplicate rows and then
write few more sql to delete duplicate.
SELECT column(s), count(*)
FROM
table-a
GROUP BY column(s)
HAVING count(*) > 1;
then massage the data with couple of more sqls.
2) This wa
Hello mysql,
Is it possible to take indexed search
by part of the string field (char\varchar)
(eg find "example" by "xam", "ple", "ex", "mp".)
Like a LIKE or REGEXP, but faster (indexed)?
(find all fields containing what part)
--
Best regards,
Yuriy mailt
I'm running RedHat 7.2 with the default install of mysql. For an unknown
reason, mysql refuses to shutdown on a reboot or by typing 'service mysqld
stop'. It used to work and I can't think of anything that I changed.
When I type 'service mysqld stop', I get:
Stopping MySQL: [FAILED]
Any ideas
Hi,
Try ALTER IGNORE TABLE your_table ADD UNIQUE
(column_where_you_dont_want_duplicates);
Regards,
Jocelyn Fournier
- Original Message -
From: "Oswaldo Castro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 26, 2002 8:20 PM
Subject: Duplicate Keys
> Hi List
>
> Sor
Hi List
Sorry for the newbie question.
Im new to MySQL. I have a table that I don't know how many duplicate records
it has, so how do I query and delete all the duplicate (or many multiple)
records from a MySQL table ?
Thanks in advance
Oswaldo Castro
---
Hi,
So I assume in this case the only way to have distinct results is to use
"GROUP BY topic" clause ?
Regards,
Jocelyn
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAI
Anyone know/using SQLRelay w/ MySQL? Any gotchas or wierdness in MT apps
using SQLRelay?
Sorry for the blast, didn't find alot in the deja archives.
TIA,
Chris
-
Before posting, please check:
http://www.mysql.com/manual.ph
Minor change, I think it should be a datetime field not a timestamp field
since timestamps are supposed to be updated by the database.
On Fri, 26 Apr 2002 [EMAIL PROTECTED] wrote:
> Date: Fri, 26 Apr 2002 17:16:06 +0100
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
>
Hello
I installed MySQL version 4.0.1 apha-nt on win2k.
I would like to know how to disable function described below:
"Word MySQL is present in more than half of rows, and as such, is
effectively treated as a stopword (that is, with semantical va
Victoria, you solved my problem!!! (after we spent way too much time trying
to figure out what was wrong with our SQL syntax) Where should we ship the
beer to? Thanks from all of us at BCA!
-
Jerry Jackson
Director of Software Development
Maybe it would be enough if you created a little syntax window on your GUI
and an Execute button beside it, so you could see what was going to be sent
to the engine before clicking Execute.
Just a thought,
Arthur
- Original Message -
From: "Petre Agenbag" <[EMAIL PROTECTED]>
To: <[EMAIL
I do not think MySQL has any scheduling abilities, clever or
otherwise. MySQL just obeys orders. Scheduling (correctly, in
my opinion) is the province of cron and suchlike.
However, I would suggest, if you have control of the search
tools, that you simply put in an extra timestamp field called
"
Works like a dream!
thanks so much.
thomas
On 26 Apr 2002, Diana Soares wrote:
> Hi, try this:
>
> SELECT courses.coursetitle,reservationid
> FROM courses,applicant LEFT JOIN reservation
> ON (reservation.applicantid = applicant.applicantid AND
> reservation.coursesid = courses.coursesid)
>
At 18:12 +0300 4/26/02, Victoria Reznichenko wrote:
>Paul,
>Friday, April 26, 2002, 5:57:56 PM, you wrote:
>
>>>What Mysql function can I use to examine blob in a table. I need to
>>>display part of the blob in hex values. Shouldn't the following sql
>>>command work :
>>>select hex(substring(col1
On Fri, Apr 26, 2002 at 09:54:37AM -0400, Brian Smith wrote:
> I can't seem to find any real currect new about a stable Mysql 4.0
> release, anyone know more about this?
The 4.0.x code is feeling pretty good with a few exceptions: full-text
search (a few folks have encountered bugs), and replica
Hey Sasha,
I recently wiped my 4.0.2 slave clean and installed the latest 4.0.2,
built from the BK tree. Then I synced it up with a nearby slave
running 3.23.47 (using rsync after I had flushed the tables on the
other slave and run a "SLAVE STOP").
I started it up and it ran for about a day bef
Hi Alec,
thanks for this answer.
a) My column is not involved by query
b) But it is necessary to hold it in the database (and I don't want to set
file_priv)
c) And it's as long as a whole document, this means 5-10K
I think, a Primary Key is as good as an Index. I will use one table for
every type
Michael Chang writes:
>
> > For example, have you called mysql_thread_init() before calling
> > mysql_real_connect() in all your threads ?
>
> However, to my understanding, mysql_thread_init() is not needed if
> only one database connection is used, and that database connection
> is established
Hi all,
I have a PHP based web interface that interacts with MySQL to let users
insert data into a table called "Messages". Once an entry is made in this
table, other applications read and process the entries, modifying them where
appropriate.
I would like to add the capability to have this inse
> For example, have you called mysql_thread_init() before calling
> mysql_real_connect() in all your threads ?
However, to my understanding, mysql_thread_init() is not needed if
only one database connection is used, and that database connection
is established when the program starts, before any
Paul,
Friday, April 26, 2002, 5:57:56 PM, you wrote:
>>What Mysql function can I use to examine blob in a table. I need to
>>display part of the blob in hex values. Shouldn't the following sql
>>command work :
>>select hex(substring(col1,1,10)) from table tbl1;
PD> HEX() converts numbers, not
Hello, Jack!
Special characters have a functional meaning to MySQL(and compilers as
well). It is necessary to escape them for any other purpose than the host
enviroments function. In MySQL \ is an escape character therefore, if you
need to pass \ as a string you must escape it \\ . There is a d
>What Mysql function can I use to examine blob in a table. I need to
>display part of the blob in hex values. Shouldn't the following sql
>command work :
>select hex(substring(col1,1,10)) from table tbl1;
HEX() converts numbers, not strings. There is no function in MySQL
for what you want.
I can't seem to find any real currect new about a stable Mysql 4.0 release,
anyone know more about this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
> I have the latest 4.0.2 source installed, and the problem is still here
> AFAIK :
>
> mysql> \s
> --
> mysql Ver 12.1 Distrib 4.0.2-alpha, for pc-linux-gnu (i686)
>
> -=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch
> <(1
What Mysql function can I use to examine blob in a table. I need to display
part of the blob in hex values. Shouldn't the following sql command work :
select hex(substring(col1,1,10)) from table tbl1;
Thanks
-
Before posting
Jerry,
Friday, April 26, 2002, 5:12:57 PM, you wrote:
JJ> I am hoping someone can shed light on this for me. We have a fairly simple
JJ> query that is pulling data from varchar(255) and integer(11) fields and
JJ> concatenating the field contents into a single results column. The problem
JJ> is th
Nick,
Thursday, April 25, 2002, 11:16:02 PM, you wrote:
NG> Egor Egorov wrote:
>>Hm ... I tested .. it works fine for me ...
>>What error did you get when your user tried to lock tables?
NG> Here is the error message:
NG> Error
NG> SQL-query :
NG> Lock Table bugs write
NG> MySQL said:
NG> selec
What Mysql function can I use to examine blob in a table. I need to display
part of the blob in hex values. Shouldn't the following sql command work :
select hex(substring(col1,1,10)) from table tbl1;
Thanks
-
Before posting
At 10:12 -0400 4/26/02, Jerry Jackson wrote:
>I apologize if this is a repost, but I've been having problems with my mail
>servers and don't know for sure what has gone out or come in recently.
>
>I am hoping someone can shed light on this for me. We have a fairly simple
>query that is pulling dat
Greetings,
I'm new to the list and apologize if this question has already been
answered.
I'm trying to figure out how to make a thread die. From the processlist
command of mysqladmin I get back a listing of unauthenticated user that
I want to drop from their connection status.
I issue the ./my
I apologize if this is a repost, but I've been having problems with my mail
servers and don't know for sure what has gone out or come in recently.
I am hoping someone can shed light on this for me. We have a fairly simple
query that is pulling data from varchar(255) and integer(11) fields and
con
>Description:
I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49
with master/slave replication.
The master mysqld is running on one machine, the slave on another.
Everything works fine until I shutdown the master server. The slave
the
I definitely think that, provided it is properly indexed, MySQL should NOT
load
the whole table in order to perform a well phrased query. That is the whole
point of
indexing the database - MySQL can go straight to the results.
How large is your "large" blob? If it is large, and not involved in a
Thanks Jeff, I'll see if it fixes it. I've got round the problem
in the meantime by opening two connections, one to each database,
but that's a bit messy and shouldn't be necessary.
Incidentally, the MySQL page for JDBC
(http://www.mysql.com/downloads/api-jdbc.html)
still offers version 2.0.4 for
Thanks Mark. I've now downloaded 2.0.13 and I'll see if the
problem is still there. Meanwhile I've used a workaround involving
two connections, one to each database, so the insert works.
Not ideal, though.
--Alan
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: T
Whats your INSERT statement look like? And does it give any errors back?
-Nick
> I am
using MySql with Visual Basic.
>
> I Got an ERROR when trying to add a new record in
situation as under.
>
> I have a table Company
> and a field in that table EmpName char
(20)
> and one record is there valu
Andrey Kotrekhov writes:
> äÏÂÒÙÊ ÄÅÎØ.
>
>
> Hmm... I use mysql_init() in each thread but:
>
> 8.4.4.4 my_thread_init()
> .
> This is automatically called by my_init() and mysql_connect().
> ~
>
> And in manual:
> To get a threaded client where you
>Description:
I'm running the precompiled binary of MySQL 3.23.49 on a Compaq
Alpha system running Compaq Tru64 UNIX V5.1.
I run a master mysqld on one machine and a replication slave on a second
machine. Everything works fine, but when I shut down the master,
If I have an InnoDB table, how can I optimize it (like OPTIMIZE
TABLE for MyISAM tables)? I've seen previous posts from Heikki
saying to use ALTER TABLE, as that effectively dumps and reimports
the table, but is that true with the new 3.23.50 version that
actually has a working ALTER TABLE?
I as
RRamasamymani,
Friday, April 26, 2002, 2:32:01 PM, you wrote:
R> It seems that sub queries are not supported in MySQL Version-3.23.48.
You can use JOIN instead of sub-selects, look at:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
http://www.mysql.com/doc/J/O/JOIN.html
R> In t
Muriel,
Friday, April 26, 2002, 1:14:02 AM, you wrote:
M> My ISP installed MYSQL -max-3.23.49a-pclinux-gnu-i686 on our
M> dedicated server. They discovered they did not install their client
M> libraries after I had already created users with the Grant permissions.
How did you create user
this is for php, if you are not using php then try something similar
//use explode to create an array with one word in each item
$sql_array = explode(" ", $sql_text)
//loop thro the array
while(list($val) = each($sql_array))
{
$val = ucfirst ($val);
$new_sql_text .= $val ;
I am using MySql with Visual Basic.
I Got an ERROR when trying to add a new record in situation as under.
I have a table Company
and a field in that table EmpName char (20)
and one record is there value is = "Piyush"
I am trying to add a new record I can add if the value of field is
less then
Hi, try this:
SELECT courses.coursetitle,reservationid
FROM courses,applicant LEFT JOIN reservation
ON (reservation.applicantid = applicant.applicantid AND
reservation.coursesid = courses.coursesid)
WHERE applicant.applicantid = 1
This gives you all courses an reservationid>0 if applicant has
Hi,
I am using MySql Ver ll.15 distrib. 3.23.41
I want to write an sql query something like:
update ddata
set ddata.pubkey = pubdata.pubkey,
ddata.title=pubdata.title
where ddata.dkey=pubdata.dkey;
This generates an error:
ERROR 1109: Unknown table 'pubdata' in where clause
and using thi
Dear MySQL,
It seems that sub queries are not supported in MySQL Version-3.23.48.
In the new release do we have this support? If so, please let me know in
which version i have to look into for this.
Thanks and regards,
R.M.Ramnarayanan,
iNautix Technologies India Private Limited,
Chennai,
India.
Amit,
Perhaps try running your LOAD DATA INFILE statement typed at the
command prompt of the mysql client, and maybe you will get more info as
to what the problem is. You may have a MySQL installation where the
'LOAD DATA INFILE' statement is not permitted by default.
However, the
Amit,
Friday, April 26, 2002, 11:57:28 AM, you wrote:
AL> Can someone help me figure out the following problem.
AL> If i fire the following command from
D:\mysql\bin>> mysql --user=netaps --password=netaps
AL> --host=192.168.100.2 --port=3306 --database=netaps
AL> --execute="LOAD DATA INFILE
AL>
Tony,
Friday, April 26, 2002, 12:15:00 AM, you wrote:
TW>Description:
TW> When dumping the 'mysql' database, the dump file contains syntax errors,
TW> and I can't find where this has been rectified in later releases.
TW> Example dump using 'mysqldump -cl mysql':
TW> [snip]#
TW> # Table structur
Jack,
Friday, April 26, 2002, 10:22:52 AM, you wrote:
J> I had use the Load Data Command to import my CSV file from my client side
J> of pc to the Mysql database which located in Server side.
J> The command i type is follow:
J> Load Data local infile 'c:\\Doucments and
J> Settings\\jack\\Deskto
Andrew,
Friday, April 26, 2002, 3:12:25 AM, you wrote:
AW> Hello, I am new to mysql - past the very basics - you may see a few silly
AW> questions - here is the first.
AW> I have a DELETE statement:
AW> delete bond_master,bond_data from bond_data where
AW> bond_master.cusip=bond_data.cusip an
Amarjot,
Friday, April 26, 2002, 1:23:45 PM, you wrote:
As> I would like to ak what spec should my PC/Server be in order to run MySQL on
As> it?
It depends on your OS and purpose of MySQL usage.
Check the following links, you can find some info there:
http://www.mysql.com/doc/O/p/Operating
Ian,
Friday, April 26, 2002, 12:52:29 AM, you wrote:
IP> I now have two mysqld processes running on my server (Freebsd / apache), and
IP> no mysql (according to a ps command).
IP> What is the safe way to kill these two, and restart mysql?
If you really want to kill, you may use "kill PID" (but
Incident Information:-
Originator:[EMAIL PROTECTED]
Recipients:[EMAIL PROTECTED]
Subject: mysql Digest 26 Apr 2002 10:54:14 - Issue 1869
Message from [EMAIL PROTECTED] was quarantined because it
contained banned content.
That's the point: Users are added about 10 times less than "objects". But
your objection about new columns is right, also about system performance. I
would have said the main problem is on a query like "show all users with
their last object" for an overview, this would be a very hard job (I think
Hi!
> "ydbxmhc" == ydbxmhc writes:
ydbxmhc> Good day, everyone, and thank you for your time!
ydbxmhc> I am not a member of the mailing list (I had to swear them off as
ydbxmhc> addictive =o) but am posting this question in the hope that some
ydbxmhc> generous soul will assist me anyway.
> My first two questions could not be answered, so, maybe I'll be luck w/
> third.
>
> A performance question: If I have user numbers and "objects" belonging to
> them(e.g.bills), is it better to have one table "bills" with many rows or
to
> have one table for every user? This means, is it bette
> What error occurs if i try to access (read or write) a table that was
locked
> (LOCK TABLES mytable WRITE) by another thread?
My belief is that you do not get an error. The thread attempting to access
the
locked table is stalled until the lock is released. If the lock is never
released, you
After two days of trying I cracked it.
Modify
/etc/my.cnf
[client]
socket=/tmp/mysock.sock
[socket]
socket=/tmp/mysock.sock
Edit
/usr/local/lib/php.ini
"mysql.default_socket="/tmp/mysql.sock"
Type
mysqladmin --socket=/tmp/mysql.sock
--
Hi,
I sent the following e-mail to the msql-mysql-modules list earlier today
regarding a deadlock error using DBD::mysql.
I was advised by Jochen Wiedmann that DBD::mysql is simply a thin layer
on top of the C interface, and that I should therefore forward my
problem to this list, so here goe
Hi
I would like to ak what spec should my PC/Server be in order to run MySQL on
it?
Thanks
Amarjot
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
Hi Ian,
1.What version of Linux use ?
2.Type "top" and you can see at least 4 mysqld processes.Is nothing bad.And
for every new connected client apear a new mysqld process.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
My first two questions could not be answered, so, maybe I'll be luck w/
third.
A performance question: If I have user numbers and "objects" belonging to
them(e.g.bills), is it better to have one table "bills" with many rows or to
have one table for every user? This means, is it better to do a sql
äÏÂÒÙÊ ÄÅÎØ.
> Andrey> Are mysql know about this!!!
>
> Sorry but if your OS doesn't support gethostbyname_r(), then
> mysql_real_connect() is not thread safe (I have just updated our
> documentation about this)
Thank you.
>
> Another issue is that if your client dies in the dbug_ code, this
>
Hi,
What error occurs if i try to access (read or write) a table that was locked
(LOCK TABLES mytable WRITE) by another thread?
Dirso.
PS: MYSQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
>
> exec(): 0509-036 Cannot load program mysql because of the following
> errors:
> 0509-150 Dependent module libreadline.a(libreadline.so) could
> not be loaded.
> 0509-022 Cannot load module libreadline.a(libreadline.so).
> 0509-026 System error: A file or direct
On Fri, 26 Apr 2002 18:27:24 +1000
"Ian Phillips" <[EMAIL PROTECTED]> wrote:
>
> Thanks to Gelu for his patience: unfortunately his suggestion of
> Gelu> Go to /etc/init.d and type : ./mysql(d) restart
> didn't work for me, as I do not have init.d in /etc - I have searched for
> ti, but not ther
Is the socket file just a location for mySQL to place the socket
information?
i.e. the file doesn't have to be there, as Mysql will create it when it
runs.
Am I understanding this correctly?
[EMAIL PROTECTED]
---
"Life must be lived as play."
-
Hi All,
Can someone help me figure out the following problem.
If i fire the following command from
D:\mysql\bin> mysql --user=netaps --password=netaps
--host=192.168.100.2 --port=3306 --database=netaps
--execute="LOAD DATA INFILE
'D:\\NetapsFiles\\jobsequence.csv' INTO TABLE
jobsequence FIELDS TE
Dear Group members
Well I'm a bit stumped
I've gone around a few times trying to get mysql working again on my server.
Here is a current list of processes running - and it seems that mysqld is
running (twice) - bother are idle (I). Is it safe to send a kill command to
these processes? (and what
1 - 100 of 107 matches
Mail list logo
