Re: IF
Is there a field to save symbols like degree in mysql --Original Message-- From: Peter Brawley To: mysql@lists.mysql.com ReplyTo: peter.braw...@earthlink.net Subject: Re: IF Sent: Mar 15, 2011 9:22 PM Yes, but Access s IIF, of the same use, evaluates all three, and the documentation explicitly says so. Let's be glad we don't depend on Access, then. PB - On 3/14/2011 7:52 PM, Sándor Halász wrote: 2011/03/14 16:08 +0100, Johan De Meersman I'm afraid I'm not authoritative on this, but it seems to me that it would be very very bad if the third, unused expression were to be evaluated - not only from a performance point of view, but who is to say that that expression is not a user-defined function that modifies the database ? Yes, but Access s IIF, of the same use, evaluates all three, and the documentation explicitly says so. MySQL s, that I have seen, says neither. Assuming the worst is safer, and then one uses CASE ..., but if not, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=prathiman...@vsnl.net Prathima Rao blackberry mail
version 5 to 4
hi mysql tem, i have a version 5 on which i have developed a database now one of the systmem has 4 i tried to migrate from 5 to 4 it says THE TABLES HAVE BEEN CREATED IN LATER VERSION I AM not able to see any table any solutions for this? i need this data in version 4 pls help Thanks Regards, Prathima Rao
Re: version 5 to 4
hi mysql tem, i have a version 5 on which i have developed a database now one of the systmem has 4 i tried to migrate from 5 to 4 it says THE TABLES HAVE BEEN CREATED IN LATER VERSION I AM not able to see any table any solutions for this? i need this data in version 4 pls help Thanks Regards, Prathima Rao - Original Message - From: Prathima Rao To: mysql@lists.mysql.com Sent: Monday, February 15, 2010 12:32 PM Subject: version 5 to 4 hi mysql tem, i have a version 5 on which i have developed a database now one of the systmem has 4 i tried to migrate from 5 to 4 it says THE TABLES HAVE BEEN CREATED IN LATER VERSION I AM not able to see any table any solutions for this? i need this data in version 4 pls help Thanks Regards, Prathima Rao
Re: Slow connection over VPN
it depends on the vpn router if u need more info let me know - Original Message - From: Duncan, Kurt (MCUSA) k...@medconnectusa.com To: mysql@lists.mysql.com Sent: Tuesday, February 17, 2009 12:09 AM Subject: Slow connection over VPN We have an application using mysql. When we run it locally there are no issues. If we try and connect to a remote database machine over VPN it works but takes a VERY long time to get anything done. We are using the exact same database. All other programs using the same VPN run fine and the speed on the VPN has tested fine. Does anyone have any ideas? Kurt Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=prathiman...@vsnl.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Happy New Year
HAPPY NEW YEAR - Original Message - From: John Daisley john.dais...@mypostoffice.co.uk To: MySQL General List mysql@lists.mysql.com Sent: Thursday, January 01, 2009 7:25 AM Subject: Happy New Year Just thought I would take this opportunity to wish everyone on the list a happy, prosperous and peaceful 2009. John Daisley Email: john.dais...@butterflysystems.co.uk Mobile: 07812 451238 MySQL Certified Database Administrator (CMDBA) MySQL Certified Developer (CMDEV) MySQL Certified Associate (CMA) Comptia A+ Certified Professional IT Technician On Wed, 2008-12-31 at 10:23 -0800, Gary W. Smith wrote: Truncate the time part of the datetime field when doing the compare AND DATE_FORMAT(customer.created_dt, '%Y-%m-%d 00:00:00') BETWEEN '2008-12-30' AND '2008-12-30' Should work. Probably not the most efficient. The other options would be to use take end date + 1 day, minue 1 second. That's even a bigger hack but it would probably be more efficient than converting all of the dates on the fly if you have a large number of records to process. From: Johnny Withers [mailto:joh...@pixelated.net] Sent: Wed 12/31/2008 10:13 AM To: MySQL General List Subject: Compare DATETIME to DATE Hi, I don't quite understand (or even know) what the proper way to compare a DATETIME column to a given DATE value is. I've used various methods but I'd like to know if there's a better way to compare these values. Right now I have a query with this in the WHERE clause (customer.created_dt is a DATETIME): AND CAST(customer.created_dt AS DATE) BETWEEN '2008-12-30' AND '2008-12-30' This was working (MySQL on Win32) before I moved the database to MySQL on RHEL 64-bit (5.0.45-log). Should that work? I've also done this: AND customer.created_dt BETWEEN '2008-12-30 00:00:00' AND '2008-12-30 23:59:59' That works on both servers, but I really don't want to have to put the time in there (unless that's the way you are supposed to do this). I've though about using DATE_FORMAT... not sure about that either. - Johnny Withers 601.209.4985 joh...@pixelated.net __ This email has been scanned by Netintelligence http://www.netintelligence.com/email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysql not starting
this has been a problem to me from mysql 3.1 version now in 4.1 also the same problem during the instant configuration wizard the last screen which has start service does not turn green and mysql doesnt start ive tried removing mysql and reinstalling does this problem has anything to do with port or what is it please help? rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error in copy data from mysql 4.1 to mysql 5.0 server
hello every one, i have two mysql servers one is the local server 4.1 and one is the centralised server 5.0 . i copy data from 4.1 to 5.0 through a option called copy database to another server/host - (drop table if exists) during this process i am not getting the same resule as i get in 4.1 ie im using a text box which sums up a value in a table that in 4.1 is showing correct but in 5.1 is showing 0 when displayed in front end(visual basic 5) even though it has the sum correct data can anyone help me regards rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error in copy data from mysql 4.1 to mysql 5.0 server
hi,, the query is select sum(gtotal) from invoice this if i connect to 4.1 says 14000 but in 5.1 it says 0.00 why so is it because i copy data from 4.1 to 5.1 rao - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: prathima rao [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, June 19, 2006 6:57 PM Subject: Re: error in copy data from mysql 4.1 to mysql 5.0 server prathima rao wrote: hello every one, i have two mysql servers one is the local server 4.1 and one is the centralised server 5.0 . i copy data from 4.1 to 5.0 through a option called copy database to another server/host - (drop table if exists) during this process i am not getting the same resule as i get in 4.1 ie im using a text box which sums up a value in a table that in 4.1 is showing correct but in 5.1 is showing 0 when displayed in front end(visual basic 5) even though it has the sum correct data can anyone help me Post the query. PB regards rao -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.0/368 - Release Date: 6/16/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.0/368 - Release Date: 6/16/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql server
i have a hp server . i have installed mysql 4 in that when ever i shut down the system and start again the mysql server does not start it says its an error when i try to reconfigure it service started will be disabled can anyone help me out - Original Message - From: leo huang [EMAIL PROTECTED] To: Lakshmi M P [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, March 28, 2006 11:47 AM Subject: Re: mysql restart error hi, Lakshmi The mysql process had ended. I get it from both mysql err log and ps output. regards, Leo Huang 2006/3/28, Lakshmi M P [EMAIL PROTECTED]: Run ps -ef | grep mysql and see any mysql process is running and if so kill the same and try to start mysql.It may help. leo huang wrote: hi, I met the MySQL restart error today. First, I stopped the running mysql server using /usr/local/mysql/bin/mysqladmin -uroot shutdown. After the server shutdowned, I restarted it using /usr/local/mysql/bin/mysqld_safe . Then, I got this error: [ERROR] Can't start server: Bind on TCP/IP port: Address already in use. There was no other process that was using the port 3306 which mysql server use. But there were some mysql connect did not release because the shutdown. The error log is followed: 060328 8:20:45 [Note] /usr/local/mysql/libexec/mysqld: Normal shutdown 060328 8:20:47 InnoDB: Starting shutdown... 060328 8:20:49 InnoDB: Shutdown completed; log sequence number 120 2134241340 060328 8:20:49 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete 060328 08:20:49 mysqld ended 060328 08:21:15 mysqld started 060328 8:21:15 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use 060328 8:21:15 [ERROR] Do you already have another mysqld server running on port: 3306 ? 060328 8:21:15 [ERROR] Aborting 060328 8:21:15 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete 060328 08:21:15 mysqld ended The netstat outputs are followed: $ netstat -al Active Internet connections (including servers) Proto Recv-Q Send-Q Local Address Foreign Address(state) tcp4 0 0 bj.3306 s4.9405 FIN_WAIT_2 tcp4 0 0 bj.3306 s4.5168 FIN_WAIT_2 tcp4 0 0 bj.3306 s4.25007 FIN_WAIT_2 tcp4 0 0 bj.3306 s4.9940 FIN_WAIT_2 tcp4 0 0 bj.3306 s4.3916 FIN_WAIT_2 tcp4 0 0 bj.3306 s4.15229 FIN_WAIT_2 tcp4 0 0 bj.3306 s4.6479 FIN_WAIT_2 tcp4 0 0 bj.3306 s4.7873 FIN_WAIT_2 Our mysql version is 4.1.18. It is running on FreeBSD 4.9-RELEASE. Any comment will be great thankful! Regards, Leo Huang -- regards, Lakshmi.M.P. DBA-Support Sify Limited. Ext:4134 ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] www.sify.com - your homepage on the internet for news, sports, finance, astrology, movies, entertainment, food, languages etc No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.3.2/294 - Release Date: 3/27/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
working on Microsoft® Windows Server™ 2003
hi, can new mysql work on Microsoft® Windows Server™ 2003 regards prao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to create binary logging for a database
hello, how can i create a binary log in a new database - Original Message - From: Adam Lipscombe [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: 14/12/2005 3:50 PM Subject: Mysqldump INSERT statements (Was Mysqldump line endings) (--result-file) option to save your output but use the output redirector to map the output of mysqldump to a file you specify, you will get the CRLF line endings you seek. Many thanks. One more thing: by default mysqldump uses --extended-insert=TRUE. This results in all the VALUES data being on one line. IF the table has much data this produces very long lines when viewed in a text editor. (WordPad crashes!) If --extended-insert=FALSE then multiple INSERT statements are used. IS there any way to have 1 INSERT statement with each subsequent data line on a separate line? E.g. : INSERT INTO t1 VALUES (1,2,3), (1,4,5), (1,6,7); TIA - Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.13.13/199 - Release Date: 13/12/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
restoring datewise data
hello, i have a database in mysql i want to restore the backup server every 15 minutes if i take a backup in sql its huge and my transfer cost of the data will be very high can anyone suggest how to restore the data in small size regards prao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
recording time of data entry
hi all, can anyone tell me if we can anywhere find out what time that data was entred in the database i was actually checking if we can find out what time that record got created into the database can anyone help!! regards prao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql export resultset to xml format
hi all, has anyone tried to export a data from a table to *.xml format i want a front end programme to do this automatically for example i have a database test in which table testing exists i want the data from that table to be exported in xml format at a click of a button regards rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump for xml
i was tring mysqldump command line for exporting data to xml format it is giving an error can anyone help me with the command line syntax rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Country codes
do any one have ready made combo box with all the country codes present - Original Message - From: Rhino [EMAIL PROTECTED] To: Björn Persson [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: 21/11/2005 6:18 AM Subject: Re: Country codes I'm not saying it was an inappropriate way to present the data but it certainly was unexpected and, in my opinion, counter-intuitive. I didn't want the original poster to see page 3, see that his own country, Brazil, was missing, and dismiss the PDF as garbage. Rhino P.S. Sorry for top-posting but I can't intersperse normally with your email. - Original Message - From: Björn Persson [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, November 20, 2005 7:21 PM Subject: Re: Country codes Rhino wrote: Be careful when reading those lists! When I looked at page 3 in the English PDF, it said it was in numeric order and the list showed all the countries that use country code 1, then country 20 (Egypt), then country 210 (spare) *without* showing 55 (Brazil). Page 6 shows countries 500 through 509, then 51 through 58, and so on. Therefore, Brazil doesn't appear until Page 6. They have obviously chosen to sort the list only on the FIRST DIGIT of the country code; that's a pretty odd form of numerical order, in my opinion! That's not normal numerical order of course, but it's exactly the order you need if you're parsing a phone number where you don't know beforehand how many digits are the country code. I suppose you could call it alphabetical order, only it's applied to digits instead of letters. Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.4/176 - Release Date: 20/11/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.4/176 - Release Date: 20/11/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.4/176 - Release Date: 20/11/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
vpn connectivity
hai all , im using mysql 4 version we are trying to connect inter units thriugh VPN will my database work and how? p rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql no series
i have a table slno and percentage slno contains 1 to 15 when i say order by slno it always comes 1,10,11,12,13,14,15,2 i want it in the form 1,2,3,4,5,6,7,8,9,10,11 can u help rao - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: 04/10/2005 2:19 PM Subject: Re: [Fwd: MySQL in C - I need help!] Hello. thing worked. I'm always stuck in some errors like *UNRESOLVED EXTERNAL REFENCE, *and amongst other errors which I don't seem to understand and decipher. Usually UNRESOLVED errors mean that you have some libraries missing. Send the code to the list and errors which which you're getting during the compilation. There is a win32 specific list, which might be a better place for you letter: http://lists.mysql.com/win32 Philippe Poelvoorde wrote: Subject: MySQL in C - I need help! From: Deep Xavier Duites [EMAIL PROTECTED] Date: Mon, 3 Oct 2005 01:10:28 -0700 (PDT) To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] X-Account-Key: account1 Return-Path: [EMAIL PROTECTED] Delivery-Date: Mon, 3 Oct 2005 09:10:46 +0100 Received: from pop3.btclick.com [213.123.26.23] by localhost with POP3 (fetchmail-5.9.11) for [EMAIL PROTECTED] (single-drop); Mon, 03 Oct 2005 09:23:56 +0100 (BST) Received: from HESA02UKER.HE.LOCAL (actually host 93.26.123.213.in-addr.arpa) by c2bsmtp01.btconnect.com with SMTP-CUST (XT-PP) with ESMTP; Mon, 3 Oct 2005 09:10:40 +0100 Received: from c2bthimr02.btconnect.com ([194.73.73.202]) by HESA02UKER.HE.LOCAL with Microsoft SMTPSVC(6.0.3790.211); Mon, 3 Oct 2005 09:10:37 +0100 Received: from web54504.mail.yahoo.com (web54504.mail.yahoo.com [206.190.49.154]) by c2bthimr02.btconnect.com (MOS 3.5.9-GR) with SMTP id DYZ47349; Mon, 3 Oct 2005 09:10:19 +0100 (BST) Received: (qmail 40462 invoked by uid 60001); 3 Oct 2005 08:10:29 - DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content -Transfer-Encoding; b=vTU9RFG/N3WHZ3XKTJUkOY8zhVvtDT//pCVI0E22Nrbbmqtmh44+g46AL/U8SN7N4WbA1mY36h BstfkNo3ILgfxxRABUyDcRDCBOZozr4ZK1QsqjjGloomEVjtaHtApVhrZJA8EkJKnQDCqBZ1m79O /pAAF/U0F1s4X9lklL8gw= ; Message-ID: [EMAIL PROTECTED] Received: from [203.177.106.130] by web54504.mail.yahoo.com via HTTP; Mon, 03 Oct 2005 01:10:28 PDT MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0-1328098071-1128327028=:38212 Content-Transfer-Encoding: 8bit X-Junkmail-Status: score=10/50, host=c2bthimr02.btconnect.com X-Junkmail-SD-Raw: score=unknown, refid=str=0001.0A090203.4340E435.0050,ss=1,fgs=0, ip=206.190.49.154 Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 03 Oct 2005 08:10:37.0755 (UTC) FILETIME=[F000B0B0:01C5C7F1] Hi, Good day! I read the forum in this link http://archives.neohapsis.com/archives/mysql/2005-q2/1532.html and somehow I guess you people had tried programming MySQL in C successfully. I just hope that I can find answers from you guys. I've been looking for answers on how to successfully run a C program that uses MySQL for weeks now. I've been into some forums to ask questions about it but I just got no reply. I've been doing a lot of research on the net on how to run and *COMPILE* it successfully. I downloaded examples and a lot of instructional materials but yet none a thing worked. I'm always stuck in some errors like *UNRESOLVED EXTERNAL REFENCE, *and amongst other errors which I don't seem to understand and decipher. Though I'm not new to C (but C to MySQL, I am), I just can't figure it out. I've been trying a lot of tools already, like MS Visual C++ 6.0, MS Visual C++ 2003, Borland C++Builder 6.0, Borland C++ Compiler 5.5, Turbo C 2.01, Turbo C++ 3.1 and even Dev-C++ 5.0. I need to present this to my class. I just hope you can help me on this matter. I would appreciate it so much. *Deep Xavier T. Duites* Faculty, College of Computer Studies Cebu Institute of Technology N. Bacalso Avenue, Cebu City Contact# (032)2617744 local 110 Mobile# (+63)9228104319 Delight thyself also in the LORD; and he shall give thee the desires of thine heart. *Psalms 37 : 4* Yahoo! for Good Click here to donate http://store.yahoo.com/redcross-donate3/ to the Hurricane Katrina relief effort. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /
restore.sql database
hello i am taking backup in *.sql format automatically how can i restore the same in the server automatically from visual basic regards p rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
log file
hi, how to create a log file of the updates done on the data in visual basic or in mysql for a particular record for example i have a purchase order record in which my junior changes say rate without my knowledge how will i know what has been changed p rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
inserting the whole record
hi, i want to copy a whole record from one table to another like below insert into p1 values(select * from p2 where pono=1); its giving me error please help regards p rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
table handle error
hai, when ever the power goes or the system restarts when im entring data from my vb application to mysql 4 database it gets corrupted and i loose some data at the end please can any one help me in this regards prathima rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
graphs
hello, can anyone suggest if there is any software available to create graphs using mysql as database regards prathima rao
error in installing
hello, i have windows 2000 i was not able to finish the server configuration i read in one of the site that sc.exe should be present i searched but could not get the same can anyone help me regards p rao -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 266.9.0 - Release Date: 3/31/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error in installing
hello gleb, thanks for the suggestion i could solve the problem in installing mysql on win 2000 the solution is below for reference Error: Cannot create Windows service for MySql. Error: 0 This error is encountered when you re-install or upgrade MySQL without first stopping and removing the existing MySQL service and install MySQL using the MySQL Configuration Wizard. This happens because when the Configuration Wizard tries to install the service it finds an existing service with the same name. One solution to this problem is to choose a service name other than mysql when using the configuration wizard. This will allow the new service to be installed correctly, but leaves the outdated service in place. While this is harmless it is best to remove old services that are no longer in use. To permanently remove the old mysql service, execute the following command as a user with administrative privileges, on the command-line: C:\sc delete mysql [SC] DeleteService SUCCESSregardsprathima rao - Original Message - From: prathima rao [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, April 01, 2005 6:09 AM Subject: error in installing hello, i have windows 2000 i was not able to finish the server configuration i read in one of the site that sc.exe should be present i searched but could not get the same can anyone help me regards p rao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR WHILE LOADING
hai, i was trying to install mysql 4 server on windows 2000 when configuringthe server i received the below error in mysql server instance configuration "could not start the service mysql error:0" can i know how to solve the error regards p rao No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 266.8.4 - Release Date: 3/27/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sqlyog
hai, am using sqlyog for mysql i have taken back up in batch ie .sql i want to restore automatically can it be possible to restore by writing a code in vb using sqlyog i have written a programme in vb for taking back up automatically need help to restore the same automatically regards prathioma rao
restoring database
hai, i have written a bat file in which the data databackup has been taken in sql it runs automatically every 1 hour and sends a automatically through email now at the other end i have to manually restore the database can any one give me the codes to restore the database automatically in vb or as a bat file the databack up say for a database test is test.sql regards prathima -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: odbc 3.51.06
dear mysql team, i was trying to save a file in mysql now can u please help me with an alternative that i save the file name in the database and how to retrieve back prathima rao - Original Message - From: Prathima Rao To: [EMAIL PROTECTED] Sent: 06/12/2003 9:23 AM Subject: odbc 3.51.06 dear mysq team, i have myodbc 3.51.01 version now how do i upgrade to latest version 3.51.06 please help regards prathima rao