Socket connections do not use tcp (meaning localhost)
Remote hosts use tcpip
Sent via BlackBerry from T-Mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
The socket hets created when you start the server
It might be in the mysql home dir, it might be in /var/run.
See if its declared in my.cnf
Sent via BlackBerry from T-Mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
From: Andy Shellam
To: Lamp Lists
Cc: mysql@lists.mysql.com
Sent: Wednesday, December 17, 2008 2:48:31 PM
Subject: Re: need help with query...
Hi,
>
> Hi Andy,
> the reason I can't use this because fields (columns) in select statement
&
From: Andy Shellam
To: Lamp Lists
Cc: mysql@lists.mysql.com
Sent: Wednesday, December 17, 2008 2:29:08 PM
Subject: Re: need help with query...
Hi Afan
Why not prefix your field names with the table name?
select
p.first_name AS person_first_name
.
not exactly this way but something like this:
$data = array(
'people' => array('lamp', 'lists', 1, '2008-12-12'),
'organization' => array(56, 'Lamp List', 'web'),
'addresses' => array('123 Main St.', 'Toon Town', 'NY', '12345')
}
thanks for any help.
-afan
- Original Message
From: John Hicks <[EMAIL PROTECTED]>
To: Lamp Lists <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Tuesday, July 8, 2008 11:20:16 AM
Subject: Re: which query solution is better?
Lamp Lists wrote:
> hi,
> I would like to get your opinions reg
hi,
I would like to get your opinions regarding which query you think is better
solution and, of course - why.
I have (very simplified example) 3 tables: orders, members and addresses
I need to show order info for specific order_id,
solution 1:
select ordered_by, order_date, payment_method, order
Thanks.
Though, I added, repair table, restarted mysql - and
the same
:(
-ll
--- Warren Young <[EMAIL PROTECTED]> wrote:
> Lamp Lists wrote:
> > I need to change ft_min_word_len fro 4 to 3. the
> > proces is very well explained on mysql.com
> > though, when open
hi,
I need to change ft_min_word_len fro 4 to 3. the
proces is very well explained on mysql.com
though, when open /etc/my.conf can't find the
ft_min_word_len line?
when check is there:
mysql> show variables like 'ft_min_word_len'
ft_min_word_len4
am I looking at the wrong file or something?
--- Lamp Lists <[EMAIL PROTECTED]> wrote:
>
> --- Lamp Lists <[EMAIL PROTECTED]> wrote:
>
> > hi,
> > I created table "tasks"
> > create table tasks(
> > task_id, int(4) not null primary key,
> > task text not null,
> > res
--- Lamp Lists <[EMAIL PROTECTED]> wrote:
> hi,
> I created table "tasks"
> create table tasks(
> task_id, int(4) not null primary key,
> task text not null,
> resolution text not null,
> fulltext (task, resolution)
> )engine=myisam
>
>
hi,
I created table "tasks"
create table tasks(
task_id, int(4) not null primary key,
task text not null,
resolution text not null,
fulltext (task, resolution)
)engine=myisam
when I run
seect * from tasks match(task,resolution)
against('"certain service"' in boolean mode)
I would get one reco
hi,
I have table, something like:
create table example (
ex_id integer(8) not null auto_increment primary key,
ex_col1 int(8) null,
ex_col2 int(4) not null,
index(ex_col1),
index(ex_col2)
)engine=myisam;
ex_col1 and ex_col2 are indexed separately.
It's been a few years since I did any regex queries, but I swear I used
to be able to do something like:
SELECT fieldname FROM tablename WHERE field RLIKE '(^|\|)2(\||$)';
And that would find '2', with an optional '|' at the beginning, or at
the beginning of the line, and an optional '|' or en
Does anyone have a clever way that I can sort on two fields? Let me
explain...I need the sort to be by the "uid" field (see below), but also
have the "parent" field taken into consideration:
Here's a sample of what I get now:
+---+---++
| uid | duplicate | parent |
+---+
> Hi Joseph,
>
> Joseph Koenig wrote:
>> Hi,
>>
>> I'm running MySQL 5.0.27-standard-log on RHEL 4. After install, I moved the
>> data directory of MySQL. I updated everything that SELinux complained about,
>> etc., and have a functional install of MySQL. It's actually been up and
>> running wit
Hi,
I want to update a table if it meets some conditions (already exist)
and INSERT otherwise?
Right now I am doing it this way:
1. SELECT the record
2. If it exist, I UPDATE it
3. If it does not exit, I INSERT a new record
Could this be done in one query? I mean like conditional update/ins
hi
i need help regarding a sql query in my php app.
the query is :
$SQL = "SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes'
LIMIT $startingID,$items_numbers_list";
i want to sort this query by the number of the repeated EMail counts.
can anyone help me with that please ?
On Mar 15, 2007, at 4:25 AM, Daevid Vincent wrote:
Can anyone recommend a real, quality, professional level mySQL GUI for
Linux?
KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right.
Something along the lines of SQLYog (Enterprise ideally).
I'm kind of disappointed that I can
I upgraded a server from 4.0 to 4.1 and then to 5.0 but I've been
running into a problem. When I was running 4.0 the passwords with the
password('password') command where being created like this:
2a287c002f9773dc now after I upgraded to 4.1 when I add a new user the
passwords end up being like
I am trying to find out the difference between the Pro and community
editions of MySQL. If I want to support GPL applications I can install
the community ed. If later want to support a non GPL application do I
need to install anything different.
I have found lots of web pages but they don't
I have some applications that need a 32 bit library for Mysql.
I would prefer to install the 64 bit version of MySQL but that doesnt
seem to come with 32 bit libraries. Can I install both libraries.
Any pointers would be appreciated
Andrew
--
MySQL General Mailing List
For list archives: http
I'm running into a problem with a ratings script I'm writing. The
overview is that a user can rate an item from 1-10. What I want it to do
is display the highest rated item, with 10 being the highest rating. In
case there are multiple items sharing the same score, the item that has
been rated t
hould find and edit
table where it sotres index/counter data..
Tom Ray [Lists] wrote:
Hey, I have a really simple question (I hope)..I have a database
that has a field in it that autoindexes the number. I screwed up and
imported a bunch of wrong data. Up to row 200 it's right, beyond
that
Hey, I have a really simple question (I hope)..I have a database that
has a field in it that autoindexes the number. I screwed up and imported
a bunch of wrong data. Up to row 200 it's right, beyond that it was
wrong so I had delete it all. The problem now is the autoindexing is set
to 1105, I
How would I do that? I'm still a novice when it comes to many aspects of
mysql.
[EMAIL PROTECTED] wrote:
Hi,
Try to enable query log.
Thanks & Regards
Dilipkumar
[EMAIL PROTECTED]:
Hey there, I inherited a couple of servers that are in production but I
noticed that there\'s not activ
Hey there, I inherited a couple of servers that are in production but I
noticed that there's not active logging for mysql on any of them. I
looked and they don't have an active my.cnf file any where on the
machines. One machine is running mysql 4.1.5 and the other is running
mysql 5.0.18
When
We have had some problems with corrupt data due to running out of space
recently. I wanted to repair the tables so I backed up our database by
dumping to a file with mysqldump. I then tried to repair the database
and had some problems with that.
I stopped MySQL and moved the database to database
On Sep 27, 2005, at 10:28 AM, Pooly wrote:
The command in PHP is:
$query="SELECT id,first_name,last_name FROM Player ORDER BY id";
$players=mysql_query($query);
When issued from the mysql prompt, order is fine, but when
called from php I'm getting that strange order:
1, 10, 11, 12, etc...
On Sep 27, 2005, at 9:56 AM, Edward Vermillion wrote:
Michael Stassen wrote:
Stephen A. Cochran Lists wrote:
On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote:
mysql> SHOW CREATE TABLE Player|
| Player | CREATE TABLE `Player` (
`id` int(16) NOT NULL auto_increm
On Sep 27, 2005, at 3:29 AM, Jasper Bryant-Greene wrote:
mysql> SHOW CREATE TABLE Player|
| Player | CREATE TABLE `Player` (
`id` int(16) NOT NULL auto_increment,
`first_name` varchar(32) NOT NULL default '',
`last_name` varchar(32) NOT NULL default '',
`year` varchar(16) NOT NULL defaul
On Sep 27, 2005, at 2:58 AM, Jigal van Hemert wrote:
You are most likely to get meaningful suggestions to solve the
mystery if you include the table definition (output of SHOW CREATE
TABLE ) and the query.
mysql> SHOW CREATE TABLE Player|
+
+---
I'm getting a strange ordering when using ORDER BY on a int column.
The rows are being returned sorted as follows:
1
10
11
12
13
14
15
2
3
4
5
6
7
8
9
I'm sure this is a simple one, but I haven't found an answer in the
archives.
Thanks,
Steve
--
MySQL General Mailing List
For list archiv
I'm using mysql 4.1.14 rpm's on Fedora Core 4.
I've setup max_heap_table_size to allow for 500M heap tables. Currently I
use roughly 435M in heap by about 16 different tables. Some use btree,
other's use default hash.
The problem is, over time mysql looks like this in top:
PID USER PR NI VIRT RES
Hallo Thorsten,
Op 14 Sep 05 schreef Thorsten Moeller aan MySQL Mailinglist:
TM> i am trying to load a csv file with "LOAD DATA INFILE". This File
TM> contains columns with decimal values with the german comma instead of
TM> the dot as separator (e.g. 3.20 is 3,20). Is there an option to handl
Hallo Michael,
Op 29 Aug 05 schreef Michael Stassen aan [EMAIL PROTECTED]:
>> >> I would like a single row in a table, and not more than one, to
>> >> be used as a preferred value in another application.
>> JBG> add a column 'preferred', tinyint(1) NOT NULL.
MS> It's hard to say without kn
Hallo Jasper,
Op 29 Aug 05 schreef Jasper Bryant-Greene aan mysql:
>> I would like a single row in a table, and not more than one, to be
>> used as a preferred value in another application.
JBG> add a column 'preferred', tinyint(1) NOT NULL.
Thank you!
Groetjes,
Hans.
--- GoldED
Hallo,
I would like a single row in a table, and not more than one, to be
used as a preferred value in another application.
Is this possible, and, if yes, how?
Groetjes,
Hans.
--- GoldED+/LNX 1.1.5/050823
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
--
MySQL General Maili
Hallo,
Op 30 Jun 05 schreef blackwater dev aan mysql@lists.mysql.com:
bd> "1","23","345","45";
bd> "34","4","444","1er";
bd> Load data local infile '/httpd/htdocs/sql/loader.sql' into table
bd> vehicles fields terminated by ',' enclosed by "'" lines terminated by
bd> ';'
I think it should b
Hello Mike,
On 27 Jun 05, mos wrote to mySQL list:
>> How can I prevent duplicate entries when I fill the data base with
>> "load data"? I tried ignore, but that has no effect.
m> Ignore/Replace will only work on Unique keys and I bet your key is
m> not unique. If you make it unique, then Ign
Hello,
How can I prevent duplicate entries when I fill the data base with
"load data"? I tried ignore, but that has no effect. Probably I'm
something very elementary, but I'm still learning...
Regards,
Hans.
jdh dot beekhuizen at duinheks dot xs4all dot nl
--- GoldED+/LNX 1.1.5/04041
Hallo Jigal,
Op 22 Jun 05 schreef Jigal van Hemert aan <[EMAIL PROTECTED]:
JvH> What about reading the data into the table and storing the
JvH> 'amount' in varchar for now. Then you can run an update query in
JvH> UPDATE `table` SET `amount`= REPLACE( `v_amount`, ',' , '.'),
JvH> `v_amount`
Hallo Anoop,
Op 22 Jun 05 schreef Anoop kumar V aan Jigal van Hemert <[EMAIL PROTECTED]>,:
AkV> Alternatively, you can parse the text files using application logic
AkV> (java, c++, etc) and then after extracting (and cleaning) your data
AkV> insert them into mysql.
I had been thinking about t
Hello Anoop,
On 22 Jun 05, Anoop kumar V wrote to All:
AkV> Are u saying that u have data in a text file and you need to parse
AkV> this and insert them into mysql?
That's what I Ntried to say, yes :) The main problem is the decimal comma
in the amounts.
Regards,
Hans.
jdh dot be
Hallo,
I get data with a format that I can't choose. The fields are enclosed
in double quotes ("), separated by commas (,). The main problem is that
some fields contain amounts with a decimal comma. I have not found a
way yet to load these data properly. Could somebody help me please?>
Groetjes,
Hallo Peter,
Op 30 May 05 schreef Peter aan [EMAIL PROTECTED]:
P> http://dev.mysql.com/doc/mysql/en/load-data-local.html
P> #
P> If LOAD DATA LOCAL INFILE is disabled, either in the server or the
P> client, a client that attempts to issue such a statement receives the
P> following error me
Hallo,
I'm using MySQL 4.0.23a as found in the SlackWare 10.1 distribution.
As I'm totally new to MySQL I tried tom follow the tutorial from the
manual. When I tried to fill the data base using a text file with the
command
load data local infile '~/temp' into table huisdier;
I got
ERROR 1148: The
Kevin Cagle wrote:
Hello!
I have a couple of tables I am doing a join on. Both have 6 fields.
Most fields have fewer than 16 characters in them, but at most 75.
Neither table is huge: one with 14004 rows and the other with 23677. I
created a temp table to insert the data into. When I perform
Philippe Poelvoorde wrote:
Hi,
mysqldump returns with this error on one of my nightly batch :
mysqldump: Out of memory (Needed 8164 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory when
retrieving data from server
Fri Dec 24 00:00:22 CET 2004
Is there any way to avoid this partic
Richard Whitney wrote:
Hi!
Can someone point me in the right direction?
I have this that works in v.4x:
$sql = "LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members`
FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY
'' LINES TERMINATED BY '\\r\\n'";
When I try it using 3.2
Hi Victor,
thanks for your reply.
Victor Pendleton wrote:
Do you have anything in the show processlist? Are you using innodb table
types and a rollback is occurring?
mysql> show processlist;
+---+-+---+---++--++-
Hi there,
after a system-crash I got the following problem.
Some seconds after starting mysql (v4.0.20) a process will stay
there taking all cpu-time it can get (99.9% ;)) ... and it can't be
terminated,
just killed completely.
mysqlcheck ran through without any problems, the logs tell nothing.
I
Hi allit's possible to use the CASE clause in MySQL like this:SELECT
statusID,
Case(statusID = 1, TotalStatus1=TotalStatus1 + 1)
Case(statusID = 2, TotalStatus2 = TotalStatus2 +1)
It's possible?
How to do that?
Thanx for your time.Crie seu Yahoo! Mail, agora com 100MB de espaço, anti-spam e antivír
Hi all
how to do this in MySQL? Returning only records with COUNT > 5?
SELECT
`groups`.`groupsDescr`,
`roles`.`roles_Agroup`,
`roles`.`rolesDescr`,
COUNT(`roles`.`rolesDescr`) AS TOTAL
FROM
`roles`
INNER JOIN `groups_roles` ON (`roles`.`rolesID` =
`groups_roles`.`fkrolesID`)
INNER
Hi
my table have an field when users can enter any chars
If users dont send any content for that field(phone), mysql store "( ) - " without
quotes in that
What im looking for:
Display IF phone field is ( ) - NOT ENTER
Otherwise display the phone of user.
It's possib
Hi all
we're using MySQL 4.0.12 with InnoDB... please do you have any scripts, comments,
suggestions, ideas, tutorials... about how to backup from that DB? It's possible to?
Thanx for your time.
Diga-me e eu esquecerei
Mostre-me e lembrarei
Ensina-me e aprenderei
-
Howdy --
What I want to do is use Xbasic as a frontend for MySQL. The problem is I'm
mainly a PHP(and a little Perl) person.
It looks like we should be able to make calls to the MySQL libs,dills & headers
from Xbasic. My interest for the mement is with doing it on Windows.
Here's the Xbasic site
Howdy --
I've been tinkering with Xbasic(http://xbasic.org). While there isn't any
native DB support (ODBC is in the works).
This got me to thinking about making calls to MySQL libs or dll(s) (in the case
of Windows).
Being mainly a PHP person (and no C), I'm hoping than someone will explain th
I have a table with 22,371,273 rows, current type is MyISAM. I have one
query tha took nearly 5 hours to complete. I do not know if this like
it should be or not, but I thought I'd ask the list. My gut feeling is
the `gropu by` that's slowing it down but nonetheless 5 hours seems
excessive. I'
Hello all...
Source table has approximately 23,000,000 rows. The explain below shows
we'll be working with 2,707,366 of those rows just inserting them into a
table. Why does this take 10 minues to run? System specifications
below all that.
* Precompiled binary from mysql.com
* Completely idle
Hallo,
I'm totally new to MySQL or any other data bases...
I installed MySQL 4.0.15a as supplied with the SlackWare 9.1 Linux
distribution. The only documentation supplied are the Reference Manual en
the man pages. But the Reference Manual is a little bit too touch for me. I
managed to get m
Is there an easy way to get an excel spread sheet imported into a MYSQL
database?
Any links to a tutorial?
Thanks in advance!
Dustin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey folks,
before posting to the bugs-list I would like to try it here to get some help :).
Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine.
Its not reproducible nor I know a query which does it.
(The log shows that at the end, so no query :-( :
Trying to get some variables.
Ok, don't shoot me for not entirely understanding indexes.
Can you build an index across two different tables w/in the same
database? I need an index on fields in table a and in table b and I
want that index to exist in table a. Is it possible? I'm running 4.0.12.
TIA,
Charlie
--
MySQL Genera
I'm researching a specific network design and have some questions that may
involve 2-way replication.
I have one master mysql server doing 1 way replication to a large number of
remotely located slaves. Each slave
serves a number of proprietary software clients running inside a private
network.
On Sat, 7 Jun 2003 15:33 , Paul DuBois <[EMAIL PROTECTED]> sent:
>
>This is a problem that is fixed in MySQL 4. If you can upgrade, that
>should help you a lot.
>
>http://www.mysql.com/doc/en/News-4.0.0.html
>
That explains that. I was relying on the online docs and it didn't even
occur to me
Hello everyone,
I'm working with MySQL 3.23.41-log developing a chat application. I need to run a
query, order the results in
descending order, then get the last 0-15 entries that are less than 20 minutes old.
The query and tables in question
are explained at the bottom of this posting. In
>Description:
after starting mysql via init script, one can not log off a SSH
session
>How-To-OBRepeat:
log into box via SSH as root
/sbin/service mysql start
attempt to log off.. and the session hangs until you use
another session to stop mysql.
>
I have been having a lot of trouble configuring mysql to do just the
simplest replication. Its a standard RedHat 8.0 install, I have followed
the directions on http://www.mysql.com/doc/en/Replication_HOWTO.html to the
letter half a dozen times now and still, the slave server crashes repeatedly
as
i downloaded mysql-4.0.8-0.src.rpm off of the mysql web-site and have tried
to compile it on several different redhat 8.0 boxes. the same error happens
whether compiling latest mysql 3.23 or 4.0 source rpms. the build moves
along for about fifteen minutes (long after i begin to believe it will
su
automake: strings/Makefile.am: Assembler source seen but `CCAS' not defined
in `configure.in'
automake: strings/Makefile.am: Assembler source seen but `CCASFLAGS' not
defined in `configure.in'
error: Bad exit status from /var/tmp/rpm-tmp.37688 (%build)
RPM build errors:
Bad exit status from /
n Thu, Dec 05, 2002 at 08:54:29PM -0200, Felipe Moreno - MAILING LISTS
wrote:
>
> Well, could you explain the behave of ORDER BY DATE,COD?
Just try it (it will order by date, then cod).
What I think you want is (as I originally said, but briefly):
create temporary table top10 select * from .
ten dates). So,
>what I really need ia an way to make a select without any "data" from the
>DB. I tried to use de LAST_INDEX() function to do this but I didn't go
>anywhere. Any ideas???
-Mensagem original-
De: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Enviada em: quinta-feira,
: SQL Select Idea
On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS
wrote:
>Well, the SQL Query you requested is exatcly the one I'm asking! :-)
No; I want to know what you intended for those 10 dates to do. The LIMIT
query
worked, as posted by someone else, w
what I'm doing above using only ONE select.
Any tips?
Best Regards,
Felipe
-Mensagem original-
De: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Enviada em: quarta-feira, 4 de dezembro de 2002 02:06
Para: [EMAIL PROTECTED]
Assunto: Re: RES: SQL Select Idea
On Tue, Dec 03, 2002 at
zembro de 2002 01:03
Para: Felipe Moreno - MAILING LISTS
Assunto: Re: RES: SQL Select Idea
Felipe -
Maybe you could...
(1) Put the first result set into a temp table, on which you could execute
subsequent queries, or
(2) Use php to construct an array of the result rows, and then use php's
arra
---Mensagem original-
De: Jim Esten [mailto:[EMAIL PROTECTED]]
Enviada em: terça-feira, 3 de dezembro de 2002 17:40
Para: 'Felipe Moreno - MAILING LISTS'; [EMAIL PROTECTED]
Assunto: RE: SQL Select Idea
Something on the order of...
SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT
Hi List Users,
I want to know if anyone has any idea on how can I do the SQL command
below to archive a result.
I have one table called processo_arquivos that have a filed called DATE
and another FIELD called COD (primary key). I want to select the last TEN
(10) dates from the Database, but
Hi List Users,
I want to know if anyone has any idea on how can I do the SQL command
below to archive a result.
I have one table called processo_arquivos that have a filed called DATE
and another FIELD called COD (primary key). I want to select the last TEN
(10) dates from the Database, but
try www.mysql.com, i heard they have docs there you can read...:)
-Original Message-
From: Admin-Stress [mailto:meerkapot@;yahoo.com]
Sent: Monday, November 04, 2002 1:41 PM
To: [EMAIL PROTECTED]
Subject: newbie: creating database error
After playing around with 'test' database, then I w
i understand there are other ways of encrypting the traffic, i am just
curious if there are any that employed internally in mysql. thanks.
-chris
-Original Message-
From: Ronald Petty [mailto:ron.petty@;unigeek.com]
Sent: Thursday, October 24, 2002 6:51 PM
To: Lists @ Apted Technologies
i am going to be setting up four mysql servers, three of which will
replicate data off of the primary. i know that in more recent versions of
mysql client/server communciations can be encrypted internally. but is
there any way to encrypt replication communcations between these mysql
servers intern
Hi,
Using MySQL, perl and DBI, is there a way to test to see if a table is
locked (as in "LOCK table..."). We batch process our updates every 3
hours or so (it's not a set schedule though, it depends when a certain level
of new updates is reached), and our main tables are locked during this t
*This message was transferred with a trial version of CommuniGate(tm) Pro*
I installed Mac OS X 10.2 this last weekend and since then I've been
having some problems with the security on the MySQL files. I thought
that I had everything fixed, but now when my web users try and update
or insert a
Does any know how to fix this database replication problem.
Last Lines from Err File
010815 21:38:55 Slave thread exiting, replication stopped in log
'salem-bin.013' at position 6867
010815 21:38:55 Error running query, slave aborted. Fix the problem, and
re-start the slave thread with
Does any know how to fix this database replication problem.
Last Lines from Err File
010815 21:38:55 Slave thread exiting, replication stopped in log
'salem-bin.013' at position 6867
010815 21:38:55 Error running query, slave aborted. Fix the problem, and
re-start the slave thread with "mysqlad
Does any know how to fix this database replication problem.
Last Lines from Err File
010815 21:38:55 Slave thread exiting, replication stopped in log 'salem-bin.013' at
position 6867
010815 21:38:55 Error running query, slave aborted. Fix the problem, and re-start the
slave thread with "mysql
Thank you
- Original Message -
From: "Grigory Bakunov" <[EMAIL PROTECTED]>
To: "Lists Servers Email" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 11:16 PM
Subject: Re: Linux to NT
> Date |Tue, 14 Aug 2001 22
Is it possible to Replication from Linux database to NT?
Thanks Kevin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
What sort of support for transactions and table/record locking is there in MySQL right
now? I had heard that only table locking was supported, and limited support for
transactions.
Aaron
-
Before posting, please check:
h
I need some help with a query to sum data for each id and write it into a
new table.
I have a source data table for each calendar month containing i.d.'s (not
unique) and a value and I need to sum all the values for each i.d. for all
months into a new table (where each i.d. will now be unique).
Hi,
I have a table like this:
mysql> select id, ticketid, rdvwhen from rdv order by ticketid asc, id
desc;
++--++
| id | ticketid | rdvwhen|
++--++
| 1 | 18 | 2001050309 |
| 2 | 20 | 20010430153000 |
| 7 | 3
Can anyone share the experiences with mysql
Full-text Search indexes? I have been reading here and
there about how slow it can be to create/update a
text index.
Also, are there any benchmarks on query results
on searching such indexes?
Christopher Lambrou,
CGL Computer Services, Inc.
Empire
Personnaly, i have found autoincrement fields to be rock solid.
I use'em all over the place on a 1 Gb database, web based.
Don't do it manually . You'll end up doing the same thing
that mysql gives you for free.
Christopher Lambrou,
CGL Computer Services, Inc.
Empire State Building,
PMB 1
Stefan,
When you insert a row in a table and you do not specify a value
for a field, mySQL (and any other DBMNS?) will do the following:
1. If field accepts null: it will set the value of that field
to null
2. If field DOES NOT accept null - no default value set: it will
set the field's va
Hi,
Is there someone who incremented the max_connection
value to something above 100 (200) (300) on Freebsd 4.2?
I had problems with mysql on freebsd 4.0, hooked up
after some days without any good reason :).
Some people told me thread libraries on freebsd
Hi,
I've site with heavy traffic, freebsd 4.2
php 4.0pl1, mysql 3.23.36.. ALL persistent connections.
I've nearly every second this error in the logfile:
10429 22:31:00 Aborted connection 2361 to db: 'alexv2' user: 'av2' host:
`localhost' (Got an error reading c
HI,
Try this
regs, pdw
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To
Hi,
Mysql ran for 6 days.. It is a website
with heavy traffic.
/usr/libexec/ld-elf.so.1: /usr/local/libexec/mysqld: Undefined symbol
"strtoull"
010423 23:18:08 mysqld restarted
/usr/local/libexec/mysqld: ready for connections
What is this function
Hi all,
Here are two tables I'm working with. I apologize if you
are not using a monospaced font and they are messed up.
This is used by a gradebook program. When a professor adds an assignment to
a class he teaches, it inserts the information about the assignment into the
assignments table,
1 - 100 of 106 matches
Mail list logo