mysql 6.0 has gone

2009-08-08 Thread 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

2009-07-20 Thread 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

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

2009-04-26 Thread 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

Re: Ordering cars

2009-04-26 Thread 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

Re: Full Text Search Problem

2009-04-24 Thread 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