Re: MySQL 5.0 - What is really available?
I would not recommend MySQL-Front ... the version they are selling is not from the same developer that did MySQL-Front 2.5 (and earlier). I bought a license (took a month to get a license key), complained about missing features (OPTIMIZE and REPAIR MyISAM tables) and was basically told I could shove it. They were rude and arrogant. G. Jensen - Original Message - From: dan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 10:30 AM Subject: Re: MySQL 5.0 - What is really available? You mention Windows XP. Check out Mysql-Front (now commercial), version 3 may fit the bill. not sure. but it was the best windows interface for mysql ever made, notice, I said best for windows... ;) mysqlCC rocks, but not sure about 5.0 support. perhaps you could test it and report, and if its not working, maybe you could even do a patch or two? :) Dan. On Tue, 30 Mar 2004 [EMAIL PROTECTED] wrote: I've downloaded and installed 5.0, it seems to be working fine. However, I need a graphical user interface to create tables and such (when I say I need, trust me, I need). I'm running on XP (that explains a lot I know) So: Is Control Center for 5.0 available? Is MyODBC 5.0 available? I'm having a hard time find from the rather extensive 'manual.html' what other than the actual database engine is available. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL 5 Stored Procedure
Do a search on this list ... this has been covered within the last two weeks several times. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 5:40 AM Subject: MYSQL 5 Stored Procedure Hello I've installed Mysql 5 and have created a database. When I try and create a stored procedure (using the example in the help) it fails. The online help states that there should be a table called 'procs' in the database for stored procedures to work. I can't see this table. The help says this should have been created as part of the installation. Any ideas as to why this is and what I can do? Thanks - Email provided by http://www.ntlhome.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: My SQL setup issue
More information please ... what Operating System, where are the MySQL binaries and data directories on your machine, did you create a my.ini, is MySQL installed as a service - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 14, 2003 1:51 PM Subject: My SQL setup issue Hello, I am unable to start MySQL 4.0. I tried installing it from a mirro image. All looks OK, but when I try to initiate it, I reveive ERROR moving data -103 server. Then I initiate WinMySQLAdmin and I believe I am supposed to be prompted for Name and Password. I actually get a window with several tabs across the top of screen; Environment, Start Check, Server, My .ini Setup, Err File. but no login. Am I doing something wrong? Thank you. William __ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Win32 vs Linux ?
Paul: In my experience, MySQL on Win32 platforms is very stable. Of the 80+ customer systems we have running our applications in conjunction with MySQL, the vast majority are on Win32. The DB server needs to be properly tuned for the application and environment, but that is the case with RDBMS you might sleect. IMHO, any instability is not related to MySQL, but rather to the O/S platform itself. Gerald Jensen - Original Message - From: Paul Fine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 17, 2003 7:45 AM Subject: MySQL on Win32 vs Linux ? Greetings. Can anyone comment on the stability of MySQL on Win32? Unfortunately I may have to use IIS for a project and am just wandering if I can expect the same sort of stability and performance using MySQL (and PHP) on a Windows Server. Thanks for any advice! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Configuration File Creation - Automatic or manual?
Adam: You create the configuration files ... the MySQL distribution has samples (my-huge.cnf, my-large.cnf, etc.) which you should edit to make sure settings are appropriate for your needs. Gerald Jensen - Original Message - From: Fortuno, Adam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 7:52 AM Subject: Configuration File Creation - Automatic or manual? All, A little confused about what creates configuration (my.cnf) files. I'm running MacOS X 10.2 (Jaguar) running MySQL 4.0.x. I was looking for the global and server level configuration files in the following directories: Global - /etc/my.cnf Server - /mysql/data/my.cnf I was unable to locate the files. Is this something I've got to create, or is it generated during installation? If the files aren't generated during installation, what does MySQL use when the .cnf files don't exist? http://www.mysql.com/doc/en/Option_files.html Regards, Adam Fortuno (x4904) Adam Fortuno (E-mail).vcf About the auto-start-up/shut-down on OS X: OS X doesn't provide (as best I can find) a way through aqua (OS X's GUI) to automatically start and stop MySQL. However, OS X allows items to be kicked-off automatically at boot-up through the /Library/StartupItems/ directory. The book Managing Using MySQL from O'Reilly (ISBN: 0-596-00211-4) has a page dedicated to the setup (page 69). I haven't been able to get this to work. I was able to download a binary that started MySQL server. The installer setup everything in the StartupItems folder. I got the stuff from www.entropy.ch (Marc Liyanage's site). With this, MySQL server starts at boot, but I cannot get it to automatically shut down! So each time I shutdown I have to first remember to shutdown mysqld (that sucks). For now, I'm just starting and stopping it manually (makes it easier to remember I have to shut it down). I'll keep at it though. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is there trigger function in MySQL ?
Steve: What you are talking about is Stored Procedures ... not available in the current stable version of MySQL. Stored Procedures are, however, being implemented in MySQL Version 5.0's development tree. This version is still in heavy development ... I wouldn't use it on a production server. Gerald Jensen - Original Message - From: Steven Wu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 08, 2003 12:49 PM Subject: Is there trigger function in MySQL ? Hi: It seems to me that there is no trigger function in MySQL but I am not sure. Recently, I have a project which need the trigger function when MySQL database server receive a alert information and wake up some procedure. Is there any other method to do the same functionality of trigger as in ORACLE databse ? Steven Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: inserting images to mysql - is it possible?
Bob: This question comes up over and over on the list ... do a search for 'images' of the list archive and you can read the accumulated pros and cons. Gerald Jensen - Original Message - From: Bob Ostermann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 30, 2003 7:35 AM Subject: Re: inserting images to mysql - is it possible? Armand- Why is it not recommended to store images in a database? I've not heard this... bob. At 09:51 PM 6/29/03 +0200, you wrote: Hi, You have to insert a new blob field where you can store binary data. But it is not recommanded to store images in a database. I recommande you to store images on a server filesystem and only the reference to the images in a database. Armand Digital Directory USA wrote: I am new to php and mysql, I have searched looked over and cannot find a way to do this... can it be done? I have set up the following in mysql. How do I upload the product images to the pPhoto column. Any suggestions? ds_produc Field Type Attributes Null Default Extra pID int(11)Noauto_increment catID int(11)No 0 pName varchar(70)Yes NULL pNum varchar(40)Yes NULL pTeaser textNo pDesc textYes NULL pPrice float(10,2)Yes NULL pSalesPrice float(10,2)No 0.00 pSale char(1)No pPhoto varchar(70)Yes NULL pPhotoWidth int(11)No 0 pPhotoHeight int(11)No 0 pSize varchar(35)Yes NULL pAvail char(1)No Y George Guebely Digital Directory USA, Inc -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] == The RediNews Network http://www.redinews.com/ Custom Financial Web Site Content phone: (516) 997-4343 == -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL on Windows 2000 Server
Neil: MySQL on Windows 2000 Server is excellent. We have installed about client 80 systems that incorporate MySQL. Some are running on Unix, some Linux, about a third on Windows NT Server, and the balance (40+ systems) are running on either Windows 2000 Server or Win2K Advanced Server. We have never had a burp that was traceable to MySQL. If we encounter any problems (which occurs seldom), it is almost always traceable to poor network administration, lack of proper network security, or failure to follow instructions. Gerald Jensen - Original Message - From: Neil Tompkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 3:23 AM Subject: mySQL on Windows 2000 Server Hi, I'm looking to purchase my own dedicated server. As standard it doesn't come with any database support. I was considering installing mySQL. At the moment I have mySQL running on Windows 2000 professional and everything looks OK at the moment. Has anyone installed mySQL on Windows 2000 server, can you tell me your experiences, or should I look for another option ? At the moment we use mySQL on linux, but my linux knowledge is limited and Win2K server is my best option. Thanks for any comments. Kind regards, Neil Tompkins _ Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile/mobilehotmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: restart or not?
Jon: Reload the permissions tables. It looks like your permissions for Joseph are on the money ... are other people able to access the database remotely? Gerald Jensen - Original Message - From: Jon Miller [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, January 28, 2003 5:05 PM Subject: restart or not? When granting someone permissions are these permissions dynamic or do I have to reload mysql? Also we have a developer who stated he cannot access the database remotely. I've granted him privileges as follows since he works on the entire system both locally and remotely. There is only one database in the system. I've set a password for access to the system also. grant all privileges on *.* to joseph@% identified by 'his_password' with grant option; grant all privileges on *.* to joseph@localhost identified by 'his_password' with grant option; GRANT RELOAD,PROCESS ON *.* TO joseph@localhost; GRANT USAGE ON *.* TO joseph@localhost; -- Jon Miller [EMAIL PROTECTED] MMT Networks Pty Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can MySQL handle 120 million records?
Joe is right ... we switched from another SQL server to MySQL in 1999, and have never looked back. MySQL has been rock solid for our applications, the MySQL development team is great to work with, and our customers like it. Gerald Jensen - Original Message - From: Joe Stump [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Michael She [EMAIL PROTECTED] Cc: Qunfeng Dong [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, December 18, 2002 1:55 PM Subject: RE: Can MySQL handle 120 million records? Without trying to sound like a troll or a rant I'd like to chime in on the side of Jeremy. I've worked with MySQL on sites that serve up over a million hits a day. We hit the 2gb file limit in Linux (NOT a MySQL problem) and moved to Solaris without incident. A friend of mine had over a billion rows in a few of this tables (statistical data mostly). As Jeremy points out all DB's have their problems, shortcomings, etc. If you have specific complaints fill out a feature request, if you've got problems fill out a bug report, but don't knock MySQL as not-worthy-of-enterprise-status because it doesn't *work* like Oracle, etc. Overall, in my many experiences, it is more than sufficient for web apps. --Joe -- Joe Stump [EMAIL PROTECTED] http://www.joestump.net -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 8:09 AM To: Michael She Cc: Qunfeng Dong; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Can MySQL handle 120 million records? On Wed, Dec 18, 2002 at 02:37:07AM -0500, Michael She wrote: I agree. MySQL is a great database, but I wouldn't call it enterprise grade. Since you haven't told us what enterprise grade means to you, that doesn't tell us much. What is it lacking to become enterprise grade in your mind? Considering that the database is used to store billing information... one has to be weary about losing all the records due to a bug or deficiency in MySQL. That's true of any database server, right? It's not really a MySQL-specific complaint. I was searching through some of the MySQL help documentation, and there have been more than a few examples in the comments where people have lost data due to wacky functions on databases greater than a couple of GBs... Imagine what you'd read it Oracle was open enough to allow comments in their on-line docs. Seriously. I've heard pretty nasty stories about Oracle, Microsoft SQL Server, and so on. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 3 days, processed 136,618,914 queries (457/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need query to determine TABLE TYPE
I'm running MySQL 3.23.52 (NT), and have discovered that some of the tables in some old databases are still ISAM (left over from the 3.22.32 days). I want to convert these tables to MyISAM, but rather than shot-gun all tables in all databases, I'd like to run a query to determine which tables are still ISAM, then ALTER them. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL-Front Discontinued
I went to http://www.anse.de/mysqlfront/ today ... the notice posted on the site says MySQL-Front - This project has been discontinued. Too bad ... Ansgar Becker developed a truly useful, powerful MySQL database management tool for us Windoze users. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: dos trouble
Home or Pro? I have no experience with WinXP Home, but with WinXP Pro you need to installed MySQL as a service, then start the service. After that, the console will start with c:\mysql\bin\mysql Instructions for installing as a service are in the MySQL Manual. -Original Message- From: Shion D. Deysarkar [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 9:32 AM To: Gerald R. Jensen Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: dos trouble Win XP On Thu, 1 Aug 2002, Gerald R. Jensen wrote: What O/S are you using ... Win2k, WinXP, etc.? - Original Message - From: Shion D. Deysarkar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 11:15 PM Subject: dos trouble I'm trying to start up mysql through dos prompt. When I enter a command like c:\mysql\bin\mysqld or anything similar (any command in the bin directory), it just waits there. I can't Ctrl-C out of it. I can end the process to get out. What's happening? -- Shion Deysarkar http://www.contrib.andrew.cmu.edu/~sdd Be water, my friend. -- Bruce Lee - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. -- Shion Deysarkar http://www.contrib.andrew.cmu.edu/~sdd Ah! That is clearly a metaphysical speculation, and like most metaphysical speculations has very little reference at all to the actual facts of real life, as we know them. -- Gwendolen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored procedures
Yes ... we all know that stored procedures have not been implemented in MySQL. Sorry to be so terse, but this is about the umpteenth posting of this same question this week ... doesn't anybody read the list or search the archive before they post stuff? - Original Message - From: andy thomas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 7:01 AM Subject: Stored procedures Does anyone know if stored procedures have been implemented in MySQL? Getting into the MySQL web site from the UK is almost impossible these days so I thought I'd ask here. Thanks in advance for any information, Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL 4.0
Sad ... we gave MySQL a try almost three years ago, wound up replacing M$'s SQL Server with MySQL, and now have 80+ very happy customers with a stable, powerful, and very cost-effective database solution. - Original Message - From: Arul [EMAIL PROTECTED] To: Thomas Spahni [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 3:42 AM Subject: Re: MYSQL 4.0 Hi Thomas I am always ready to give a try .. But u see Managers will not be ready to take such a risk...and Morever our client will not give a try ..:(( -Arul - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: Arul [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 1:27 PM Subject: Re: MYSQL 4.0 Arul, as you are intending to use open source software for free why not give it a try and help with debugging? 4.0.1 is remarkably stable except for some glitches in replication and boolean fulltext search. Alpha status applies mainly to the newly developed features. Go ahead and have fun! Thomas On Wed, 26 Jun 2002, Arul wrote: Hi Any idea when MySQL 4.0 stable release will be made.. As of now only Alpha is released.. Also any sites which run on 4.0 Alpha Regards, -Arul To pass the List : sql , query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Stored procedures
I noticed ... but he was somehow able to get on the list to post his message! -Original Message- From: Roma Gupta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 9:13 AM To: 'Gerald Jensen'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Stored procedures I think you didn't notice. He cannot access Mysql website from UK :) -Original Message- From: Gerald Jensen [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 9:16 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Stored procedures Yes ... we all know that stored procedures have not been implemented in MySQL. Sorry to be so terse, but this is about the umpteenth posting of this same question this week ... doesn't anybody read the list or search the archive before they post stuff? - Original Message - From: andy thomas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 7:01 AM Subject: Stored procedures Does anyone know if stored procedures have been implemented in MySQL? Getting into the MySQL web site from the UK is almost impossible these days so I thought I'd ask here. Thanks in advance for any information, Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL PHP Development IDE
Thanks for the advice ... I'll take a look at dbg2 ... if I get stuck, I'll shoot you a plea for help! Gerald Jensen -Original Message- From: BD [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 9:38 AM To: Gerald R. Jensen Cc: [EMAIL PROTECTED] Subject: Re: MySQL PHP Development IDE At 06:37 AM 2/21/2002 , you wrote: This off topic, but one of our programmers is interested in NuSphere's PHPEd development interface and I would liek some feed back from other users. His interest lies not so much in using for database table modeling, but for PHP and Perl development. I am well aware of the conflict a few months ago between MySQL and NuSphere, but I have never heard anything one way or the other about PHPEd. At nearly $500 per package, it is not a decision I wish to make without some feedback from the community. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? Any feed back (either to the list or me me privately) will be appreciated. Gerald Jensen Gerald, I tried PHPEd from NuSphere and it only partially worked. I spent a lot of time trying to get it to work properly and failed. :( I tried 4 or 5 different PHP debuggers and I didn't like any of them. Not being one to give up easily, I kept looking. I found an excellent PHP debugger and editor from https://sourceforge.net/projects/dbg2/. It took a little while getting it installed because there are no docs, but I've been using it for a month and couldn't be happier. The author Dmitri has borrowed a lot of ideas from the Delphi IDE so using it is quite intuitive. I use it as my main PHP editor. It is also faster than any other PHP debugger I've tried (there are no annoying delays or screen flashes when single stepping through the PHP code) and it can also debug into Include files which other debuggers may not be able to do. It can also display Local, Global, Call Stack, Watch, Immediate, Breakpoint windows at the bottom of the screen. It can also display arrays and all class object properties which is very cool. All in all, it's a great PHP editor/debugger. There are versions for Windows (which is what I'm using), BSD and Linux. You also get the source code for it and you'll definitely like the price. It's free. :-) Brent If you have a problem setting it up, shoot me off an email and I'll see what I can do. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 1058 Win2K Server with MySQL
We are trying to install MySQL on a Windows 2000 Server, but are getting 'error 1058' when we try to start the service. The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is: [mysqld] port=3306 big-tables skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 basedir = F:/MYSQL/ console [mysqldump] quick set-variable = max_allowed_packet=16M [MYSQL] no-auto-rehash [isamchk] set-variable= KEY=16M [client_fltk] help_file= F:\MYSQL\sql_client\MYSQL.help client_file= F:\MYSQL\MYSQL.options history_length=20 database = Wires queries_root= F:\MYSQL\queries last_database_file= F:\MYSQL\lastdb This system is to use MyISAM tables. From a DOS prompt, we switched into the F:\MYSQL\BIN directory and... mysqld-nt --install Win2K reports the service installed. When we ... net start mysql we get the following error: System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. Anyone had this problem ... found a fix ... have any idea what is wrong??? Any feedback will be appreciated. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error 1058 Win2K Server with MySQL
Problem is solved ... customer had his server configured so any new services being installed were automatically disabled! That is why the service would not start. We have installed MySQL on about a dozen Win2K Advanced servers ... this is the first time we have encountered this issue. Thank you to those who responded! - Original Message - From: Miguel Angel Solorzano [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 12:05 PM Subject: Re: Error 1058 Win2K Server with MySQL At 07:49 19/02/2002 -0600, Gerald Jensen wrote: Hi! Did you tried to put the datadir variable too in the my.cnf file ? Anyway, when the service is failing try to start it as console: mysqld-nt --standalone --console In this way you should see the messages errors, also you can see them in the \data\mysql.err file. Regards, Miguel We are trying to install MySQL on a Windows 2000 Server, but are getting 'error 1058' when we try to start the service. The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is: [mysqld] port=3306 big-tables skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 basedir = F:/MYSQL/ console [mysqldump] quick set-variable = max_allowed_packet=16M [MYSQL] no-auto-rehash [isamchk] set-variable= KEY=16M [client_fltk] help_file= F:\MYSQL\sql_client\MYSQL.help client_file= F:\MYSQL\MYSQL.options history_length=20 database = Wires queries_root= F:\MYSQL\queries last_database_file= F:\MYSQL\lastdb This system is to use MyISAM tables. From a DOS prompt, we switched into the F:\MYSQL\BIN directory and... mysqld-nt --install Win2K reports the service installed. When we ... net start mysql we get the following error: System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. Anyone had this problem ... found a fix ... have any idea what is wrong??? Any feedback will be appreciated. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 1058 on Windows 2000 Server
We are trying to install MySQL on a Windows 2000 Server, getting 'error 1058' when he tries to start the service. The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is: [mysqld] port=3306 big-tables skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 basedir = F:/MYSQL/ console [mysqldump] quick set-variable = max_allowed_packet=16M [MYSQL] no-auto-rehash [isamchk] set-variable= KEY=16M [client_fltk] help_file= F:\MYSQL\sql_client\MYSQL.help client_file= F:\MYSQL\MYSQL.options history_length=20 database = Wires queries_root= F:\MYSQL\queries last_database_file= F:\MYSQL\lastdb This system is to use MyISAM tables. From a DOS prompt, we switched into the F:\MYSQL\BIN directory and... mysqld-nt --install Win2K reports the service installed. When we ... net start mysql we get the following error: System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. Anyone had this problem ... found a fix ... have any idea what is wrong??? Any feedback will be appreciated. Gerald Jensen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: M$ SQL Export to Mysql Help
Curtis ... Do you have the database/table created on the MySQL server? If so, you can use MSAccess (need ODBC connections to both servers) to Link Tables and move the data acros that way. We did it that way until our programmers wrote a C++ app that replicates server-to-server. Gerald Jensen - Original Message - From: Curtis Spencer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 2:54 PM Subject: M$ SQL Export to Mysql Help I have a nicely sized database of about 40 records, which I have in MS SQL but I need to move it to my production server, which is Mysql. I was going to do it this way: Export MS SQL database into a file and then use LOAD DATA INFILE But I was wondering if there were a way to export into SQL and then just use \. Database.sql to import it very quickly. I am worried that the exporter will mess up the file because it is so large. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Use of the MySQL logo - licensing agreement
Ed: I would hope that someone from MySQL AB will address this. It is particularly important to those of us who purchased blocks of licenses under TcX's OEM arrangement. We have an OEM agreement for another software product with a Canadian company. The written agreement is very simple, but grants us specific rights to use their logo and trademark. Compliance is easy, and we don't have to check with anybody. Gerald Jensen -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 6:38 AM To: Gerald R. Jensen; [EMAIL PROTECTED] Subject: RE: Use of the MySQL logo - licensing agreement This is just a WAG ... but do you suppose this is a result of the flap with NuSphere? I agree - but man, have they ever screwed it up for the rest of us! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Paris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: html
Theo: Yes ... MySQL doesn't really care much what the data is you are storing. The best source for info is the MySQL manual (link below) ... you probably want top look at storing data in either TEXT or BLOB fields. Gerald Jensen - Original Message - From: Theo Richel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 2:18 PM Subject: html Is it possible to store html in Mysql-fields? Where can I find more info in this? Thanks Theo Richel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proper Case NOT lower case
Keith: You want to RENAME tables where applicable, and ALTER the respective columns to the desired case. Both are done through queries. The MySQL Manual has detailed info on using these commands. Gerald Jensen - Original Message - From: Keith Spiller [EMAIL PROTECTED] To: Php-db [EMAIL PROTECTED] Cc: MySQL [EMAIL PROTECTED] Sent: Thursday, August 16, 2001 2:48 PM Subject: Opps: Proper Case NOT lower case -Opps: I meant to say I would like to convert to Proper Case, rather than lower case or UPPER CASE. I'm reading data from a mysql table that is entirely in uppercase letters. I'd very much like to convert them to Proper Case. After searching a while, I found that there is are php commands to convert text strings between upper and lower case, but I was unable to find anything that can convert to proper case. Does any one know of a way to do this, or a script that will accomplish it? Or, is there a mysql command that can handle the matter for me? Thanks, Keith - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: local MySQL server authenticating users by machine username
Bennett: Regardless of the login username / password, you have to GRANT user rights to create, alter, etc. in MySQL. By default, the root user has those rights, but not other users. Gerald Jensen - Original Message - From: Bennett Haselton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 4:50 PM Subject: local MySQL server authenticating users by machine username The first page of the MySQL tutorial at: http://www.mysql.com/doc/C/o/Connecting-disconnecting.html says that when you connect to the MySQL server, it authenticates you based on a username and password that you enter, unless the server is also configured to allow anonymous access, in which case you can log in with no username. Isn't it also true that if you connect to the MySQL server on your local machine, the server authenticates you based on the username that you're already logged in under? I'm just trying out the MySQL server on my machine, and when I'm logged to the machine as bhaselto and I invoke mysql (with no username or password on the command line), I get the mysql prompt, however I am not able to create new databases. However, if I quit mysql, then su to become root, and then invoke mysql again with no username/password arguments, when I get the mysql prompt I am able to create new databases. (If this is right, then should I send an update suggestion to the author of the http://www.mysql.com/doc/C/o/Connecting-disconnecting.html page? Is he or she on the list?) -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql and PHP
Matt: MySQL and PHP are both 'server-side' components, so there is no need to instal them locally (unless, of course, you want to do your development and testing off-line). If you are doing any significant level of PHP work, I would suggest installing a local version of both MySQL and PHP. I have local versions installed on both WinNT and Linux machines on the network ... everything gets tested on both platforms before it goes live. Gerald Jensen - Original Message - From: Matt Gaskin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 7:51 AM Subject: MySql and PHP Hi All Currently I have rented space on a Web Server that has MySql installed and PHP, They have created a database directory for myself. Do I need to install Mysql and PHP locally to take advantage of this. If so where do I start. I have had no experience of the above two products, although I have written a number of websites in HTML and a number of access databases. We have just started to get a number of enquiries for databases online and would like to develope in this area. Thanks M - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.org
Justin: Thanks ... but I couldn't care less. I have neither the time nor inclination to examine NuSphere's motives. I am a business man, and I made a business decision. Gerald Jensen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Justin Farnsworth Sent: Friday, July 13, 2001 7:49 AM To: Gerald R. Jensen Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mysql.org Gerald R. Jensen wrote: Monty: I was on the verge of authorizing the purchase of 3 copies of NuSphere's PHPEd package (US$300 each) for our developers when I became aware of the controversy surrounding 'Enhanced MySQL' and mysql.org. The purchase order went into the round file, and Hell will freeze over before I buy anything from NuSphere. A small gesture, perhaps, but an appropriate one. At least our company won't be contributing to their largess. Even people with such deplorable business ethics understand a loss of income from sales. [ snip, snip ===] Do not jump to the conclusion that I am starting out to be an apologist for NuSphere/Progress. It is wise to honor the old dictum Never ascribe malice to that which can be attributed to ignorance. I am not sure if this type of emotional leap is proper until a bit more information comes out and some of the heat dies down. There are always two sides to every situation. There are two issues, the domain mysql.org, and the other, more difficult to understand, the aspect of GPL violation. The domain/trademark issue will get settled by legal means and there is enough of a corpus of law precedent that a settlement and/or judgement will occur. I personally do not see such a great importance of mysql.org in this matter. Obviously, many of you on this list do not share this opinion. Now most of us in/using Open Source probably do not _really_ understand the meaning and ramifications of the GPL. We _think_ we know, and we certainly have a feeling about what the GPL means. Ironically, Richard Stallman's take is, in a legal sense, crystal clear compared with the GPL. NuSphere indicated that is was going to put their products under the GPL. They have indicated that Gemini will be GPL's. Are they to be punished for being late in doing so? NuSphere supports Open Source and is public on this position. The irony of this situation is that it _may_ be to the advantage of the Open Source community if NuSphere is not knee-jerked pilloried, and tarred and feathered out of the minds of the Open Source community. It is complete speculation upon my part that ultimately, MySQL will be replaced in all those embedded applications where Progress now sits. Though it may change in the near future, commercial developers needing an embedded database usually prefer a solution like Progress because of the Company-behind-it, rather than have MySQL. MySQL may/would gain credibility if Progress is replaced. Now, I hope this is all settled to everybody's benefit. It may not be possible because of emotion. But I know that I would personally like to see MySQL start to creep into large manufacturing management systems and other systems where Progress now has a significant hold. Then, and only then, will the community be able to easily tap into MySQL and offer better intranets, tools, and other solutions. So, I am suggesting to everyone to just wait and see. It might not be as bad as it seems... -- Justin Farnsworth - Technical Director Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: logs on nt4
Pete: Check the config file (C:\MY.CNF or C:\WINNT\MY.INI) ... you should see a line like: log=d:/mysql/mysql.log If the line if commented out (# log=d:/mysql/mysql.log), then logging is off. Remove the #, shutdown and restart the mysqld server. Gerald Jensen - Original Message - From: Pete Kuczynski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 4:45 PM Subject: logs on nt4 Hi, Where would I find the logs files from Mysql on a NT4 server? I have Nusphere Mysql installed with Apache/PHP and Mysql I monotor the Apache Error and Access logs, but should'nt there be logs generated by Mysql? I don't want to run out of disc space cause I neglected to clear them out. Thanks for any insight in advance! Pete -- ___ Pete Kuczynski Principal Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: convert an ms access database file
We haven't had a chance to test it yet, but the documentation for MySQL-Front (http://www.anse.de/mysqlfront/download.php) mentions a new feature which permits import of Access databases. MySQL-Front is a beta / free product at this point ... which we have foudn to very stable and very useful! Gerald Jensen - Original Message - From: Terrell Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 7:41 AM Subject: convert an ms access database file I need to convert an ms access database file to a mysql compatible pipe delimited database file. I downloaded a program to convert the database, but it needs to connect to the mysql server on my dedicated server. When I try to connect it says 'ipaddress.internetprovider' is not allowed to connect to this MySQL server. How can I use the GRANT/REVOKE command through mysql to grant myself access to it? - Sign up for ICQmail at http://www.icq.com/icqmail/signup.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I need to convert an ms access database file to a mysql compatible pipe delimited database file
Can you can connect to MySQL with PHPMyAdmin or DBTools? What application are you trying to use when you get the failure-to-connect message? Is the server physically located in your place, or out on the net? If you don't have administrative access (telnet, PHPAdmin, MySQLFront, etc.), you have no way to use the GRANT command to do anything with privileges. If your MySQL server is out on the web, someone (ISP?) with admin rights needs to lend a hand. G. Jensen - Original Message - From: Terrell Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 1:47 PM Subject: I need to convert an ms access database file to a mysql compatible pipe delimited database file Thanks, but I already have a program good enough called phpmyadmin and I need to use another program called dbtools. dbtools can connect to the mysql server and convert ms access files to pipe delimited text files. I just need to grant a user (myself) permission somehow to access the server. When I try to setup a connection to the mysql server it says 'myipaddress.myinternetprovider' is not allowed to connect to this MySQL server. How can I use the GRANT/REVOKE command or something else through mysql/putty to grant myself access to it? Any help is appreciated, thanks again - Sign up for ICQmail at http://www.icq.com/icqmail/signup.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: inserting a colum into a existing table
Marco: You want to use the ALTER TABLE command (http://www.mysql.com/doc/A/L/ALTER_TABLE.html) G Jensen - Original Message - From: Marco Kammerer [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 6:34 AM Subject: inserting a colum into a existing table Hello I am writing a programm in java that is checking my mysql db if everything is correct, so that I can you that db later in my java programm to write datas into it! I am fresh to mysql, but I got everything so fare, that the prog is able to make a no root user with the appr. rights, creates, drops db, creates tables, drops tables but i need one more thing! How can i add to an existing table - called t1 - in the database db1 some more columes? I just need the mysql syntax like it will be entered : local:~ # mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1617 to server version: 3.22.32 Type 'help' for help. mysql use db1; Database changed mysql show tables; +---+ | Tables in db1 | +---+ | t1 | +---+ 1 row in set (0.00 sec) mysql select * from t1; +---++ | id_t1 | t1_text| +---++ | 1 | NULL | +---++ 1 row in set (0.00 sec) mysql command to add colum for example t1_info! mysql select * from t1; +---+++ | id_t1 | t1_text| t1_text | +---+++ | 1 | NULL | NULL | +---+++ 1 row in set (0.00 sec) Sorry if this stuff is to easy for you, i am working hard to get better :-) Thanks Marco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL on Windows 2k
Daniel ... Make sure the path to C:\MYSQL\BIN (or wherever it is installed) is in the PATH environment variable (Settings - Control - System - Environment). Login as Administrator and edit the value for the path variable, set and apply ... your problems should be over! G. Jensen - Original Message - From: "Daniel J." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 22, 2001 11:20 AM Subject: MYSQL on Windows 2k I installed mysql as a service and it starts/stops fine, but whenever I try any commands starting with 'mysql' on the prompt it says it's an unrecognized command. Please help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: windows 2000
We run MySQL (3.22.32) on Windows 2000 servers, and have found that if we issue the NET STOP MYSQL command from the DOS Prompt, it does in fact shutdown the service ... it just takes much longer than on the WinNT platform. Patience is the key. Same with removing the installed service. In every instalaltion we have done, error 1067 always occurs when we issue a NET STOP MYSQL command - Original Message - From: "Andy J" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: "Micke Bjork Coolbase" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 9:59 AM Subject: Re: windows 2000 Micke Can't really speak for Professional but I have it running fine on Server and Advanced Server. If my memory is right then 1067 is normally that the service cannot respond to the control function effectively. Together with the fact that you cannot remove the service after uninstall, this suggests to me that the service is not being installed or initialised correctly on install of MySQL - not sure why, unless it is a Professional problem. Try using mysql command line to see if it will connect - a problem with BIND on NT used to give this 1067 error BUT the service was actually started and running OK despite it. Go figure! :-) You might try removing the following registry key to remove the service (then reboot, natch!):- HKLM\SYSTEM\CurrentControlSet\Services\MySQL See how that goes. Andy - Original Message - From: "Micke Bjork Coolbase" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 8:53 AM Subject: windows 2000 Hello, Im having a problem running MySQL on a Windows 2000 Professional plattform. There is no problem installing or uninstalling mysql, but you cant start MySQL or the MySQL service. In the service list a MySQl entry exist, but when Im tying to start it I get the erro 1067. It is imppossible ti remove the service also. It cant be removed event thoug I have uninstalled MySQL. How can I get MySQL running on Windows 2000? / Micke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Printed MySQL manual
Denis: I'm not sure you really want a printed MySQL manual ... the software is dynamic, and is constantly being upgraded. The online manual is updated frequently, and is closer to the software you may be using. As an alternative, I would suggest one of the fine books on MySQL. Our developers each have a copy of the Paul DuBois book ("MySQL" / New Riders) as well as the O'Reilly book "MySQL mSQL". Both are excellent learning and reference resources, and are invaluable in understanding and applying SQL syntax. G. Jensen - Original Message - From: "Denis L. Menezes" [EMAIL PROTECTED] To: "mysql list" [EMAIL PROTECTED] Sent: Monday, February 19, 2001 8:36 PM Subject: Printed MySQL manual Hello friends. Can anyone please advise how I can obtain a printed copy of the MYSQL manual? thank you. denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php