Re: account that can only do backup

Hi, File Privilege will do that. But the FILE privilege can only be granted globally (using ON *.* syntax).Therefore, attempts to restrict it to a particular scope will lead to error. so try with grant file on*.* to 'user'@'localhost'; Hope this will do. Thanks ViSolve DB Team - Original

Re: system : Install Mysql 5.x binaries with php4 on Debian

On 13 Dec 2006 at 18:59, Gilles MISSONNIER wrote: Hello, I use Debian Linux, and I could install (with apt-get install) fine the Mysql-4.1+apache+php4. I tried fine Mysql 5. on the same debian machine. Now I want to use mysql 5. through web/php4 Then I run into problem, like :

ANN: SQL Maestro 6.12 released

Hi! SQL Maestro Group is happy to announce a new version of our powerful GUI solution for MySQL server administration and database development. http://www.sqlmaestro.com/products/mysql/maestro/download/ Also we're happy to grant you a time-limited 25% discount on all our products and

Re: definition of Created_tmp_files in show status

Thanks for that. Is the only reason for temporary files then going to be replication? And if so, should I be worried that thousands of files have been created for this purpose? Are you saying that I can tune the size (and thus the number) of the temp files by adjusting the temporary table

How to combine mysql structures?

Hi! I have several tables in my database. I have optimized the structures but i did that in an other database so that nothing went wrong. Okay how do i combine those structures now? Like making a dump of both structures and merge them somehow and then redump it back into the system and the

Workaround for distinct?

+++ | id | color | +++ | 1 | red| | 2 | blue | | 3 | red| | 4 | yellow | | 5 | yellow | | 6 | blue | | .. | ...| I'm trying to select 5 random records, but no more than 1 of any given color. According to the notes in the documentation and to my

Re: Workaround for distinct?

I tried this out this morning on MySQL 5. It works. Please try this in MySQL 4 and see. drop table if exists color_table; create table color_table (id int not null auto_increment,color varchar(10),primary key (id)); -- -- Loading Color Data -- insert into color_table (color) values

Re: Workaround for distinct?

I tried this out this morning on MySQL 5. It works. Please try this in MySQL 4 and see. Unless I'm way off, I do not believe your solution will work in 4.x because it doesn't support sub-queries... thnx, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Workaround for distinct?

On Thu, 14 Dec 2006, Chris Boget wrote: =I tried this out this morning on MySQL 5. = It works. Please try this in MySQL 4 and see. = =Unless I'm way off, I do not believe your solution will work in 4.x because =it doesn't support sub-queries... = 4.1 does. See

RE: MySQL 5.0.27: character problem

I have run into this as well. Windows uses CP-1522 (if I remember correctly), which is not exactly equivalent to UTF-8. I presume it is also not exactly equivalent to the character set you're using for MySQL. I wound up writing a program to convert the one character set to the other. Regards,

Re: Workaround for distinct?

Here onoe that should work. It only uses a LEFT JOIN It does not use Subqueries It does not use DISTINCT Here it is : select min(A.id) id,A.color from color_table A left join color_table B on A.color=B.color and A.idB.id group by A.color order by rand(); Give it a Try !!! - Original

Re: Workaround for distinct?

Thanks, but the table structure that I have to work with cannot be changed. Any solution with the simple table I listed? On Dec 14, 2006, at 9:30 AM, Rolando Edwards wrote: Here onoe that should work. It only uses a LEFT JOIN It does not use Subqueries It does not use DISTINCT Here it is :

Re: Workaround for distinct?

This works also select min(A.id) id,A.color from color_table A left join color_table B on A.color=B.color group by A.color order by rand(); - Original Message - From: Rolando Edwards [EMAIL PROTECTED] To: Dwalu Z. Khasu [EMAIL PROTECTED] Cc: Brian Dunning [EMAIL PROTECTED],

Re: MySQL 5.0.27: character problem

Thanks for the reply, Mr Schwartz. I will see if I can find some clue on how to write such a program myself. - Eric Jerry Schwartz skrev: I have run into this as well. Windows uses CP-1522 (if I remember correctly), which is not exactly equivalent to UTF-8. I presume it is also not exactly

Re: Workaround for distinct?

