mysql 6.0 has gone

[zhu dingze]

When I approaching mysql download page.
It happens find mysql 6.0 download page disappeared from mysql dev pages.

What has on earth happened?

-- 
Dingze Zhu

We are running the best Chinese MySQL and Solaris Community in China.
Welcome to visit http://www.mysqlsystems.com

Re: mysqldump output

[zhu dingze]

we need more information,
such as your client and server version, the command that exactly your input
etc.

2009/7/14 JingTian jingtian.seu...@gmail.com

 hi all,

 i use mysqldump to backup my database,
 the command line is; mysqldump -p -u -h database_name  database_name.sql

 i find in the database_name.sql, there is a line:
 Not dumping tablespaces as no INFORMATION_SCHEMA.FILES table on this server

 can anyone tell me what does it mean?

 thanks very much,
 --
 Tianjing




-- 
Dingze Zhu

We are running the best Chinese MySQL and Solaris Community in China.
Welcome to visit http://www.mysqlsystems.com

Re: Error : Incorrect key file for table 'X'

[zhu dingze]

Hey Dude,
So many errors imply that there are some issues with your meta_data other
than the tables and files itself.
Please note, MySQL has upgrade some information in Information_schema
Database.
May I ask which kind of data have you been backup? including
information_schema.




Bests,
Dingze

2009/4/25 Mark ad...@asarian-host.net

 C'mon, guys, there's gotta be someone who knows something about this. :)
 Anyone? Anyone? Bueller? Bueller? I even did a complete mysqldump (from
 the 5.0.77 mysqld) and imported it that way. To no luck, alas.

 Thanks,

 - Mark


 -Original Message-
 From: Mark [mailto:ad...@asarian-host.net]
 Sent: zaterdag 25 april 2009 2:34
 To: mysql@lists.mysql.com
 Subject: Error : Incorrect key file for table 'X'

 Odd. I just painstakingly upgraded to MySQL 5.1.34, coming from 5.0.77.

 So, I run: /usr/local/bin/mysql_upgrade, and get these all over the

 place (see below; just a few lines: the error list is too long to post in

 whole). So, accomodating MySQL, I run:



 /usr/local/bin/myisamchk --force --extend-check --update-state -O

 key_buffer=128M -O sort_buffer=128M -O read_buffer=2M -O write_buffer=2M

 /var/db/mysql/*/*.MYI



 Makes no difference, though. All the tables are unusable now (thank God

 for Vmware!). But obviously, I can't take it to the producton server like

 this (FreeBSD). Anyone any idea what's happening?



 Thanks,



 - Mark







 Repairing tables

 albatross.banned

 Error: Incorrect key file for table 'banned'; try to repair it

 error: Corrupt

 albatross.bridge

 Error: Incorrect key file for table 'bridge'; try to repair it

 error: Corrupt

 albatross.categories

 Error: Incorrect key file for table 'categories'; try to repair it

 error: Corrupt

 albatross.comments

 Error: Incorrect key file for table 'comments'; try to repair it

 error: Corrupt

 albatross.config

 Error: Incorrect key file for table 'config'; try to repair it

 error: Corrupt

 albatross.dict

 Error: Incorrect key file for table 'dict'; try to repair it

 error: Corrupt

 albatross.ecards

 Error: Incorrect key file for table 'ecards'; try to repair it

 error: Corrupt

 albatross.exif

 Error: Incorrect key file for table 'exif'; try to repair it

 error: Corrupt

 albatross.favpics

 Error: Incorrect key file for table 'favpics'; try to repair it

 error: Corrupt

 albatross.filetypes

 Error: Incorrect key file for table 'filetypes'; try to repair it

 error: Corrupt

 albatross.hit_stats

 Error: Incorrect key file for table 'hit_stats'; try to repair it

 error: Corrupt

 albatross.plugins

 Error: Incorrect key file for table 'plugins'; try to repair it

 error: Corrupt



 Etc, etc.


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/mysql?unsub=mysql.li...@gmail.com

Re: Ordering cars

[zhu dingze]

select brand, max(year) from cars group by year order by yearunion
select brand, year from cars order by year


2009/4/25 Olav Mørkrid olav.mork...@gmail.com

 Say I have a table with any number of car brands, with belonging street
 dates.

 Is it possible to do the following type of sort in a single query?

 1. First I want the newest model of all car brands, but only one of
 each brand! And they should be ordered by year

 2. Then I want the cars that weren't the newest of their brand, also
 ordered by year

 Currently, I do two similar queries where I use group by on the
 first batch, but since each query is rather heavy, I would like to
 reduce them to one query if possible.

 select brand, year from cars order by [WHICH METHOD?]

 Ferrari   |   2008
 Porsche   |   2005
 Jaguar|   1997
 --+---
 Ferrari   |   2006
 Porsche   |   2004
 Ferrari   |   2003
 Jaguar|   1995
 Jaguar|   1992
 Porsche   |   1981

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/mysql?unsub=mysql.li...@gmail.com




-- 
Dingze Zhu

We are running the best Chinese MySQL and Solaris Community in China.
Welcome to visit http://www.mysqlsystems.com

Re: Full Text Search Problem

[zhu dingze]

'Words' shows in more than 50% rows will be regards as a stop words.

2009/4/24 mysupp...@asuma.com

 Hi,

 I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).

 'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
 ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF
 COMMERCE'.

 When I did a search like the following;

 SELECT COUNT(*) FROM article WHERE MATCH (agency) AGAINST ('DEPARTMENT OF
 COMMERCE');

 It returned count(*) = 0 instead of count(*) = 6.

 Could you kindly advise me what did I do wrong?

 Thanks,

 Jack





 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
 http://lists.mysql.com/mysql?unsub=mysql.li...@gmail.com