SELECT ascending incremental values

I'm doing a top 10 list from a database based on a group by and order by, something like select UserId, count(*) as NumActions from Actions group by UserId order by NumActions desc limit 10; Is there any way to put a separate column so I get results like Rank, UserId, NumActions 1, 123, 43 2,

Re: SELECT ascending incremental values

Hi Waynn, Try: SET @row := 0; SELECT @row := @row + 1 AS Rank, UserId, count(*) as NumActions from Actions group by UserId order by NumActions desc limit 10; HTH, Cor - Original Message - From: Waynn Lue [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, February 22,

Migrating form 3.23.49 to 5.0.32

I'm doing the above migration as mentioned in the subject line. I figured I would use the MySQL Migration Toolkit to help it along but it won't let me connect to my 3.23.49 server. Is there any other way to migrate all my data easily. Thanks, Ed -- MySQL General Mailing List For list

Re: Migrating form 3.23.49 to 5.0.32

On Fri, February 22, 2008 10:01, Ed Curtis wrote: I'm doing the above migration as mentioned in the subject line. I figured I would use the MySQL Migration Toolkit to help it along but it won't let me connect to my 3.23.49 server. Is there any other way to migrate all my data easily. Thanks,

Re: Migrating form 3.23.49 to 5.0.32

In the last episode (Feb 22), Ed Curtis said: I'm doing the above migration as mentioned in the subject line. I figured I would use the MySQL Migration Toolkit to help it along but it won't let me connect to my 3.23.49 server. Is there any other way to migrate all my data easily. Basically

mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

So I am trying to use mysqldump --tab for the first time. I am running into the same problem everybody does on their first try --- Errcode: 13. I have set the permissions on the target directory to be completely liberal --- anybody can do anything with it --- and I still get Errcode: 13. I

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

Mike Spreitzer wrote: So I am trying to use mysqldump --tab for the first time. I am running into the same problem everybody does on their first try --- Errcode: 13. I have set the permissions on the target directory to be completely liberal --- anybody can do anything with it --- and I still

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

I am running MySQL 5.0.51a-community on RedHat Enterprise Linux 4. Here is a further typescript showing the failure: [EMAIL PROTECTED] /]# mysqldump -u root -p --skip-opt --quick --tab=/dump1 wyky red1_p2 Enter password: mysqldump: Got error: 1: Can't create/write to file '/dump1/red1_p2.txt'

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

what happens when you delete the files that are already in there? Looks like you're dumping to a file owned by root. Jed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Move couple files to another directory/hard drive

Hi. I have extra hdd only for mysql /var/lib/mysql directory. I have one big database and ten different tables into it. I had to move three of them into another directory on different hdd becouse lack of disk space at /var/lib/mysql directory. Is it possible and how can I do that ? Regards. --

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

Sorry if I have confused people by presenting evidence in the wrong order. Also, it seems that the .sql file is written by the client while the .txt file is (attempted to be) written by the server. Here is a single typescript with all the evidence: [EMAIL PROTECTED] ~]# cd / [EMAIL

Re: Move couple files to another directory/hard drive

Grzegorz Paszka wrote: Hi. I have extra hdd only for mysql /var/lib/mysql directory. I have one big database and ten different tables into it. I had to move three of them into another directory on different hdd becouse lack of disk space at /var/lib/mysql directory. Is it possible and how can I

Re: mysqldump: Got error: 1: Can't create/write to file 'dumpdir/tablename.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE'

Mike Spreitzer wrote: Sorry if I have confused people by presenting evidence in the wrong order. Also, it seems that the .sql file is written by the client while the .txt file is (attempted to be) written by the server. Here is a single typescript with all the evidence: [EMAIL PROTECTED]