I think got it now !!! If you run this query multiple times, you will get a list of colors all the colors and corresponding IDs ordered by Color, and randomly ordered within color. Here is the query: select AAA.color,AAA.bid id from (select AA.color,AA.id,AA.bid from (select min(A.id) id,B.id

RE: MySQL 5.0.27: character problem

I did it in PHP, using the iconv() function. I do batches, with the CP1252 (my original message was wrong) files named *.orig. I am doing this to build web pages, but I think it might serve your purpose with minor modifications. Note that the PHP folks warned me that PHP is not really UTF-8 safe!

mysql v5 math a bit out. How do I round the info to become correct

I am running a small procedure for set jobs that calculates a running total for me to display. It works fine in most cases but the math concerns me. I am using 5.0.18 on my Windows PC and the latest 5.x on my Linux server (both test machines). The finance table is an InnoDb table. CreditAmount and

Re: mysql v5 math a bit out. How do I round the info to become correct

For exact calculations, you need to use the DECIMAL data type. See this section in the manual for the reasons why: http://dev.mysql.com/doc/refman/5.1/en/precision-math-examples.html Cheers, Jay Kerry Frater wrote: I am running a small procedure for set jobs that calculates a running total

Where to get Source Distribution of MySQL Server 5.0 Standard for FreeBSD?

Hi Where one can find Source Distribution of MySQL Server 5.0 Standard for FreeBSD? -- Thanks! BR / vj

Re: MySQL 5.0.27: character problem

Here's what I get when I perform mysql show variables like char%; +--+-+ | Variable_name| Value | +--+-+ | character_set_client | latin1

RE: MySQL 5.0.27: character problem

I'm not sure you haven't got it backwards. I don't really know what character_set_system means, unless it is the character set that the server uses to create file names or some such. The real question is, what does your query-creating editor speak? As I said, I get very confused. When I figured

Re: Where to get Source Distribution of MySQL Server 5.0 Standard for FreeBSD?

VeeJay wrote: Hi Where one can find Source Distribution of MySQL Server 5.0 Standard for FreeBSD? Not on the website, that's for sure. Have you tried the usual warez sites, p2p networks, etc? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW,

Re: MySQL 5.0.27: character problem

Thanks for the help, Jerry, I think I solved it. I opened the script (a standard windows text file) in UltraEdit. It can convert between some different text formats. After some experimenting it seems that selecting the conversion ansi-to-oem does the trick! It's now inserted properly into

Re: Where to get Source Distribution of MySQL Server 5.0 Standard for FreeBSD?

Daniel Kasak wrote: VeeJay wrote: Hi Where one can find Source Distribution of MySQL Server 5.0 Standard for FreeBSD? Not on the website, that's for sure. Have you tried the usual warez sites, p2p networks, etc? Actually the source tarball IS on the mysql download site. -- One day at

Re: Where to get Source Distribution of MySQL Server 5.0 Standard for FreeBSD?

On Thursday 14 December 2006 14:37, Bruce Ferrell wrote: Where one can find Source Distribution of MySQL Server 5.0 Standard for FreeBSD? Not on the website, that's for sure. Have you tried the usual warez sites, p2p networks, etc? Actually the source tarball IS on the mysql download

Re: Where to get Source Distribution of MySQL Server 5.0 Standard for FreeBSD?

Daniel Kasak wrote: VeeJay wrote: Where one can find Source Distribution of MySQL Server 5.0 Standard for FreeBSD? Not on the website, that's for sure. Have you tried the usual warez sites, p2p networks, etc? Really? Seems pretty straightforward to me. One the downloads page, under the

RE: mysql v5 math a bit out. How do I round the info to become correct

Thanks for the reference Jay. Most helpful. Kerry -Original Message- From: Jay Pipes [mailto:[EMAIL PROTECTED] Sent: 14 December 2006 20:29 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: mysql v5 math a bit out. How do I round the info to become correct For exact

Start at a number to find next available number

I have this perl mysql statement below that finds the next available number that's not in two table, and it works find. But what if I wanted to find the next available number starting at 100 or 1000, how would I introduce that in this code? my $sth = $dbh-prepare( SELECT MIN(allnum) FROM

Re: definition of Created_tmp_files in show status

Hi, Since, these files disappear at the end of the session, for good performance, better keep tmp_table_size smaller, so we can eliminate populating in-memory tables, and make use of disk. The temporary table size is not only determined by tmp_table_size but also by max_heap_table_size

Strange table problem

Hi everybody, I have a very strange table problem - a table was created in one of our databases, but I can't seem to drop it. I tried with phpmyadmin and with mysql from command-line. If I try to view it I receive this error: View 'product_beta.test' references invalid table(s) or

Re: MySQL 5.0.27: character problem

Eric, I think that you don't have to write a conversion program because MySQL have built-in pretty good character set conversions. All you need to do is to tell MySQL which character set uses your file with your SQL commands. Create your file with one of the character sets MySQL