Suppression of result in SELECT @temp := column?
Is there any way to not sending the result of a user variable assignment to the client? I.e. Suppress the result of; SELECT @temp := columnID FROM table WHERE column = whatever LIMIT 0,1 ...since I only use @temp in my next statement to produce the actual result. Also, is there a equivalence to the MSSQL statement; SET NOCOUNT ON ...in MySQL, which suppresses the rows affected messages? Thanks! Jens Pettersson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A new Machine
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy bank and build a new linux mysql server. Here's my problem: I have, at present, two rather large databases. (A: 4Million records in one table, 15 Million in another; B: 1.5Million and 5Million) The databases are relatively static. That is, they they are updated by batch processes twice per year or so. They are realatively well normalized. (I'd say well, but that would be bragging. :) The business is a harvest type of operation, I ignore them for months then beat them to death for 120 days. I'm not rich, but what hardware and distro do you experts suggest? (My current Win2K server is a dual p3-650, 1gb with the databases on 2 36gb U160 10K drives. ) I've got no problem moving the drives out of that system (especially since I just bought a new one...)-- (I'd put my redhat 8 on it this afternoon, except it also runs my exchange server and that's a different migration...) sign me... Fed up at the Beach... [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
info
We have received your email, thank you. Normally it is our goal to respond to all of our email within 24 hours. Please insure that you have gone to our FAQ's page at: http://www.affordable-fuel-injection.com/fuel-injection-questions.htm for basic information on fuel injection. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: COBOL Syntax of calling MySQL's C API
I am COBOL illiterate. You could try passing hex zero 0x00 as NULL. I have no idea of the correct syntax for doing this in COBOL. Pat... - Original Message - From: Arunachalam [EMAIL PROTECTED] To: Patrick Sherrill [EMAIL PROTECTED] Cc: mySQL List [EMAIL PROTECTED] Sent: Friday, January 02, 2004 2:20 AM Subject: Re: COBOL Syntax of calling MySQL's C API When I change the value of fMySQLSocket to NULL i.e., 05 C-cMySQLSocketpic x(8). 88 fMySQLSocket value NULL. The compiler shows the following error; 219 E NULL initial value invalid for 'NULL' So how can I assign NULL to this condition name variable? suggest me pls... ragards Arun. --- Patrick Sherrill [EMAIL PROTECTED] wrote: BTW the error also indicates your client is trying to connect to the localhost i.e. the same machine you are connecting from. Try using the IP address of the server instead of the servername. This should also be a string (eg. 123.123.123.123). You most likely have a parameter/data type problem. The parameters being passed from your COBOL program, are not getting to the 'C' routine as the correct data types or parameters (remember NULL is not zero). Pat... - Original Message - From: Arunachalam [EMAIL PROTECTED] To: Patrick Sherrill [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 4:22 AM Subject: Re: COBOL Syntax of calling MySQL's C API hi, From COBOL I have tried to Connect to MySQL using the C API functions given by MySQL. Finally I struck up with the error during runtime as Can't connect to MySQL server on localhost (10061) I have a doubt Is, we have to start explicitly MySQL in the server machine? i.e., mysqld. If so with out start the mysqld in the server I can able to connect to the server using MySQLCC, is an utility tool provided by MySQL and MySQLExplorer is a free utility tool provided by ToolMagic softwares. More than this I can able to connect to MySQL server and fetch the data using simple C++ program using C API of MySQL. I believe, no one do start the MySQL in my server. I am running my application in Windows2000 machine (client), myserver is at Linux machine (server). So what I can to do?. Arun. --- Patrick Sherrill [EMAIL PROTECTED] wrote: Being COBOL illiterate, I may not be able to help. Two questions come to mind in reviewing the parameters you are passing. Are the parameters by reference passed as char-like pointers and the parameters by content passed as integers? If they are, then the only issue I see as a possibility is that 'fMySQLSocket' should be passed as NULL not 0. Also make sure mysqld is running on 'myserver'. I hope this helps... Pat... BTW replies to the list usually yield better results. - Original Message - From: Arunachalam [EMAIL PROTECTED] To: Patrick Sherrill [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 8:44 AM Subject: COBOL Syntax of calling MySQL's C API Hello Patrick, The actual calling routines in C is; MYSQL *mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned long client_flag) I have declared the variables with values are; 05 C-cMySQLHostName pic x(9). 88 fMySQLHostName value 'myserver'. 05 C-cMySQLUserIdpic x(4). 88 fMySQLUserId value 'arun'. 05 C-cMySQLPassword pic x(4). 88 fMySQLPassword value 'arun'. 05 C-cMySQLDBNamepic x(6). 88 fMySQLDBName value 'MyDBMS'. 05 C-cMySQLPort pic x(4). 88 fMySQLPort value '3306'. 05 C-cMySQLSocketpic x(8). 88 fMySQLSocket value '0'. 05 C-cMySQLFlag pic x(8). 88 fMySQLFlag value '0'. It's equivalent COBOL coding for the C coding syntax is; CALL C_mysql_real_connect using by reference E-ptrSQLConnect by reference C-cMySQLHostName by reference C-cMySQLUserId by reference C-cMySQLPassword by reference C-cMySQLDBName by content C-cMySQLPort by reference C-cMySQLSocket by content C-cMySQLFlag giving E-ptrSQLEnv I have tested that before reaching this Calling portion all the variables hold the values what I have set earlier. but after execution it stores the error as it's value (i.e., Can't connect to MySQL server on localhost (10061) ) and the pointer variable E_ptrSQLConnect hold value 0. Before invoking
Re: Bug in mysql.h header file
This is not a bug, you need to set your project/programming environment in VC++ to include support for sockets. I haven't written any non socket programs in several years, so it's part of my standard set-up. MySQL is client/server and uses sockets. You do need to link with a socket library. In the case of VC++ this is Winsock (wsock32.lib). I normally include support for sockets in my stdfx.h (#include afxsock.h // MFC socket extensions). This is included with your VC++ installation and not part of mysql source. Then, add wsock32.lib, mysqlclient.lib and any other external library you need to link with in your 'Project Settings'(Alt-F7'). These are added under the 'Link' tab in the 'Input' category. Libraries are added in the 'Object/library module' field separated by spaces (e.g. 'wsock32.lib mysqlclient.lib'). Don't forget to add the path to the mysqlclient library in the 'Additional library path:' field. Pat... - Original Message - From: P Arunachalam [EMAIL PROTECTED] To: Patrick Sherrill [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 6:36 AM Subject: Bug in mysql.h header file I was trying to establish connection to MySQL through a simple C program using it's C API mysqL_init(), mysql_reak_connect(), ... in VC++ Editor. It shows Errors ; Compiling... MYSQL.C c:\mysql\include\mysql_com.h(116) : error C2061: syntax error : identifier 'SOCKET' MYSQL.OBJ - 102 error(s), 1 warning(s) I have corrected this errors by including winsock.h header file into my program. After including winsock.h my program work fine and produce my expected results. Herewith I have included the Sample C Program too for your reference... Incase it is a bug you please produce the correct version of mysql.h header file to me. Thanks. regards, Arun. --- Patrick Sherrill [EMAIL PROTECTED] wrote: Statically linking using C API only you will need mysqlclient.lib For odbc interface you'll need to make odbc calls in your code and use myodbc.dll (Install myodbc on the client). You can mix calls, but why would you. I have found the C API to be the best solution for us. We statically link for dll avoidance. You can get the source or pre-built client libraries from the MySQL web site. I hope this helps. Pat... [EMAIL PROTECTED] CocoNet Corporation SW Florida's First ISP 825 SE 47th Terrace Cape Coral, FL 33904 - Original Message - From: P Arunachalam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 4:31 AM Subject: reg C API from MySQL Yahoo! India Mobile: Download the latest polyphonic ringtones. Go to http://in.mobile.yahoo.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: Field Name whitespace via MyODBC
Yes, if you are using v3.23.6 or above, ALTER TABLE on the command line should accept quoted column names to allow you to change the column names. Pat... - Original Message - From: Brian Duke [EMAIL PROTECTED] To: 'Patrick Sherrill' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 11:19 AM Subject: RE: Field Name whitespace via MyODBC I can just alter table to rename the fields right? -Original Message- From: Patrick Sherrill [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 5:27 AM To: Brian Duke; [EMAIL PROTECTED] Subject: Re: Field Name whitespace via MyODBC Brian, I think you are going to need to rename your fields/columns. If you are unable to rename them in mysql then you will probably need to rename them in your jet database with Access and re-import them. Your column names should be literals not wrapped in graves or quotes and should contain no whitespace. Whitespace is frequently used as a delimiter. I also avoid any characters other than alphanumeric and the occasional underscore character in field/column names . It helps avoid OS idiosyncrasies and simplifies naming conventions. I hope this helps. Pat... [EMAIL PROTECTED] CocoNet Corporation SW Florida's First ISP 825 SE 47th Terrace Cape Coral, FL 33904 - Original Message - From: Brian Duke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 2:50 AM Subject: Field Name whitespace via MyODBC On the windows machine I have Acess2003. I installed the MyODBC to push the data into the FreeBSD MySQL server. The connection worked like a dream. Kudos to the MyODBC team. The table that the connection created included field names that have spaces in the name. I'm trying to access the data thru my PHP scripts. I tried this: $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , `LERG_7_SHA.SHA INDICATOR` , `LERG_7_SHA.H ORG B TDM` FROM LERG_7_SHA WHERE ( LERG_7_SHA.SWITCH = \$npa\ AND `LERG_7_SHA.SHA INDICATOR` = \$nxx\ ) LIMIT 0, 30; And $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , \'LERG_7_SHA.SHA INDICATOR\' , \'LERG_7_SHA.H ORG B TDM\' ,\'LERG_7_SHA.H ORG C TDM\' , LERG_7_SHA.HOST , LERG_7_SHA.OCN , LERG_7_SHA.AOCN FROM LERG_7_SHA WHERE (LERG_7_SHA.SWITCH = \$npa\ AND \'LERG_7_SHA.SHA_INDICATOR\' = \$nxx\ ) LIMIT 0, 30; Both do not work. The query breaks down where the backticks are or tries to add the literal string of 'LERG_7_SHA.SHA INDICATOR' in the result data. I have tried with single quotes and double quotes. I can issue this command on the mysql command line and it does work. Can someone help me syntax this line correct? The script.php and the database are on the same FreeBSD machine. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: msaccess frontend
There are many tools in the contributions section to manipulate a mysql database without the need to resort to Access and odbc. What do you need to do? Pat... - Original Message - From: Colleen Dick [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, October 18, 2003 11:42 AM Subject: msaccess frontend Have anybody ever set up MS Access as a frontend to mysql? the dB is an already established mysql db running on linux I don't want to convert it, just use access to get to it. I have followed the recipe at http://www.washington.edu/computing/web/publishing/mysql-access.html I can see the tables so I know I'm connecting and the linkage is working. I understand that access has issues with enums, so I made a really simple test table with just an auto_inc key and a VARCHAR. When I double click that table icon (it's a globe icon) I get Reserve Error -1104. Would it be better to just redo all the tables from access in the first place? This database isn't huge. Thanks... -- 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: Re: My details [INF2003082300000269]
Thanks for writing to [EMAIL PROTECTED] This is an auto-generated response to let you know that your message has reached our general information box on 8/23/2003 at 5:38:55 AM. Customer Service will be processing and, if necessary, responding to your inquiry shortly. We usually reply to general inquiries within one business day and appreciate your patience. There is no need to respond to this message, but if your message was concerning a technical support issue, a sales-related question, or beta product, there is a more direct and quicker way of contacting the appropriate SoftArtisans personnel--please see below. -- SoftArtisans Technical Support, Sales, and Beta Mailboxes -- Occasionally, our general information box receives messages that are more appropriate for another mailbox. For faster service, please consider resending your message directly to one of the follwing: For free technical support issues, please send your message directly to: [EMAIL PROTECTED] For a sales consultation, quote request, or other sales-related question, please send your message directly to: [EMAIL PROTECTED] For comments, feedback, or questions regarding our beta products, please send your message directly to: [EMAIL PROTECTED] If this is an urgent technical support problem and you require a guaranteed response time, SoftArtisans offers two levels of paid technical support: PRIORITY SUPPORT. Guaranteed response within two business hours of placing your call or sending your e-mail. There is no guarantee that we'll be able to provide an immediate resolution of your problem, but we will work on it until we can come to a conclusion. We will always provide you an expected date to issue you a patch if necessary. Please see instructions at: http://www.softartisans.com/softartisans/priorsup.html PER-INCIDENT SUPPORT. Guaranteed response within one business day of placing your call or sending your e-mail. There is no guarantee that we?ll be able to provide an immediate resolution of your problem, but we will work on it until we can come to a conclusion. If you would like to use a Per-incident technical support that was packaged with a product purchase (such as ASPStudio with Annual Maintenance), please call with your order number. Otherwise, please see instructions at: http://www.softartisans.com/softartisans/persup.html - Tracking Your General Information Request - Every incoming email is assigned a unique tracking number. Your tracking number is: [INF200308230269] In order to help us track the progress of request, please include [INF200308230269] in the subject line of any further mail regarding this issue. - SOFTARTISANS HOURS OF OPERATION - Monday through Friday, 9:00 a.m. to 5:00 p.m. Eastern Time (GMT-5) We look forward to reading your message and will respond as quickly as possible. Thanks. Sincerely, SoftArtisans Customer Service http://www.softartisans.com P.S. Please stay in touch! The SoftArtisans monthly newsletter is filled with helpful product information, upgrade notices and ASP tips. Please visit http://discuss.softartisans.com/cgi-bin/wa.exe?SUBED1=newsletterA=1 if you would like to receive or stop receiving the newsletter. You are currently subscribed to the newsletter as [EMAIL PROTECTED] SoftArtisans respects your privacy and will not sell or rent personally identifiable information to anyone. Our privacy policy is posted at http://www.softartisans.com/softartisans/privacypolicy.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[kapper.net #16695] Re: Another Replication Problem
Hallo User, diese eMail wurde automatisch als Antwort auf Deine Nachricht generiert und bestaetigt Dir die Uebernahme in unser Bearbeitungssystem. Wir werden schnellstmoeglich antworten. Bitte ein wenig Geduld, wir vergessen niemanden. Solltest Du Information sofort benoetigen, rufe uns bitte an. Bitte behalte diese Ticket-ID im Betreff der eMail bei: [kapper.net #16695] nur so ist unsere Korrespondenz eindeutig für alle beteiligten nachvollziehbar. Danke für Dein Interesse, die kapper.net::verwaltung ;-) [EMAIL PROTECTED] - Hi User, this email is an automatically generated reply that confirms the receipt of your mesage and tells you we're already working on your request now. We will respond ASAP, please give us a little time. If you need your information right now, please call us and let us know. Please do also keep this messages Ticket-ID in the subject for further emails: [kapper.net #16695] only this makes sure our communication is as accurate as possible. Thank you for talking to us, the kapper.net::administration ;-) [EMAIL PROTECTED] [...deutsche version am beginn...] -- 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 stops processing
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql stops processing
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: two masters replicating to a single slave
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: two masters replicating to a single slave
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB locking: Different behavior on 3.23.55 and 4.0.13
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB locking: Different behavior on 3.23.55 and 4.0.13
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with MySQL, Windows 2003, IIS6, ASP?
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with DELETE and a subquery
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems with MySQL, Windows 2003, IIS6, ASP?
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Function to extract difference in Minutes from DateTime variables
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Function to extract difference in Minutes from DateTime variables
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Help...
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Help...
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql setup problem
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access Denied
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select part of a field into another field
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select part of a field into another field
Estoy tomando el sol . q -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RedHat 8 and mysql-server-3.23.52-3
I have a RH 7.1 system that is fully patched and it happens to me as well. What is the fix? I am using RH provided binary RPMs so am at mysql-server-3.23.36-1 . Thanks, Tom Egor Egorov wrote: Nicholas, Tuesday, October 22, 2002, 10:11:52 AM, you wrote: NC I have recently installed RedHat 8 and the following RPMs: NC [root@chimp etc]# rpm -q mysql NC mysql-3.23.52-3 NC [root@chimp etc]# rpm -q mysql-server NC mysql-server-3.23.52-3 NC I am having problems connecting to the server remotely through the TCP NC connection, the firewall is completely disabled: NC njc2@hilton njc2/mysql/bin mysqladmin -h chimp.battlemonkey.net -p NC version NC Enter password: NC mysqladmin: connect to server at 'chimp.battlemonkey.net' failed NC error: 'Lost connection to MySQL server during query' Nicholas, it's a well known issue. It happens because of buggy glibc. - 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: Connectiva 7.0
Before you do that. Try: mysql -u root -p mysql And put in your root password (when prompted) for the machine. The Connectiva installation may have initialized the mysql database with the machine's root password. If so follow the docs to change that, as it is not a good security measure to have services share the root passwd. Also, if that does not work then dig around for the script that initializes the mysql db and see if the mysql root password is in there. Better to try a few things before you go and reinstall. Tom Silmara wrote: Linux Connectiva is one Brazilian version of Linux and when I installed Connectiva in the full installation, the MySQL was installed too. Maybe, I will need to install again. Yesterday I tried, but I think I need to unistalling the MySQL. How I do it? - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Silmara [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 12:11 PM Subject: Re: Connectiva 7.0 What is Linux Connectiva 7.0, what is the default installation of MySQL, and where did you get it? Silmara wrote: I have an installation of Linux Connectiva 7.0 with the default installation of MySQL. I stated MySQL but I can't connect to DataBase. mysql -u root mysql Access denied to 'root@localhost' (Using Password NO) What's wrong? - 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 - 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: RedHat 8 and mysql-server-3.23.52-3
Got it. It is --skip-name-resolve and that worked around the problem. What should I be on the lookout for to get a real fix? Will there be a patch/update/etc for glibc from RH or is there something that the mysql dev team is coming up with? Thanks, Tom Egor Egorov wrote: Terra, Tuesday, October 22, 2002, 1:44:45 PM, you wrote: TI I have a RH 7.1 system that is fully patched and it happens to me as TI well. What is the fix? I am using RH provided binary RPMs so am at TI mysql-server-3.23.36-1 . Temporary solutions: - downgrade glibc; - run nscd; - run MySQL server with --skip-name-resolving option - 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: RedHat 8 and mysql-server-3.23.52-3
PS: mysqladmin does not output this option as one of the available options. [root@terra]# mysqladmin -p variables | grep skip Enter password: | skip_locking| ON | | skip_networking | OFF | | skip_show_database | OFF Terra Info wrote: Got it. It is --skip-name-resolve and that worked around the problem. What should I be on the lookout for to get a real fix? Will there be a patch/update/etc for glibc from RH or is there something that the mysql dev team is coming up with? Thanks, Tom Egor Egorov wrote: Terra, Tuesday, October 22, 2002, 1:44:45 PM, you wrote: TI I have a RH 7.1 system that is fully patched and it happens to me as TI well. What is the fix? I am using RH provided binary RPMs so am at TI mysql-server-3.23.36-1 . Temporary solutions: - downgrade glibc; - run nscd; - run MySQL server with --skip-name-resolving option - 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: creating database
sql,query How can i have each users database to be stored in it's home dir ? - 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
creating database
As i selling web hosting with mysql as a package, and i like to restrict on the amount of space used. I had setup quotas on the plans. How can i create databases to the user's account, home dir, so that the customer can check his quota. Or how should i go about restricting? 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
mysql - problem with timeout
hello ... first excuse my bad english ;-( we have a problem . one of our servers is working with the following components and configuration: linux suse 7.1 mysql 3.23.33 phpadmin 2.2.5 webmin 0,90 our problem . we work with a few databases in mysql ... often when we start more than (perhaps) hundred search-queries with a perlscript, whitch will show an output of the mysql-database, there is the problem, that mysql dont close the query-connection. many people said to us, there must be a chance to configure mysql so, that mysql will close a search-connection after ** seconds our question: whe will we configure mysql, that we will set a timeout for queries and connections? must it be in the perl-scripts or can we do this on the server with our webmin-tool? please . help us with a good documentation from youreself . maybe in german language?! thanks a lot . guenter m. schmitt koeln - deutschland - 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
Updated: Lost data problem Was: Corrupt .FRM files
Hi all, Some days ago (March 11) permissions were broken in catalogue of the mySQL database. Even though the permissions were not correct any more, MySQL continued to work. We think MySQL started to work with cache (with image of tables in RAM...) instead and all this time our backup system made copies automatically from HDD (not from RAM) which means that it backed up the same file all the time! On April 4th the server and Mysql were restarted and permissions were corrected at that time. Mysql then took the data from HDD and started to work with database from March 11th. As a result we have a current backup copy now. Is there any way to recover the data that used to be stored in RAM (maybe stored in some kind of cache file on the server)? Hopefully someone has an idea on what can be done! Best regards, Andreas - 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
corrupt .FRM files?
Yesterday we discovered a strange problem with our database running on MySQL version 3.23.45 on a Linux OS version 2.2.16 The MySQL database had been running perfectly with a PHP interface on the web since january 30th and records were added normaly. Now suddenly the MySQL server is brought back into the state of March 11th, which means that all data since then are not shown. It seems that there is a problem with the permission to files of DB. there a solution on how we can fix or repair DB - files? Also does anyone have ideas on what might have happened. Thank you very much in advance! Best regards, Andreas http://www.dancegrooves.com Your dance music source on the internet! Dance Grooves Draadbaan 37 A 2352 BM Leiderdorp The Netherlands Phone: (+31)-(0)71-54 23 676 Fax: (+31)-(0)71-54 23 678 - 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
WebStream Announces move into the WebCasting arena
This is an Official WebStream Press Release Release date: January 25, 2002 For more information contact: Crawford Grimsley, Vice President of WebCasting Services [EMAIL PROTECTED] 954-730-7127 Ext. 217 WebStream Announces move into the WebCasting arena FOR IMMEDIATE RELEASE WebStream Internet Solutions (http://www.webstream.net), a leading provider of comprehensive business Internet services, announces the creation and launch of its new WebCasting Division. In conjunction, WebStream also announces the appointment of Mr. Crawford Grimsley to the position of Vice President of WebCasting Services. Mr. Grimsley is a two-time Heavyweight Boxing Champion and veteran of the WebCasting business. Mr. Grimsley was responsible for the creation of Boxing Line and ProWebCast, two early leaders in pioneering this still new field. Since partnering with WebStream in 1998, Mr. Grimsley has successfully produced live audience WebCasts for The American Comedy Awards, The Essence Awards, Miss Hawaiian Tropic, Victoria's Secret, The Cannes Film Festival, The Sundance Film Festival, many main boxing events and top name venues worldwide. In joining WebStream as head of the new division, Mr. Grimsley will be responsible for the creation and integration of business-to-business WebCast services with WebStream's already existing applications and services. WebCasting services that WebStream is now offering are video hosting and encoding, live WebCasting, on-line training, on-line seminars and video conferencing. All services are available through WebStream's multi-media collaboration tool, or WebPlayer (http://player.webstream.net). WebStream's WebCast Services provide corporations large and small, tremendous cost savings by streaming content on-line as opposed to conventional methods of training employees or communicating with clients and prospects. WebStream's state-of-the-art network is based on an OC-12 fiber redundant backbone provisioned by UUNet with additional gigabit fiber connectivity provided by Yipes Communications. Founded in 1997, with headquarters in Fort Lauderdale, WebStream Internet Solutions is a premier web hosting company and a leading provider of comprehensive business Internet services, with an emphasis on serving the business-to-business market in more than 120 countries and every U.S. State. WebStream Internet Solutions (http://www.webstream.net) offers a wide range of Internet solutions, including high-speed Web hosting, co-location services, E-commerce, WebCasting, Web design/programming services and traffic generation. --30-- Would you like to un-subscribe from this mailing list? If so, please click : http://demo.webstream.net/optout/optout.cfm?email=mysql%40lists%2Emysql%2Ecommailgroup=Global If the above link is not available, cut and paste this into your browser window. - 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
Internet Usage Surging and Outsourcing Web Hosting Saves Millions!
It's been a hot summer indeed, not only for the weatherman, but for Internet folks as well. The latest round of economic warnings come at a time when everyone has been once again scared by the media. Don't believe all the hype that you hear on the news. As a matter of fact, a surprising new study by an Internet pioneer has found that Internet traffic has grown faster than ever in recent months, contradicting widely held views that Internet growth has slowed. Dr. Lawrence Roberts of Caspian Networks says his new research is based upon actual scientific data, rather than on the financial performance of equipment vendors. As a leader of the team that developed ARPANET, which evolved into the modern Internet, Roberts says he was able to gain unusual access to top scientists at leading carriers. By signing non-disclosure agreements with the top 19 carriers, Roberts' team was able to access information about their network topologies and traffic. Network traffic was sampled in April and October of 2000 and April of 2001. Roberts said his data for that 12-month period shows that traffic has been doubling every six months on average across core IP service providers' networks. That equates to an annual growth rate of about 400 PERCENT. In other news, IN-HOUSE WEB HOSTING is on its way out, according to a recent report by Jupiter Media Metrix, as U.S. companies discover that they can save big bucks and potential time and money-eating errors by outsourcing Web-hosting tasks. Currently, 34 percent of U.S. companies handle hosting internally and another 24 percent manage their applications internally but outsource server management. Many companies have opted for in-house hosting due to security concerns, control issues, and customer service and confidentiality issues, according to Jupiter. The problem is that companies overestimate the competitive advantages of in-house Web hosting and fail to see the possible cost reductions that come with outsourcing the service, Jupiter reported. U.S. companies with in-house Web hosting spend more on staffing and technology than they would if they outsourced these functions, saving 30 percent to 40 percent of their Web-hosting costs, according to the researcher. The cost-reducing benefits of outsourcing are most apparent in companies with mid- to high-traffic sites, Jupiter said. Over three years, a company with a staff of 18 people to 25 people would pay three times more per year than it would to outsource the activity. In addition to paying too much for Web hosting, companies perform other Web hosting blunders such as initiating Web projects before their site hosting and technology infrastructure design is built, Jupiter said. Eighty percent of companies jump the gun on their Web development projects, Jupiter said, and due to this lack of planning, nine out of 10 of these ventures will incur some avoidable rebuilding. Jupiter recommends that companies undertake infrastructure design in tandem with first-stage application planning and development. If this precaution is not taken, companies risk exceeding their scalability limits and may have to shift into crisis mode, incurring sky-high hosting costs, the researcher reported. By choosing a technology infrastructure provider simultaneously with an application developer, companies can cut implementation delays by 25 percent to 30 percent, Jupiter reported. When selecting for a Web hosting provider, companies should look for reliability, scalability, security, a proven track record, accountability, response speed, and customer service, the researcher suggested. After all, according to Jupiter, slimming down a company's in-house Web hosting could fatten up its bank account in the long run. If you would like to find out how we have been helping businesses small and large to save money by outsourcing your web services, contact one of our Account Representatives today. Since 1997, WebStream has proven to be a reliable solution. Sincerely, Jason Edwards Director of Promotions WebStream Internet Solutions [EMAIL PROTECTED] http://www.webstream.net/ (888) 932-2333 Toll-Free (954) 730-7127 Local (954) 733-7067 Fax (954) 730-7405 Help Desk Would you like to un-subscribe from this mailing list? If so, please click : http://demo.webstream.net/optout/optout.cfm?email=mysql%40lists%2Emysql%2Ecommailgroup=GlobalBusiness If the above link is not available, cut and paste this into your browser window. - 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:
WebStream Internet Solutions Signs Contract With Broward Alliance
This is an Official WebStream Press Release Release date: August 23, 2001 For more information contact: Gary Lee at 888-932-2333 WebStream Internet Solutions Signs Contract With Broward Alliance FOR IMMEDIATE RELEASE Fort Lauderdale, FL - August 23, 2001 - WebStream Internet Solutions has signed a three-year contract with The Broward Alliance, one of the nation's premier economic development organizations, to expand and host their web site. The new web site will serve as a source for information on business expansion and relocation, film/TV production, workforce education, minority business development, and site location assistance in Broward County, Florida. WebStream is under contract to develop the new Broward Alliance web site and will now continue to also host the site, which is popular with companies seeking to expand into the Greater Fort Lauderdale, Florida area. For more information on The Broward Alliance, point your browser to web site address http://www.browardalliance.org/. We look forward to working with WebStream on the Alliance's new site, said Yvonne Lopez, Broward Alliance Vice President of Communications. Their quality of work and creative talents will be showcased around the world as we brand Broward County as an international business center. Since 1997, WebStream Internet Solutions has developed and hosted web sites in over 110 countries. Among the successful Internet sites WebStream has launched and is hosting are CBS Records, Don King Productions, SurplusBid and Evander Holyfield. For a more in-depth look at WebStream clients, visit the web address http://www.webstream.net/. WebStream has become a leader in the Internet industry due to its commitment to customer support and dedication to developing quality web sites. With a unique seasoned combination of designers and programmers, WebStream creates web sites that fit the needs of both large companies and small organizations. With an enthusiastic attitude about transforming the way e-business gets done, we strive to improve the online presence of each of our clients, said WebStream CEO Kerry Brewer. We use our years of experience, creativity and technological expertise to design and build powerful web sites. WebStream has developed an outstanding reputation for providing solutions for interactive learning, online brand building, business design, revenue management, online payment processing and customer relationship management. WebStream has become one of the nation's leading providers of comprehensive business Internet services due to its loyal client roster. P.S. Have you tried our SiteBuilder yet? If not, then go to http://sitebuilder.webstream.net/ to find out how easy it is to build your own web site in minutes with fun and ease! ==30== Would you like to un-subscribe from this mailing list? If so, please click here: http://demo.webstream.net/optout/optout.cfm?email=mysql%40lists%2Emysql%2Ecommailgroup=GlobalBusiness If the above link is not available, cut and paste this into your browser window. - 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
full text indexes
Hi, I am facing aproblem in full text index catalog. I have uploaded tables using sql server 7 from client to server having database mysql server. I am finding that while connecting to the server the full text index feature becomes inactive, though on client machine it is active. Now I am not able to define full text index. Your guidance to this regard shall be appreciable. Bye for now, Atul Soni - 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