Could not start the service MySQL:Error 0
Hello, I've downloaded and installed MySQL 5.1 on the machine where I work. However, during the server configuration thru MySQL Instance Server Config Wizard, on the screen Ready to execute..., the following error occurs in the Start service point: Could not start the service MySQL:Error 0. I'm using Windows XP and there lot of other programs installed on my machine. How to fix this issue ? How can I remove previous instances of MySQL on my computer ? I mean, clean everything related to MySQL from my computer. Thanks and looking forward to news.
Re: Could not start the service MySQL:Error 0
I suffered the same problem, and the following worked for me: http://www.andy.name.my/2009/03/cannot-create-windows-service-for-mysqlerror0/
ordering search results
Can't find anything on the web that deals with my problem(s). I have to display thousands of book listings by title, sub_title with 10 books per page. The php/mysql code works fine - except: ASC or DESC does not change one iota. I have checked by commandline and find that it is not working at all how I would expect. From commandline, using just title and switching between ASC DESC give totally different results rather than displaying the same data in reverse order. The display is, as mentioned above, 10 books per output page: so, from what appears to me, the ordering seems to be done on the entire db not just on the search results (this is basically from a SELECT statement). Furthermore, not all the data is in 1 table; authors, categories publishers are in separate tables because of 1 to many many to 1 relationships. Still another problem is the use of a number of foreign languages which have those strange accent on many letters that do not order very well. Now, that I have spewed out my problems, would it be possible that there is someone out there who could suggest how to go about figuring this out? Thanks in advance. -- Hervé Kempf: Pour sauver la planète, sortez du capitalisme. - Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Could not start the service MySQL:Error 0
Hello, I followed the site instructions but I am still facing the problem... This issue is driving me crazy... I don't know what else to do... Is there a way to remove everything related to MySQL from my machine ( a complete clean up ) ? I'm asking that because there are lots of softwares installed in my machine and one of these softwares might be generating some kind of MySQL conflict ( I guess ). - Original Message - From: thomas.william.anth...@googlemail.com To: Carlos A. Octaviano ; mysql@lists.mysql.com Sent: Friday, July 17, 2009 9:25 AM Subject: Re: Could not start the service MySQL:Error 0 I suffered the same problem, and the following worked for me: http://www.andy.name.my/2009/03/cannot-create-windows-service-for-mysqlerror0/
RE: ordering search results
From your description of your problem, it's very difficult to understand what you're doing and what results you're trying to get. Making some assumtions, I think you might need to use a technique described in this link to get the results you want: http://jan.kneschke.de/projects/mysql/groupwise-max Otherwise, for better help: 1) Show us the exact query you are doing, and the structure of the tables. 2) Show a small sample data set if possible 3) Show what the result set you want would look like. Regards, Gavin Towey -Original Message- From: PJ [mailto:af.gour...@videotron.ca] Sent: Friday, July 17, 2009 8:07 AM To: MySql Subject: ordering search results Can't find anything on the web that deals with my problem(s). I have to display thousands of book listings by title, sub_title with 10 books per page. The php/mysql code works fine - except: ASC or DESC does not change one iota. I have checked by commandline and find that it is not working at all how I would expect. From commandline, using just title and switching between ASC DESC give totally different results rather than displaying the same data in reverse order. The display is, as mentioned above, 10 books per output page: so, from what appears to me, the ordering seems to be done on the entire db not just on the search results (this is basically from a SELECT statement). Furthermore, not all the data is in 1 table; authors, categories publishers are in separate tables because of 1 to many many to 1 relationships. Still another problem is the use of a number of foreign languages which have those strange accent on many letters that do not order very well. Now, that I have spewed out my problems, would it be possible that there is someone out there who could suggest how to go about figuring this out? Thanks in advance. -- Hervé Kempf: Pour sauver la planète, sortez du capitalisme. - Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
RE: Slave log files going nuts...
The binlogs are closed and reopened every time you do a FLUSH LOGS; command, or when the server restarts. Is your server crashing continuously? Take a look at your error log as well. Regards, Gavin Towey -Original Message- From: Gary Smith [mailto:g...@primeexalia.com] Sent: Thursday, July 16, 2009 3:16 PM To: Todd Lyons Cc: mysql@lists.mysql.com Subject: RE: Slave log files going nuts... I'll have to look into that. We have a single cronjob that just does a mysqldump daily but not during the time of the log file generation, but that's all I can think of off the top of my head. Gary From: tly...@sitehelp.org [tly...@sitehelp.org] On Behalf Of Todd Lyons [tly...@ivenue.com] Sent: Thursday, July 16, 2009 2:41 PM To: Gary Smith Cc: mysql@lists.mysql.com Subject: Re: Slave log files going nuts... On Thu, Jul 16, 2009 at 1:18 PM, Gary Smithg...@primeexalia.com wrote: I have a new slave I setup against a new master server. The master server has 4 log files in it, the most current being updated on the 16th. The slave server on the other hand has several files, many which seem to be blank. This slave is set to slave the master and act as a master for downstream slaves. Note, there is no master/master on this configuration, even though the master itself could do it. Any ideas? Something is doing several 'mysqladmin refresh' or a related command, all sequentially in a row in short order. Look at your cron jobs that start or end around the time that all those empty binlogs are being created. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline
At 04:52 PM 7/16/2009, Todd Lyons wrote: On Wed, Jul 15, 2009 at 11:58 AM, mosmo...@fastmail.fm wrote: I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions? Why can't you copy the InnoDb files to another machine and open the database with another MySQL server? (You could do it on your current server but it will be CPU disk intensive). Then do a: create table MyTable1 engine=MYISAM select * from InnoTable1; If these tables are large, then you could use: create table MyTable1 engine=MYISAM select * from InnoTable1 limit 0; insert into MyTable1 select * from InnoTable1 limit 0,10; insert into MyTable1 select * from InnoTable1 limit 10,10; to import just 100k rows at a time. Now build the indexes for MyTable1. Could do it easier I would think: ALTER TABLE t1 ENGINE = MyISAM Yes, I had thought of that but I find it is safer if he copies the data from an InnoDb table to a MyISAM table. That way he can abort the operation without any fear of having his InnoDb table corrupted. With the Limit clause he can also do it in sections and it gives him more control of the operation. At least that's the way I'd do it. Mike Repeat for each table. Script it if it's more than a few tables. Note that foreign keys will break if your InnoDB table uses them. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ordering search results
Here's the query: SELECT * FROM book ORDER BY $sort $dir LIMIT $offset, $records_per_page; $sort == 'title, sub_title'; $dir==ASC (or DESC); $offset== (any multiple of 10); $records_per_page== 10; I could let the user change these, but I decided it is simpler to keep it at 10 books/page. Only the $dir is user settable. The character set is utf8-general; (I just went through some self-torture changing all those foreign curlicues to :cutesy_stuff; fortunately, the mysql replace() function helped - but six languages have quite a few weird accents. The title field can be fairly long - 182 chars; sub_title is 128, but it looks like I have to lengthen that too; found some truncated inputs. Another problem is the Thes - how do you exclude them from the ordering. Also: one output with just title for field returned a series of The Art.., The Birds..., The Birth...etc. in ASC; whereas DESC returned: Boats, Black Cumin, Birds of..., Biological..., Bioarchaeology.., Avaris... etc. Darryle Steplight wrote: You might have to change the collation you are currently using to one that best match the language of those weird accents you are referring too. That's part of the reason you may be getting unexpected results with your ORDER BY statement. Also, can you show us your select statements? On Fri, Jul 17, 2009 at 11:06 AM, PJaf.gour...@videotron.ca wrote: Can't find anything on the web that deals with my problem(s). I have to display thousands of book listings by title, sub_title with 10 books per page. The php/mysql code works fine - except: ASC or DESC does not change one iota. I have checked by commandline and find that it is not working at all how I would expect. From commandline, using just title and switching between ASC DESC give totally different results rather than displaying the same data in reverse order. The display is, as mentioned above, 10 books per output page: so, from what appears to me, the ordering seems to be done on the entire db not just on the search results (this is basically from a SELECT statement). Furthermore, not all the data is in 1 table; authors, categories publishers are in separate tables because of 1 to many many to 1 relationships. Still another problem is the use of a number of foreign languages which have those strange accent on many letters that do not order very well. Now, that I have spewed out my problems, would it be possible that there is someone out there who could suggest how to go about figuring this out? Thanks in advance. -- Herv� Kempf: Pour sauver la plan�te, sortez du capitalisme. - Phil Jourdan --- p...@ptahhotep.com � http://www.ptahhotep.com � http://www.chiccantine.com/andypantry.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: � �http://lists.mysql.com/mysql?unsub=dstepli...@gmail.com -- Hervé Kempf: Pour sauver la planète, sortez du capitalisme. - Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ordering search results
You might have to change the collation you are currently using to one that best match the language of those weird accents you are referring too. That's part of the reason you may be getting unexpected results with your ORDER BY statement. Also, can you show us your select statements? On Fri, Jul 17, 2009 at 11:06 AM, PJaf.gour...@videotron.ca wrote: Can't find anything on the web that deals with my problem(s). I have to display thousands of book listings by title, sub_title with 10 books per page. The php/mysql code works fine - except: ASC or DESC does not change one iota. I have checked by commandline and find that it is not working at all how I would expect. From commandline, using just title and switching between ASC DESC give totally different results rather than displaying the same data in reverse order. The display is, as mentioned above, 10 books per output page: so, from what appears to me, the ordering seems to be done on the entire db not just on the search results (this is basically from a SELECT statement). Furthermore, not all the data is in 1 table; authors, categories publishers are in separate tables because of 1 to many many to 1 relationships. Still another problem is the use of a number of foreign languages which have those strange accent on many letters that do not order very well. Now, that I have spewed out my problems, would it be possible that there is someone out there who could suggest how to go about figuring this out? Thanks in advance. -- Hervé Kempf: Pour sauver la planète, sortez du capitalisme. - Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dstepli...@gmail.com -- A: It reverses the normal flow of conversation. Q: What's wrong with top-posting? A: Top-posting. Q: What's the biggest scourge on plain text email discussions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Re: Could not start the service MySQL:Error 0
Try looking in Control Panel-Administrative Tools- Services and deleting all the MySQL services.
RE: ordering search results
Please echo the query and show the actual result. We have no way to know what your program puts in your variables. The problem is often a that a programming error causes the code to construct a query that's different from what you assume. Regards, Gavin Towey -Original Message- From: PJ [mailto:af.gour...@videotron.ca] Sent: Friday, July 17, 2009 1:25 PM To: Darryle Steplight Cc: MySql Subject: Re: ordering search results Here's the query: SELECT * FROM book ORDER BY $sort $dir LIMIT $offset, $records_per_page; $sort == 'title, sub_title'; $dir==ASC (or DESC); $offset== (any multiple of 10); $records_per_page== 10; I could let the user change these, but I decided it is simpler to keep it at 10 books/page. Only the $dir is user settable. The character set is utf8-general; (I just went through some self-torture changing all those foreign curlicues to :cutesy_stuff; fortunately, the mysql replace() function helped - but six languages have quite a few weird accents. The title field can be fairly long - 182 chars; sub_title is 128, but it looks like I have to lengthen that too; found some truncated inputs. Another problem is the Thes - how do you exclude them from the ordering. Also: one output with just title for field returned a series of The Art.., The Birds..., The Birth...etc. in ASC; whereas DESC returned: Boats, Black Cumin, Birds of..., Biological..., Bioarchaeology.., Avaris... etc. Darryle Steplight wrote: You might have to change the collation you are currently using to one that best match the language of those weird accents you are referring too. That's part of the reason you may be getting unexpected results with your ORDER BY statement. Also, can you show us your select statements? On Fri, Jul 17, 2009 at 11:06 AM, PJaf.gour...@videotron.ca wrote: Can't find anything on the web that deals with my problem(s). I have to display thousands of book listings by title, sub_title with 10 books per page. The php/mysql code works fine - except: ASC or DESC does not change one iota. I have checked by commandline and find that it is not working at all how I would expect. From commandline, using just title and switching between ASC DESC give totally different results rather than displaying the same data in reverse order. The display is, as mentioned above, 10 books per output page: so, from what appears to me, the ordering seems to be done on the entire db not just on the search results (this is basically from a SELECT statement). Furthermore, not all the data is in 1 table; authors, categories publishers are in separate tables because of 1 to many many to 1 relationships. Still another problem is the use of a number of foreign languages which have those strange accent on many letters that do not order very well. Now, that I have spewed out my problems, would it be possible that there is someone out there who could suggest how to go about figuring this out? Thanks in advance. -- Herv� Kempf: Pour sauver la plan�te, sortez du capitalisme. - Phil Jourdan --- p...@ptahhotep.com � http://www.ptahhotep.com � http://www.chiccantine.com/andypantry.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: � �http://lists.mysql.com/mysql?unsub=dstepli...@gmail.com -- Hervé Kempf: Pour sauver la planète, sortez du capitalisme. - Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.
RE: ordering search results
I think I see it anyway: ORDER BY tile DESC, sub_title ASC Each item in the list fields takes ASC/DESC individually. Your statement would only change the sort order on the second column, not both. -Original Message- From: PJ [mailto:af.gour...@videotron.ca] Sent: Friday, July 17, 2009 1:25 PM To: Darryle Steplight Cc: MySql Subject: Re: ordering search results Here's the query: SELECT * FROM book ORDER BY $sort $dir LIMIT $offset, $records_per_page; $sort == 'title, sub_title'; $dir==ASC (or DESC); $offset== (any multiple of 10); $records_per_page== 10; I could let the user change these, but I decided it is simpler to keep it at 10 books/page. Only the $dir is user settable. The character set is utf8-general; (I just went through some self-torture changing all those foreign curlicues to :cutesy_stuff; fortunately, the mysql replace() function helped - but six languages have quite a few weird accents. The title field can be fairly long - 182 chars; sub_title is 128, but it looks like I have to lengthen that too; found some truncated inputs. Another problem is the Thes - how do you exclude them from the ordering. Also: one output with just title for field returned a series of The Art.., The Birds..., The Birth...etc. in ASC; whereas DESC returned: Boats, Black Cumin, Birds of..., Biological..., Bioarchaeology.., Avaris... etc. Darryle Steplight wrote: You might have to change the collation you are currently using to one that best match the language of those weird accents you are referring too. That's part of the reason you may be getting unexpected results with your ORDER BY statement. Also, can you show us your select statements? On Fri, Jul 17, 2009 at 11:06 AM, PJaf.gour...@videotron.ca wrote: Can't find anything on the web that deals with my problem(s). I have to display thousands of book listings by title, sub_title with 10 books per page. The php/mysql code works fine - except: ASC or DESC does not change one iota. I have checked by commandline and find that it is not working at all how I would expect. From commandline, using just title and switching between ASC DESC give totally different results rather than displaying the same data in reverse order. The display is, as mentioned above, 10 books per output page: so, from what appears to me, the ordering seems to be done on the entire db not just on the search results (this is basically from a SELECT statement). Furthermore, not all the data is in 1 table; authors, categories publishers are in separate tables because of 1 to many many to 1 relationships. Still another problem is the use of a number of foreign languages which have those strange accent on many letters that do not order very well. Now, that I have spewed out my problems, would it be possible that there is someone out there who could suggest how to go about figuring this out? Thanks in advance. -- Herv� Kempf: Pour sauver la plan�te, sortez du capitalisme. - Phil Jourdan --- p...@ptahhotep.com � http://www.ptahhotep.com � http://www.chiccantine.com/andypantry.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: � �http://lists.mysql.com/mysql?unsub=dstepli...@gmail.com -- Hervé Kempf: Pour sauver la planète, sortez du capitalisme. - Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.