Re: Oh GAWD somone HELP :)
Sorry! I have made a mistake. Are you sure the host you connected from can be reservely lookup on 192.168.0.2? This is really important and have brother me for a period of time. Regards, Well thats the thing, I did an more than one user that was allowed to connect TO 192.168.0.2 from various hosts on my network and all hosts can reverse lookup from my dns server. no good - Original Message - From: KH Chiu [EMAIL PROTECTED] To: Poodle [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 2:53 AM Subject: Re: Oh GAWD somone HELP :) You should add a user who allow to connect from 192.168.0.2 before you can connect to MySQL remotely. Further more, make sure that your host can reverse lookup 192.168.0.2. This can be done by add an entry in the /etc/hosts or create a DNS entry. Regards, Just installed mysql nice one i though set it all up read the nessasary docs nice one i thought tried to connect remotly [root@tasha root]# mysqladmin -h 192.168.0.2 version -uroot - ppassword mysqladmin: connect to server at '192.168.0.2' failed error: 'Lost connection to MySQL server during query' oh bugger played around with the configs for a few hours tried everything i could think of read some more docs tried everything i could think of again still the same any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL query optimizer mode
Deer Sir,, I would like to know which optimizer mode used in MySQL, cost base or rule base? There was no detail description about MySQL query optimizer in MySQL Reference Manual.. could you let me know about MySQL query optimizer mode? thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
'Disappearance of the mysql.sock when the computer is shut down and restarted'
Hello, I'm new to MySQL and to linux. I'm using an Omnibook XE3 with RAM 254 on SuSE linux 8.1. In one of the slots of a Texas instrument pcmcia I have a Xircom PC card modem 56K. During startup this has to be disconnected when linux is starting hardware scan on boot - but otherwise works OK. I have loaded MySQL 3.23.55 as an RPM for i386 an this works OK and I logout and login as another user without problems ### but when the computer is shutdown and restarted it appears as if the mysql.sock disappears. Or am I unable to start the mysql server When I try the comand mysql etc i get Error 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have tried to stick the socket with shell chmod +t /var/lib/mysql and shell ls -ld /var/lib/mysql confirmes the last permission to t (as suggested onpage 724 in the ref manual). I have also made a binary installation mysql-3.23.55-pc-linux-i686 or something with pretty much the same result. In essens: I lose mysql.sock when the computer is restarted or I'm unable to start the msql server and reestablish the msql.sock after reboot and Before I restart the computer MySQL works very OK both with rpm install and binary install What to do? What do I do wrong? Fredrik Lundgren Norrköping - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Oh GAWD somone HELP :)
[root@erin /]# ping kaley PING kaley (192.168.0.4) from 192.168.0.2 : 56(84) bytes of data. 64 bytes from kaley (192.168.0.4): icmp_seq=1 ttl=128 time=0.356 ms - Original Message - From: KH Chiu [EMAIL PROTECTED] To: Poodle [EMAIL PROTECTED]; KH Chiu [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 8:38 AM Subject: Re: Oh GAWD somone HELP :) Sorry! I have made a mistake. Are you sure the host you connected from can be reservely lookup on 192.168.0.2? This is really important and have brother me for a period of time. Regards, Well thats the thing, I did an more than one user that was allowed to connect TO 192.168.0.2 from various hosts on my network and all hosts can reverse lookup from my dns server. no good - Original Message - From: KH Chiu [EMAIL PROTECTED] To: Poodle [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 2:53 AM Subject: Re: Oh GAWD somone HELP :) You should add a user who allow to connect from 192.168.0.2 before you can connect to MySQL remotely. Further more, make sure that your host can reverse lookup 192.168.0.2. This can be done by add an entry in the /etc/hosts or create a DNS entry. Regards, Just installed mysql nice one i though set it all up read the nessasary docs nice one i thought tried to connect remotly [root@tasha root]# mysqladmin -h 192.168.0.2 version -uroot - ppassword mysqladmin: connect to server at '192.168.0.2' failed error: 'Lost connection to MySQL server during query' oh bugger played around with the configs for a few hours tried everything i could think of read some more docs tried everything i could think of again still the same any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why is MySQL 4 standard binary 4mb larger than max?
Just curious since max has more featured compiled in yet it's quite smaller for download at mysql.com. Xing - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow Fulltext Search on Large Table
Hi!
On Feb 18, Peter Bryant wrote:
My problem is that my fulltext searches run quite slowly.
I have a 2300MB table with 4.3M rows and an index (primarily a fulltext
index) of 1300M. My hardware is a dual Athlon MP1500+ with 2GB of memory.
I am running MySQL 4.0.10.
My my.cnf includes:
set-variable = key_buffer=16M
set-variable = key_buffer_size=128M
Why do you set both key_buffer and key_buffer_size ?
key_buffer is old (and obsolete) name for key_buffer_size.
Check
SHOW VARIABLES LIKE 'key_buffer%'
to see whether it's 16M or 128M.
Manual says:
Increase this to get better index handling (for all reads and
multiple writes) to as much as you can afford; 64M on a 256M
machine that mainly runs MySQL is quite common. If you, however,
make this too big (for instance more than 50% of your total
memory) your system may start to page and become extremely slow.
Remember that because MySQL does not cache data reads, you will
have to leave some room for the OS filesystem cache.
You can check the performance of the key buffer by doing `SHOW
STATUS' and examine the variables `Key_read_requests',
`Key_reads', `Key_write_requests', and `Key_writes'. The
`Key_reads/Key_read_request' ratio should normally be 0.01.
I have found that:
1) Searching for non-existant words is fast (1s)
2) Searching for common words is slow (e.g. select a count of matches on a
single word with 15135 matches on a 2300MB table takes 3 min 38.54 sec)
In boolean or natural-language mode ?
3) Boolean search for a +common word +nonexistant word completes
immediately.
4) Add in a LIMIT n on a popular term and the results complete quicker.
Completion time is less than O(n). O(log n?)
In boolean or natural-language mode ?
For natural-language mode it means that a lot of time is spent reading
*huge* number of matched rows from the disk, after fulltext search itself
was completed (list of matched rows - disregarding LIMIT - was built).
For boolean mode it is expected to be O(n).
5) A repeat search runs faster (1s vs. 35s). Presumably because of OS
file caching and the key_buffer_size variable.
6) against ('aword') limit 2000 and against ('+adifferentword' in
boolean mode) limit 2000 take about the same time to reach their limits
(2000).
Sorry ? When you change *both* the word *and* the mode ?
How can you compare ? Try either the same word in both modes or
different words in the same mode.
7) match(subject, message_body) against ('Linux Kernel') and message_body
like '%Linux%' and message_body like '%kernel%' limit 2000 returns in
about the same time as against ('+Linux +kernel' in boolean mode) limit
2000 (24s)
On really popular words search in boolean mode should be slightly slower
than LIKE - it's the same 1/3 heuristic MySQL uses in ... WHERE a=4 ...
queries. If in more than 30% of the table a=4, it would be faster to do
a table scan, reading rows sequentially, than to resolve the query with
an index, reading data rows in almost random order.
Search in natural language mode could be significantly slower.
So, onto my questions:
1) Are there any server settings I should be looking at to improve fulltext
search performance?
key_buffer_size
2) Can my SQL be written differently (e.g. is boolean mode faster or not?)
Boolean mode is O(log(N)) faster, where N is number of rows found.
It matters when some words in the query are very popular.
3) Is there a way to get a list of the most commonly occuring words in a
fulltext index? Then I can avoid them in searches. MySQL doesn't happen
to drive it's queries by finding the word with lowest frequency first does
it?
Not yet. It queries all the words simultaneously - so if one word is
nonexistent (or very rare) it will abort the search early.
But optimization you're talking about will be added soon too.
(fulltext index structure was changed a month ago
to allow this particular optimization)
4) Are there any MySQL code changes on the horizon that could help to speed
up fulltext word searching?
See above.
5) Is there anything else I could do that would allow me to get results
faster (within about a 30 second timeframe). Having searches that don't
return all matching rows would be acceptable (but not desirable). e.g. I'm
thinking of just deleting less important rows from my large table.
having searches that don't return all matching rows could be done in
natural language search mode only (of course), and it will be added
soon too, as above.
egards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
___/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.
Hi Benjamin, I hope you have a nice day. - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Jason Maskell [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, February 17, 2003 1:14 PM Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap. On Mon 2003-02-17 at 03:38:07 -0600, [EMAIL PROTECTED] wrote: Reply when you have a job, dumbass. I have a system that makes more in a week than you make in a year crashing because of this buggy piece of shit. If a system supposedly making millions a year is unstable you are a fool that you haven't solved it already using your advanced support contract (http://www.mysql.com/support/), that you surely have. I don't give a rats ass what your worthless opinion on my post is. Now fuck off, dumbass. Yeah. That lack of respect is exactly why I refused to read your ...you can not ask respect from this man which already make the prove that have no BRAIN. original post about the problem to the end. As I said, that is a list of volunteers and your attitude surely doesn't help you to get answers. Bye, Regards, Benjamin. Gelu - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: Jason Maskell [EMAIL PROTECTED] Sent: Monday, February 17, 2003 3:35 AM Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap. On Mon 2003-02-17 at 02:40:57 -0600, [EMAIL PROTECTED] wrote: Oh grow up. Exactly the kind of reply I expected from you. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow Fulltext Search on Large Table
Peter,
Here are my suggestions based on past and current experience.
1) set-variable = sort_bufffer=8M
Since you have a lot of records there you will no doubt be doing quite
a lot of sorting. Increase the sort_buffer. This would also speed up
new index creation.
2)
set-variable= ft_min_word_len=3 (mysql defaults to 4)
set-variable= ft_max_word_len=100 (mysql defaults to 256)
set-variable= ft_max_word_len_for_sort=10 (mysql defaults to 20 I
think)
In real life, people want to be able to find Tom and Cat so you
want to fulltext to index 3 letter words as well at the cost of index
size. However, by decreasing the max_word_len and len_for_sort by over
half, you have effectively decreased the full-text index size by 50%.
This would speed up your searches big time.
(must recreate fulltext index for the above changes to take effect)
3)
If you are doing full-text searches on a db that gets a lot of updates
and inserts, do the following.
a) create a slime but duplicate table such as mytable_fulltext
b) mytable_fulltext has only the primary key of mytable and only the
varchar/blob fields that you
need to search on. Create full-text index on them and remove the
full-text index on mytable
c) every night or whatever interval you choose, truncate/empty
mytable_fulltext and do a
insert into mytable_fulltext select key, title, summary from mytable
What the above does it give you constant performance/scalability
during peak load and avoid the table locks of myisam updates and
inserts.
Hope you find it helpful and if you find something that does help and
is even better share it with us since full-text search is one of the
slowest feature of mysql and every ounce of performance boost is worth
the extra effort.
Xing
On Monday, February 17, 2003, at 07:30 PM, Peter Bryant wrote:
My problem is that my fulltext searches run quite slowly.
I have a 2300MB table with 4.3M rows and an index (primarily a
fulltext index) of 1300M. My hardware is a dual Athlon MP1500+ with
2GB of memory. I am running MySQL 4.0.10.
My my.cnf includes:
set-variable = key_buffer=16M
set-variable = key_buffer_size=128M
set-variable = max_allowed_packet=16M
set-variable = sort_buffer=4M
set-variable = max_connections=1024
set-variable = max_connect_errors=900
set-variable = table_cache=1200
I have found that:
1) Searching for non-existant words is fast (1s)
2) Searching for common words is slow (e.g. select a count of matches
on a single word with 15135 matches on a 2300MB table takes 3 min
38.54 sec)
3) Boolean search for a +common word +nonexistant word completes
immediately.
4) Add in a LIMIT n on a popular term and the results complete
quicker. Completion time is less than O(n). O(log n?)
5) A repeat search runs faster (1s vs. 35s). Presumably because of
OS file caching and the key_buffer_size variable.
6) against ('aword') limit 2000 and against ('+adifferentword' in
boolean mode) limit 2000 take about the same time to reach their
limits (2000).
7) match(subject, message_body) against ('Linux Kernel') and
message_body like '%Linux%' and message_body like '%kernel%' limit
2000 returns in about the same time as against ('+Linux +kernel' in
boolean mode) limit 2000 (24s)
On smaller tables search runs 'acceptably fast'. However, with this
larger table, performance on certain searches is unacceptable. I'm
having to resort to killing database connections when they run too
long.
So, onto my questions:
1) Are there any server settings I should be looking at to improve
fulltext search performance?
2) Can my SQL be written differently (e.g. is boolean mode faster or
not?)
3) Is there a way to get a list of the most commonly occuring words
in a fulltext index? Then I can avoid them in searches. MySQL
doesn't happen to drive it's queries by finding the word with lowest
frequency first does it?
4) Are there any MySQL code changes on the horizon that could help to
speed up fulltext word searching?
5) Is there anything else I could do that would allow me to get
results faster (within about a 30 second timeframe). Having searches
that don't return all matching rows would be acceptable (but not
desirable). e.g. I'm thinking of just deleting less important rows
from my large table.
Thanks in advance for any help,
Peter Bryant
_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
Re: Slow Fulltext Search on Large Table
Hi! On Feb 18, xing wrote: Peter, Here are my suggestions based on past and current experience. Unfortunately, they are mostly wrong :( 1) set-variable = sort_bufffer=8M Since you have a lot of records there you will no doubt be doing quite a lot of sorting. Increase the sort_buffer. This would also speed up new index creation. This variable setc a max. memory size allocated for filesort operation - which is used in ORDER BY and GROUP BY when EXPLAIN shows filesort used in the last column. It does not apply to new index creation. Instead myisam_sort_buffer_size is used there. 2) set-variable= ft_min_word_len=3 (mysql defaults to 4) set-variable= ft_max_word_len=100 (mysql defaults to 256) set-variable= ft_max_word_len_for_sort=10 (mysql defaults to 20 I think) In real life, people want to be able to find Tom and Cat so you want to fulltext to index 3 letter words as well at the cost of index size. However, by decreasing the max_word_len and len_for_sort by over half, you have effectively decreased the full-text index size by 50%. This would speed up your searches big time. Decreasing index - yes, but not decreasing ft_max_word_len and ft_max_word_len_for_sort. Words that are longer that 100 letters are *extremely* *extremely* rare. less that 0.001% in the index. Furthermore, even they will be probably not valid words but just repeated sequences of characters like ___ or x, etc. Nobody will ever search for this. Removing them will not make the index any noticeably smaller, and will have no impact on the search speed whatsoever. As for ft_max_word_len_for_sort - it is used only during index creation. Reducing it, as you propose, will mean that MySQL will be able to put twice as much words in each sort bucket - which is good, but all the words longer than 10 will be ignored there and MySQL will insert them after repair_by_sort in done, one word by one - that is slow way. Whether it will give a speedup or not depends on the word length distribution in the data. Usually, 20 covers about 98% words. There is utility program ft_dump that comes only in MySQL source distribution. It can show you the length or word frequency distribution. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlimport error
we get a strange error when trying to import data into our database: mysqlimport: Error: Can't get stat of 'KUNDEN' (Errcode: 13), when using table: KUNDEN it is NO permission Problem, the file ist world readable and the user CAN access the DB. any hints what else could be the problem ??? Version: mysql 3.23.54 OS: SuSE-Linux 7.0 Kernel: 2.2.16 regards -- Stefan Immel |N|O|C Network Operation Center -+-+-+--- | Grove Auf der Stuecke 6Tel. +49 2773-8167-0 35708 Haiger / Germany Fax +49 2773-8167-20 -- mailto:[EMAIL PROTECTED] http://www.grove.de There is always hope, only because it is the one thing nobody's figured out how to kill yet. ~ Galen, Crusade Racing The Night -- http://www.nocr2.de - NOC R2 die Lösung für den IT-Workflow -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slow retrieval of distinct on indexed fields
Hello, This is not an urgent problem, but it has always intrigued me... It's simplified case, but it makes the point. Let us assume that we have a table create table T (id unsigned int unique, name char(10)); create index i_name on T(name); Let's insert into it say 5 mil rows with name field being just say 5 distinct values AAA, BBB, CCC, DDD, EEE. Now the question. Why a query like select distinct name from T; takes about 3 sec to return just a bunch of rows? As I understand it, index contains all these 5 values, so just simple lookup into index should take fractions of a second. Can anyone comment on this? MySQL team? Thanks, Ren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Archive on remote Machine.
Hi, I use Select * into outfile filepath from table to archive the database. Is there any way to archive this into a different machine. (Not current machine) Yes Mapping to new machine and then giving path is an option. Any other opton.? Anis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqlimport error
it is NO permission Problem, the file ist world readable and the user CAN access the DB. stupid me, it WAS a permission problem. The permission for a directory in the path wasn't right. sql, mysql or what else the spam filter needs. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InterBase vs. Mysql
Hi, I am a MySQL admin. I like it very much. It is very quick,stable and easy in configuration. But I have a boss, who has been told about InterBase. He told me I should interest in the InterBase, because it is programmed by russian, who made a great project and told him mysql is totaly worse in comparison with the InterBase. Actually he didn't prooved it, he just heared about it from the russians. Did anyone met with the InterBase and can tel me something about it and prove me that the Mysql is BETTER? I need arguments for using the MySQL for a company (lets tell about 100 people, who use it very intensive through the whole day 7 days a week). Best regards, Maciej Bobrowski - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innoDB (errno: 121)
Using innoDB with Mysql 4.0.10-gamma-max-nt and getting lots of: MySql Error: Could not execute command [ ... ] on server because: Can't create table '.\rr\cons.frm' (errno: 121) Where 'rr' is the name of my database. Some of which I just can't get away from never mind what I do. My latest failure: create table if not exists cons ( code integer unsigned not null auto_increment primary key, items_count integer not null default 0 ) type=innodb This error (121) is not listed on http://www.innodb.com/ibman.html#Error_codes Is there somebody who knows what this is, and how I can get away from it? Regards, Ben. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: InterBase vs. Mysql
Hi Maciej, I don't know much about Interbase, but MySQL is for some cases a very good choice! Some database engineers would say MySQL isn't a database because it has no transactions by know (in a stable version). But think about, if you really need this!!! In versions 4.x (coming soon in a stable version) transactions, subselects etc. would be available! We use MySQL because of its speed and the costs are very low! Have a look on http://www.w3research.com ! The charts are rendered in realtime by a roxen server in the data comes out of MySQL. Regards Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
hi Maciej, the only arguments you can get in favour of mysql is that it's free, and some of its SQL statement are faster than interbase. Interbase has the advantage of having views, stored procedures,triggers,and it's crazily fast. Don't forget that interbase is also written by professionnal on borland campus, guyz who completed a university degree and were assessed and were judged good enough to work with borland; whilst the average developpers for mysql are volunteers who are not paid for what they are doing! I think you should insist on the free aspect of mysql and it's simplicity of use, because for somebody who knows the 2 databases, features wise, robustness wise and speed wise, interbase is far ahead of mysql. _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql shutdown hangs-solaris
Jerry, Thanks for the information. Do you run mysql as service ??Bcoz I do not have the binary files that you had mentioned. I use binary files safe_mysqld and mysqladmin to start and stop the mysql in my Application. Any inputs for my below mentioned problem is appreciated. Thanks Regards Sunil Gavaskar Sunil Gavaskar wrote: Anybody can help this??? thanks regards sunil Hi, I am facing mysql shutdown process hanging problem on Solaris 5.8, mysql 3.23.40 I am running our product Web NMS which uses MySQL DB, on solaris machine. While shutting down the application, except MySQL process, all other process are killed and the application hangs. On analysis I found that, mysqladmin -h localhost shutdown is hanging. *But when I tried to take the dump, the process (mysqladmin -h localhost shutdown) gets killed. *Kindly provide us the cause of the problem. Herewith I have attached the files, ps_before_shutdown.txt- Processes list before shutting down the Web NMS bash-2.03$ ps -aef|grep -i telesyn root 1541 1524 0 Feb 11 pts/57:25 /opt/TelesynNMSBeta/jre1.4/bin/rmiregistry 1099 root 1524 1516 0 Feb 11 pts/5 93:12 /opt/TelesynNMSBeta/jre1.4/bin/java -cp /opt/TelesynNMSBeta/classes::/opt/Teles hmgaya 450 410 0 Feb 10 pts/20:00 /usr/dt/bin/sdt_shell -c unset DT; DISPLAY=atn65.telesyn.corp:0; hmgaya 452 450 0 Feb 10 pts/20:00 -bash -c unset DT; DISPLAY=atn65.telesyn.corp:0; /usr/dt/bin/ nobody 1548 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1544 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1549 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http root 1539 1526 0 Feb 11 pts/5 223:56 /opt/TelesynNMSBeta/mysql/bin/mysqld -Sg --basedir=/opt/TelesynNMSBeta/mysql -- nobody 1546 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1545 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http root 1543 1 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1551 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1568 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1569 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1570 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1571 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http bash-2.03$ ps_during_hang.txt- Processes list while application is hanging bash-2.03$ ps -aef|grep -i telesyn root 1524 1516 2 Feb 11 pts/5 93:14 /opt/TelesynNMSBeta/jre1.4/bin/java -cp /opt/TelesynNMSBeta/classes::/opt/Teles hmgaya 450 410 0 Feb 10 pts/20:00 /usr/dt/bin/sdt_shell -c unset DT; DISPLAY=atn65.telesyn.corp:0; hmgaya 452 450 0 Feb 10 pts/20:00 -bash -c unset DT; DISPLAY=atn65.telesyn.corp:0; /usr/dt/bin/ nobody 1548 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1544 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1549 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1546 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1545 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http root 1543 1 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1551 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1568 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1569 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1570 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http nobody 1571 1543 0 Feb 11 ?0:00 /opt/TelesynNMSBeta/apache/bin/httpd -d /opt/TelesynNMSBeta/apache -f conf/http root 3769 1524 0 15:47:13 pts/50:00
problem in connecting to DB
hello all,
i would like to put a problem as what iam facing... i created a new database
new user, but i didn't give the password...
then i logged in to mysql
ie
c:\mysql\bin mysql
then
mysql use mysql
then
mysqlupdate user set password=password('pswd') where user= 'username';
then i got the result as 1row updated.
then i quit from mysql using mysql\q
now when i want to connect
i.e.
c:\mysql\bin mysql -u username -ppswd dbname;
iam getting error stating Error 1405:Access denied for user:
'username@localhost ' (user password :YES)'
IAM WORKING ON COMMANDLINE @ MYSQL SERVER ITSELF
can someone throw light onthis... it will be of grate help
Thanks in advance
Ganesh Rajan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
Inandjo Taurel wrote: hi Maciej, the only arguments you can get in favour of mysql is that it's free, Free??? Bollocks. I program for a small company producing commercial programs. We have found: MySQL Licence will cost us more than our product price. MySQL sails staff are rude and unfriendly. I contribure to MySQL stuff (in a minor way), and now I am expected to pay as well. Get real! This is the main reason why I am looking at PostgreSQL at the moment, although I've not looked much at Interbase, any good? Either that, or fork MySQL into FreeMySQL, as we can do under the GPL, and not charge our selves :) Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: InterBase vs. Mysql
Just a small comment: Rusch (ext) Reiner wrote: Hi Maciej, I don't know much about Interbase, but MySQL is for some cases a very good choice! Some database engineers would say MySQL isn't a database because it has no transactions by know (in a stable version). But think about, if you really need this!!! Very much so! With dependent foreign key constraints that are being developed by MySQL, you have to use delayed constraint checking in the form of a transaction, or with cyclic references, you can never add data to your tables :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: InterBase vs. Mysql
Hi Ben, hi Maciej, the only arguments you can get in favour of mysql is that it's free, Free??? Bollocks. you're right! It's NOT free. Just for personal use there're no costs. I program for a small company producing commercial programs. We have found: MySQL Licence will cost us more than our product price. MySQL sails staff are rude and unfriendly. I contribure to MySQL stuff (in a minor way), and now I am expected to pay as well. Get real! This is the main reason why I am looking at PostgreSQL at the moment, although I've not looked much at Interbase, any good? Ok, if you're not making money on what you're working, then you're right! But: Is it the fault of MySQL AB that you sell your work for nothing? I don't understand, why everybody wants anything for free! Open Source != Freeware The license of MySQL is very cheep! Look at oracle and you know what I try to explain. Ok, Oracle is an other thing, seems to be for very greath projects, but if you need speed and having a small budget then MySQL is a good choice. Regards Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: AW: InterBase vs. Mysql
Hi Ben, Some database engineers would say MySQL isn't a database because it has no transactions by know (in a stable version). But think about, if you really need this!!! Very much so! With dependent foreign key constraints that are being developed by MySQL, you have to use delayed constraint checking in the form of a transaction, or with cyclic references, you can never add data to your tables :) ok, you're right! But there are possible other ways to solve this. You possibly could take care by your program. In our project we have no problems like this because we use different tables for input and output. We use unique keys so that theres no corrupted data. Regards Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
Inandjo, Subject: Re: InterBase vs. Mysql From: Inandjo Taurel Date: Tue, 18 Feb 2003 11:48:53 + ... Don't forget that interbase is also written by professionnal on borland campus, guyz who completed a university degree and were assessed and were judged good enough to work with borland; whilst the average developpers for mysql are volunteers who are not paid for what they are doing! most MySQL developers are paid employees of MySQL AB who receive salary from MySQL AB. I hold a PhD in mathematical logic from the University of Helsinki. I think you should insist on the free aspect of mysql and it's simplicity of use, because for somebody who knows the 2 databases, features wise, robustness wise and speed wise, interbase is far ahead of mysql. Can you refer to some published benchmark where InterBase beats MySQL? Best regards, Heikki Tuuri Innobase Oy sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
MySQL Licence will cost us more than our product price. Wow, what a company!! how much do you sell your products ?? MySQL sails staff are rude and unfriendly. Can't tell, anytime i needed help, i used this forum, and i rather met some real interesting guyz and dedicated guyz (widenius, egorov, dubois...) and others ready to help! I contribure to MySQL stuff (in a minor way), and now I am expected to pay as well. Get real! truely, get real, where else can you find this combination of things(low licence cost,ease of installation and maintenance,active forum with prompt reponses and solutions!) for almost free! This is the main reason why I am looking at PostgreSQL at the moment, although I've not looked much at Interbase, any good? have a look at interbase, you will be amazed! as for postgresql, the best is to get the linux version which is complete,stable and robust. Either that, or fork MySQL into FreeMySQL, as we can do under the GPL, and not charge our selves :) Good luck, if you mean it. We'll see what you'll bring out!! Ben _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: InterBase vs. Mysql
Rusch (ext) Reiner wrote: Hi Ben, you're right! It's NOT free. Just for personal use there're no costs. Ok, if you're not making money on what you're working, then you're right! But: Is it the fault of MySQL AB that you sell your work for nothing? I don't understand, why everybody wants anything for free! Open Source != Freeware The license of MySQL is very cheep! Look at oracle and you know what I try to explain. Ok, Oracle is an other thing, seems to be for very greath projects, but if you need speed and having a small budget then MySQL is a good choice. MySQL is cheeper than Oricle. But it's not free. Not by a long way. Our market is for large scale small products. Stuff which can be downloaded and paid for later. Simple desk-top databases. It's a good market and were good at it. When our applications sell for £50, a $100 licence fee is quite a lot. A $10 is quite a lot on 1000 products, when $0 is available. It's amazing what the effect of the word 'Manditory' on customers has... Here MySQL cannot compete. Your too expensive. Possibly only that MS-MSDE is 50Mb to download that anybody thinks about MySQL at all. Here there are very little competitive DBMS systems. But there are some, and more each day. PostgreSQL, MSDE, SapDB, OpenInterbase (or what ever it's called). It's worth noting, that all of these are also more mature than MySQL, (Views, Procedures, Transactions, Triggers, Functions...) and all of them are cheeper. Where will we be in ten years time? Not MySQL the way it's going. Which is a shame, as I acutally like MySQL. Regards, Ben Regards Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: InterBase vs. Mysql
Rusch (ext) Reiner wrote: you're right! It's NOT free. Just for personal use there're no costs. It's a little more liberal than that. For example, you can run a web site with it for free if you want. The restriction is the standard GPL licensing restriction that says you can't use it for free in a commercial application unless that application is also GPL'ed. MySQL was built itself with other GPL software so it's probably required to have this sort of licensing. So you *can* use if for free -- just release the source to your application. 8-) The licensing info is here: http://www.mysql.com/products/licensing.html -- Steve SapovitsGSI Commerce, Inc.http://www.gsicommerce.com Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innoDB (errno: 121)
Ben, you can search with Google http://www.google.com/advanced_group_search?hl=en with InnoDB 121 That brings up the explanation which I pasted to the end of this email. Best regards, Heikki Innobase Oy sql query .. Subject: innoDB (errno: 121) From: Ben Clewett Date: Tue, 18 Feb 2003 11:30:42 + Using innoDB with Mysql 4.0.10-gamma-max-nt and getting lots of: MySql Error: Could not execute command [ ... ] on server because: Can't create table '.\rr\cons.frm' (errno: 121) Where 'rr' is the name of my database. Some of which I just can't get away from never mind what I do. My latest failure: create table if not exists cons ( code integer unsigned not null auto_increment primary key, items_count integer not null default 0 ) type=innodb This error (121) is not listed on http://www.innodb.com/ibman.html#Error_codes Is there somebody who knows what this is, and how I can get away from it? Regards, Ben. ... From: Heikki Tuuri ([EMAIL PROTECTED]) Subject: Re: Innodb table with auto-increment column doesn't create (err 1005) View: Complete Thread (2 articles) Original Format Newsgroups: mailing.database.mysql Date: 2003-01-30 09:50:58 PST Matthias, what have you done? Below you create table 'foo' but mysql answers that it cannot create 'stundenliste.frm'. mysql create table foo (id int auto_increment,unique key (id)) type=innodb; ERROR 1005: Can't create table './test_smurf/stundenliste.frm' (errno: 121) mysql create table stundenliste (id int auto_increment) type=innodb; ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key mysql create table stundenliste (id int auto_increment) type=myisam; *SUCCESS* I guess you have the table stundenliste in the internal data dictionary of InnoDB, but have somehow managed to delete the .frm file. Look to the file yourhostname.err in the datadir of MySQL. You should find there: heikki@hundin:~/mysql-standard-4.0.6-gamma-pc-linux-i686/bin mysqld 030130 14:15:17 InnoDB: Started mysqld: ready for connections 030130 14:15:48 InnoDB: Error: table test/stundenliste already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm file InnoDB: and not used DROP TABLE? Have you used DROP DATABASE InnoDB: for InnoDB tables in MySQL version = 3.23.43? InnoDB: See the Restrictions section of the InnoDB manual. InnoDB: You can drop the orphaned table inside InnoDB by InnoDB: creating an InnoDB table with the same name in another InnoDB: database and moving the .frm file to the current database. InnoDB: Then MySQL thinks the table exists, and DROP TABLE will InnoDB: succeed. InnoDB: You can look further help from section 15.1 of InnoDB: http://www.innodb.com/ibman.html I tested deleting the .frm file manually and indeed I got: heikki@hundin:~/mysql-standard-4.0.6-gamma-pc-linux-i686/bin mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.6-gamma-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create table stundenliste (id int auto_increment,unique key (id)) type=in nodb; ERROR 1005: Can't create table './test/stundenliste.frm' (errno: 121) mysql Regards, Heikki Innobase Oy sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: InterBase vs. Mysql
Hi, the OpenSource GPL'd version of InterBase 6.01 is called Firebird and is available from: http://sourceforge.net/projects/firebird On Hannover CeBit'2002 I talked to a guy from MySQL AB. It was the time the Firebird 1 release was delayed because of errors in the SQL engine. The guy told me he knew about the problem because MySQL follows the development of InterBase respective Firebird since it potentially would be a concurrent if more people knew about it. MySQL IMHO very much develops it's feature-richness towards InterBase keeping it's own simplicity. InterBase for instance knows subselects but why use a complicated subselect if a MySQL (LEFT) JOIN is so fast and easy to write? Just my two Euro-cents :-) Regards Bernhard - Original Message - From: Ben Clewett [EMAIL PROTECTED] To: Rusch (ext) Reiner [EMAIL PROTECTED] Cc: Inandjo Taurel [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 1:29 PM Subject: Re: AW: InterBase vs. Mysql Here there are very little competitive DBMS systems. But there are some, and more each day. PostgreSQL, MSDE, SapDB, OpenInterbase (or what ever it's called). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
hi heikki, thanks for correcting me on the salary aspect. Most benchmark published actually give credit to mysql when it comes to Mysql Vs Interbase, but as an end user, the best tests are the one i conduct myself in my premises. Therefor when i say that mysql Vs interbase definitely goes to interbase, understand that it's the result of my own experience! Bear in mind that all the benchmark published can give you all the credit possible, if my experience as an enduser proove me otherwise, i'll tend to believe what i can see and proove, not what i can read in an article! So my word to any enduser would be : conduct your own experiences... and see for yourself. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why is MySQL 4 standard binary 4mb larger than max?
On Tue 2003-02-18 at 01:17:16 -0800, [EMAIL PROTECTED] wrote: Just curious since max has more featured compiled in yet it's quite smaller for download at mysql.com. Because the MySQL-Max package only contains mysqld-max, and you are supposed to install it alongside of the MySQL package, which contains everything else needed, not only the standard mysqld. HTH, Benjamin. PS: Please start a new thread when you start a new subject (i.e. do not use a unrelated message and reply to that). Else, most mail readers will show it belonging to the post you replied to. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysqlimport error
On Tuesday 18 February 2003 12:08, Stefan Immel wrote: we get a strange error when trying to import data into our database: mysqlimport: Error: Can't get stat of 'KUNDEN' (Errcode: 13), when using table: KUNDEN it is NO permission Problem, the file ist world readable and the user CAN access the DB. Check if the user that mysql server is ran under has permission to the file, and check also privileges on the directories. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Archive on remote Machine.
On Tuesday 18 February 2003 12:51, Ahmed S K Anis wrote: I use Select * into outfile filepath from table to archive the database. Is there any way to archive this into a different machine. (Not current machine) Yes Mapping to new machine and then giving path is an option. Any other opton.? You can't use SELECT .. INTO OUTFILE for this. Use for example mysqldump program. For more info look at: http://www.mysql.com/doc/en/SELECT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: RE: renaming temporary table
On Monday 17 February 2003 18:47, Arne dot Muller at aventis dot com wrote: I've tried to rename a temporary table, and I got an error ERROR 1017: Can't find file: './GOdevel/xgp.frm'). I guess it does not make too much sense to rename a temp table ... . However, I thought this might be worth mentioning. It's a known behaviuor: http://www.mysql.com/doc/en/Temporary_table_problems.html Use ALTER TABLE instead. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Bug in ORDER BY
On Monday 17 February 2003 21:06, Ken Goff wrote: I have encountered what appears to be a bug in MySQL regarding ORDER BY related to a date field when also used in conjunction with DATE_FORMAT() or UNIX_TIMESTAMP(). When these functions are applied to my date field, MySQL ignores any included ORDER BY within the query. I first noticed this bug using PHP with MySQL but have confirmed it occurs when entering the query directly within Terminal. The table consists of the following 4 fields with their data types described: EventId - number - mediumint(10) - auto_increment EventDate - date Event - text EventOrder - number - mediumint(5) The following query sorts properly: SELECT * FROM EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50; The following ignores ORDER BY and instead sorts by EventId: SELECT EventId, DATE_FORMAT(EventDate, '%c-%e-%Y') as FormattedEventDate, Event, EventOrder FROM EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50; So does the following sort by EventId instead of using the ORDER BY: SELECT EventId, UNIX_TIMESTAMP(EventDate), Event, EventOrder FROM EventList ORDER BY 'EventDate', 'EventOrder' LIMIT 50; Is there any way around this bug? I want to list dates in US style of m-d- instead of -m-d. It works fine for me. Could you provide example of wrong ordering? Please, include also EvendDate column in the output. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Limit the database size
On Tuesday 18 February 2003 04:26, KH Chiu wrote: I am planning to offer a free service that allow users to use my server to learn php and MySQL. I am a bit worry about if one of users (either intentionally or unintentionally) get into infinite loop with insert statement. It will quickly eat up the disk space and make my server unfunctional. So is there any way to limit the size of individual database? With MySQL - nope. You can limit size of the database directory. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: rownum
On Tuesday 18 February 2003 09:14, geeta varu wrote: does mySQL have rowid or rownum if yes please give an exampl Well .. _rowid exists in MySQL. If you have primary or unique key you can refer to this column as _rowid. But this primary or unique key must consists of one integer column. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
Hi. Just a little correction. On Tue 2003-02-18 at 12:44:39 +0100, [EMAIL PROTECTED] wrote: Hi Maciej, I don't know much about Interbase, but MySQL is for some cases a very good choice! Some database engineers would say MySQL isn't a database because it has no transactions by know (in a stable version). MySQL 3.23 has InnoDB support and therefore transactions and is the stable version since for two years now. The only change with 4.0 is that InnoDB is going to be part of the MySQL package instead of MySQL-Max, as it was with 3.23. But think about, if you really need this!!! In versions 4.x (coming soon in a stable version) transactions, subselects etc. would be available! Soon coming as stable is 4.0 (it is already good enough for production use, IMHO), but sub-selects are in 4.1, which is still declared alpha. The main features of 4.0 as listed on http://www.mysql.com/doc/en/News-4.0.x.html are: - a query cache (may vastly improve performance for many apps) - improved FULLTEXT indexing - MERGE table improvements - support for UNION in select - libmysqld, a embedded version of MySQL - more fine grained privileges (with GRANT) - dynamic server variables (change the configuration on the fly) - rewrite of replication with new features - and some other stuff HTH, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
On Tue 2003-02-18 at 12:02:59 +, [EMAIL PROTECTED] wrote: [...] This is the main reason why I am looking at PostgreSQL at the moment, although I've not looked much at Interbase, any good? Either that, or fork MySQL into FreeMySQL, as we can do under the GPL, and not charge our selves :) Aehem. There seems to be some misconception here. Either your program is fine with MySQL being GPL or not. If it is (and your forking example would work for you) either by using MySQL in a way that your program is not required to be GPL'ed or by GPL'ing your program, you need no commercial license from MySQL AB either, and you can already distribute your program with MySQL without the need of a fork or whatever. Or your program needs a commercial license, than forking MySQL would not help, because you still have to adhere to the GPL. The only reason MySQL AB can hand out a commercial license is because they are also the Copyright holders, which you aren't even after forking. HTH, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: InterBase vs. Mysql
Ben Clewett wrote: Here MySQL cannot compete. Your too expensive. Possibly only that MS-MSDE is 50Mb to download that anybody thinks about MySQL at all. Here there are very little competitive DBMS systems. But there are some, and more each day. PostgreSQL, MSDE, SapDB, OpenInterbase (or what ever it's called). Write your software to handle mutiple backends and let the customer choose what they're willing to pay for. If they want to use it with MySQL, they pay the licensing fees. If they want to use it with Postgres, they don't. I they find Postgres too slow and want to use MySQL, that's their choice. If they decide they want to use it with Oracle, that's their choice too. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Inandjo Taurel wrote: hi Maciej, the only arguments you can get in favour of mysql is that it's free, and some of its SQL statement are faster than interbase. Interbase has the advantage of having views, stored procedures,triggers,and it's crazily fast. Don't forget that interbase is also written by professionnal on borland campus, guyz who completed a university degree and were assessed and were judged good enough to work with borland; whilst the average developpers for mysql are volunteers who are not paid for what they are doing! Most of the developers for MySQL are 'professional labour' with 'university degrees' who are _paid_ by MySQL AB to develop the MySQL product. We also had to be 'assessed good enough to work for MySQL AB', and the interview is around 2 years long, because a large part of getting your foot in the door is based on your participation in the MySQL user community, and the fact that you've demonstrated in-depth knowledge of MySQL and MySQL internals. We do get a large amount of effort from the community (which we really, really appreciate), but a large majority of it is in answering questions in the mailing lists, testing, filing good bug reports and in providing connectivity to the database from other languages and tools (PERL, PHP, Java, Ruby, et-al). This community effort is what makes MySQL (and all other open-source databases) a special breed, and available to many people for varied uses, at low-to-no cost. Many of these uses were not even imagined by the people behind the core database software! -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+UkBMtvXNTca6JD8RAvxNAKCF6d07cZBY0Ia+hevQ70dY+NusiwCfdnXM GVCSUGL+qZKP/Fblv9nBVzg= =lboH -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
Hi. On Tue 2003-02-18 at 11:48:53 +, [EMAIL PROTECTED] wrote: hi Maciej, the only arguments you can get in favour of mysql is that it's free, and some of its SQL statement are faster than interbase. Well, and outstanding support, IMHO. Interbase has the advantage of having views, stored procedures,triggers,and it's crazily fast. Don't forget that interbase is also written by professionnal on borland campus, guyz who completed a university degree and were assessed and were judged good enough to work with borland; whilst the average developpers for mysql are volunteers who are not paid for what they are doing! You seem to have some greater misconception about the development of MySQL. Please don't make such statements when you don't know the background. Although MySQL had some great contributions (in source code or otherwise) from volunteers, it is mainly developed by the staff of professionals of MySQL AB. So the speak about university degrees is pointless (aside from that, why do you think volunteers wouldn't have a degree...). I think you should insist on the free aspect of mysql and it's simplicity of use, because for somebody who knows the 2 databases, features wise, robustness wise and speed wise, interbase is far ahead of mysql. I give you features wise. The other two, robustness and speed wise, I see no indication for. HTH, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: rownum
geeta varu wrote: does mySQL have rowid or rownum if yes please give an exampl Please search the archives for _rowid to find the previous discussions on this. It comes down to having an unsigned int auto_increment primary key value in your table to use as the rowid. That's what we all use (some people here may not, of course). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Limit the database size
Thank you very much for your information. Can you tell me more how to limit size of directory in Linux? I can only set quota for users or groups but not for directory. Thank you very much. On Tuesday 18 February 2003 04:26, KH Chiu wrote: I am planning to offer a free service that allow users to use my server to learn php and MySQL. I am a bit worry about if one of users (either intentionally or unintentionally) get into infinite loop with insert statement. It will quickly eat up the disk space and make my server unfunctional. So is there any way to limit the size of individual database? With MySQL - nope. You can limit size of the database directory. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu CA Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
On Tue 2003-02-18 at 12:57:04 +, [EMAIL PROTECTED] wrote: [...] Most benchmark published actually give credit to mysql when it comes to Mysql Vs Interbase, but as an end user, the best tests are the one i conduct myself in my premises. Therefor when i say that mysql Vs interbase definitely goes to interbase, understand that it's the result of my own experience! Hm. So you take the limited experience of your use case and make general statements from that. Don't get me wrong. I absolutely believe you that InterBase is faster for you in your use cases. But that doesn't mean that it is in general. As you can see from the reactions, it would help if you stated your personal experience as such. Bear in mind that all the benchmark published can give you all the credit possible, if my experience as an enduser proove me otherwise, i'll tend to believe what i can see and proove, not what i can read in an article! I don't see how this is less biased than a benchmark might be. Of course, it is the relevant part for you personally, in accordance with the next statement. So my word to any enduser would be : conduct your own experiences... and see for yourself. Absolutely. Seconded. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Limits and order bys
I have a question regarding the use of LIMIT with ORDER BY. My problem is as follows: I want my users to be able to pageanate through result sets, so I've written some code that will display the results of a query 15 rows at a time in a HTML table. The next set of results can be accessed by pressing the next button and ditto for the previous set. The query is SELECT name FROM documents LIMIT 10, 15 I want to further extend this functionality by allowing the users to click on the column name (in the table header) and then sort the current set of results from by the chosen column. So lets say I had the following mysql SELECT name FROM documents LIMIT 2, 4; +---+ | name | +---+ | Visual Patterns Intellectual Property.doc | | footer.jpg| | getHWSerialNumber.txt | | env.php.txt | +---+ Now, I want to order by name. So I should get +---+ | name | +---+ | env.php.txt | | footer.jpg| | getHWSerialNumber.txt | | Visual Patterns Intellectual Property.doc | +---+ But, when I apply the following query mysql SELECT name FROM documents ORDER BY name ASC LIMIT 2, 4; I get +---+ | name | +---+ | env.php.txt | | footer.jpg| | getHWSerialNumber.txt | | Ideas.doc | +---+ I can only assume that MySql is ordering by name before limiting the result set. Obviously I want the reverse. Any ideas? Thanks --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Inserting '#' char as part of a field
Hi
Are there any other characters with the same problem like #?
Thanks
-Original Message-
From: Robby Tanner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 18, 2003 1:16 AM
To: Stefan Hinz
Cc: [EMAIL PROTECTED]
Subject: RE: Inserting '#' char as part of a field
I solved the issue (eventually) by using a different control.
It seems the batch component interprets #'s differently than regular table
and query components. I'll use query components in the future.
Thanks anywaym,
Rob
-Original Message-
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 4:10 PM
To: Robby Tanner
Cc: [EMAIL PROTECTED]
Subject: Re: Inserting '#' char as part of a field
Robby,
How can I get MySQL (via ZeosDBO in Delphi 5) to accept the #
sign? Add extra quotes or a backslash before the character?
Use double
quotes? Some other method?
I know about nothing of Delphi and Zeos, but I'd try a backslash
before the # character. Here's what I get with the mysql client:
mysql INSERT INTO mytest (bla) VALUES ('#'),('\#');
Query OK, 2 rows affected (0.03 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql SELECT bla FROM mytest;
+--+
| bla |
+--+
| #|
| #|
+--+
2 rows in set (0.00 sec)
Obviously, the backslash changes nothing, so I guess it won't hurt
trying.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I am getting tired of this argument. This is the MySQL Users mail list, not a list to slagg of MySQL, its features or staff. Constructive comment is always welcome, but people on this list have chosen to use MySQL because of what it is and will become. They accept the GNU license or they take out a MySQL license. One of the main advantages of MySQL of other GNU databases is speed. Whilst triggers, functions, views, locking and constraints are all nice, they all place load on a DBMS. If you need them, so be it, if not use MySQL and enjoy the speed. All the best Simon - -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+UkbNSJvgVrMNWjYRAiNzAKDT+k7vzCYnwUmSJzYmKN2SYM6VqwCgzs2v TOC3NALEzeSgUnqHpN5VK+M= =+OEQ -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Various replication problems with 4.0.10-gamma
Hi, I'm having a bit of a nightmare getting replication working. Both slave and master are 4.0.10-gamma If I install fresh copies on two clean machines, and follow the instructions in manual.txt, everything works fine. The problem is that I need to do this in a production environment, so I can't quite follow the instructions. I've tried using LOAD DATA FROM MASTER, but this aborts and the logfile shows a ER_NET_MASTER_READ has occurred in the middle of the third table. So, I removed the mysql data directory on the slave, and completely re-installed and re-populated it (just to be sure I had a clean start). Then tried again by taking a snapshot - Just one database to start with. I then tried a CHANGE MASTER TO ... and SLAVE START This now fails with: 030218 14:21:53 Error updating slave list: Query error It seems that replication is trying to do a SHOW SLAVE HOSTS. I assume that this is running on the master, so I tried to login to the master by hand and run it to see what the error is. I get the error: ERROR 1227: Access denied. You need the REPLICATION SLAVE privilege for this operation I've tried setting the grants again, but it doesn't seem to make any difference: mysql GRANT REPLICATION SLAVE,RELOAD,SUPER ON *.* TO myuser@myhost IDENTIFIED BY 'mypass' mysql show grants for myuser@myhost; ++ | Grants for myuser@myhost | | ++ | GRANT RELOAD ON *.* TO 'myuser'@'myhost' IDENTIFIED BY PASSWORD 'asdadadasdadasas' | | ++ 1 row in set (0.00 sec) Whats going on here ? Thanks JohnT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication problems
Hi All I am trying to make a replication for my database. The master and the slave both in version 3.23.41 and i am working on windows 2000. I create user with FILE privilege and I flush all the tables and block write queries. Now I run the query SHOW MASTER STATUS and I get null in all the columns (file, position, Binlog_do_db and Binlog_ignore_db) What should I do? Thanks, Inbal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANN: EMS MySQL DataPump 1.1 released!
EMS HiTech company is very glad to announce MySQL DataPump 1.1 -- the next version of our data conversion utility. You can download the latest version from http://www.ems-hitech.com/mysqlutils/download.phtml What's new in version 1.1? 1. The console version of MySQL DataPump is immediately available. This command-line utility allows converting databases to MySQL in one touch! 2. The Connection String history is now kept and recently built strings are available in the drop-down menu. 3. Now you can disable displaying error messages when importing data. 4. Tables with foreign keys referencing themselves do not influence data import into other tables. 5. Now when editing foreign keys not all the rules are displayed but only rules supported by the server version. 6. Foreign keys referencing tables not selected for conversion are removed from the selected tables now. What is MySQL DataPump? EMS MySQL DataPump is a powerful utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL database or any other database with ADO support) to MySQL databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target MySQL database and select tables for import. Don't forget to check out other our products: http://www.ems-hitech.com/sqlmanagers Powerful database administration tools for InterBase/FireBird, MySQL and PostgreSQL servers http://www.ems-hitech.com/sqlutils/ Cross-platform data management utilities http://www.ems-hitech.com/components/ Powerful components for Delphi/C++ Builder developers We hope you'll like our products. Thank you for your attention. Best Regards, EMS HiTech Team http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem in connecting to DB
Everytime you use UPDATE, INSERT, DELETE to update user privileges you
must do a FLUSH PRIVILEGES for changes to take effect.
Check the manual:
http://www.mysql.com/doc/en/Privilege_changes.html
On Tue, 2003-02-18 at 11:57, Ganesh Rajan wrote:
hello all,
i would like to put a problem as what iam facing... i created a new database
new user, but i didn't give the password...
then i logged in to mysql
ie
c:\mysql\bin mysql
then
mysql use mysql
then
mysqlupdate user set password=password('pswd') where user= 'username';
then i got the result as 1row updated.
then i quit from mysql using mysql\q
now when i want to connect
i.e.
c:\mysql\bin mysql -u username -ppswd dbname;
iam getting error stating Error 1405:Access denied for user:
'username@localhost ' (user password :YES)'
IAM WORKING ON COMMANDLINE @ MYSQL SERVER ITSELF
can someone throw light onthis... it will be of grate help
Thanks in advance
Ganesh Rajan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Diana Soares
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow retrieval of distinct on indexed fields
In the last episode (Feb 18), Renars Jeromans said: This is not an urgent problem, but it has always intrigued me... It's simplified case, but it makes the point. Let us assume that we have a table create table T (id unsigned int unique, name char(10)); create index i_name on T(name); Let's insert into it say 5 mil rows with name field being just say 5 distinct values AAA, BBB, CCC, DDD, EEE. Now the question. Why a query like select distinct name from T; takes about 3 sec to return just a bunch of rows? As I understand it, index contains all these 5 values, so just simple lookup into index should take fractions of a second. Can anyone comment on this? MySQL team? You need to walk the entire index to make sure you have all the values. There might be a single AAB inbetween those million AAA's and million BBB's. It requires a full index scan, which is usually a lot faster than a full table scan, but it is still not instantaneous. In your example it won't be any quicker since your table only has two rows, but in the usual case where a row may be a couple hundred bytes long there is a bigger difference. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question
Sir/Ma'am, I am building a database (using MySQL) consisting of a list of emplyees with specific and unique information for each. I want to link an employees badge number with their photo. I have photos for all employees in JPG format. How can I link the badge number to a photo? Ideally, I would like to click on the badge number and the photo would come up. Any help is greatly appreciated. Thanks much. Robert D. McGraw Anteon Corporation Database Administrator Battle Simulation Center Ft. Hood, TX DSN 738 3061 Comm. (254) 288 3061 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access denied 3.23.55
Hi! Is it a bug? C:\mysqlmysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 29 to server version: 3.23.55-max-nt mysql create database R; Query OK, 1 row affected (0.06 sec) mysql grant all privileges on `R%`.* to b; Query OK, 0 rows affected (0.00 sec) C:\mysqlmysql -u b R ERROR 1044: Access denied for user: 'b@localhost' to database 'r' On 3.23.48 it work OK...8( WBR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow retrieval of distinct on indexed fields
I've always thought that adding a count of index entries to the index file would be helpful. Like (generic index entry): word:15:1,2,5,7,etc... where word is the indexed value, 15 is the number of times it appears, and 1,2,5,7 is the record offsets (or byte offsets for dynamic stuff) of the appearances of the indexed value. This way, getting a count of indexed values would be quick, and scanning the index would no longer be necessary, because the count (15) would tell you how many index entries to skip to get the next indexed value in the index. Peter ^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Renars Jeromans [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 10:14 AM Subject: Re: Slow retrieval of distinct on indexed fields In the last episode (Feb 18), Renars Jeromans said: This is not an urgent problem, but it has always intrigued me... It's simplified case, but it makes the point. Let us assume that we have a table create table T (id unsigned int unique, name char(10)); create index i_name on T(name); Let's insert into it say 5 mil rows with name field being just say 5 distinct values AAA, BBB, CCC, DDD, EEE. Now the question. Why a query like select distinct name from T; takes about 3 sec to return just a bunch of rows? As I understand it, index contains all these 5 values, so just simple lookup into index should take fractions of a second. Can anyone comment on this? MySQL team? You need to walk the entire index to make sure you have all the values. There might be a single AAB inbetween those million AAA's and million BBB's. It requires a full index scan, which is usually a lot faster than a full table scan, but it is still not instantaneous. In your example it won't be any quicker since your table only has two rows, but in the usual case where a row may be a couple hundred bytes long there is a bigger difference. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Question
Why don't you link the badge number to the url of the photo? e.g. BadgeNumber PhotoURL 1 c:\MyPhoto\1.jpg 2 c:\MyPhoto\1.jpg etc ... Then you can get the URL and simply load the photo --- Rob ** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ** -Original Message- From: McGraw, Robert--G3(Contractor-ANTEON Corp) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 18, 2003 5:24 PM To: '[EMAIL PROTECTED]' Subject: Question Sir/Ma'am, I am building a database (using MySQL) consisting of a list of emplyees with specific and unique information for each. I want to link an employees badge number with their photo. I have photos for all employees in JPG format. How can I link the badge number to a photo? Ideally, I would like to click on the badge number and the photo would come up. Any help is greatly appreciated. Thanks much. Robert D. McGraw Anteon Corporation Database Administrator Battle Simulation Center Ft. Hood, TX DSN 738 3061 Comm. (254) 288 3061 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Question
Usually the best way to do this is to store the images in an accessible directory and then store the URL for the image in the database. It's a fairly simple exercise also to create an upload function that will associate the two for you automatically. Hope this helps, _M ]-Original Message- ]From: McGraw, Robert--G3(Contractor-ANTEON Corp) ][mailto:[EMAIL PROTECTED]] ]Sent: Tuesday, February 18, 2003 10:24 AM ]To: '[EMAIL PROTECTED]' ]Subject: Question ] ] ]Sir/Ma'am, ] ]I am building a database (using MySQL) consisting of a list of ]emplyees with ]specific and unique information for each. I want to link an ]employees badge ]number with their photo. I have photos for all employees in JPG format. ]How can I link the badge number to a photo? Ideally, I would like to click ]on the badge number and the photo would come up. Any help is greatly ]appreciated. ] ]Thanks much. ] ] ]Robert D. McGraw ]Anteon Corporation ]Database Administrator ]Battle Simulation Center ]Ft. Hood, TX ]DSN 738 3061 Comm. (254) 288 3061 ] ] ] ]- ]Before posting, please check: ] http://www.mysql.com/manual.php (the manual) ] http://lists.mysql.com/ (the list archive) ] ]To request this thread, e-mail [EMAIL PROTECTED] ]To unsubscribe, e-mail ][EMAIL PROTECTED] ]Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ] ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
aes_encrypt/aes_decrypt returns null for valid input data
Description: aes_encrypt/aes_decrypt works correctly for a test case. Change only the last two digits of the string needing to be encrypted and it returns null. I formed the queries below by cut and paste, so I was sure that the password was constant. The actual problem occured when my C program, using a server side password that was not altered during execution, would work correctly for 55 insert statements and have an error on one. As I was about to send this, I repeated the test except for changing the key to gary. Everything worked then. Linux/Red Hat Version 8.0 Tested on 4.0.2-alpha-log and 4.0.10-gamma-standard How-To-Repeat: mysql describe sop_uid; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | sop_uid | varchar(150) | YES | | NULL| | | case_id | int(11) | YES | | NULL| | | study_id | int(11) | YES | | NULL| | | series_id | int(11) | YES | | NULL| | | unique_number | int(11) | YES | | NULL| | +---+--+--+-+-+---+ 5 rows in set (0.00 sec) mysql delete from sop_uid; Query OK, 3 rows affected (0.00 sec) mysql INSERT INTO sop_uid ( sop_uid, case_id, study_id, series_id, unique_number ) - VALUES ( AES_ENCRYPT(1.2.840.113619.2.55.1.1762891793.2470.1041939826.111, titepfda), 46, 130, 603, 113177); Query OK, 1 row affected (0.00 sec) mysql select aes_decrypt(sop_uid, titepfda), case_id,study_id,series_id,unique_number from sop_uid where unique_number=113177; +--+-+--+---+---+ | aes_decrypt(sop_uid, titepfda) | case_id | study_id | |series_id | unique_number | +--+-+--+---+---+ | 1.2.840.113619.2.55.1.1762891793.2470.1041939826.111 | 46 | 130 | |603 |113177 | +--+-+--+---+---+ 1 row in set (0.00 sec) mysql INSERT INTO sop_uid ( sop_uid, case_id, study_id, series_id, unique_number ) - VALUES ( AES_ENCRYPT(1.2.840.113619.2.55.1.1762891793.2470.1041939826.158, titepfda), 46, 130, 603, 113177); Query OK, 1 row affected (0.00 sec) mysql select aes_decrypt(sop_uid, titepfda), case_id,study_id,series_id,unique_number from sop_uid where unique_number=113177; +--+-+--+---+---+ | aes_decrypt(sop_uid, titepfda) | case_id | study_id | |series_id | unique_number | +--+-+--+---+---+ | 1.2.840.113619.2.55.1.1762891793.2470.1041939826.111 | 46 | 130 | |603 |113177 | | NULL | 46 | 130 | |603 |113177 | +--+-+--+---+---+ 2 rows in set (0.00 sec) mysql select version(); +---+ | version() | +---+ | 4.0.10-gamma-standard | +---+ 1 row in set (0.00 sec) Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: aes_encrypt/aes_decrypt returns null for correct input data Severity: Priority: Category: mysql Class: Release: mysql-4.0.10-gamma-standard (Official MySQL-standard binary) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux gary.rad.med.umich.edu 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Oct 15 11:24 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x1 root root 1235468 Sep 5 19:12 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 18:50 /usr/lib/libc.so Configure command: ./configure
Re: 'Disappearance of the mysql.sock when the computer is shut downand restarted'
Maybe you don't have your mysqld setup to start automatically when the system boots. Check the manual for help on setting up mysql daemon to start automatically after a boot: http://www.mysql.com/doc/en/Automatic_start.html On Tue, 2003-02-18 at 08:48, Fredrik Lundgren wrote: Hello, I'm new to MySQL and to linux. I'm using an Omnibook XE3 with RAM 254 on SuSE linux 8.1. In one of the slots of a Texas instrument pcmcia I have a Xircom PC card modem 56K. During startup this has to be disconnected when linux is starting hardware scan on boot - but otherwise works OK. I have loaded MySQL 3.23.55 as an RPM for i386 an this works OK and I logout and login as another user without problems ### but when the computer is shutdown and restarted it appears as if the mysql.sock disappears. Or am I unable to start the mysql server When I try the comand mysql etc i get Error 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have tried to stick the socket with shell chmod +t /var/lib/mysql and shell ls -ld /var/lib/mysql confirmes the last permission to t (as suggested onpage 724 in the ref manual). I have also made a binary installation mysql-3.23.55-pc-linux-i686 or something with pretty much the same result. In essens: I lose mysql.sock when the computer is restarted or I'm unable to start the msql server and reestablish the msql.sock after reboot and Before I restart the computer MySQL works very OK both with rpm install and binary install What to do? What do I do wrong? Fredrik Lundgren Norrköping - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Diana Soares - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: received 0 length packet from server
Resetting the binlogs on the master didn't make a difference. Syncing all MySQL versions didn't make a difference. I've checked network configuration, permissions on both the replication user (on the master) and the files on slaves. The master error log has nothing in it. Is there a way to turn up the verbosity of the log files without building a debug version of MySQL? -Original Message- From: Jeremy Tinley [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 4:07 PM To: [EMAIL PROTECTED] Subject: RE: received 0 length packet from server A few more tidbits: * All slaves are running the static i686 linux build (mysql-3.23.55-pc-linux-i686) under RH8.0 (since RH8 won't compile MySQL without it dumping core). * More log snippets: 030217 15:43:01 Slave: received 0 length packet from server, apparent master shutdown: 030217 15:43:01 Slave: Failed reading log event, reconnecting to retry, log 'binlog.010' position 540017428 030217 15:43:01 Slave: reconnected to master 'repl@master1:3306',replication resumed in log 'binlog.010' at position 540017428 030217 15:43:01 Slave: received 0 length packet from server, apparent master shutdown: 030217 15:44:01 Slave: Failed reading log event, reconnecting to retry, log 'binlog.010' position 540017428 030217 15:44:01 Slave: reconnected to master 'repl@master1:3306',replication resumed in log 'binlog.010' at position 540017428 030217 15:44:02 Error reading packet from server: Lost connection to MySQL server during query (server_errno=2013) 030217 15:44:02 Slave: Failed reading log event, reconnecting to retry, log 'binlog.010' position 540037417 030217 15:44:02 Slave: reconnected to master 'repl@master1:3306',replication resumed in log 'binlog.010' at position 540037417 This is one complete cycle of the problem. This time, I see server_errno=2013. Perror doesn't have anything on this error. -Original Message- From: Jeremy Tinley [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 3:37 PM To: [EMAIL PROTECTED] Subject: received 0 length packet from server Howdy, Running MySQL 3.23.54 on master, 3.23.55 on all slaves, I'm experiencing the following situation: slave1 slave4 both receive 0 length packets from the server. slave2 slave3 both work fine. slave1 2 are identical machines both in hardware and configuration slave3 4 are different from 1 2, and from each other in hardware only The my.cnf files are the same, same subnet, different switches (but a machine that works, and one that doesn't are on the same switch). Log files look like this (trimmed for neatness): 030217 15:16:47 Slave: received 0 length packet from server, apparent master shutdown: 030217 15:16:47 Slave: Failed reading log event, reconnecting to retry, log 'binlog.010' position 531922547 030217 15:16:47 Slave: reconnected to master 'repl@master1:3306',replication resumed in log 'binlog.010' at position 531922547 030217 15:16:47 Slave: received 0 length packet from server, apparent master shutdown: 030217 15:16:47 Slave: Failed reading log event, reconnecting to retry, log 'binlog.010' position 531922771 030217 15:16:47 Slave: reconnected to master 'repl@master1:3306',replication resumed in log 'binlog.010' at position 531922771 Troubleshooting thoughts, anyone? The slaves are in an LVS cluster and can be downed at any time. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow retrieval of distinct on indexed fields [OT?]
Dan Nelson wrote: You need to walk the entire index to make sure you have all the values. There might be a single AAB inbetween those million AAA's and million BBB's. Another DBA and I once discussed that an index of index values would be helpful for such large searches as web search engines (for example). An index would list all the words that are indexed with their offsets within the index itself, and then those offsets would contain the locations in the document for that word; if you needed to find AAB, its the second entry (in alpha order) in the word index, and its list of positions within the document is the 10234th entry (or byte position) within the index file. To know how many entries, one would simply grab the next index item (AAC in this case) and subtract (10235 - 10234 = 1 entry for AAB). AAA - 1 AAB - 10234 AAC - 10235 1: 12 2: 25 [...] 10233: 4285 10234: 73 10235: 4123 To top that off, finding closest matches to AAA with relation to AAC in a sentence (for example) would be simple as you can walk the index for AAA and AAC at the same time (since you know where both start in the index very quickly) and simply increment each according to the diff. between the position offsets in each (which are sorted in position order). Just thinking out-loud, and no, I've never benchmarked it but I played with the idea in Python a few times as a proof-of-concept. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. SQL http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question
* McGraw, Robert--G3(Contractor-ANTEON Corp) I am building a database (using MySQL) consisting of a list of emplyees with specific and unique information for each. I want to link an employees badge number with their photo. I have photos for all employees in JPG format. How can I link the badge number to a photo? Ideally, I would like to click on the badge number and the photo would come up. Any help is greatly appreciated. Easiest possible way: Rename each photo to badgenumber.jpg. This does not require a database at all, just a web server. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
I'm not here to slag MySQL, but this point is extremely interesting. Benjamin Pflugmann wrote: Aehem. There seems to be some misconception here. Either your program is fine with MySQL being GPL or not. If it is (and your forking example would work for you) either by using MySQL in a way that your program is not required to be GPL'ed or by GPL'ing your program, you need no commercial license from MySQL AB either, and you can already distribute your program with MySQL without the need of a fork or whatever. Or your program needs a commercial license, than forking MySQL would not help, because you still have to adhere to the GPL. The only reason MySQL AB can hand out a commercial license is because they are also the Copyright holders, which you aren't even after forking. There is also some middle ground here. Which is the overlap of the two. Where the user (me) wants to use a OSS DBMS, is happy to forward the source code, inform the customer of the GPL licence etc. But at the same time produce a commercial application which then uses this installed DBMS server/client, without effecting the GPL package. MySQL say that this is an extension of the application, and therefore breaks the GPL, and therefore a licence is needed. They are however, the only big GPL user who thinks this way. I note for example the number of companies selling commercial CGI software designed to run on Apache, server/client, to which no licence is mandatory. Also Sendmail, GCC, other DBMS's, and indeed GNU/Linux it's self. None of these very large groups consider a licence *mandatory* for use when supporting a commercial application. I use the term 'mandatory', they may still choose to purchase a licence. If they did insist on a licence, a very large number of very large companies would have to withdraw a very large number of products. Eg, IBM who use Sendmail to support their commercial email servers. Therefore, I can see no reason why not somebody could fork MySQL into FreeSQL. It would take a few hours at SorceForge, a 'sed' of MySQL into FreeSQL', and a good posting to Slashdot. Keep it 100% GPL without breaking either the wording or the spirit of the document. Remove all reference to copyright material belonging to MySQL. It's either GPL or cpryright, not both. Then use this without commercial licence... BTW, as to another posting. 'Either accept the GPL or purchase a licence'. I do note another option (apart from forking): Use something else. Is MySQL really that good? I do worry that with arrogant statements like this, this is exactly what people will do, in droves. If that's okay with you, well... HTH, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow retrieval of distinct on indexed fields
In the last episode (Feb 18), Peter Grigor said: I've always thought that adding a count of index entries to the index file would be helpful. Like (generic index entry): word:15:1,2,5,7,etc... where word is the indexed value, 15 is the number of times it appears, and 1,2,5,7 is the record offsets (or byte offsets for dynamic stuff) of the appearances of the indexed value. This way, getting a count of indexed values would be quick, and scanning the index would no longer be necessary, because the count (15) would tell you how many index entries to skip to get the next indexed value in the index. What you describe above is similar to a bitmap index; they trade off a more complicated encoding scheme for extremely fast counts. Storing the record offset is sort of inefficient; that's 4 (8?) bytes per record. If you either store a bitmap of rows that that value occurs in (i.e. 1100101 in your example), or delta record/byte offsets (1,+1,+3,+2,0), and then compress those, you can shrink your indexes to an incredibly small size. Compressed indexes take a lot longer to update, though. See http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:125271:200211:bmokiphdlmibimfljjkf for a description of how I would implement bitmap indexes in MySQL . -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question
I'd create a table with id, username, ,badgenumber, url. then have i.e. 1, Jerry, 007, /dir/images/jerry.jpg 2, Bob, 008, /dir/images/bob.jpg or something like that. The scripting to get that out and generate the html would be very easy. There are a few examples here that would cover what you want : http://www.devshed.com/Server_Side/PHP Jerry - Original Message - From: McGraw, Robert--G3(Contractor-ANTEON Corp) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 3:24 PM Subject: Question Sir/Ma'am, I am building a database (using MySQL) consisting of a list of emplyees with specific and unique information for each. I want to link an employees badge number with their photo. I have photos for all employees in JPG format. How can I link the badge number to a photo? Ideally, I would like to click on the badge number and the photo would come up. Any help is greatly appreciated. Thanks much. Robert D. McGraw Anteon Corporation Database Administrator Battle Simulation Center Ft. Hood, TX DSN 738 3061 Comm. (254) 288 3061 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: InterBase vs. Mysql
Hi Ben, I'm not sure what you really want to sell. If you have to take a license from MySQL because of a commercial use, you just have to take ONE license. Correct me, if I'm wrong! If you want to sell your programs etc. which uses MySQL then see it in another way: Firstly MySQL isn't very expensive in my opinion. If your client wants to buy your programs then he has to buy a license (when his way is a commercial one). So this would be a must that your client has to take. But, if you would sell programs based on Microsoft Windows, what would be the difference? None! Your client would need to have a valid license on this OS! But would you say, Microsofts Windows (for example!) would be bad just because it's difficult to tell your client that he NEED'S windows to run your work? NO, you wouldn't! Perhaps because everyone has windows. But why to think in another way about MySQL? I think this isn't fair!!! Regards, Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug in UNION? Different results
Description: if i use the following UNION statement, i do not get the same result as if i'm using the two selects separately or with a temporary table. i do not know if this is a bug, but i can not explain this behaviour. maybe someone can help me out... How-To-Repeat: using the following query does get strange results: (select distinct a, if(name '',name,text1) as name, firstname, tabPerson.classID, tabPerson.personID, 1 as contentID, DATE_FORMAT(tabContent.date,'%d.%m.%Y') as fdate, tabContent.contenttypeID, tabContent.title, tabContent.linkID, tabContent.timestamp from ((tabPerson LEFT JOIN tabPerson_Content ON tabPerson_Content.personID = tabPerson.personID) LEFT JOIN tabContent ON tabContent.contentID = tabPerson_Content.contentID) where (contenttypeID = 4 or contenttypeID = 9 or (contenttypeID = 29 AND contenttypeID = 32)) AND (tabContent.classID = 0 OR tabContent.classID = -1 OR tabContent.classID OR ISNULL(tabContent.classID)) GROUP BY tabPerson.personID ORDER BY tabContent.timestamp DESC LIMIT 10) UNION ALL (select b, name, firstname, tabPerson.classID, tabPerson.personID, tabContent.contentID, DATE_FORMAT(tabContent.date,'%d.%m.%Y') as fdate, tabContent.contenttypeID, tabContent.title, tabContent.linkID, tabContent.timestamp from ((tabContent LEFT JOIN tabPerson_Content ON tabPerson_Content.contentID = tabContent.contentID) LEFT JOIN tabPerson ON tabPerson.personID = tabPerson_Content.personID) where (tabContent.contenttypeID = 12 or tabContent.contenttypeID = 13 or (tabContent.contenttypeID = 26 AND tabContent.contenttypeID = 28)) AND (tabContent.classID = 0 OR tabContent.classID = -1 OR tabContent.classID OR ISNULL(tabContent.classID)) GROUP BY tabContent.contentID ORDER BY tabContent.timestamp DESC LIMIT 10) ORDER BY timestamp DESC LIMIT 10 while using this query, gets the correct results: CREATE TEMPORARY TABLE tmp select distinct a, if(name '',name,text1) as name, firstname, tabPerson.classID, tabPerson.personID, 1 as contentID, DATE_FORMAT(tabContent.date,'%d.%m.%Y') as fdate, tabContent.contenttypeID, tabContent.title, tabContent.linkID, tabContent.timestamp from ((tabPerson LEFT JOIN tabPerson_Content ON tabPerson_Content.personID = tabPerson.personID) LEFT JOIN tabContent ON tabContent.contentID = tabPerson_Content.contentID) where (contenttypeID = 4 or contenttypeID = 9 or (contenttypeID = 29 AND contenttypeID = 32)) AND (tabContent.classID = 0 OR tabContent.classID = -1 OR tabContent.classID OR ISNULL(tabContent.classID)) GROUP BY tabPerson.personID ORDER BY tabContent.timestamp DESC LIMIT 10; INSERT INTO tmp select b, name, firstname, tabPerson.classID, tabPerson.personID, tabContent.contentID, DATE_FORMAT(tabContent.date,'%d.%m.%Y') as fdate, tabContent.contenttypeID, tabContent.title, tabContent.linkID, tabContent.timestamp from ((tabContent LEFT JOIN tabPerson_Content ON tabPerson_Content.contentID = tabContent.contentID) LEFT JOIN tabPerson ON tabPerson.personID = tabPerson_Content.personID) where (tabContent.contenttypeID = 12 or tabContent.contenttypeID = 13 or (tabContent.contenttypeID = 26 AND tabContent.contenttypeID = 28)) AND (tabContent.classID = 0 OR tabContent.classID = -1 OR tabContent.classID OR ISNULL(tabContent.classID)) GROUP BY tabContent.contentID ORDER BY tabContent.timestamp DESC LIMIT 10; SELECT * from tmp ORDER BY timestamp DESC LIMIT 10; DROP TABLE tmp; Fix: Submitter-Id: submitter ID Originator:lru Organization: pixworx multimedia Category: mysql Release: mysql-4.0.10-gamma-standard (Official MySQL-standard binary) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux paprika 2.4.18-4GB #1 Wed Mar 27 13:57:05 UTC 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS='' LIBC: -rwxr-xr-x1 root root 1394302 Oct 2 10:06 /lib/libc.so.6 -rw-r--r--1 root root 25361748 Oct 2 09:36 /usr/lib/libc.a -rw-r--r--1 root root 178 Mar 23 2002 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To
Re: InterBase vs. Mysql
Ben Clewett wrote: MySQL say that this is an extension of the application, and therefore breaks the GPL, and therefore a licence is needed. They are however, the only big GPL user who thinks this way. No they're not. The issue is not the use of the server (as previously discussed a few weeks back), but the library. If you use the older library version (which is LGPL'd), you can basically do as you please as you believe you should be able to. As the new library is under the GPL, you can't legally link it to a non-GPL-compatible program at all (without purchasing a different license). Therefore, I can see no reason why not somebody could fork MySQL into FreeSQL. You forget that (as someone else pointed out, perhaps Ben) MySQL's Copyright still lies with MySQL AB. You can fork the code and modify and distribute it _under the GPL_ but that doesn't buy you anything -- you don't then have the right to link it against a commercial program or even to relicense it. All you have is a renamed version of MySQL that is still under the GPL. That's not what you're hoping for, is it? It's either GPL or cpryright, not both. Then use this without commercial licence... You obviously need a good lawyer. The GPL is a license agreement, not a Copyleft statement. Copyright still applies (as it does to all works) and the license specifically states that. In fact, the GPL text says that if you don't agree to all the limitations of the GPL then you simply fall under those of international Copyright law, which are much harsher (and still apply). You need to re-read the GPL a few times and pay a lawyer to help you understand it. MySQL really that good? I do worry that with arrogant statements like this, this is exactly what people will do, in droves. Many people here are perfectly happy with the GPL, I might add. I license all my MySQL-related code under the GPL. I don't distribute it to anyone, so its not terribly relevant, but its well marked and noted as being either GPL'd or for personal use only (most of which is GPL'd as well). I don't write much commercial, non-GPL code. I write a lot of commercial and GPL'd code though, and so do many other people (like MySQL AB). You might want to consider it too. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re[2]: InterBase vs. Mysql
Actually, I think you are not quite right in all respects. but feel free to correct me if I am wrong Somebody, or some entity still needs to hold the copyright of a product. How that entity chooses to sell or distribute that product is up to them. In this case MySQL AB is the copyright holder. They have a fast, highly reliable product which meets the need of the majority of web-developers (and other developers). It is not as feature rich as, say Interbase or MSSQL Server. (I would love triggers and stored procedures, so that I can store business logic in the RDBMS) This is my interpretation (after clarification from MySQL, and www.mysql.com ), of MySQL's licence: If a product is inherrently tied to using MySQL, i.e. without MySQL it would need re-development, alteration, or would not work. And you are profiting from the sale of that product, then MySQL insist a license should be purchased. If the product is DB Agnostic or if the product is open-source and is distributed under GPL, then it doesn't need a license. Basically, if you profit from MySQL's work, they want a very modest fee for there effort (much cheaper then other traditionally commercially available RDBMS.) HTH, Richad I'm not here to slag MySQL, but this point is extremely interesting. Benjamin Pflugmann wrote: Aehem. There seems to be some misconception here. Either your program is fine with MySQL being GPL or not. If it is (and your forking example would work for you) either by using MySQL in a way that your program is not required to be GPL'ed or by GPL'ing your program, you need no commercial license from MySQL AB either, and you can already distribute your program with MySQL without the need of a fork or whatever. Or your program needs a commercial license, than forking MySQL would not help, because you still have to adhere to the GPL. The only reason MySQL AB can hand out a commercial license is because they are also the Copyright holders, which you aren't even after forking. There is also some middle ground here. Which is the overlap of the two. Where the user (me) wants to use a OSS DBMS, is happy to forward the source code, inform the customer of the GPL licence etc. But at the same time produce a commercial application which then uses this installed DBMS server/client, without effecting the GPL package. MySQL say that this is an extension of the application, and therefore breaks the GPL, and therefore a licence is needed. They are however, the only big GPL user who thinks this way. I note for example the number of companies selling commercial CGI software designed to run on Apache, server/client, to which no licence is mandatory. Also Sendmail, GCC, other DBMS's, and indeed GNU/Linux it's self. None of these very large groups consider a licence *mandatory* for use when supporting a commercial application. I use the term 'mandatory', they may still choose to purchase a licence. If they did insist on a licence, a very large number of very large companies would have to withdraw a very large number of products. Eg, IBM who use Sendmail to support their commercial email servers. Therefore, I can see no reason why not somebody could fork MySQL into FreeSQL. It would take a few hours at SorceForge, a 'sed' of MySQL into FreeSQL', and a good posting to Slashdot. Keep it 100% GPL without breaking either the wording or the spirit of the document. Remove all reference to copyright material belonging to MySQL. It's either GPL or cpryright, not both. Then use this without commercial licence... BTW, as to another posting. 'Either accept the GPL or purchase a licence'. I do note another option (apart from forking): Use something else. Is MySQL really that good? I do worry that with arrogant statements like this, this is exactly what people will do, in droves. If that's okay with you, well... HTH, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: InterBase vs. Mysql
Okay... BTW, I have cleared purchacing licences with my own people, and we do not have a problem. Neither do I not like MySQL, I do. The licence model you have supports a model similar to that of Oricle. Large, small quantity, expensive products. We are at the opposite end. Small low cost products which are Shareware, or low cost. (Even Shareware needs a MySQL Licence.) In this case the MySQL licence is up to 200% of the cost of the product. You say it's cheep... It is for one. I need hundreds/thousands. The licences also cannot be purchaced without an expensive support contract. You gues are too good, I don't need one :) To be fare, you do discounts for low cost software. But if only $10 on 5000 products is still the difference between hiring, or firing, a programmer. Is this case, you can say, 'Well, f*** off then', and we will. But there are a lot more small companies than large ones. There may be a time when one too many companies are using, say, SapDB, and MySQL becomes a backwater... The MS model is not the same as everybody has this and paid for it, often without evern knowing it. Even if, like me, I wipe it and install something else. I feal I am digging my self a grave here, so this will be about my last ever posting... Either that or your mailing administrator will start bouncing my mail Ben Rusch (ext) Reiner wrote: Hi Ben, I'm not sure what you really want to sell. If you have to take a license from MySQL because of a commercial use, you just have to take ONE license. Correct me, if I'm wrong! If you want to sell your programs etc. which uses MySQL then see it in another way: Firstly MySQL isn't very expensive in my opinion. If your client wants to buy your programs then he has to buy a license (when his way is a commercial one). So this would be a must that your client has to take. But, if you would sell programs based on Microsoft Windows, what would be the difference? None! Your client would need to have a valid license on this OS! But would you say, Microsofts Windows (for example!) would be bad just because it's difficult to tell your client that he NEED'S windows to run your work? NO, you wouldn't! Perhaps because everyone has windows. But why to think in another way about MySQL? I think this isn't fair!!! Regards, Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem with replication and corrupting tables
An update. I'm now running the debug version on the slave. I could not trace
out 'info' since it wrote way too much to the trace file.
What I did find that was unique when the table crashed is this:
handle_slave_sql: query: insert into forums_posts_new_3 (
w_search: error: Got errno: 0 from key_cache_read
mi_write: error: Got error: 126 on write
my_message_sql: error: Message: 'Incorrect key file for table:
'forums_posts_new_3'. Try to repair it'
sql_print_error: error: Slave: error 'Incorrect key file for table:
'forums_posts_new_3'. Try to repair it' on query 'insert into
forums_posts_new_3
I don't know why it had a problem with error zero from key_cache_read --
that seems to be the oddest thing in the log. It appears no where else.
I'll keep digging. Does no one else have a problem with a slave stopping and
corrupting its own tables?
The only thing about the insert query that may be seen as odd is that it has
binary data in it. That is one of the fields is like this:
'xÚÍTKoã6^P¾÷W~L}ÉÅÕf~K^B^EÚÝ,~\®~Qm7Û\0qÐ`~O#~S~R^HQ¤AÒQÕ_ßoH%V^N=ôP`~Q~Ge~
J3ó=ffKIó¡Ó~AZ~Ò$^O~MiRGm`¥é`9FbGø0^[´K?Ó~MN~T:m^B^]9à$RòHc~\^NÄ^T~S^O^S~M
^Fi~X^F^_Ø^Rç^PÒN~QoȤ~J^^ðÕé¿^R)~^ò»Þ¨H^G^^4Õ|èQ^TW^]¾LåC·~@±(~DòRÇèX½»¾¿ú.
ÿûÌ©~[(²Q^[Z^?~Y¨Áw^].@^A~Oa\0;I;~B¨°e²
^^ݶß[~^~Lk¡~@~K^UÝ¡b2~@2ÊoÀ^Wîå?^E¹~\^Y^O^\z(a
^N^PGyö.3i~Bw~I¢æ~\\\N~NæÐ~_~N4\{®n~R^D~]~F£~DË~EàYel\\Ø~U*#Ô¥Æf`ò²^N¾×ùi^P
w
®~N±Z~_ù¯·B¯ã^DÊ~R¥~H?~Cȶ|X~S`Uùdö~!àú£w^W~I~N§~T~QL/~D~A3Û~P~I®~V%ÿÔ0»õ^mÖ
Yù^?Éü~GxmMJVÓíé0Q`^S~A~Cá~E+ÜgßîP³áÁØ~IÐ_³qq^CÍ}E×@^F^Es0^]:è
èñ¡ð^UÍ~K1^U=~JÍR@ù¿¡{¦ágc7P?^U?^P7áb^BÞÜ^ZÞYá~C~FÅKk~^æ21C~K*Ø~Y87»^A~U
¥;ø^SL˽ÀÃ~IɶN^WA?×zåÛ^C^NiäܨÆÍ^e~]*úÝwÎM~R_Ò·n¹^A^T±~CJ^_~Vɾj|
^Yø~B~G^Ua^H^T+%7-ÚF/Así!Â0ÑV
^?áÐê~Jö`8^C±¦í^Rf¶^E\~L~N:^EiÄ~O:ê~Ph~O^TCÖD~VÆÑ2P~Kj~]^L·$^Qí^A¯fP~W:þ
÷´Ó¨~Wt^HF l^zÎ^Q¥tís~_|
qGÀíµ\\^D#^H*UN®~D^A2~DL^BÚWU%)T`×g~WæÀç~Y^\±e~T^_^]E~OõC£?Y%vÕAs~_·~QË^XÀC¡
^OB¦^Oç`~T*hÞ^^S^HÞ^_caÚ^[k^QóÓåiCÙ}9t~A¹t^A~J^CcQ¤A^W\4ÅÕ^YÀ~\ì~GKé3ý:^
S¸¢{ç^MQ[Ù^Ay%ü\^G¯ÂS¦^R^S^P~W^TbR͹û~\ÂÎ| E¿Ü`xq^A}åâr~H;^O~[^Z#éÊ8c8e¹|
HÙãe^R^T®ç~~_^[M~WÅ!kp@^^ÜÏ~Ijû²~B^Vµ÷i^ÿ~_$~LŦ^\wnÉ2¥à~F~]Vk*´¡lãå\0ÝÞå~_
^U½3CK1^\Þ¯ß~X~A[^]ßt|NUk~Z58~Jïßþ^HMTêðpõÿ^G~\AþçRtïc\\Ä×á*ÿ}s^\éáÓ~N®w;º
ÙíöôøÛí-mo^_·_÷t^?÷ëçÕê~[õå^_-:^G^W'
I'm starting to run out of ideas...
-steve-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Bug in ORDER BY
I'm glad you found the problem! Sorry my suggestion did not work. I'm still confused on why you have quotes around the field names in the order by part of the query, though. All the best! -steve- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow retrieval of distinct on indexed fields
I grant you that, however my point was about the total count of the indexed word's appearance, which would still stay the same, regardless of the encoding of the position information. Peter ^_^ - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Peter Grigor [EMAIL PROTECTED] Cc: Renars Jeromans [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 11:12 AM Subject: Re: Slow retrieval of distinct on indexed fields In the last episode (Feb 18), Peter Grigor said: I've always thought that adding a count of index entries to the index file would be helpful. Like (generic index entry): word:15:1,2,5,7,etc... where word is the indexed value, 15 is the number of times it appears, and 1,2,5,7 is the record offsets (or byte offsets for dynamic stuff) of the appearances of the indexed value. This way, getting a count of indexed values would be quick, and scanning the index would no longer be necessary, because the count (15) would tell you how many index entries to skip to get the next indexed value in the index. What you describe above is similar to a bitmap index; they trade off a more complicated encoding scheme for extremely fast counts. Storing the record offset is sort of inefficient; that's 4 (8?) bytes per record. If you either store a bitmap of rows that that value occurs in (i.e. 1100101 in your example), or delta record/byte offsets (1,+1,+3,+2,0), and then compress those, you can shrink your indexes to an incredibly small size. Compressed indexes take a lot longer to update, though. See http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:125271:200211:bmokiphdlmibimfl jjkf for a description of how I would implement bitmap indexes in MySQL . -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
This will be my last posting. I don't belive I am being constructive and have no wish to instantly be hated by the whole of MySQL. Michael T. Babcock wrote: Ben Clewett wrote: MySQL say that this is an extension of the application, and therefore breaks the GPL, and therefore a licence is needed. They are however, the only big GPL user who thinks this way. No they're not. The issue is not the use of the server (as previously discussed a few weeks back), but the library. If you use the older library version (which is LGPL'd), you can basically do as you please as you believe you should be able to. As the new library is under the GPL, you can't legally link it to a non-GPL-compatible program at all (without purchasing a different license). What you say is that the API is in my application. The API is part of MySQL. Therefore my application is GPL or needs a licence. Therefore, if I was to use ODBC, I would not be using your API in my application, and could install MySQL under the GPL and use my application without licence? (If I so choose.) You forget that (as someone else pointed out, perhaps Ben) MySQL's Copyright still lies with MySQL AB. You can fork the code and modify and distribute it _under the GPL_ but that doesn't buy you anything -- you don't then have the right to link it against a commercial program or even to relicense it. All you have is a renamed version of MySQL that is still under the GPL. That's not what you're hoping for, is it? This may be true. I am a programmer, not a solicitor. It does seem to fly in the face of Ritchard Stallman's origional idea and intent of the GPL. So your software may be folked, but then not used as it then violates some other law. If that's the case, so be it. I better copyright all my GPL projects ASAP... Many people here are perfectly happy with the GPL, I might add. I license all my MySQL-related code under the GPL. I don't distribute it to anyone, so its not terribly relevant, but its well marked and noted as being either GPL'd or for personal use only (most of which is GPL'd as well). I don't write much commercial, non-GPL code. I write a lot of commercial and GPL'd code though, and so do many other people (like MySQL AB). You might want to consider it too. I wish I had that sort of job I would prefer this option. Unfortunatelly I am a dying breed of employed programmer selling commercial applications. Maybe my own applications will be replaced with a GPL ones. I might even wright them my self. Until then, saving money on erronious licence fees payes for my family to eat. Where, if I may, I would love to leave this Ben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
stuck with converting a query from a sub query
Hi
I am having trouble to convert the following query with a sub query to use
a join, any advice I would be most grateful
Select Distinct portlet.* from portlet, portletAssignment PortletAssignment
where PortletAssignment.Group_FK in ('group1', 'group2')
AND portlet.name not in (
SELECT portlet_fk FROM UserTabAssignment WHERE user_fk = 'guest' AND
portal_FK = 'mysqlPortal' AND tabNumber = 0 AND subtabName =
'firstSubtab')
thanks
Alice Farbles
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need some help accessing unsigned columns from Delphi
I'm trying to write a Delphi program that accesses a MySQL database via
MyODBC. It's going pretty well except for a sticky problem I'm having with
an unsigned integer column.
I have a column named 'IP', type unsigned integer, that will hold IP
addresses. However, Delphi seems to assume this column is a signed integer
column and limit the range accordingly. At least that's my best guess for
what's happening. For example, this code fragment:
IP := $;
Str( IP, IPstring );
tblDigital.FieldByName('IP').AsString := IPstring;
throws an exception saying that 4294967295 is not a valid value for this
field.
Do I have any options other than giving up and using a signed BIGINT field?
--
David Brodbeck, System Administrator
InterClean Equipment, Inc.
Ypsilanti, Michigan
[EMAIL PROTECTED]
(734) 975-2967 x221
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
On Tue 2003-02-18 at 16:11:11 +, [EMAIL PROTECTED] wrote: Benjamin Pflugmann wrote: [...] There is also some middle ground here. Which is the overlap of the two. No. Either the way you distribute your software is GPL-compliant or not. If it is not, you need a commercial license, if it is, you are fine. Forking the source requires it to be still under the GPL, so the license requirements have not changed. MySQL say that this is an extension of the application, and therefore breaks the GPL, and therefore a licence is needed. Okay, you can argue, if MySQL AB's interpretation of the GPL is correct, but this changes nothing. Even if you fork, they will still own the copyright on a major part of the code and can still sue you, if they like (I do not mean to imply that they would be fast to sue). They are however, the only big GPL user who thinks this way. I note for example the number of companies selling commercial CGI software designed to run on Apache, Wrong example. Apache is not licensed under GPL (it's Apache License). to which no licence is mandatory. Also Sendmail, Neither is sendmail.(it's BSD license). GCC, Have not seen many packages that add on GCC. And derived output of GCC is explicitly excluded from being GPL. other DBMS's, Examples? PostgreSQL is not GPL'ed, InterBase neither (I am not sure if that is still current, but last time I looked it was not). and indeed GNU/Linux it's self. That's a valid reference in that Linus Torvald has indeed said that he does not think kernel modules have to be GPL'ed, but then, Linus is not someone who much cares about such issues. [...] Therefore, I can see no reason why not somebody could fork MySQL into FreeSQL. It would take a few hours at SorceForge, a 'sed' of MySQL into FreeSQL', and a good posting to Slashdot. Keep it 100% GPL without breaking either the wording or the spirit of the document. Remove all reference to copyright material belonging to MySQL. It's either GPL or cpryright, not both. No offense meant, but you seem to have a lack of understanding of how the GPL works. It cannot work without copyright. It is based on it. It sounds as if you base your opinion on hearsay. I suggest to read the GPL FAQ http://www.gnu.org/licenses/gpl-faq.html. Or talk to an lawyer if you need. Then use this without commercial licence... BTW, as to another posting. 'Either accept the GPL or purchase a licence'. I do note another option (apart from forking): Use something else. Is MySQL really that good? I do worry that with arrogant statements like this, this is exactly what people will do, in droves. What's the problem? Do use whatever fits best with your need. The point of the statement is that there is no right to have MySQL without cost. You can have it with without cost, if you abide by the GPL. Or else you can buy it. Or you can use something else. Freedom of choice. Although that may sound arrogant, it is not meant this way. It is meant as being realitistic: The people who put a lot of hard work into making MySQL have chosen the GPL. So you should respect that. One could also see it the other way: it sounds kind of arrogant of people trying to tell MySQL AB how they have to license their software. You are free to choose the product of your choice. MySQL AB is free to choose the license(s) of their choice. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: AW: InterBase vs. Mysql
Hi Ben, I feal I am digging my self a grave here, so this will be about my last ever posting... Either that or your mailing administrator will start bouncing my mail I don't think so. You said nothing bad! Just talking about things which perhaps could be better or discuss that would no reason to take you from the list of discussions about MySQL!!! Regards Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InterBase vs. Mysql
Ben Clewett wrote: What you say is that the API is in my application. The API is part of MySQL. Therefore my application is GPL or needs a licence. Please don't confuse API and library. The libmysql or libmysqld libraries are GPL'd. Anything linked against them is automatically also GPL'd (unless licensed otherwise). The API simply describes how to use the library. Therefore, if I was to use ODBC, I would not be using your API in my application, and could install MySQL under the GPL and use my application without licence? (If I so choose.) Technically speaking, if you had an ODBC server and MySQL server installed and connected with an LGPL or BSD or commercial ODBC client to those services and never modified or linked against those services or the mysql library in any way, you'd be clear of the GPL as far as the MySQL library is concerned. Some will argue that, of course, but claiming that connecting over a network port to an ODBC server is somehow linking against that server is pretty tough. That said, ODBC doesn't give you all the features of the library. I better copyright all my GPL projects ASAP... Everything you write _is_ Copyright to you (unless its a work-for-hire, etc.) automatically. Registering those Copyrights is often unnecessary (sign a copy with PGP, E-mail it to someone, have them sign it and store a copy of it; that'll pretty much prove you wrote it for many cases). Maybe my own applications will be replaced with a GPL ones. I might even wright them my self. Until then, saving money on erronious licence fees payes for my family to eat. I might add that I believe most of the MySQL AB programmers' families do in fact eat. They're paid. As are the programmers for ReiserFS (also GPL'd). These types of business models are different, but not unprofitable. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
License question
My company develops commercial project which is close to well know ICQ but has slightly different appliance. Can I use MYSQL for storing list of users, collecting some statistics, logs and other related information or I have to buy license? __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: stuck with converting a query from a sub query
Hi, you may try:
SELECT DISTINCT portlet.*
FROM portletAssignment PortletAssignment,
portlet LEFT JOIN UserTabAssignment UTA
ON (portlet.name=UTA.portlet_fk AND UTA.user_fk = 'guest' AND
UTA.portal_FK = 'mysqlPortal' AND UTA.tabNumber = 0 AND
UTA.subtabName = 'firstSubtab')
WHERE PortletAssignment.Group_FK in ('group1', 'group2')
AND UTA.portlet_fk IS NULL
Remember that your query (and also this) may have a problem because
there is no relation between portletAssignment and portlet (you didn't
specify any join, so i couldn't use one).
On Tue, 2003-02-18 at 17:11, Alice Farbles wrote:
Hi,
I am having trouble to convert the following query with a sub query to use
a join, any advice I would be most grateful
Select Distinct portlet.* from portlet, portletAssignment PortletAssignment
where PortletAssignment.Group_FK in ('group1', 'group2')
AND portlet.name not in (
SELECT portlet_fk FROM UserTabAssignment WHERE user_fk = 'guest' AND
portal_FK = 'mysqlPortal' AND tabNumber = 0 AND subtabName =
'firstSubtab')
thanks
Alice Farbles
--
Diana Soares
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C API Changes?
Are there any (significant) changes in the C API between MySQL 3.X and 4.X? If so, where are they located. mail-filter: sql,query,queries,smallint -- Amy and Joseph Kormann - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: InterBase vs. Mysql
You can require GPL components without having to distribute them. That way you don't have to support them, either. Curtis Ben Clewett said: Okay... BTW, I have cleared purchacing licences with my own people, and we do not have a problem. Neither do I not like MySQL, I do. The licence model you have supports a model similar to that of Oricle. Large, small quantity, expensive products. We are at the opposite end. Small low cost products which are Shareware, or low cost. (Even Shareware needs a MySQL Licence.) In this case the MySQL licence is up to 200% of the cost of the product. You say it's cheep... It is for one. I need hundreds/thousands. The licences also cannot be purchaced without an expensive support contract. You gues are too good, I don't need one :) To be fare, you do discounts for low cost software. But if only $10 on 5000 products is still the difference between hiring, or firing, a programmer. Is this case, you can say, 'Well, f*** off then', and we will. But there are a lot more small companies than large ones. There may be a time when one too many companies are using, say, SapDB, and MySQL becomes a backwater... The MS model is not the same as everybody has this and paid for it, often without evern knowing it. Even if, like me, I wipe it and install something else. I feal I am digging my self a grave here, so this will be about my last ever posting... Either that or your mailing administrator will start bouncing my mail Ben Rusch (ext) Reiner wrote: Hi Ben, I'm not sure what you really want to sell. If you have to take a license from MySQL because of a commercial use, you just have to take ONE license. Correct me, if I'm wrong! If you want to sell your programs etc. which uses MySQL then see it in another way: Firstly MySQL isn't very expensive in my opinion. If your client wants to buy your programs then he has to buy a license (when his way is a commercial one). So this would be a must that your client has to take. But, if you would sell programs based on Microsoft Windows, what would be the difference? None! Your client would need to have a valid license on this OS! But would you say, Microsofts Windows (for example!) would be bad just because it's difficult to tell your client that he NEED'S windows to run your work? NO, you wouldn't! Perhaps because everyone has windows. But why to think in another way about MySQL? I think this isn't fair!!! Regards, Reiner - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
reserved or key words as database object names.
Hi, I need to create a table named Case, but MySQL is rejecting it, may be because it is a reserved word. I understand that I can change the name to something sensible. Is there still a way to create a table with such names, for example, by enclosing them in double quotes. I would like to use such names for compatibility reasons with other database we are currently using. Thanks, Raju - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: reserved or key words as database object names.
In the last episode (Feb 18), Ayyapraju Ganapathiraju said: I need to create a table named Case, but MySQL is rejecting it, may be because it is a reserved word. I understand that I can change the name to something sensible. Is there still a way to create a table with such names, for example, by enclosing them in double quotes. I would like to use such names for compatibility reasons with other database we are currently using. You can quote reserved words by enclosing them in backtics: `Case` -- Dan Nelson [EMAIL PROTECTED] sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Printing out tables...tip
Since my original posting, asking how to: print out tables in mysql via out put to a printer. Thanks to all that responded, big thanks to Edward! Here is the tip for all Mac users, running 10.2.x and mysql. goto: http://localhost:631/ ( this program is built-in on 10.2 ) its called CUPS, goto manage printers, and see what name is given for your printer. ( write it down ) in mine, its: _192_168_0_11 Next; lets say you db is call Contacts, and you have a table in contacts call phone this first thing is do the following: mysql \P lpr -P _192_168_0_11 (Hit Enter) PAGER set to lpr -P _192_168_0_11 mysql select * from phone; 6 row in set (0.08 sec) mysql \n It sends output to the screen again. Use it when you want to stop sending all of that output to the printer. -- Happy printing, Richard- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: reserved or key words as database object names.
Excellent, Thanks a lot. It worked. - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Ayyapraju Ganapathiraju [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 1:37 PM Subject: Re: reserved or key words as database object names. In the last episode (Feb 18), Ayyapraju Ganapathiraju said: I need to create a table named Case, but MySQL is rejecting it, may be because it is a reserved word. I understand that I can change the name to something sensible. Is there still a way to create a table with such names, for example, by enclosing them in double quotes. I would like to use such names for compatibility reasons with other database we are currently using. You can quote reserved words by enclosing them in backtics: `Case` -- Dan Nelson [EMAIL PROTECTED] sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
% does not match the mysql host in mysql.user table
Description: The % character in the Host field of the mysql.user table does not seem to match the host on which mysqld is running. How-To-Repeat: GRANT USAGE ON *.* TO user@'%' mysql -u user -h machine.apple.com (from machine.apple.com) Fix: GRANT USAGE ON *.* TO [EMAIL PROTECTED] Submitter-Id: submitter ID Originator: Organization: Apple MySQL support: none Synopsis: % does not match the mysql host in mysql.user table Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.54 (Source distribution) Environment: System: Darwin dzone200.apple.com 6.4 Darwin Kernel Version 6.4: Wed Jan 29 18:50:42 PST 2003; root:xnu/xnu-344.26.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Feb 14 16:49 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure '--prefix=/usr/local/simonSaysMySQL/' '--with-innodb' '--enable-thread-safe-client' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Various replication problems with 4.0.10-gamma
On Tuesday 18 February 2003 15:36, Harald Fuchs wrote: In article [EMAIL PROTECTED], John Taylor [EMAIL PROTECTED] writes: I get the error: ERROR 1227: Access denied. You need the REPLICATION SLAVE privilege for this operation I've tried setting the grants again, but it doesn't seem to make any difference: mysql GRANT REPLICATION SLAVE,RELOAD,SUPER ON *.* TO myuser@myhost IDENTIFIED BY 'mypass' mysql show grants for myuser@myhost; ++ | Grants for myuser@myhost | ++ | GRANT RELOAD ON *.* TO 'myuser'@'myhost' IDENTIFIED BY PASSWORD 'asdadadasdadasas' | ++ 1 row in set (0.00 sec) Whats going on here ? Perhaps you forgot to run mysql_fix_privilege_tables? That was it - thanks. Replication now seems to be running, but the tables are not being updated on the slave. I can see the updates arriving in the relay log, but they don't get added to the database. There are no errors in the log Processlist looks OK to me ... mysql show full processlist; ++-+---+--+-+---+--+---+ | Id | User| Host | db | Command | Time | State || Info | ++-+---+--+-+---+--+---+ | 1 | system user | none | NULL | Connect | 11609 | Reading master update || NULL | | 2 | system user | none | NULL | Connect | 11609 | Slave: waiting for |binlog update | NULL | | 5 | root| localhost | vpopmail | Query | 0 | NULL || show full processlist | ++-+---+--+-+---+--+---+ 3 rows in set (0.00 sec) and the slave staus looks OK too ... mysql show slave status; +---+-+-+---+-+-++---+---+--+---+-+-+++--+-+-+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File || Read_Master_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Master_Log_File | |Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | |Last_errno | Last_error | Skip_counter | Exec_master_log_pos | Relay_log_space | +---+-+-+---+-+-++---+---+--+---+-+-+++--+-+-+ | mymaster | myuser | 3306| 60| mysqld.013 || 516424 | loki-relay-bin.003 | 381962| mysqld.012| |Yes | Yes | | | 0 ||| 0| 516424 | 381966 | +---+-+-+---+-+-++---+---+--+---+-+-+++--+-+-+ 1 row in set (0.00 sec) The permissions on the database directory and files are rwx-- mysql:mysql Is here anything else that I can check for ? I have only taken a snapshot and copied one of the databases so far - could that be the problem ? Thanks JohnT - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Connector/J 3.0.6 STABLE Has Been Released
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 3.0.6 a new version of the Type-IV all-Java JDBC driver for MySQL has been released. It is now available in source and binary form from the Connector/J download pages at http://www.mysql.com/downloads/api-jdbc-stable.html and mirror sites. Note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site. This is the first STABLE release for the feature set that has been frozen for version 3.0 of Connector/J. Version 3.0.6 has reached a level of stability that is appropriate for production use. From the changelog: * Fixed ResultSetMetaData to return when catalog not known. Fixes NullPointerExceptions with Sun's CachedRowSet. * Fixed DBMD.getTypeInfo() and DBMD.getColumns() returning different value for precision in TEXT/BLOB types. * Allow ignoring of warning for 'non transactional tables' during rollback (compliance/usability) by setting 'ignoreNonTxTables' property to 'true'. * Fixed SQLExceptions getting swallowed on initial connect. * Fixed Statement.setMaxRows() to stop sending 'LIMIT' type queries when not needed (performance). * Clean up Statement query/method mismatch tests (i.e. INSERT not allowed with .executeQuery()). * More checks added in ResultSet traversal method to catch when in closed state. * Fixed ResultSetMetaData.isWritable() to return correct value. * Add 'window' of different NULL sorting behavior to DBMD.nullsAreSortedAtStart (4.0.2 to 4.0.10, true, otherwise, no). * Implemented Blob.setBytes(). You still need to pass the resultant Blob back into an updatable ResultSet or PreparedStatement to persist the changes, as MySQL does not support 'locators'. * Backported 4.1 charset field info changes from Connector/J 3.1 Have fun with it! -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+UpHqtvXNTca6JD8RAjNLAKCGAF2+6R0UzgblEr4G482iUYlOxwCdHP9j FZFNo7Yk/S/lr7M241QLkYM= =2MpI -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Connector/J 3.1.0 ALPHA Has Been Released
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 3.1.0 a new version of the Type-IV all-Java JDBC driver for MySQL has been released. It is now available in source and binary form from the Connector/J download pages at http://www.mysql.com/downloads/api-jdbc-dev.html and mirror sites. Note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site. This is an ALPHA release for the feature set that is in line with the features MySQL-4.1 is offering, including Unicode character sets and server-side prepared statements. From the changelog: * Added 'requireSSL' property. * Added 'useServerPrepStmts' property (default 'false'). The driver will use server-side prepared statements when the server version supports them (4.1 and newer) when this property is set to 'true'. It is currently set to 'false' by default until all bind/fetch functionality has been implemented. Currently only DML prepared statements are implemented for 4.1 server-side prepared statements. * Track open Statements, close all when Connection.close() is called (JDBC compliance). Have fun with it! -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+UpJqtvXNTca6JD8RAs6BAJ92gLQCwv3IaZdD7CqS9j38ykBCFQCeL6/e 5jLINCBQz8y6HT2wsYQG06Q= =fGwb -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Creating Tab Delimited Textfile to Load Data Into MySQL Table
I'm just starting out, doing tutorials and exercises up the wazoo, trying to learn MySQL and PHP. I've created a table in a test database. When I do a DESCRIBE [table_name], the columns come up just as they should. Populating them with data's another story. I've created a textfile in a text editor. The first row is the column heads; succeeding rows are actual data. The entries in a row are separated by a single tab; at the end of a row, I'm hitting RETURN. I entered twelve rows of data. The book I'm working from shows NULL as some entries; and the last column, shows a timestamp in each cell of that last column. I typed NULL every time my sample showed it and all fourteen digits of each timestamp entry. So far, so good? Back in MySQL, at the prompt, I entered: load data local infile ' and then I dragged the textfile into the Terminal window. I was greeted with: Query OK, 1 row affected (0.44 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 3 Question: Where do I find these Warnings named and detailed? When I do a SELECT * FROM [table_name], the column heads appear just fine, where and as they should. But there's only a single row of data, when I typed in twelve rows in the textfile. Also, that one row of data is all wrong. Only the first column, entitled userid is correct, the number 1. The other entries merely parrot the column heads, and they're off by one, with the second and third in the second column, and all entries incorrectly moved one column to the left. The last column, which is where the timestamp should go, contains a batch of zeros. What do I need to do to fix this? Thank you. Steve Tiano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Quick License Question...
Quick question about the license issue that I thought of while reading through the Interbase Vs. MySQL threads. If I develop a program that uses MySQL for my company and it is only used for internal use, never repacked and sold/distributed outside the company what type of license aggrement is that under? This project would have code that would obviously be 'sensitive' information for the company so Open Source would be out the question, but as this would never be re-distributed am I right in thinking we do not need to buy a license aggrement from MySQL? I was reading throuhg the manual in the license section and noticed they said it would be 'nice' that if MySQL was helping your enterprise then you should at least buy some support from them. However, I am comfortable enough with MySQL and its use is VERY light weight that it would be pretty silly to buy support from them. Not saying anything against the MySQL team, but they did make the product fairly easy to work with :) Thanks for any info on these questions! -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creating Tab Delimited Textfile to Load Data Into MySQL Table
Stephen Tiano wrote: I'm just starting out, doing tutorials and exercises up the wazoo, trying to learn MySQL and PHP. I've created a table in a test database. When I do a DESCRIBE [table_name], the columns come up just as they should. Populating them with data's another story. I've created a textfile in a text editor. The first row is the column heads; Why? succeeding rows are actual data. The entries in a row are separated by a single tab; at the end of a row, I'm hitting RETURN. Did you specify that lines be terminated by '\r' ? I entered twelve rows of data. The book I'm working from shows NULL as some entries; and the last column, shows a timestamp in each cell of that last column. I typed NULL I believe that should be \N every time my sample showed it and all fourteen digits of each timestamp entry. So far, so good? Back in MySQL, at the prompt, I entered: load data local infile ' and then I dragged the textfile into the Terminal window. I was greeted with: Query OK, 1 row affected (0.44 sec) Records: 1 Deleted: 0 Skipped: 0 Warnings: 3 Question: Where do I find these Warnings named and detailed? You have only one record, because you have only 1 line. RETURN is not the default line terminator. You can't see the warnings. When I do a SELECT * FROM [table_name], the column heads appear just fine, where and as they should. But there's only a single row of data, when I typed in twelve rows in the textfile. Also, that one row of data is all wrong. Only the first column, entitled userid is correct, the number 1. The other entries merely parrot the column heads, and they're off by one, with the second and third in the second column, and all entries incorrectly moved one column to the left. The last column, which is where the timestamp should go, contains a batch of zeros. What do I need to do to fix this? Fix your input file, and use the right options for the load data command. Posting bothe would have helped. Thank you. Steve Tiano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C API Changes?
--- Amy Joseph Kormann [EMAIL PROTECTED] wrote: Are there any (significant) changes in the C API between MySQL 3.X and 4.X? If so, where are they located. Yes.Are some changes between ver 3.x and 4.x.If i understand well i think you try to find where this changes are declared/prototype?...on h files. Regards, Gelu mail-filter: sql,query,queries,smallint -- Amy and Joseph Kormann .- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Different value from same function
Weird problem here running 3.23.55-Max. I'm (still) trying to get my IP address DB working, but have run into a problem. When I use the inet_aton function during an insert, I get a very different value than if I use the function by itself on the CLI. Please see below. The IP address I am trying to use is 172.20.20.2. When I run select inet_aton(172.20.20.2) on the CLI, I get 2886996994, which is the correct value; when I run the same function during an insert, I get 2147483647, which is not correct. Any thoughts on this one? I'm stumped. mysql describe host; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | name | varchar(20) | | PRI | | | | ip | int(4) | | | 0 | | | admin | varchar(30) | | | | | | subnet | varchar(20) | | | | | ++-+--+-+-+---+ 4 rows in set (0.01 sec) mysql insert into host values ( - Test1, - inet_aton(172.20.20.2), - Pixies, - Elive - ); Query OK, 1 row affected (0.00 sec) mysql select * from host; ++++--+ | name | ip | admin | subnet | ++++--+ | Test1 | 2147483647 | admin1 | sub1 | ++++--+ 1 row in set (0.01 sec) mysql select inet_ntoa(2147483647); +---+ | inet_ntoa(2147483647) | +---+ | 127.255.255.255 | +---+ 1 row in set (0.00 sec) mysql select inet_aton(172.20.20.2); +--+ | inet_aton(172.20.20.2) | +--+ | 2886996994 | +--+ 1 row in set (0.00 sec) -- Aaron Conaway Network Engineer III Verisign, Inc. -- Telecom Services Division http://www.verisign.com Office: 912.527.4343 Fax: 912.527.4014 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Limits and order bys
Sort them yourself after retrieving them. Rob wrote: I have a question regarding the use of LIMIT with ORDER BY. My problem is as follows: I want my users to be able to pageanate through result sets, so I've written some code that will display the results of a query 15 rows at a time in a HTML table. The next set of results can be accessed by pressing the next button and ditto for the previous set. The query is SELECT name FROM documents LIMIT 10, 15 I want to further extend this functionality by allowing the users to click on the column name (in the table header) and then sort the current set of results from by the chosen column. So lets say I had the following mysql SELECT name FROM documents LIMIT 2, 4; +---+ | name | +---+ | Visual Patterns Intellectual Property.doc | | footer.jpg| | getHWSerialNumber.txt | | env.php.txt | +---+ Now, I want to order by name. So I should get +---+ | name | +---+ | env.php.txt | | footer.jpg| | getHWSerialNumber.txt | | Visual Patterns Intellectual Property.doc | +---+ But, when I apply the following query mysql SELECT name FROM documents ORDER BY name ASC LIMIT 2, 4; I get +---+ | name | +---+ | env.php.txt | | footer.jpg| | getHWSerialNumber.txt | | Ideas.doc | +---+ I can only assume that MySql is ordering by name before limiting the result set. Obviously I want the reverse. Any ideas? Thanks --- Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Feature Request: Return AUTO_INCREMENT on INSERT
How about this: mysql CREATE TABLE tablename (value1 int(10) AUTO_INCREMENT, value2 timestamp(14), PRIMARY KEY (value1)); Query OK, 0 rows affected (0.00 sec) mysql INSERT SQL_RETURN_INSERT_ID INTO tablename (value1, value2) VALUES (0, NOW()); +-+ | INSERT_ID() | +-+ | 1 | +-+ 1 row in set (0.01 sec) mysql INSERT SQL_RETURN_INSERT_ID INTO tablename (value1, value2) VALUES (0, NOW()), (0, NOW()); +-+ | INSERT_ID() | +-+ | 2 | | 3 | +-+ 2 rows in set (0.01 sec) I'd just *love* it if inserting and retrieving the auto_increment value was atomic. Thoughts? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Different value from same function
Your INT in your table is a signed INT, which is going to have a maximum value of 2^31, thus your IP address is causing the field to roll over. You need to change your IP column to UNSIGNED INT. That should solve your problem. j- k- On Tuesday 18 February 2003 12:33, Aaron Conaway wrote: ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ mysql -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
