Hi everyone,
So, back to the problems with auto_increment columns and replication
problems. I have noticed this problem always occures when using INSERT
SELECT syntax with an auto_increment key
simple example:
CREATE TABLE test1 (value INT);
INSERT INTO test1 SET value=1;
INSERT INTO t
Hi!
On Sep 09, [EMAIL PROTECTED] wrote:
>
> I'm using MySQL v4.0.12 on Redhat Linux 9.0
>
> I have a python script (using the MySQLdb module) that inserts a large
> batch of records to several MyISAM tables. The largest table (named
> 'log') has 20 columns. A single column defines the primary
> I installed mysql 4.0.14 binary distribution on RedHat
> 8.0 following the instructions in the manual. But I
> can't get it to work. Please help.
>
> When I start mysql using the command:
>
> shell> bin/mysqld_safe --use=mysql &
>
> the following message shows:
> "Starting mysqld daemon with
Hi all,
I installed mysql 4.0.14 binary distribution on RedHat
8.0 following the instructions in the manual. But I
can't get it to work. Please help.
When I start mysql using the command:
shell> bin/mysqld_safe --use=mysql &
the following message shows:
"Starting mysqld daemon with databases
I have 2 databases, in each is a table called 'resources', my cleint has
asked that they always be identical to each other. Database1 will be the
master by which all else is made equal. My question:
Should I just create website #2 to talk to Database #1, I am hesitant to do
this as I have a conn
On Tue, Sep 09, 2003 at 02:56:56PM -0700, [EMAIL PROTECTED] wrote:
>
> This seemed like an ideal case to DISABLE KEYS, insert the data and
> then ENABLE KEYS based on the MySQL documentation. And running some time
> tests proves that this approach runs much faster.
>
> However, in doing so, th
This should work, but will not use any index on date_field:
SELECT field FROM table WHERE DATE_FORMAT(date_field, "%Y-%m-%d") =
'2003-10-10';
This is better and will allow an index to be used if appropriate:
SELECT field FROM table WHERE date_field >= "2003-10-10 00:00:00" AND
date_field < DATE_A
Dear All,
We recently upgraded from 3.23 to 4.1.
We used to use queries such as:
SELECT field FROM table WHERE date_field like '2003-10-10%'
(The date_field is a "datetime" field)
Since we found the performance quicker than using the date functions.
However this no longer works in 4.1, and th
In the last episode (Sep 09), Andrew Kuebler said:
> I need to store strings encrypted with TripleDES that sometimes
> contain unprintable characters (Hexidecimal values under 20). The
> values do not seem to properly store in CHAR columns and I don't see
> any other column types that might work.
I need to store strings encrypted with TripleDES that sometimes contain
unprintable characters (Hexidecimal values under 20). The values do not
seem to properly store in CHAR columns and I don't see any other column
types that might work.
Anyone have any other suggestions?
Thank you in advance!
> I've read about using symbolic links, but only for using
> multiple data
> directories, not splitting a file (not to mention, across
> more than one node).
Symlinks wont work for splitting a file...
> Since MySQL doesn't directly support this, any ideas on doing
> it at the OS
> level t
In a message dated 9/9/03 7:53:59 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> By "partitioning", you mean having one table divided across N
> partitions?
Yes, I do.
>
> Such a feat isn't directly possible with MySQL, however you can create N
> tables instead of 1, and use a table
Martin Gainty wrote:
Daniel
Pass thru query executes on an ODBC Database.
Is your MySQL Server setup as an ODBC Database?
-Martin
Yes of course.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2
Daniel
Pass thru query executes on an ODBC Database.
Is your MySQL Server setup as an ODBC Database?
-Martin
- Original Message -
From: "Daniel Kasak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 09, 2003 4:17 PM
Subject: Calling a stored procedure from MS Access
By "partitioning", you mean having one table divided across N
partitions?
Such a feat isn't directly possible with MySQL, however you can create N
tables instead of 1, and use a table of Type=RAID on the master to
"unify" them for purposes of queries that need to access data from many
partitions.
Hi all.
I have MySQL-5 running and have made a simple stored procedure which
accepts a varaible and selects from a table based on that variable:
create procedure msp_BillingBySavingsNo(input_SavingsNo int)
select * from Billing where SavingsNo=input_SavingsNo
If I enter the mysql client and type
In the last episode (Sep 09), Bill Todd said:
> I know, I know, with database servers more is always better. However,
> assume I need to deploy MySQL using InnoDB to multiple sites. Hardware cost
> is a significant consideration. Is there any information available on
> MySQL's memory requirements?
I know, I know, with database servers more is always better. However,
assume I need to deploy MySQL using InnoDB to multiple sites. Hardware cost
is a significant consideration. Is there any information available on
MySQL's memory requirements? Most database vendors give you something as a
starting
I'm using MySQL v4.0.12 on Redhat Linux 9.0
I have a python script (using the MySQLdb module) that inserts a large
batch of records to several MyISAM tables. The largest table (named
'log') has 20 columns. A single column defines the primary key. There
isn't an auto increment column. Many of
Andy Kannberg wrote:
Hi all,
I'm trying to compile MySQL 4.0.14 on a SUN Enterprise 220R, running on Solaris 9
12/02 with the latest patch clusters installed. I use gcc 3.2.3 to compile, along with
gnu make 3.80
I've followed instructions in the MySQL Docs from www.mysql.com, so I've run this
Hi all,
I'm trying to compile MySQL 4.0.14 on a SUN Enterprise 220R, running on Solaris 9
12/02 with the latest patch clusters installed. I use gcc 3.2.3 to compile, along with
gnu make 3.80
I've followed instructions in the MySQL Docs from www.mysql.com, so I've run this
command :
CFLAGS="-O3
Does anyone know if it is better to have 1 large innodb datafile on a disk or
if it is better to have a few smaller datafiles?
Here is what I have. Both drives are 15K scsi running at full 160MB/S speed.
/var/lib/mysql/ - contains all myisam tables as well as a 1GB innodb
datafile.
/mysql2 -
Hi,
Actually, I don't see why you can't have your full-text indexes on
seperate tables and use a query like this:
SELECT
MATCH(t1.col) AGAINST('string') + MATCH(t2.col) AGAINST('string') AS rel
FROM table1 t1
INNER JOIN table2 t2 ON (t2.id=t1.id)
WHERE MATCH(t1.col) AGAINST('string') AND -- or u
Hi Donald,
Is the script possibly sending a query larger than max_allowed_packet
(1MB default)? Have you read http://www.mysql.com/doc/en/Gone_away.html
?
Matt
- Original Message -
From: "Donald Tyler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, Sept
In a message dated 9/9/03 4:52:53 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> If you're accessing your db through JDBC, an idea that I've been following
is
> the c-jdbc project...
Very nice, but we will be using LAMP (Perl and PHP). :-/
>
> http://c-jdbc.objectweb.org/
>
> it'
If you're accessing your db through JDBC, an idea that I've been following is the
c-jdbc project...
http://c-jdbc.objectweb.org/
it's software raid clustering for databases... it's still in beta, but it looks very
promising for easy clustering. Combined w/ MySQL's master/slave setup, it could
Hi,
We are trying to find a way to distribute a large MySQL database across
several systems, each configured as a master to a slave. At this point we are
tossing architectural ideas around and here is where we are right now:
Primary (Master)
I'm running MySQL 4.0.14 on Mac OS X 10.2.6 on a development server. We
have around 60 tables on the development server and the production
servers. 18 tables that exist on the production server are replicated
to our development server. We use the replicate-wild-do-table config
option to tell it
I seem to be having some trouble with using GRANT and REVOKE. I am
implementing a "user management" form in my application that does the
following:
REVOKE ALL ON mydb.* FROM 'Username'@'%'
I get an error "Access denied for user: 'MyAdmin@' to database
'mydb'". The Revoke statement is being exec
And although it blows out your single-query theory further out of the water,
you could query your listing for a count of each starting letter of the last name,
getting something like this:
[syntax will be wrong (closer to Oracle syntax), but I don't have a mysql installation
at work to get it r
I'm not quite following what you are asking. If you want to limit the
result to only 10 items per page, you're going to need to come up with
some paginating code (it actually isn't that hard). You could easily
get more than 10 names starting with a single letter.
If you want to create specific
Hi,
Thanks for your reply...
I'm aware of this..But wondering if there is any way
to do this, i mean integrate the mysql authentication
with windows authentication...
Thought it'd be good if users of my database
application needn't type their username and passwords
every time they start the app.
Thanks Martin,
No I do not have that option unfortunately. I really do suspect that it has
nothing to do with mysql and that rather it is the router/IPs configuration
and called them upon this, but they said all is fine. So I frankly have no
clue where to go from here.
thanks again for any sug
- Original Message -
I would use MySQL CC (command center, I think...)... I seem to remember
someone mentioning that mysql gui is discontinued...
CC is available from the mysql.org site, and is very easy to install on
windows xp (it's on my laptop...)
I second that. It's easy on Linux
Hi to all...i've a problem...would anyone help me?
I've a table called COURSES, where there are some universitary courses.
I've a table called DIDACTIC_UNITS, where there are some subjects with some
info like the professor, the course year, etc.
The problem is that some didactic units can be lend
At 10:29 -0700 9/9/03, Madhavi Kutty wrote:
Hi ,
Is there any way i can use the os authentication in
Windows(2000 or XP) to work with the mysql server? So
that a person can get access to the server when they
log in to a machine?
MySQL doesn't know anything about your OS accounts.
You use GRANT to
I have a page that is a directory of names ordered by lastname,
firstname (e.g. SELECT fn, ln FROM directory ORDER BY ln, fn LIMIT 0,10).
I have it paginated so that there are 10 results per page. What I'd
like to do instead of having page numbers (which can be unhelpful when
trying to page t
Hi,
this is the weirdest error I have ever encountered.
We get an error 2013 lost connection when we try to connect via mysql to
another machine having mysql on it as well. The weird part is that when
we change the IP address of the connecting machine to another service
provider it works fin
I have this strange feeling of deja-vu
This was just posted to the list recently (last week?), and currently, you cannot do
cross-table full-text indexes, excepting boolean text searches, which would be slow.
I have this strange feeling of deja-vu
Dan Greene
> -Original Message-
Hong,
I suggest reviewing the MySQL manual (sections 4.3.9.1 through 4.3.9.4
inclusive). As best I know, those are the manual sections dealing with SSL.
4.3.9.1 -> http://www.mysql.com/doc/en/Secure_basics.html
4.3.9.2 -> http://www.mysql.com/doc/en/Secure_requirements.html
4.3.9.3 -> http://www.
Hello everybody!
Fulltext search fulfills all my needs, only it would be great if someone
walked me through using multiple tables with this feature. How to address
this MATCH to indexes on different tables?
Things like MATCH(table1.column, table2.column) give me errors.
Thanx in advance,
--
M
Dear Sir/Madam:
I have download MySQL 4.0 Windows version server binaries. Would you please
tell me is this version support SSL? How to config it?
Thanks a lot,
Hong
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
I am using mysql_connect. But I just changed it to mysql_pconnect and it did
exactly the same thing.
-Original Message-
From: Marek Kilimajer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 10:48 AM
To: Donald Tyler
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Lost Connection to M
I have a script that is processing data from a single table and splitting it
into smaller normalized tables.
The script takes anywhere between 5-10 minutes to complete, and as it runs
it constantly outputs a report on its progress.
The script seems to run fine the first time I run it, but w
Ken,
The problem is that you've got a compound index on files which type_id isn't
the first item. If you create a new index on files, just on type_id, all
will be fine.
Mysql would only be able to use a compound index for this query if type_id
was the first column in it.
Andy
> -Original M
I cant build mysql-3.23.36 in Red hat Linux 9. But I can build succussfully
in Red hat Linux 7 and 8.
If I use mysql version greater than 4 I didnt get any error. But I want to
build mysql-3.23.36.
make[2]: Entering directory `/usr/local/mysql-3.23.36/client'
/bin/sh ../libtool --mode=link
c++ -O3
Hi ,
Is there any way i can use the os authentication in
Windows(2000 or XP) to work with the mysql server? So
that a person can get access to the server when they
log in to a machine?
Regards,
Madhavi
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web
Having developed such an app myself (albeit in Oracle where the wonder of 'connect by'
exists which according to 'to-do' lists is coming for MySQL yippie!), this is what
I recommend...
1- if your forum is 'threaded', i.e. a message is in response to another, you can use
that linking to get
I have a query that won't seem to use an index. See below for the EXPLAIN, the tables
and the indexes (relevant fields only, so no need to ask me why I'm bothering to do a
query with nothing else in it).
Note that if I change "select t.Desc" to "select t.type_id", then MySQL correctly uses
the
I found the problem which I will outline here just in case anyone else
runs across it in the future:
It appears that a slave will not replicate data from it's own server-id.
In my case, a large portion of the binary logs on my slave had originally
come from the master, so when the master trie
Hi there!
--- Christopher Knight <[EMAIL PROTECTED]> wrote:
> next:
> select cols from table where id > YOUROLDID and
> forums = CURRENT_FORUM order by id limit 1
> previous:
> select cols from table where id < YOUROLDID and
> forums = CURRENT_FORUM order by id desc limit 1
Thanks for your answer
next:
select cols from table where id > YOUROLDID and forums = CURRENT_FORUM order by id
limit 1
previous:
select cols from table where id < YOUROLDID and forums = CURRENT_FORUM order by id
desc limit 1
however, this may not be as fast or efficient enough
ou might want to create another id field
As I suggested..
Of course, my advice assumes that each related message is stored in
id sequence. If it is not, then your application might have to assign
a unique sequential id (in addition to the id field I mentioned above)
that associates the messages together as a group.
Hi there!
--- Mark Richards <[EMAIL PROTECTED]> wrote:
> If you simply have a table with an id field that has
> the auto-increment
> attribute (field is int(10)) then you can get the
> current id and go from
> there. To get the current ID of a record you just
> created, you can use the
> mysql_in
SET AUTOCOMMIT=0; -- Disable automatic COMMITs after each statement.
-- Tx #1. Do your work here.
COMMIT; -- or ROLLBACK if there was an error.
-- Tx #2. Do more work here.
COMMIT; -- etc...
Keep in mind that errors can result in either the offending statement
being rolled back (leaving the rest
Maria,
If you simply have a table with an id field that has the auto-increment
attribute (field is int(10)) then you can get the current id and go from
there. To get the current ID of a record you just created, you can use the
mysql_insert_id($link) function in PHP, or the MySQL equivalent. Reme
Does anyone know of any programs that will parse e00 files and load the data into
MySQL?
Does anyone have any "real world" experience with the spatial capabilities of MySQL?
Is it still
"somewhat beta" or is it really "ready for prime time"?
Thanks.
Mike
__
Do
At 12:43 AM 9/9/2003, you wrote:
Bill,
- Original Message -
From: ""Bill Todd"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, September 09, 2003 4:27 AM
Subject: Do InnoDB rollback segments expand dynamically?
> Using InnoDB with an autoextend tablespace, if I star
Hi there!
I'm currently developing a web where we let users
create their own forums. All the messages (wherever
they are posted) are stored in the same mysql table.
When users read a certain message I would like to
display the previous and next message in that forum.
Since all the messages (of t
Oh, right- I forgot to mention that. Part of the error
message in trying to connect to the database said that
it couldn't find the mysql.err file. I installed mySQL
in C:\mysql but the error message from the DOS shell
said it couldn't find the file:
D:\mysql\data\english\mysql.err. I am not sure wh
MySQL Colleagues:
If you're interested in a new commercial-grade Web application server
product which includes a commercial license of MySQL 4 embedded,
please read on. We're excited to provide a version of Lasso with
MySQL 4 built-in. This yields superior performance and provides
tighter secu
On Tue, Sep 09, 2003 at 01:30:51AM -0500, Matt W wrote:
>
> > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
> > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
> >
> > MySQL 4.0.15-Yahoo-SMP: up 1 days, processed 47,861,708 queries (374/sec. avg)
>
> Off topic: Been wonderi
Yes it still is a MySQL DB but not on the same system albeit another system
on the network.
Regards
Barry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Heikki,
You can get the new driver at
http://codecentral.borland.com/codecentral/ccweb.exe/author?authorid=163237
I have not tried it to see if the multiple connection problem is fixed. I am
new to MySQL and have not tried to use it with dbExpress yet.
Bill
> -Original Message-
> From:
Sinisa Milivojevic wrote:
On Mon, 08 Sep 2003 19:57:25 +0100
Steve Davies <[EMAIL PROTECTED]> wrote:
Hi All
I'm currently trying to learn C so that I can recode some php/mysql apps
I've got but I've run into probs right at the start.
I'm trying to compile the examples PDuBois MySQL (myclient
There's also
# backup databases
for dbname in `echo 'show databases;' | mysql -u$dbuser -p$dbpassword`
do
echo "Backing up database $dbname..." >>
$destdir/backup.log
mysqldump -u$dbuser -p$dbpassword $dbname | zip -q9
$destdir/db_$dbname.zip - >> $destdir/backu
Hi guys,
I have an INNODB database and I want to port the data to another one. Please let
me know of the feasibilty of the idea and if any tools are available as this regards.
Regards
Barry
* Jonathan Edwards
> I'm running MySQL on a Linux server with 2 processors, 4 Gb memory and
> SCSI disks. I am using MySQL to manage a database with 3 million reports
> and various auxiliary tables which are also fairly large.
>
> My question is: How do I make the best use of the 4 Gb memory availa
Scott,
You should be able to find a file titled 'mysql.err' in your data directory.
This file will contain information that should help you get started.
-Original Message-
From: Scott D. Spiegler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 6:59 AM
To: [EMAIL PROTECTED]
Hi,
I am using the binary distribution of mySQL for
Windows-2000 and am not able to connect to the
DBserver. I used the Setup executable to install the
application. I verified that the my.ini file was
created and contained appropriate information. But,
when I right-click with my mouse on the stop
I implement some simple per-user limits by setting max_questions to 800 (via
GRANT). This is ok for virtually all users, but a few routinely hit that
limit and are locked out for the hour.
The choice of 800 queries/hour was arbitrary on my part. I would prefer to
gather metrics on usage in order
Rafa,
is this the server you suspected to have some hardware problem?
Please send me the whole .err log for analysis.
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
Order
Description:
Hello,
We are working with mysqld-max-nt 4.0.14 under Win2000 service-pack4.
We have a server with two Pentium-III MMX 500Mhz proccesors and 780MB Ram.
We work with InnoDB tables. We have reserved 300MB to InnoDB and use
a RAID 5.
We were working when Mysql/I
Hi All
I'm currently trying to learn C so that I can recode some php/mysql apps
I've got but I've run into probs right at the start.
I'm trying to compile the examples in PDuBois MySQL (myclient.c the
really easy one ;-( ) and get the errors below.
I'm using SuSE 8.2 but also get the same erro
Hi,
I'm running MySQL on a Linux server with 2 processors, 4 Gb memory and
SCSI disks. I am using MySQL to manage a database with 3 million reports
and various auxiliary tables which are also fairly large.
My question is: How do I make the best use of the 4 Gb memory available?
I've tried increa
Steve Radabaugh <[EMAIL PROTECTED]> wrote:
>
> I have been exploring MySQL's full text search feature and have not been
> able to find any information on querying a full text search across
> multiple tables. Do you have to make recursive queries to each table?
You can't create fulltext index on
Michael Harly <[EMAIL PROTECTED]> wrote:
> I try to improve the security on the mysql and now I can't get into it.
> I get this massage.
>
> ?Access denied for user: '@localhost' to database 'mysql' ?
It means that there is no entry in the table user for 'your_user'@'localhost'. Where
'your_user
Is there a way of getting one checksum for a structure of tables of a
database. The problem we are facing is that we have 2 database servern with
the same table structure and with the same data in the tables, it is NOT
possible to sync both of them! The data in the data is not changed very
ofte
78 matches
Mail list logo
