Hi Jeremy
I'm planning to use a dual xeon 2.8Ghz and 6/8 gb ram
on the database server.
Redhat 9 is the o.s.
Applications (perl dbi) will reside on other boxes.
What hw/o.s. are you using?
Can you send me your variables (max connections etc.) ... just for a check
;)
Thanks!!
|-Original Mess
anyone have a good sample script of connecting mysql from C API? thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Asif,
- Original Message -
From: "Asif Iqbal" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 31, 2003 10:41 PM
Subject: Mysqld is keep crashing
>
>
> This is what I bumped into now
>
> 030731 15:39:50 mysqld started
> 030731 15:39:52 InnoDB: Database was n
Hello guys,
Im kinda new at creating databases thru the command line
When I try to login using.
Mysql -h hostname -username -p
I get this message on command line.
C:\Documents and Settings\Karl James>mysql -h hostname -u username -p
-p;
'mysql' is not a recognized as a internal or exteranl comman
Mysql is in default directory
my.ini - sure looks correct accourding to manual
Trying to start frist time using command:
C:\mysql\bin\mysqld --standalone
Yields this error message: Can't fine
messagefile'C:mysqin\share\english\errmsg.sys'aborting
Now in C:\mysql\share\english\ there is an er
i am using Linux 6.2(Zoot) and MySql 2.23.36and found the following error while
compiling the C program using mysql APIcc -o test prog1.c -L /usr/lib/mysql -I
/usr/include/mysql -lmysqlclientThe following Error occured
:/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress'
Hi
Environment: RedHat 7.2
MySQL: v 3.23.41
Connections: Perl DBI
I have a question if there is any features in mysql 3 /4 to support
connection priorisation. Currently we are running some update queries
that squeeze all all other connections running on the database.
Does any one have any sugge
On Thu, 31 Jul 2003, Ola Ogunneye wrote:
> I am running mysql 4.0.13 on Apache 2.0.47 and PHP 4.3.2. I can log onto
> my Mysql and I can show databases, and create users and passwords. OS
> is Windows 2000 Advanced Server.
>
> In trying to backup my database, I used the MySQL Second edition synta
ISBN 0-7357-1212-3
On Fri, 1 Aug 2003, Lucas Fonzalida - Soporte Tecnico wrote:
> Asif, can you paste here the ISBN?
>
> Thanks!!
>
> Lucas
>
> -Mensaje original-
> De: Asif Iqbal
> Enviado el: Jueves, 31 de Julio de 2003 22:05
> Para: Ralph Guzman
> CC: 'Fawad Siddiqui'; [EMAIL PROTECTE
Asif, can you paste here the ISBN?
Thanks!!
Lucas
-Mensaje original-
De: Asif Iqbal
Enviado el: Jueves, 31 de Julio de 2003 22:05
Para: Ralph Guzman
CC: 'Fawad Siddiqui'; [EMAIL PROTECTED]
Asunto: RE: Books advice
I just ordered this book
MySQL
The definitive guide to using, programmi
Greetings
I have MySQL 4.0.14 running on WinXP.
Whenever I create a temporary table from an existing
table that has multiple keys ( the temporary table has
columns reordered from the original table ) with a
query like -
create temporary table if not exists
`mn`.`sqlyog_23796` ( `entryid` int(6)
I am running mysql 4.0.13 on Apache 2.0.47 and PHP 4.3.2. I can log onto
my Mysql and I can show databases, and create users and passwords. OS
is Windows 2000 Advanced Server.
In trying to backup my database, I used the MySQL Second edition syntax
and also used something somebody suggested in a p
> I have tried to remove myself from this list, but the unsubscribe
> function does not function. How does one get off of this list?
I'd tell you to search the friendly archives, but the string "unsubscribe"
is part of every post recorded in the archives. But browsing backwards
for several weeks
Which version is targetted for optimization of OR searching on two keys,
that is, "select * from sometable where f1 = 123 or f2 = 123",
as described in http://www.mysql.com/doc/en/Searching_on_two_keys.html
?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
I just ordered this book
MySQL
The definitive guide to using, programming,
and administering MySQL 4
by Paul Dubois
I found it more technical than MySQL cook book by Paul Dubois
On Thu, 31 Jul 2003, Ralph Guzman wrote:
> Here are two other books that I would recommend, specially the first
> o
* Petre Agenbag
[...]
> This works:
>
> select distinct name, max(id) as mid from table group by name
>
> but it only returns the name and the highest id for such a name.
>
> if I try this:
>
> select distinct name, max(id) as mid, anything_else from table group by
> name
>
> it returns the FIRST
Hi
I guess I will plug Paul's books. I have his MySQL book and his MySQL
and Perl for the Web. I really enjoyed the second one but the MySQL book
was very well written. I also have read Sam's teach yourself MySQL in 21
days which seemed pretty light weight and I never look up anything in i
Here are two other books that I would recommend, specially the first
one:
* SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in
SQL
by Michael J. Hernandez, John L. Viescas
Joe Celko's SQL for Smarties: Advanced SQL Programming
by Joe Celko
-Original Message-
From: Fa
Hi,
I would like to learn about RDBMS, namely mysql of course, but know really nothing in
this area, so have to learn about; RDBMS, SQL and mysql from scratch.
In this regard, if anyone knows of any books they think would start me off on the
right foot, I would be very grateful.
I have done s
The permissions should be as follows:
/usr/local/mysql/data/ mysql owner 600 is no problem
if the linux.err does not exist create one
touch linux.err
now u can try. I hope it helps.
--
Aftab Jahan Subedar
Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
81/1-A North Jatrbari
Dha
I have to do a catalog search through multiple tables and columns for
product model number, description, and name. I realize that doing
pattern matching with multiple LIKE statements is slow so I found that
FULLTEXT searches is a better alternative.
I have added a FULLTEXT index to the tables I'm
I have tried to remove myself from this list, but the unsubscribe
function does not function. How does one get off of this list?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The simplest way, if you have the ability to make an ODBC connection to
the mySQL box, would be to create an ODBC linked table in access and
then run an append or make-table query against the linked table, as per
your situation requires.
I assume that you could write a macro that would run the
Hi
I have purchased a package that uses ASP and SQL, my webhost provides MYSQL
and I have loaded my access database and all seems to be working fine.
Except the stored procedures (Queries) the webhost says MYSQL doesn't support
stored procedures, as this site confirms (wait for v5.0) but th
how about
UPDATE testTable set testField='' WHERE
test_id >= 100 and test_id <= 1000;
Mike Doanh Tran wrote:
>
> Hi,
>
> How do i use the UPDATE statement to update a range of Primary Key id
> numbers. (let say 100 through 1000).
>
> Example,
>
> UPDATE testTable set testField='' WHE
I'm building an integrated system with Access and mySQL. Some company has na internal
system based on Access and a web site with a form that saves its variables in a mySQL
db. Can I make a system that migrates automatically the data from the mySQL online db
for the the local Access db? And how?
Hi,
How do i use the UPDATE statement to update a range of Primary Key id
numbers. (let say 100 through 1000).
Example,
UPDATE testTable set testField='' WHERE
test_id in (100:1000);
Thanks in advance for any comments,
Mike
--
MySQL General Mailing List
For list archives: http://lis
Hello,
I am having some performance difficulties due to the number of
connections getting so high. I know that the correct way to solve this
is by using connection pooling, but for now I can't figure out why the
connections are'nt being released as I expect.
I am using Tomcat 4.0, with mm.mysql-
On Thu, Jul 31, 2003 at 08:36:02PM +0200, NEWMEDIAPLAN wrote:
> Can mysql handle 5000 concurrent webusers sending queries to the db through
> a web search engine.
> Is it possible (with a very big server/hw) ?
What OS are you using? And how much hardare?
--
Jeremy D. Zawodny | Perl, Web, M
On Thu, Jul 31, 2003 at 02:51:10PM -0400, [EMAIL PROTECTED] wrote:
>
> Hopefully jeremyz will toll in.. he's probably hit it before ;)
I've been up to 2000 connections on a 1GB FreeBSD box. With some
tweaking, I'm sure you could go quite a bit higher.
Jeremy
--
Jeremy D. Zawodny | Perl, W
Hi, I'm a new user of MySQL on Linux.
I have been an Oracle DBA; and know that anyone familiar with Oracle takes
backup procedures very seriously
Anyone have recommendations for nightly backup procedures for MySQL
(transactional) databases? The literature seems a little ambiguous on this.
>From going over
http://www.mysql.com/doc/en/MySQL_indexes.html (again)
http://www.mysql.com/doc/en/Indexes.html (again)
And doing some experimentation it seems that when I build a compound
index (A key spanning multiple column) of column types
String, int, int - sorting the result takes a very
Hi
Did you remember to flush???
- Original Message -
From: "Adam Fortuno KOVICK" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: July 31, 2003 4:33 PM
Subject: ARGGH! - User password problems
> All,
>
> I've been attempting to assign a password to a user with the following
> sta
All,
I've been attempting to assign a password to a user with the following
statement:
UPDATE mysql.user SET password=PASSWORD('foo') WHERE user = 'acc_name';
I get the typical:
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
However, when the user attempts the lo
Contents are Direct Alliance Corporation CONFIDENTIAL
-
- For writing long sql statements I prefer mysqlcc,
and the tab feature is nice.
- Phpmyadmin also has some handy feature. Most of it is preference...
If learn to use both then all the better...
-Original Message-
From: Dathan
No.
Ones a client application the other is a web app.
The client application has SQL completion, the web app does not.
-->-Original Message-
-->From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 31, 2003 11:52 AM
-->To: [EMAIL PROTECTED]
-->Subject: Mysqlcc vs Phpmyad
This is what I bumped into now
030731 15:39:50 mysqld started
030731 15:39:52 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 3491794745
InnoDB: Doing recovery: scanned up to
I was wondering if anybody wth expereince with other
tables types than MyIsam would be able to fill in a few blanks for me:
I'm trying to find what file extentions are associated with what table types. And
which file types are associated with the Field's listed below of a SHOW TABLE STATUS.
Or
mysqlcc has a limit of 1000 on all queries I run. I can understand this for
SELECT queries, but it makes no sense for INSERT... SELECT queries.
Is there a way to override this limit?
-Jackson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
The answer (like most of these) is, "it depends". You really need to
benchmark your application to know how often a "user" is going to
actually hit your database server, and how many connections the
application creates for each user. I've got a server that handles the
databases for 3000 users h
Hello again people,
Can someone tell me if mysqlcc does the same thing as phpmyadmin.
Thank you all
Ola
Hopefully jeremyz will toll in.. he's probably hit it before ;)
On Thu, 31 Jul 2003, NEWMEDIAPLAN wrote:
>
> I was considering different boxes. But I'm courious to know if
> anyone here knows the possibility we have with mysql... just to foresee the
> crash.
>
> Just a software matter assuming w
it's like bash_history.. command history (used with up/back key mostly)
You want to get rid of it for good: ln -sf /dev/null .mysql_history
On Thu, 31 Jul 2003, Jean Hagen wrote:
> We're just getting started with MySQL on Linux; I was browsing my home
> directory and found a file called .mysq
I was considering different boxes. But I'm courious to know if
anyone here knows the possibility we have with mysql... just to foresee the
crash.
Just a software matter assuming we have a very big server :)
I saw max_connections and things like this. What's the real limit, tested?
|-Origin
We're just getting started with MySQL on Linux; I was browsing my home
directory and found a file called .mysql_history. It contains a history of
all mysql commands I've entered - including logging on, setting passwords
for users, etc.
Sure enough, other users of mysql have the same file.
Qu
I'm not sure you'd want to do that way... Perhaps 5+ replicated boxes from
a master that share the queries equally (hardware load balancer).. Might
be cheaper in hardware than buying some heavy horsepower box..
On Thu, 31 Jul 2003, NEWMEDIAPLAN wrote:
> Can mysql handle 5000 concurrent webuser
Can mysql handle 5000 concurrent webusers sending queries to the db through
a web search engine.
Is it possible (with a very big server/hw) ?
Thanks. Roberto
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
Can mysql handle 5000 concurrent webusers sending queries to the db through
a web search engine.
Is it possible (with a very big server/hw) ?
Thanks. Roberto
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Victoria,
I just had this problem solved for me by the list. It was permissions
on the mysql/data directory. See the topic "Running mysql (complete
newbie)".
HTH
Peter
On Thu, 2003-07-31 at 08:50, Victoria Reznichenko wrote:
> Vidhya CS <[EMAIL PROTECTED]> wrote:
> > I am this error while run
Anyone know when it will be considered production stable?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am opening 4 different databases and was hoping when I do a mysql_query I
could just grab the connection id rather than reconnecting everytime I want
to query a new database.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 9:08 PM
To: [EMAIL
At 02:32 PM 7/30/2003, you wrote:
Group,
I have been working on a project for a while now trying to figure out how
to remove duplicate records from a single table using a query. To
complicate matters, what constitutes a duplicate record is a match on
several fields, but not all fields. I have
Hi,
Ok , i complete my answer about the MySQL version. I have used all three
versions 4.0.13
(debug - max - standard) for Linux RedHat.
And all theses versions have indicated the same message : mysqld got
signal 11.
Has a procedure to , may be, find what goes wrong in section : E.1.4
Using a Stac
I am currently in the process of building a calender/date MySQL table that will
be searched for available dates for holiday tours?
I want to use a time column as there will be a restriction on places for up to 3
days so this will have to be taken into account.
Has anyone done something like this?
> Hello Dan,
>
> Probably the reason that no-one has replied to you is that
> on-one feels that they have anything helpful to add to what
> you already know. A quick check on my system shows that the
> data and index sizes reported by SHOW TABLE STATUS are the
> same as the byte sizes of the M
Excellent Terry Thanks I'll into that a little more.
Basically I'm trying to make the most efficient function I can
That will return the size of a table and the size of a database,
so I can put it in aPelr module and make it avaialable to all.
Thanks
Dan
> -Original Message-
> From: T
Is it possible to run 3.23.43 and 4.0.13 on the same server?
I don't see anything in the documentation that should prohibit this as
long as the installations are in different directories, use different
sockets/ports and data directories.
Can this be done utilizing mysqld_multi and if so are ther
hi,
the > sign remains in the command , so you will have :
C:\mysql\bin\>mysqldump -u ola -p --opt --databases --complete-insert
--flush-logs > d:\path\to\backup\filename.sql
The > sign will redirect output into file.
Thierno 6C
-Original Message-
From: Ola Ogunneye [mailto:[EMAIL PROTE
Hi,
rapid correction !!
in the backup command, retrieve the word mysql placed just after
--flush-logs .
Thierno 6C
-Original Message-
From: Thierno Cissé [mailto:[EMAIL PROTECTED]
Sent: jeudi 31 juillet 2003 15:40
To: 'Ola Ogunneye'
Cc: [EMAIL PROTECTED]
Subject: RE: Help!!! Need to back
Hi all,
My slave has been working fine up until now. Here is the error message.
030730 11:32:28 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'SQLServer1-bin.034' at position 77571524
ERROR: 1062 Duplicate entry '120816' for key 1
030730 11:32:28 Slave: er
Hi,
when you run this backup command, it wait that you provide a password
(it is as if it were spirit to treat the command)
without prompt; so just after you press enter key to run the backup
command, type here you password.
Also you can place directly the password in the command like this :
mysql
Dan
What you may be looking for (and I had to hunt around to find it myself!)
is
myisamchk -eis table_name
Hope that helps - just because you don't get an answer doesn't mean we
don't care - it probably means we don't know.
Terry
--Original Message-
> Ok, if this is th
To select records only once try something like
select * from your_table
group by field1, field2, ..
Regards, Paul
Kim Mackey wrote:
> Group,
>
> I have been working on a project for a while now trying to figure out
> how to remove duplicate records from a single table using a query. To
Hello Dan,
Probably the reason that no-one has replied to you is that on-one feels
that they have anything helpful to add to what you already know. A quick
check on my system shows that the data and index sizes reported by SHOW
TABLE STATUS are the same as the byte sizes of the MYD and MYI files
hi,
> Still a newbie, and running mysql on windows 2000 Advanced Server. I
am trying to backup
> mysql and was confused as to which command to use. I see the following
options
use mysqldump .
If you want backup whole database(s) , proceed to next :
mysqldump -u username -p --opt --databases --com
This script is run on *nix machines only. It installs the mysql and test
databases into mysql. Windows installation does this by default. BTW, these
*.sh are BASh scripts.
Scott
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 10:50 AM
To:
Hi,
I'm sure I'm missing something simple. I've searched the doc but can't find an answer.
I downloaded and installed MySQL for Windows this morning, V4.1. Unzipped, installed
and started the server as a service, no problems. Installed the ODBC driver. A-OK
But, the DOC tells me I have to r
Hello list,
is there a common naming system for db objects ?
Like:
1) Tables: mytable, tblmytable, tbl_mytable
2) Indices: idx_anindex
3) Columns: int_somenumber, date_lastupdate
4) id for the numerical primary key e.g. table customers.id
and then for referencing foreign keys
table
Hello again,
Still a newbie, and running mysql on windows 2000 Advanced Server. I am
trying to backup mysql and was confused as to which command to use. I
see the following options
mysqldump
mysqlhotcopy
Now the confusion is really in the syntax used in the MYSQL Second
Edition. I looked on pa
mysql> SHOW VARIABLES LIKE "have_innodb";
+---+--+
| Variable_name | Value|
+---+--+
| have_innodb | DISABLED |
+---+--+
1 row in set (0.02 sec)
mysql>
===
Goodygood, Victoria !!!
Thank you Sir,
This saves my keyboard,
now ple
hi
No,I installed Mysql server (not max) by default.
=== 2003-07-31 09:56:00 you have composed：===
>Hi,
>i already have this problem with MySQL 4.0.13 (max) on RedHat, with the
>same message in .err file.
>Does you enable QUERY_CACHE in your configuration ?
>
>Thierno 6C
>
>---
Ok, if this is the wrong mysql list could someone tell me
which list would best be able to handle my question if no one
on this list knows how to get the table and database sizes?
TIA
Dan
> Ok at least could someone tell me if the SHOW TABLE STATUS
> fields 'Data_length' and 'Index_length' a
Hi Programmers,
after this legal statement
ALTER TABLE EMPLOYEE TYPE = InnoDB;
I get
Warnings: 0
and still MySQL claims to have to use Type = MyISAM,
Which has never supported Foreign Key constraints.
There must be a workaround for this,
My queries are unambiguous, and MySQL does not obey
"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote:
>
> according to what I experience,
> I do definitely run the default binaries, perhaps the daemon mysqld
> has to be started with an option in order to support InnoDB ?
>
> How can this be investigated ?
>
> C:\mysql\bin>mysqld -v
> mysqld V
Morten,
On Thu, Jul 31, 2003 at 03:27:51PM +0200, Morten Gulbrandsen wrote:
> according to what I experience,
> I do definitely run the default binaries, perhaps the daemon mysqld
> has to be started with an option in order to support InnoDB ?
>
> How can this be investigated ?
>
Well, I ne
>
> If this is the case, is there a crude workaround method of
> attempting to
> perform the following until such a time as it is?
>
> SELECT COUNT(*) FROM messages WHERE forum_id IN (SELECT forum_id FROM
> forums WHERE team_no = 400)
select count(message_id) -- assuming you have a non-null
I believe the multiple 'SELECT' statements will not be included until
version 4.1 is released?
If this is the case, is there a crude workaround method of attempting to
perform the following until such a time as it is?
SELECT COUNT(*) FROM messages WHERE forum_id IN (SELECT forum_id FROM
forums WH
Dear Fred,
according to what I experience,
I do definitely run the default binaries, perhaps the daemon mysqld
has to be started with an option in order to support InnoDB ?
How can this be investigated ?
C:\mysql\bin>mysqld -v
mysqld Ver 3.23.55-max-debug for Win95/Win98 on i32
C:\mysql\b
"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote:
>
> I use Version DBMS MySQL 3.23.55 runing under Windows 2000.
>
> I have coded this from a textbook;
> ===
>
>
> C:\mysql\bin>type constraint.sql
> USE company;
>
> DROP TABLE IF EXISTS EMPLOYEE;
>
> CREATE TABLE EMPLOYEE
> (
> FNAME
Hi,
On Thu, Jul 31, 2003 at 02:46:06PM +0200, Morten Gulbrandsen wrote:
> According to the manual :
>
> "7.5.5.2 Foreign Key Constraints
> Starting from version 3.23.43b InnoDB features foreign key constraints.
> InnoDB is the first MySQL table type which allows you to define foreign
> key constr
Dear MySQL developers,
Could some experienced Database developer please take a look at this ?
It is supposed to be plain SQL2.
How can it be coded under MySQL
Especially all referential triggered actions.
According to the manual :
"7.5.5.2 Foreign Key Constraints
Starting from version 3.23
Alec Smith <[EMAIL PROTECTED]> wrote:
> I have two tables as below:
>
> CREATE TABLE domain_types (
> type_id INT(4) NOT NULL AUTO_INCREMENT,
> name VARCHAR(10) UNIQUE NOT NULL,
> description VARCHAR(75),
> PRIMARY KEY(type_id)
> ) TYPE=INNODB COMMENT="Types of domains we store";
>
> CREATE T
Hello programmers:
I use Version DBMS MySQL 3.23.55 runing under Windows 2000.
I have coded this from a textbook;
===
C:\mysql\bin>type constraint.sql
USE company;
DROP TABLE IF EXISTS EMPLOYEE;
CREATE TABLE EMPLOYEE
(
FNAME VARCHAR(15) NOT NULL,
MINIT CHAR,
LNAME
Thank you very much!
1. Is it a way to grow the speed of the replication out of the
master-connect-retry variable?
2. I backup the databases. Assuming that the last relay log file is
sql-relay-bin.005 and the last bin log file is sql-bin.007, can I simply
delete the files from sql-relay-bin.001 t
"Jon Hancock" <[EMAIL PROTECTED]> wrote:
>
> I have read in past postings that UTF8 is not yet working with MySQL 4.1 on the
> Windows build.
> Can anyone verify this?
Yes, utf8 was not compiled. It will be fixed in the next release.
> If it is not yet working, can anyone give an estimate when
"Primaria Falticeni" <[EMAIL PROTECTED]> wrote:
>
> How can I see the value of master-connect-retry? show variables doesn't work
> on it.
Use SHOW SLAVE STATUS command:
http://www.mysql.com/doc/en/SHOW_SLAVE_STATUS.html
--
For technical support contracts, goto https://order.mysql.com/?
GlacierI have connect my web server (master) to my local server (slave)
through dial-up and replicate 2 databases.
a) Is there a log file describing the replications that happend (if any)?
b) how do I know when to stop the dial-up so not to stop any data transfer
through repliication?
Thanx Nikos
"Victoria Reznichenko" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Marcin Blazowski" <[EMAIL PROTECTED]> wrote:
> > "Marcin Blazowski" <[EMAIL PROTECTED]>> wrote:
> >>> I've created a database and a user with ALL PRIVILEGES and GRANT
OPTIONS
> To be able give permissions to oth
The cleanest way is to add a column (ukey) to the table which will uniquely
identify each record.
This will help you in the following phases too. Let's say the name of your
table is 'focus_table'.
1.adding the unique key 'ukey':
ALTER TABLE 'focus_table'
ADD COLUMN
ukey BIGINT(12) AUTO_INCREMENT P
Hi,
i already have this problem with MySQL 4.0.13 (max) on RedHat, with the
same message in .err file.
Does you enable QUERY_CACHE in your configuration ?
Thierno 6C
-Original Message-
From: powercola [mailto:[EMAIL PROTECTED]
Sent: jeudi 31 juillet 2003 09:47
To: [EMAIL PROTECTED]
Subj
hello
I have a OpenBSD3.3 box with mysql-server 4.0.13. the mysql-server runs
normally at the beginnig . Trouble come up these days that the mysqld server will down
. There's error messages appers that lost connection during query when the client
connect to it.
There's errors
Hi List
Can anyone help me to do the following without the need of subselects:
I have a table that contains rows where mostly, the only common field is
the "name". The rest of the data fields, even though they are related to
the "name", differs from row to row ( they are things like the address
I'm reticent to consume any more of this lists bandwidth and trust this will
end the thread, but here is my point. There are many 'gotchas' to consider
when developing an application that uses any dynamic file structure from
simple flat ascii
files to engorged dbms's. Add multi-user and multi-tas
Vidhya CS <[EMAIL PROTECTED]> wrote:
> I am this error while running mysqld_safe
> # ./bin/mysqld_safe --user=mysql &
> [1] 19413
> # Starting mysqld daemon with databases from
> /export/home/siptech/vidhya/ifmonitor/mysql/data
> 030728 12:17:49 mysqld ended
>
> The daemon is not starting . what
> -Original Message-
> From: Donald Tyler [mailto:[EMAIL PROTECTED]
> Sent: 30 July 2003 16:42
> To: [EMAIL PROTECTED]
> Subject: Advice wanted on Data Structure
>
>
> I have a question that I hope I can explain well enough:
>
> I am trying to figure out a data structure for an inventory
>
Kim Mackey wrote:
Group,
I have been working on a project for a while now trying to figure out
how to remove duplicate records from a single table using a query. To
complicate matters, what constitutes a duplicate record is a match on
several fields, but not all fields. I have been successful
On Wed, 2003-07-30 at 17:40, Vladimir Shiray wrote:
>
> How can I make hotcopy of my database if it have many tables (more than 1000) ???
> mysqlhotcopy failed when it try to lock all tables ...
>
> How many tables can I lock at one time ?
> Can I increase this limit ?
>
Hi,
You probably ran ou
Beacuse of this type of mail , i got listed on spam bag for using the
mailing lists inform the linux comunity of my site , wich is a free service.
If see this kind of junk on any mailing list ill make it my personal mission
to have you domain fried
Don't post unless it's goning to help the opens
98 matches
Mail list logo
