I mean, much faster to other db that are currently on the symbian platform.
On 6/15/05, Louie Miranda <[EMAIL PROTECTED]> wrote:
>
> that looks like a good idea, and im hoping it will be much faster.
>
> but, how can it ran on a symbian platform?
>
> On 6/15/05, AJIT SADASIVAN <[EMAIL PROTECTED
that looks like a good idea, and im hoping it will be much faster.
but, how can it ran on a symbian platform?
On 6/15/05, AJIT SADASIVAN <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am new to this group...Just wanted to findout
> whether Embedded MySQL library is available for
> Symbian ( Series 60
I have just installed MySQL 5.0.6-beta on windows following the standard
installation procedure.
I have noticed that the table proc is missing from the mysql database and I can
not run the CREATE PROCEDURE statement.
What am I missing? I need to creare store procedure to port my application.
Ple
Sorry, I have found the reason why. I have MySQL 4.1 and MySQL 5.0 running on
different port. I was not passing --port=3307 to mysql client to connect to the
correct server.
> -Original Message-
> From: Frondoni, Giorgio
> Sent: Tuesday, June 14, 2005 10:23 PM
> To: 'mysql@
Hi,
I am new to this group...Just wanted to findout
whether Embedded MySQL library is available for
Symbian ( Series 60 platform).Any effort going on in
this direction..?
Any idea about the rough memory footprint..
With Regards
Ajit.S
__
Hello,
Even if I change the value to 2G it still will not load ? Because the
value was 500M before do I not have to remove the ib* files and have
them recreated ?
Michael
Michael Gale wrote:
Hello,
I am running mysql 4.0.20 with Innodb and we have upgrade grade the
RAM in the system
Dear all,
I have a MySQL 4.0.23 server running on an OpenBSD machine. When I try
to connect to it with MySQL Administrator 1.0.21 from my Mac OS X
machine, I get this error:
Connection error
Could not connect to MySQL instance at .
Error: unknown system variable 'sql_mode' (code 1193)
I can conn
Hi Rahul,
There are ODBC drivers that you could use, also you may like to look the
BCI and/or UCI interfaces. If you can flatten the data (eg. no
multivalues) you could put the lot into a Type 1 or Type 19 file and
then load the data as required.
You could also just create an I descriptor to get
Hello,
I guess IBMs Universe Database will be having an ODBC
interface. Then you can use a GUI like SQLyog
(www.webyog.com) to do an ODBC Import from IBMs
database to MySQL.
Regards,
Karam
--- Rahul Bollampally <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Has any body migrated an IBM's Universe databa
If you are on Windows then you can use a GUI like
SQLyog (www.webyog.com) to do the job.
I think it will be the easiest way to do that.
Karam
--- Kory Wheatley <[EMAIL PROTECTED]> wrote:
> I want to backup our entire Mysql database structure
> for
> mysql 3.23.58 and dump it in the newly insta
Hello,
I have finished reading something similer on the web, why is there a
2GB limit ?
If I can compile the kernel to say eys there is 4GB of memory why can
mysql not use 3GB of it ?
For know I have set the limit at 2GB.
Michael
Partha Dutta wrote:
If you are running on a 32 bit operat
If you are running on a 32 bit operating system, (e.g. Linux) you can not
allocate that much memory for InnoDB. The max you could allocate would be
2GB, but that would be pushing it. You also have to account for MyISAM
memory usage (key_buffer_size) and per thread memory allocations as well.
Par
Hello,
I am running mysql 4.0.20 with Innodb and we have upgrade grade the RAM
in the system from 1GB to 4GB :).
Now If I change the:
innodb_buffer_pool_size
From 500M to 3G the service will not start. I remember reading
something about this before and I believe I need to delete the
ib_lo
I imported data into a table "mytable" into a databse "mydb" with existing
data.
mysqlimport -L mydb data.txt
that operation failed.
I interrupt it.
It seems that I imported data with the same indexes (duplicate entries)
I tried: delete from mytable;
that seems to fail too
What happens whe
On Wednesday 15 June 2005 01:57, [EMAIL PROTECTED] wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> removed from the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/u/mysql/42af6ed786f34b14/richard.bennett=skynet.be
>
> This confirmation ser
On 15/06/2005 11:22 a.m., Kevin Burton wrote:
Simon Garner wrote:
I'm not entirely clear what you're talking about, but you could also
have a look at INSERT IGNORE..., or INSERT... ON DUPLICATE KEY UPDATE,
or REPLACE INTO...:
The problem is that I do NOT want it to update.
Also.. REPLACE c
Simon Garner wrote:
I'm not entirely clear what you're talking about, but you could also
have a look at INSERT IGNORE..., or INSERT... ON DUPLICATE KEY UPDATE,
or REPLACE INTO...:
The problem is that I do NOT want it to update.
Also.. REPLACE causes the row to be DELETED and INSERTED again
On 15/06/2005 10:28 a.m., Kevin Burton wrote:
I've been thinking about this for a while now.
If you have an app that can compute a unique key (hashcode) and you have
a unique index it should be possible to just do an INSERT instead of a
SELECT first to see if the record doesn't exist and then
Howdy all, I have a question about a SQL statement
that I'm trying to execute. When I execute the
statement I get the following error: The table
'#sql_bd6_3' is full.
What does this mean exactly?
Thanks,
Tripp
__
Yahoo! Mail Mobile
Take Yahoo!
see the my.cnf examples in the install dir, and look at innodb* variables.
you can migrate each table just using :
alter table toto engine=innodb;
Mathias
Selon "Stembridge, Michael" <[EMAIL PROTECTED]>:
> I currently use MyISAM on an internal web application server; our data takes
> up 10mb a
different box, different versions, use export/import (backup table or LOAD DATA)
Mathias
Selon Kory Wheatley <[EMAIL PROTECTED]>:
> I want to backup our entire Mysql database structure
> for
> mysql 3.23.58 and dump it in the newly installed
> mysql 4.1.10
>
> What is the best command to do a
I want to backup our entire Mysql database structure
for
mysql 3.23.58 and dump it in the newly installed
mysql 4.1.10
What is the best command to do a backup and dump
everything into the new MYSQL version on a different box?
__
Do You Yahoo!?
Tire
the already implemented solution is :
select ... for update;
a unique key gives you an error that you have to manage for updating rather than
insert.
you must catch and analyse that the error is "duplicate key" and not another.
but this is right if you want lauch insert without waiting to see if t
I've been thinking about this for a while now.
If you have an app that can compute a unique key (hashcode) and you have
a unique index it should be possible to just do an INSERT instead of a
SELECT first to see if the record doesn't exist and then an INSERT.
This should be 2x faster than the
I currently use MyISAM on an internal web application server; our data takes
up 10mb at this time, though this is likely to grow substantially in the
coming year. The database sees moderate heavy read and moderate write usage
from 50 users.
We're upgrading our sever from Red Hat 7.3 to SuSE
Hi,
for the first query,
select concat(team_id,' (',sum(points),')') from games,points
where games.game_id=points.game_id
and games.team_id1=points.team_id
group by team_id
can solve the problem.
For the second, join players and points.
Mathias
Selon David Legault <[EMAIL PROTECTED]>:
> Hello
You're welcome.
if you have more than one pnid, you should use perl or php. then use a loop to
manage each pnid query, then send it to the server, and use it's result.
another simpler solution :
mysql> create table sql as select concat('vt_',pnid) tbl from vt_parition where
pnid regexp ('^[0-9]{
Hi,
Has any body migrated an IBM's Universe database to mySQL if so
could you guys please help me out, I need to migrate a huge dataset in
Universe to mySQL to generate an analysis report.
Rahul :-\
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
It always helpd me to change MySQL's "user" to connection in my head
when I begin to think about access control. Then in most database
designs that I have seen, row access control is just as important as
database/table/column. Then the question becomes does the "user" have
direct access to the data
Danny,
>that is an interesting formulation which you gave. can you
please comment
>that with an example? would you create roles for users who are
assigned the
>same privileges and individual users who have multiple roles?
In this fragment from an example, a role has a name (roles.name), eg
Scott Gifford <[EMAIL PROTECTED]> writes:
[...]
> I think I'm going to take a look at the MySQL source and see if
> there's anything I can tweak to get the effect I want. I'll report
> back my results.
The MySQL source looked a bit too complex for casual hacking, but
here's what I ended up doin
Hello,
I'm a regular user of MySQL but lately on a personal project I've run
into some very complexe query management and am a little bit confused on
how to get it working. This is a hockey league stats website application.
I have 4 tables with the following columns:
teams -> team_id | team_
Danny Stolle <[EMAIL PROTECTED]> writes:
[...]
> 3. Create multiple user IDs for each role played by each user
> (dannys_arch as an architect, dannys_dev as a developer).
An interesting argument in favor of the much maligned "option 3" is
that it allows users to select which of their privileges
Paul Mitchell wrote:
Hello All,
I'm trying to get mediawiki working on a solaris 9 domain (this is on
a Sun 15k, FWIW). I had mysql installed and in a fit of stupidity,
managed to remove /tmp/mysql.sock. After scouring the Usenet via
google, and searching through the archives at lists.mysq
Peter,
that is an interesting formulation which you gave. can you please
comment that with an example? would you create roles for users who are
assigned the same privileges and individual users who have multiple roles?
Best Regards,
Danny Stolle
Netherlands
Peter Brawley wrote:
Danny
/>1.
Hello!
Many thanks to everybody who tried to help me!
> N.B. you should have only one pnid to make your query work (UNIQUE pnid),
> or LIMIT the result of the subquery by LIMIT 1.
I need to do the following:
Get one or more than one "pnid" from vt_partition and then make queries to the
"vt_pni
George,
from a MySql point of view, how would you deal with security on a site?
would you than create individual users?
Best Regards,
Danny Stolle
EmoeSoft, Netherlands
[EMAIL PROTECTED] wrote:
Danny,
My 2 cents (American dollars): From a security standpoint (if you are a financial instit
Hi Kevin,
i started this discussion to find out, how most database administrators
or users involved in managing MySql, would deal with a topic as User
Management. So the question(s) is(are) more hypothetical, e.g. "What if
(...) 'you would have a development site and an accounting site'" how
On 14 Jun 2005, at 17:52, [EMAIL PROTECTED] wrote:
My suggestion, lame as it is, would be to use a 0 (zero) in place
of the
NULL value. That way, you always have a valid entry for PARENT_ID,
you can
still identify the tops of the trees (parent_id=0) and you have gotten
around the only-one-pa
Danny,
My 2 cents (American dollars): From a security standpoint (if you are a
financial institution) you'd would never get away with #2 because there is no
audit trail with multiple users using a "generic" user id.
The MySQL implementation of security is not implemented with auditing and
Hello All,
I'm trying to get mediawiki working on a solaris 9 domain (this is on a
Sun 15k, FWIW). I had mysql installed and in a fit of stupidity, managed
to remove /tmp/mysql.sock. After scouring the Usenet via google, and
searching through the archives at lists.mysql.com, I'm still in a
Danny
>1. Giving the user a Single user ID and assign the privileges to
that user ID
>2. Create role-bases users and have different people share the same
user ID
>for a given role.
>3. Create multiple user IDs for each role played by each user
(dannys_arch
>as an architect, dannys_dev as a
Danny,
I would stay away from option 3 for exactly the example you provided.
You have 1 user with 2 roles. What if you had 30 users with 2 roles? I
would choose option 2 because I would only have to maintain 2 users in
MySQL, not 60 as you would in option 3. For option 1, you would have 30
users,
Hi Kevin,
yes it is a complex matter, i agree completely. but how would you plan
this as a dba or the person involved on administrating MySql. For
instance: You would choose option 2 as the preferable one. But what
would you do if somebody would change its role or that the person would
get ot
Danny,
Although my experience with MySQL user management is limited to just
maintaining a handful of users, I find it rather overly-complex because
of the need to maintain a table of users and 'from where' they can have
access, and to what databases they can have access to. For example, I
just in
Hello,
You forgot a parenthesis in the regexp function.
Second, if you construct your query with prepared statements, you can do it :
mysql> insert into vt_partition(pnid) values('01234567890');
mysql> select concat('vt_',pnid) into @tbl from vt_parition where pnid regexp
('^[0-9]{11}$') ;
mysql>
"Jigal van Hemert" <[EMAIL PROTECTED]> writes:
> From: "Scott Gifford"
[...]
>> Right, ALL would be a great plan if it weren't for the LIMIT 1.
>
> The LIMIT 1 will be performed *after* the recordset is sorted :-(
Ah, I think that is the piece I was missing.
[...]
>> I'm a little surprised My
Damn! You're right!! I only looked at the subquery itself, not the context
and I missed that his "subquery" seems to an expression to get part of his
table name! That is definitely not valid in any dialect of SQL that I know
;-)
I wonder if the query itself is mistyped? Maybe he missed the last h
Have you looked at this page of the manual?
http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html
It describes several ways to do the sort of searches you want to do and
there are several examples.
You might find that LIKE or STRCMP() work better than REGEXP for your
requirements.
hi,
i would like to discuss 'user management' in mysql. Working with Oracle
you can assign users to roles giving them privileges provided by that
role. MySql doesn't have Roles. I have read (Managing and Using MySql,
O'Reilly) 3 options on managing users having multiple roles in a MySql
envir
admin <[EMAIL PROTECTED]> wrote on 06/14/2005 01:01:33 PM:
> Hello!
> MySQL v. 4.1.11.
> I'm trying to write a subquery, MySQL says "Error".
> select num, theme, intro
> from vt_(select pnid from vt_partition where pnid regexp '^[0-9]{11}$')
> order by date desc, timer desc;
> describe vt_parit
Marcus Bointon <[EMAIL PROTECTED]> wrote on 06/14/2005 12:37:18
PM:
> I have a table that uses a self join to represent simple hierarchies.
> I have a parent_id field that contains a reference to the same
> table's id field. Not all items have a parent, so parent_id is nullable.
> The problem I
Hello!
MySQL v. 4.1.11.
I'm trying to write a subquery, MySQL says "Error".
select num, theme, intro
from vt_(select pnid from vt_partition where pnid regexp '^[0-9]{11}$')
order by date desc, timer desc;
describe vt_parition:
+--+--+--+-+--+
In some hierarchies I have seen people put the the current id in the
parent_ID Field {basicaly pointing to them self} to represent the top of
the hierarchy.
I don't know how much this would affect the rest of your application but
it would get rid of the null's
-Original Message-
From: Ma
I have a table that uses a self join to represent simple hierarchies.
I have a parent_id field that contains a reference to the same
table's id field. Not all items have a parent, so parent_id is nullable.
The problem I run into is in defining the foreign key constraint - if
a parent item i
Hi
Thanks that really does answer my question and it meets my requirements as
well.
Thank you
With kind regards
Andy
--
Registered Linux User Number 379093
-- --BEGIN GEEK CODE BLOCK-
Version: 3.1
GAT/O/>E$ d-(---)>+ s:(+)>: a--(-)>? C$(+++) UL>$ P-(+)>++
L+++>$ E---(-
Andy Pieters <[EMAIL PROTECTED]> wrote on 06/14/2005 09:59:09 AM:
> > I seriously encourage you to read up on
> > transactions and InnoDB and I strongly suggest you change your table
> > design (to use InnoDB). That way you have an actual "ROLLBACK" command
at
> > your disposal. Otherwise you wil
> I seriously encourage you to read up on
> transactions and InnoDB and I strongly suggest you change your table
> design (to use InnoDB). That way you have an actual "ROLLBACK" command at
> your disposal. Otherwise you will be re-inventing the wheel by creating a
> versioning-locking system for My
Hello.
There were several bugs related to timestamp
at 4.0.22 and later. Does the problem remains
on 4.1.12 (4.0.24)?
manasvini nandakumar <[EMAIL PROTECTED]> wrote:
> Hi all,
> I have a very strange problem with mysql-4.0.22
> running on a big endian processor platform.When the
> tim
Andy Pieters <[EMAIL PROTECTED]> wrote on 06/13/2005 06:14:42 PM:
> Hi all
> As part of an automated patch system, I am facing the following problem:
> * A script will update the program from version x to version y
> * The script contains file actions, and database (mysql) actions
> * The action
Yannick wrote:
Hey guys,
I am not able to install properly mysql. Please see below the technical
details or the bug report.
The installation goes well until I try to add the root user :
[EMAIL PROTECTED]:/usr/bin> mysqladmin -u root -h fujitsu password x
[EMAIL PROTECTED]:/usr/bin> my
Hi all,
I have a very strange problem with mysql-4.0.22
running on a big endian processor platform.When the
timestamp gets updated as '2005-01-01 23:00:00', it
actually seems to be converted internally as
2005010423.Similarly '2005-01-02 23:00:00' is
'2005010523'.
The problem is that let us
2005/6/10, Atle Veka <[EMAIL PROTECTED]>:
> software has much to do with this, the biggest problem is your disk. :)
>
Don't understimate what a McAfee VirusScan can do on your pc's
performance :-), however, you are probably right.
--
Ciao
Nico
--
MySQL General Mailing List
For list archives: ht
> mysql> create table ABC (col1 varchar(10));
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> show tables;
> +--+
> | Tables_in_userdb |
> +--+
> | abc |
> +--+
> 1 row in set (0.00 sec)
>
> mysql>
>
> NOTE THE FACT THAT THE TABLE IS
> I have MySQL 4.1.12 running on a MacOS X 10.4.1 development
> setup where I often load a 1Gb db and later on drop
> it/reload/generally make a mess. I just noticed that though
> the database is holding only
> 4 small records totalling less than 1k, my ibdata1 file is
> sitting at over 800Mb.
* Rhino:
> You'll need three alter statements:
> - one to add the new column
> - one to get rid of the old primary key
> - one to set the new column as the primary key
In addition to adding the new column, there will be neccessary to populate
the column with unique values. A primary key must allwa
I have MySQL 4.1.12 running on a MacOS X 10.4.1 development setup
where I often load a 1Gb db and later on drop it/reload/generally
make a mess. I just noticed that though the database is holding only
4 small records totalling less than 1k, my ibdata1 file is sitting at
over 800Mb. I'm gues
From: "Scott Gifford"
> >> Apparently MySQL's optimizer sees that it can use the primary key for
> >> mirealsource_home_supplemental to do the query, but for some reason
> >> decides not to.
> > This is often the case when the query will probably return more than 30%
of
> > the records in that tabl
68 matches
Mail list logo
