RE: DB/table problem

Hi Todd, I didn't mention xtrabackup because I have no experience with it =) I know the other methods work, and honestly, for most mysql users just starting out, it's easier to use mysqldump. It's simple, and it's easy to get help with, and it works across storage engines. Regards, Gavin Tow

RE: DB/table problem

No, the .frm files don't contain data. They are only the table structure. You should always test your backup and restore procedure nefore you need to use it. Regards, Gavin Towey From: Néstor [mailto:rot...@gmail.com] Sent: Thursday, September 10, 2009 4:35 PM To: Gavin Towey Cc: mysql@lists.m

Re: Natural join problem

Thanks. That worked. Jason Trebilcock wrote: Methinx you need a "GROUP BY" in there. See below. -Original Message- From: John Meyer [mailto:john.l.me...@gmail.com] Sent: Thursday, September 10, 2009 6:48 PM To: mysql@lists.mysql.com Subject: Natural join problem Two tables: USER

RE: Natural join problem

Methinx you need a "GROUP BY" in there. See below. > -Original Message- > From: John Meyer [mailto:john.l.me...@gmail.com] > Sent: Thursday, September 10, 2009 6:48 PM > To: mysql@lists.mysql.com > Subject: Natural join problem > > Two tables: > > USERS: > USER_ID (PK) > . . .etc > > T

Natural join problem

Two tables: USERS: USER_ID (PK) . . .etc TWEETS: TWEET_ID (PK) USER_ID (FK) Trying to get the user information and the number of tweets each person has: SELECT USERS.USER_NAME, COUNT(TWEETS.TWEET_ID) AS 'TWEETCOUNT' FROM TWEETS NATURAL JOIN USERS; But it seems to be just rolling up all the

Re: DB/table problem

OK, All I have then is a bunch of .frm files. Can I recover the data from the FRM files if I install mysql 5.0 without INNODB? Thanks, On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey wrote: > When using innodb, your data is stored in the data/ibdata* files. Copying > the database directory is

Re: DB/table problem

On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey wrote: > When using innodb, your data is stored in the data/ibdata* files.  Copying > the database directory is not a valid backup. > > In the future, I would suggest using mysqldump.  However if you want to make > a file-system copy backup with innod

RE: DB/table problem

When using innodb, your data is stored in the data/ibdata* files. Copying the database directory is not a valid backup. In the future, I would suggest using mysqldump. However if you want to make a file-system copy backup with innodb you need to 1. Shutdown the server 2. Copy *everything* in

Is myisam_repair_threads considered safe

myisam_repair_threads "If this value is greater than 1, MyISAM table indexes are created in parallel (each index in its own thread) during the Repair by sorting process. The default value is 1. Note :Multi-threaded repair is still beta-quality code." The note is present is all versions of MySQL

DB/table problem

I am running mysql 5.0 on a windows 2003 host with php and apache I am trying to restore a database from 08/28/2009. The backup is done by windows and all I do is copy the "data/scroller612" folder to the DATA folder in the MYSQL directory. when I restore/copy it I get the following errors my .e

Re: how to query this

This can also help: select id,value from table order by value desc limit 1; Cheers Claudio 2009/9/10 Slackli User > Thanks all the info. > Just got what I wanted. > > 2009/9/10 Wolfgang Schaefer : > > John Daisley schrieb: > >> SELECT MAX(value), id FROM table > >> GROUP BY id; > >> > >> >

Re: how to query this

Thanks all the info. Just got what I wanted. 2009/9/10 Wolfgang Schaefer : > John Daisley schrieb: >> SELECT MAX(value), id FROM table >> GROUP BY id; >> >> >> > > I guess what Slackli had in mind was more something like this: > SELECT id, value > FROM table > WHERE value = (SELECT max(value) FROM

Re: how to query this

John Daisley schrieb: > SELECT MAX(value), id FROM table > GROUP BY id; > > Regards > > John Daisley > Mobile +44(0)7812 451238 > Email j...@butterflysystems.co.uk > > Certified MySQL 5 Database Administrator (CMDBA) > Certified MySQL 5 Developer > Cognos BI Developer > > --- >

Re: MyQuery 3.1 Beta Released

For those of you who downloaded 3.1, there was a slight bug in that, that should not cause any big operational problems, but it could cause a crash. So I have released a bugfixed version 3.1.1, available for download on Sourceforge, just like before. http://sourceforge.net/projects/myquery/ B

RE: how to query this

SELECT MAX(value), id FROM table GROUP BY id; Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI Developer --- Sent from HP IPAQ mobile device. -Origina

MySQL University session on September 10: Customizing MySQL Enterprise Monitor

Customizing MySQL Enterprise Monitor http://forge.mysql.com/wiki/Customizing_MySQL_Enterprise_Monitor Today (September 10, 13:00), Mark Leith will show how to customize the MySQL Enterprise Monitor: Customizing MySQL Enterprise Monitor. Mark is a MySQL support manager, and knows Enterprise Monitor

how to query this

Hello, sorry I'm not good at SQL statement. I have a table, whose stru is like: idvalue 1 33 2 987 3 10 4 22 ... I want to get the max value and the corresponding id, using this sql: select max(value),id from table; but it won't work. so what's the

MyQuery 3.1 Beta Released

MyQuery 3.1 is now ready for download from Sourceforge: http://sourceforge.net/projects/myquery/ The features of this release includes, but is not limited to: - UTF-8 support - Events management dialog - SQL Statement profiling - Much enhanced drag and drop support - Drag a dictionary object, an