äÏÂÒÙÊ ÄÅÎØ.
> On Thu, Nov 14, 2002 at 02:44:47PM +0200, Andrey Kotrekhov wrote:
> > Hi, All! sql
> >
> > Can I run 2 mysqld that use the same DB?
> > Not replication , 1 DB on my HDD but 2 mysqld work with this DB.
> >
> > For example I have external RAID and I want decrease CPU usage.
> > I run
On Fri, 15 Nov 2002, Edwin Raj wrote:
} [root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password
} 'simple'
} /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
} error: 'Can't connect to local MySQL server through socket
} '/tmp/mysql.sock' (111)'
} Check that
If this could help to analyse the problem, when I try to create a
password this is the message I get
[root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password
'simple'
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server
Hello Friends,
I have installed mysql version 3.23.52 binary file. The installation
went well without any errors but when I type mysql in the command prompt
I get this error. Can someone help me fix this. Am using red hat 6.2 version
Rgds
Edwin
---
> is there any configuration that turn on auto commit
> persistently ... i mean for each client connections?
> (in my.cnf [client] or something else)
The default is ON. Turning it off is how a client begins a transaction. If
you want to prevent users from using transactions, you can use MyISAM
tab
>Description:
a) --enable-assembler causes "invalid opcode" with strings.s
"strings-x86.s", line 1: Illegal mnemonic
"strings-x86.s", line 1: Syntax error
make: Fatal error: Command failed for target `strings-x86.o'
b) Incorrect socket length declara
Hello,
I have a problem about foreign key in using MySQL.com manual. According to
the example in MySQL.com manual, one foreign key is ok. However, I have 3
tables (ie. 2 for parent tables and 1 for child table). When I use 2 or more
foreign keys, I have the following errors.
Case 1:
mysql> cr
On Thu, 14 Nov 2002, Roger Baklund wrote:
} * Vince LaMonica
[snip]
} > The user has created multiple author cols in the publications table
} > because the order of the author matters [eg: it is better for someone to
} > be an author1 than an author2 or a dreaded author5]. Some publications
} > ha
MASTER Ver 12.10 Distrib 4.0.2-alpha, for pc-linux-gnu (i686)
SLAVE Ver 12.10 Distrib 4.0.2-alpha, for unknown-freebsdelf4.6 (i386)
On my Master I am getting this:
mysql> SHOW BINLOG EVENTS IN '/usr/local/var/www200-bin.008' FROM 38717800;
ERROR 2006: MySQL server has gone away
No connection.
Hi
have you looked at GRANT
http://www.mysql.com/doc/en/GRANT.html
I think it is what you are looking for
Peter
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
Slave SQL thread initialized, starting replication in log
'www200-bin.008' at position 38717817, relay log
'./s142-17-103-3-relay-bin.056' position: 9212273
021114 16:34:12 Error in Log_event::read_log_event(): 'read error',
data_len=161,event_type=2
021114 16:34:12 Slave SQL thread: I/O erro
I have a question about using count in an Intersect Statement. I want to
get the total count of the following SQL Statement: How would I do this?
SELECT
nvl((c.sr_num),0)),
FROM
s_evt_act a,
s_srv_req c
WHERE
a.sra_sr_id = c.row_id and
a.priv_flg = 'N' and
a.x_cp_created between (sysd
Assume two tables:
CREATE TABLE block_ip (
datestamp int(11) NOT NULL default '0',
remote_addr char(15) NOT NULL default '',
PRIMARY KEY (remote_addr),
KEY datestamp (datestamp)
) TYPE=MyISAM;
CREATE TABLE brute_force (
datestamp int(11) NOT NULL default '0',
remote_addr char(15) NO
>Description:
Running the mysql_install_db or configure scripts fail to install
database tables. mysqld cannot find libgthreads.so even though it is
in /usr/local/lib. Script also complains that libc are not 100 %
compatible; I think I have the latest versio
Hello,
I have installed Red Hat 8.0 and Mysql from the CD's. I am able to telnet
to localhost at port 3306. However I can not telnet to the external ip
address at port 3306. netstat -a lists *:mysql listening. When I run a
mysql from a Win 2k box I get : ERROR 2013: Lost connection to MySQL ser
At 14:49 -0700 11/14/02, Brock Taylor wrote:
Hi,
I have installed mysqld-max-nt on my Win NT (SP 6) machine. I got a message
of success. When I try to start mysql (NET START MYSQL) I get an error
1067. Reading the documentation I see that maybe I should be starting it
with named pipes. Not sur
You might want to try actually running the query.
mysql_query ($query);
or
mysql_query ($query,$db);
depending on your preference.
-Original Message-
From: Beauford [mailto:beauford.2003@;rogers.com]
Sent: Thursday, November 14, 2002 1:53 PM
To: [EMAIL PROTECTED]
Subject: Update help
Hi,
Hi,
I'm trying to update a table from my webpage but not having much luck,
although it works from the command line. Obviously I am missing
something and would appreciate any help.
Also. Is there a good tutorial or help page for Mysql. I find the one at
www.mysql.com not very helpful.
TIA
The co
Hi,
I have installed mysqld-max-nt on my Win NT (SP 6) machine. I got a message
of success. When I try to start mysql (NET START MYSQL) I get an error
1067. Reading the documentation I see that maybe I should be starting it
with named pipes. Not sure... But when I enter the command
mysqld-max-
> >The thing with Oracle is that once a row is assigned a ROWID, it
never
> >changes. It doesn't matter if the row grows and has to move within
the
> >block (or if it has to move to another block, for that matter).
That's
> >why ROWIDs work in Oracle.
> >
>
> Neither does an auto_increment index
At 12:58 13/11/2002 +0200, Octavian Rasnita wrote:
Hi,
Hi all,
I was able to install the module DBD::mysql for Perl 5.6.1 using ppm (under
Windows 2000) but after installing Perl 5.8, ppm can't find this module
anymore.
I had the same issue, then I removed Perl and re-installed the
below early
Anyone have experience with Hotscripts Enterprise Timesheet and Payroll application?
It's my first attempt at running a MySQL aplication. Here is the link:
http://www.hotscripts.com/Detailed/14498.html
The installation seemed to go flawlessly. Apache webserver was running as well as
MySQL v3.2
One other simple task that you can try is to just perform a ping. If you
can ping the server with the new IP address, then your network is not the
problem.
Bruce
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "Chris Walcott" <[EMAIL PROTECTED]>; "Mysql-L (E-mail)"
<
Yes.You can put the new IP address instead of the name (no localhost).When
you make update, you must be sure that YOU DON'T REPLACE and the record
where the Host field is 'localhost'.You must replace only the record where
in Host field is the name of computer/server which must connect to the
MySQL.
right now the host field has 2 entries: localhost and newpop (the name of the server).
There are no IP numbers. Should I replace the host name entry with the new IP
address?
thanks!
- chris
> -Original Message-
> From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
> Sent: Thursday, Novembe
Hi,
It's possible that in mysql.user table to exist the old IP address of your
machine.You should check the field Host using:
use mysql;
select Host,User from user where User='YOUR_USER_NAME';
If in the Host field you see the '%' character that means your problem is
not from MySQL... else you sh
if ANYONE has any suggestions for this I would greatly appreciate
it :) I just dont know where else to turn for help ...
If I launch MySQL 3.23.38, everything is fine. If I open tables,
creat db,
add records whatever, no problem. When I close MySQL my hard
drive is ? alot and I ca
It is very possible. Your network may need an update as to what the new IP
address is. Most networks take anywhere from 20-30 minutes to get the
updates (depends upon your network administrators configuration). Another
may be with your code. If you are using ODBC, you may need to change the
cod
What is the mysql.db table for?
It looks like it contains user and database permissions of some kind..
but.. many of the rows in the "db" table refer to databases and/or users
that don't exist on my server anymore, which were dropped with "drop
database".
Also, is the proper way to REMOVE a us
How do I set a username/passwd to a specific database for authentication?
I know how to create users but I can't find anything in the docs about how to password
protect a database that is publicly available.
I'm using mysql with ColdFusion and one of the things you are aupposed to supply when
b
I just got mysql up and running (I'm a new user). I'm using it with ColdFusionMX.
Just as I was about to bind a database to coldfusion, my IT department decided to move
my server to a new IP address.
Now I can't get a database to bind to coldFusion and I'm wondering if it's because the
IP addr
Hi,
You can use :
INSERT INTO SELECT * FROM YOUR_TABLE
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: <[EMAIL P
Cute.
sql, query
~K Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql-help@;lists.mysql.com]
Sent: Thursday, November 14, 2002 6:38 AM
To: Black, Kelly W [PCS]
Subject: confirm unsubscribe from [EMAIL PROTECTED]
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTEC
Ed,
You could use the insert .. select syntax.
See: http://www.mysql.com/doc/en/INSERT_SELECT.html
Cheers,
Andrew
-Original Message-
From: [EMAIL PROTECTED] [mailto:ed@;home.homes2see.com]
Sent: Thursday, 14 November 2002 18:50
To: [EMAIL PROTECTED]
Subject: Copying one table to anoth
Say I have 2 tables with the exact same formatting (fields, values, etc.)
Is there an easy way to dump the contents of one table to the other in SQL
rather than outputting the one to a .txt or .sql and inputing it into the
other table?
Thanks,
Ed
--
At 18:06 14/11/2002 +0800, Wong, Kee Lang wrote:
Hi,
Sorry but I wasn't be able for to repeat the behavior reported:
Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.
D:\>c:\mysql\bin\mysqld --standalone
Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 198
Hello,
I have a problem with the installation of mysql.
The configure is ok but I have this message when I run the make command:
---
PIC -o .libs/libmysql.lo
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostb
I've read the mysql replication documentation, and I've seen mentioned
only once setting up the replication loop: A -> B -> C -> A.
I'd like to setup a simple version of the same: A <-> B so that if A goes
down my application can talk to whichever server is up and when A comes
back up he will resy
FlashGuy wrote:
What SQL statements do I have to use to get the following results?
http://www.google.com ... "sql query howto" ...
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before
> SELECT papers.id,
> concat(a1.first_name,' ',a1.middle_name,' ',a1.last_name)
> as author1,
> concat(a2.first_name,' ',a2.middle_name,' ',a2.last_name)
> as author2,
> concat(a3.first_name,' ',a3.middle_name,' ',a3.last_name)
> as author3,
> concat(a4.first_name,' ',a4.middle_name,' ',
At 11:17 -0500 11/14/02, Richard Idalski wrote:
I'm looking for the proper way to raise the Max Datafile size for a table of
mine that's just about maxed out.
What's the table type, and are you sure you're reaching the max table
size rather than running into a limit on your file system's file si
On Thu, Nov 14, 2002 at 09:02:59AM -0500, Nicholas Elliott wrote:
> Hey folks,
>
> I've looked around, but haven't seen anything similar to _quite_ the problem
> I have. The symptoms are thus: memory usage for each mysqld process in top
> creeps up to around 13%, 274MB, and stays there, no matte
At 11:15 -0600 11/14/02, Greg Macek wrote:
Thanks for the tip! Looks like I can change my date_archived field to
timestamp(8), since all I care about for this is the date information
(actual time is useless to me). My sql query all of a sudden got a lot
simpler. Thanks again for the help!
TIMEST
Thanks for the tip! Looks like I can change my date_archived field to
timestamp(8), since all I care about for this is the date information
(actual time is useless to me). My sql query all of a sudden got a lot
simpler. Thanks again for the help!
On Thu, 2002-11-14 at 11:07, Matthew Baranowski wr
Bungarz,
Wednesday, November 13, 2002, 11:13:18 AM, you wrote:
BK> Hi!
BK> We are using mysql, version 4.0.4 beta on windows 2000 Server.
BK> I packed a table with 100 million rows, using myisampack.
BK> Now queries don't use the index of this table.
BK> It's not possible for me, to work with tabl
Rodrigo,
Tuesday, November 12, 2002, 10:44:38 PM, you wrote:
>> I want to change a tablename in my database. How do i do that? I want to
RSM> do
>> it from a webpage so i need to use php.
Take a look at ALTER TABLE statement:
http://www.mysql.com/doc/en/ALTER_TABLE.html
or RENAME TABLE stat
Hey Greg:
A slightly easier way to do this is to use a "timestamp" field. Timestamp is
just a standard mysql data type. When a record is added, it records the
current time. When a record is updated, the timestamp field will be set to
the time of the update.
http://www.mysql.com/doc/en/DATETIME.ht
On Thu, Nov 14, 2002 at 02:44:47PM +0200, Andrey Kotrekhov wrote:
> Hi, All! sql
>
> Can I run 2 mysqld that use the same DB?
> Not replication , 1 DB on my HDD but 2 mysqld work with this DB.
>
> For example I have external RAID and I want decrease CPU usage.
> I run 2 mysqld on different server
Well, amazingly enough, it works great! I found a test box to try it on
first before implementing this on the production box. This will
definitely make life easier...
On Thu, 2002-11-14 at 10:14, gerald_clark wrote:
> Did you try it?
> Did it work?
>
> Greg Macek wrote:
>
> >Hello,
> >
> >I rec
I'm looking for the proper way to raise the Max Datafile size for a table of
mine that's just about maxed out.
I've been trying various ALTER TABLES commands but none have worked, and I'm
even sure the alter tables is the way to go with this.
What is the proper way to raise that variable.
This i
Hello,
I recently stumbled upon the INSERT INTO..SELECT abilities. Basically
what I'm doing is archiving records into another table before deleting
them (inventory information). However, I'd like to have the archive
table to have one more field than the original table: a date_archived
function. So
Greetings
I have a MySQL server with my ISP. Previously I was able to connect to the
server using any client. But now when I connect it says lost connection
during query ?
What is the reason ?
Rgds
Insane
-
Before posting, ple
Hi,
What SQL statements do I have to use to get the following results?
I have a preferences page that lists directories with check boxes. This is displaying
by querying my database. It looks something like this:
Preferences: (Click to omit directories from listing)
[ ] dir1
[ ] dir2
[ ] d
your probably looking for curtime()
CURTIME()
CURRENT_TIME
Returns the current time as a value in 'HH:MM:SS' or HHMMSS
format, depending on whether the function is used in a string
or numeric context:
mysql> select CURTIME();
-> '23:50:26'
mysql> select
Can anyone help with (what I hope is) a pretty simple time function
query? I need to extract a set of records from a table based on
separate date and time columns, where both the date and time are older
or equal to now.
For example, my sql query is going to look a bit like this:
select ID, Live
Victoria,
On Thu, 14 Nov 2002, Victoria Reznichenko wrote:
> Mark,
> Thursday, November 14, 2002, 12:02:31 AM, you wrote:
>
> MI> I am having a problem with replication. When I create a new database on
> MI> the master, the CREATE DATABASE command is not shipped to the slave.
> MI> Subsequent ta
P.,
Wednesday, November 13, 2002, 6:05:15 PM, you wrote:
PF> what mysql version is recommended for running w/apache 1.3.26 & php
PF> 4.2.2?
PF> i'm having trouble getting mysql config'd w/these & wonder if i should
PF> avoid/lean to any particular versions?
3.23.53 is a stable version, 4.0.4 is
Silmara,
Wednesday, November 13, 2002, 6:45:51 PM, you wrote:
S> The MySQL have SPOOL where can I stores query results in a file?
S> How can I do this?
Sorry, your question is not clear enough for me.
Take a look at SELECT .. INTO OUTFILE command
or may be --tee option of mysql command-line cli
Has anyone here tried to put Open Directory RDF data (ie, www.dmoz.org)
into MySQL? I've done this fairly successfully with the exception of
the non-English characters (primarily the stuff in the "World"
category). The data is in UTF-8 which is a character set that MySQL
doesn't seem to suppo
Roger Baklund wrote:
Wouldn't you be better of using GRANT? If you encrypt the content of the
database, any searching must be done on the encrypted value, and sorting
would be difficult...
How would MySQL react to having some of its data files stored on
encrypted loop-back devices that aren'
* Fraser Stuart
> We are about to embark on a project that requires data encryption - mainly
> to stop sensitive information being viewed accidentally (ie viewing tables
> directly through odbc connections or standard mysql clients). The server
> (solaris) will not be publicly accessible.
Wouldn't
Hey folks,
I've looked around, but haven't seen anything similar to _quite_ the problem
I have. The symptoms are thus: memory usage for each mysqld process in top
creeps up to around 13%, 274MB, and stays there, no matter what I set my
config to.
79 processes: 76 sleeping, 3 running, 0 zombie,
I wanted to move the Access Database to Mysql.. I downloaded
MysqlFront and that did the trick... Thanks so much
On Thu, 2002-11-14 at 00:27, Chris Couture wrote:
> When you say "port" are you asking to export the access DB to mysql? If
> so, Intelligent Converters makes one and you can also do
Fraser Stuart wrote:
From this I'm leaning towards DES encryption - only because I can store the
key on the server.
Don't use DES for any secure information. If by "secure" you mean "I
don't care if they see it, but I'd prefer if they didn't", the go ahead.
If by "secure" you mean "No way!
My application is intended to be scalable. In the eyes of the marketing
departments, it should be scalable from zero to infinity. But we all know
that this is not possible indefinitely - at some point you reach a
bottleneck. In the case of my system, that bottleneck will eventually be
the MySQL wri
Dean Harding wrote:
The thing with Oracle is that once a row is assigned a ROWID, it never
changes. It doesn't matter if the row grows and has to move within the
block (or if it has to move to another block, for that matter). That's
why ROWIDs work in Oracle.
Neither does an auto_increment i
is there any configuration that turn on auto commit
persistently ... i mean for each client connections?
(in my.cnf [client] or something else)
Thanks in advance.
Natale Babbo
--- Devi Annisetty <[EMAIL PROTECTED]> ha
scritto: > Hi Peter,
>
> Thank you very much
> I got one more question
> Do I
Hi Peter,
Thank you very much
I got one more question
Do I need to change the table type to transaction-safe tables (InnoDB
and BDB) ?
AS I am going thru the manuals I read that tables should be of InnoDB
or BDB inorder to work for manual commit.
once again thanks in advance,
Devi
-Origin
Hi Maximo,
> How should I set my memory usage in my.cnf I have a hard time
> understanding how MySQL works with memory, how it manages it, etc. What
> should I consider when setting my memory settings??? I have included a
> paste of my.cnf
>
> # The MySQL server
> [mysqld]
> port
Hi, All! sql
Can I run 2 mysqld that use the same DB?
Not replication , 1 DB on my HDD but 2 mysqld work with this DB.
For example I have external RAID and I want decrease CPU usage.
I run 2 mysqld on different servers, but they use 1 DB.
Is this possible?
Sorry for my english.
Best regards
This method will work alright for the time being. It's actually better
than the method they use now anyway.
Thanks for all the ideas.
Ed
> This looks like two different results... a SQL query returns _one_
> resultset.
>
> Try this:
>
> SELECT CompanyName,AgentName,count(*) as ads
> FROM
Maximo,
Wednesday, November 13, 2002, 10:09:07 PM, you wrote:
MM> Where can I get a "tuning guide" for MySQL (MyISAM and InnoDB)...
MM> memory-wise and son on?
Some notes you can find in the MySQL and InnoDB manuals:
http://www.innodb.com/ibman.html#InnoDB_tuning
http://www.mysql.com/do
Alexander,
Thursday, November 14, 2002, 2:49:56 PM, you wrote:
AB> I would like to know if are there any certification for MySQL like DBA
AB> Oracle or something like that?
Yes, MySQL AB is working on a certification program. Visit the following page
for more details:
http://www.mysql.com/ce
Mark,
Thursday, November 14, 2002, 12:02:31 AM, you wrote:
MI> I am having a problem with replication. When I create a new database on
MI> the master, the CREATE DATABASE command is not shipped to the slave.
MI> Subsequent table creation and table updates on the new database on the
MI> master are
Kevin,
Thursday, November 14, 2002, 1:09:15 AM, you wrote:
KLG> If this is a FAQ, I haven't been able to find it. I am a newbie to MySQL,
KLG> but I've followed the directions carefully and I get this whenever I start
KLG> mysqld:
KLG> # bin/safe_mysqld --user=mysql &
KLG> [1] 24487
KLG> z
Staffan,
Thursday, November 14, 2002, 9:44:05 AM, you wrote:
SH> I'm using RedHat 8.0 and MySQL 3.23.52. I've also downloaded the MySQL Control
Center (latest). On the Linux mashine everything works just fine, but when I try to
connect to MySQLserver from
SH> Win2k using alpha version of MySQL C
* Alexander Burbello
> I would like to know if are there any certification for MySQL like DBA
> Oracle or something like that?
They are working on it:
http://www.mysql.com/certification/index.html >
--
Roger
-
Before posting,
Hi,
I would like to know if are there any certification for MySQL like DBA
Oracle or something like that?
Grettings
Alexander
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
* Silmara
> When I try to use the following command
>
> ALTER TABLE TABLE_1 DROP PRIMARY KEY;
>
> I get one error
>
> ERROR1114: The table '#sql-240_2' is full
>
> My table have 309195 records.
>
> How can I resolve this problem?
You probably have a full disk.
When you ALTER a table, mysql will o
* Vince LaMonica
[...]
> The authors table has 4 cols: id [primary/smallint/autoincrement],
> last_name, middle_name, first_name.
>
> The publications table has several cols, but the ones most important to
> this question are: id [primary/smallint/autoincrement], author1
> [smallint,
> foreign key
Thanks for the answers, but I have other problem...
When I try to use the following command
ALTER TABLE TABLE_1 DROP PRIMARY KEY;
I get one error
ERROR1114: The table '#sql-240_2' is full
My table have 309195 records.
How can I resolve this problem?
Kind regards,
Sil
--
Hey,
The thing with Oracle is that once a row is assigned a ROWID, it never
changes. It doesn't matter if the row grows and has to move within the
block (or if it has to move to another block, for that matter). That's
why ROWIDs work in Oracle.
But apparently, that's not the case with MySQL (pe
Hi Benjamin,
> > Isn't _rowid some type of internal variable? What is its exact
> purpose and
> > significance?
Thanks for nailing the matter down.
> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:39492:cnfpdcnkgalicmjgekef
"My main concern is that if we would make ROWID's available for the
Hi all,
I've been training someone on how to use MySQL, and apparently I'm
suffering from brain fade big time. The user has created two tables; an
authors table and a publications table.
The authors table has 4 cols: id [primary/smallint/autoincrement],
last_name, middle_name, first_name.
Th
Dear Sir,
I am very new to the mySQL product. I am trying to do some R&D on the
possibility to port the MS SQL to mySQL for our system. I have tried with
mysql-3.23.53-win. I able to start the mySQL and run the mysqlshow command
and others.
However, if I try with the mysql-max-4.0.4-beta-win, I s
Maximo,
- Original Message -
From: "Maximo Migliari" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 13, 2002 11:31 PM
Subject: MySQL load problems.
> Hello all,
>
> I've been having some problems with MySQL crashing. I use a mixture of
> MyISAM and Inno
86 matches
Mail list logo
