does MySql Supports shared Objects
hi! Dynamic shared objects could enable user written code to be integrated with the server at run time! . Does MySql support shared objects, since MySql is an open source database i believe it can support DSO. If its not true is there any alternative! Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: does MySql Supports shared Objects
In the last episode (Jun 20), Prem Soman said: hi! Dynamic shared objects could enable user written code to be integrated with the server at run time! . Does MySql support shared objects, since MySql is an open source database i believe it can support DSO. Yes, they're called User Defined Functions (UDF) in the manual. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connecting ASP
Hi, Im hosting a website in a Linux server. By now Im learning PHP and its amazing. How ever I need to create a online system and meanwhile Ill to do it in ASP (which I already handle). My host gives me MySQL and I use it ok. Now, what Ill like to do is to know how to connect my ASP page to a MySQL database? I can do it in my Win32 PC, but with MyODBC. So, how can I do it? Hope somebody helps me. Thanks
MySQL/InnoDB-3.23.57 is released
Hi! InnoDB is a MySQL table type which supports transactions, foreign keys, and a non-free hot backup tool. InnoDB is included in MySQL-Max-3.23 and in all downloads of MySQL-4.0 and MySQL-4.1. You can download all of these from http://www.mysql.com. 3.23.57 is a bugfix release of the old stable 3.23 branch. For production use I consider 4.0.13 already better than 3.23 branch versions. See http://www.innodb.com/ibman.html. Changelog: * Fixed a bug: InnoDB forgot to call pthread_mutex_destroy() when a table was dropped. That could cause memory leakage on FreeBSD and other non-Linux Unixes. * Fixed a bug: MySQL could erroneously return 'Empty set' if InnoDB estimated an index range size to 0 records though the range was not empty; MySQL also failed to do the next-key locking in the case of an empty index range. * Fixed a bug: GROUP BY and DISTINCT could treat NULL values inequal. The following bug fixes did not make it to 3.23.57 but will appear in 3.23.58: * An outstanding bug: InnoDB could make the index page directory corrupt in the first B-tree page splits after mysqld startup. A symptom would be an assertion in page0page.c, in function page_dir_find_slot(). * An outstanding bug: InnoDB could in rare cases return an extraneous row if a rollback, purge, and a SELECT coincided. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL/InnoDB-3.23.57 is released
Hi! The following essential change was forgotten from the changelog of 3.23.57 below, though it is listed in the MySQL-3.23.57 changelog: * Changed the default value of innodb_flush_log_at_trx_commit from 0 to 1. If you have not specified it explicitly in your my.cnf, and your application runs much slower with this new release, it is because the value 1 causes a log flush to disk at each transaction commit. Best regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 20, 2003 10:49 AM Subject: MySQL/InnoDB-3.23.57 is released Hi! InnoDB is a MySQL table type which supports transactions, foreign keys, and a non-free hot backup tool. InnoDB is included in MySQL-Max-3.23 and in all downloads of MySQL-4.0 and MySQL-4.1. You can download all of these from http://www.mysql.com. 3.23.57 is a bugfix release of the old stable 3.23 branch. For production use I consider 4.0.13 already better than 3.23 branch versions. See http://www.innodb.com/ibman.html. Changelog: * Fixed a bug: InnoDB forgot to call pthread_mutex_destroy() when a table was dropped. That could cause memory leakage on FreeBSD and other non-Linux Unixes. * Fixed a bug: MySQL could erroneously return 'Empty set' if InnoDB estimated an index range size to 0 records though the range was not empty; MySQL also failed to do the next-key locking in the case of an empty index range. * Fixed a bug: GROUP BY and DISTINCT could treat NULL values inequal. The following bug fixes did not make it to 3.23.57 but will appear in 3.23.58: * An outstanding bug: InnoDB could make the index page directory corrupt in the first B-tree page splits after mysqld startup. A symptom would be an assertion in page0page.c, in function page_dir_find_slot(). * An outstanding bug: InnoDB could in rare cases return an extraneous row if a rollback, purge, and a SELECT coincided. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB file size...
I am currently working on some experiments and have to deal with some millions of tuples. As you can imagine indexing is essentiall. However My InnoDB file has grown to over 3.6G and fragmentation is sometimes a big problem. Additionally the file keeps its size even after dropping the 'big' tables. So, any suggestions in order to optimize the space usage? thanx in advance aik_b
extending MySql
thank u nelson! that was very useful for me. can these UDF's provide a better way to access the sever specific information such as the date and number of times the server was restarted Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/yyyy') ?
Hi everybody, Is there any function like Oracle TO_DATE in order to insert a date into a DATE type field according to a different format than -mm-dd? I wish to insert a date into a date field but my date format is dd/mm/. If not, is there any workaround using mysql functions? AFAIK mysql reference does not mention this... Thanks, Marc Pomar _ Dale rienda suelta a tu tiempo libre. Encuentra mil ideas para exprimir tu ocio con MSN Entretenimiento. http://entretenimiento.msn.es/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/yyyy') ?
use DATE_FORMAT(date, format) e.g: DATE_FORMAT(1999-12-01, %M %e, %Y) - December 1, 1999 *taken from Paul Dubois MySQL book BRgds, -- Richard Bornay Test Data Managment ST Assembly Test Services 6824-1367 Marcos Pomar [EMAIL PROTECTED]20/06/2003 05:36 PM To: [EMAIL PROTECTED] cc: (bcc: BORNAY Richard/Engr/STATS/ST Group) Subject: Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/') ? Hi everybody, Is there any function like Oracle TO_DATE in order to insert a date into a DATE type field according to a different format than -mm-dd? I wish to insert a date into a date field but my date format is dd/mm/. If not, is there any workaround using mysql functions? AFAIK mysql reference does not mention this... Thanks, Marc Pomar _ Dale rienda suelta a tu tiempo libre. Encuentra mil ideas para exprimir tu ocio con MSN Entretenimiento. http://entretenimiento.msn.es/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/yyyy' ) ? sql
Hi Marcos, you can use simple string-functions to manage this. For example: dd/mm/ - -mm-dd CONCAT_WS('-',RIGHT('dd/mm/',4),SUBSTRING('dd/mm/',4,2),LEFT('dd/mm/',2)) CONCAT_WS(separator, string_1 ,string_2 ...)puts strings together with separato RIGTH(string,N) gives the first N chars of string LEFT(string,N) gives the last N chars of string SUBSTRING(string,pos,N) gives N chars of string from pos prosit Klaus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Validate Table Structure With XML Structure
I have created tables in a MySQL Database for importing data from an XML file. My aim is to have MySQL table structures that correspond accurately with the XML structure. What are the available ways to validate the two structures or create the first structure from the second? Also: From a proper Database-Design point of view: Do I design the MySQL Database first and then design the XML/Schema afterwards or vice versa? This message and any attachments are confidential and intended solely for the addressee. Any unauthorized use, alteration or dissemination is prohibited. Lawyers Access Web (Pty) Ltd. accepts no liability whatsoever for any loss, whether it be direct, indirect or consequential, arising from information made available and actions resulting there from.
search and replace.
Is there is a way to do a search and replace on the mysql cmd prompt? I want to replace text in about 20 rows that has the same pattern with a replacement. I have a table that has a column 'name' and a column 'url' which holds menu items for a website. Both columns are type varchar. 'url' has about 20 rows starting with 'disciplines/someurl' and I want to replace 'disciplines' with 'programs'. Is there a way to do this in mysql? I know I can do it in php, but it would be cool to do it, (and probably faster) to do it in mysql. I know how do use the regexp for SEARCHING, but can I do a replace on the same cmd with an UPDATE? thanks in advance, Craig. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: search and replace.
Try something like this: UPDATE tablename SET url = concat(programs, substring(url,12)) where url like (disciplines/%); Andy -Original Message- From: Craig Harding [mailto:[EMAIL PROTECTED] Sent: 20 June 2003 17:31 To: [EMAIL PROTECTED] Subject: search and replace. Is there is a way to do a search and replace on the mysql cmd prompt? I want to replace text in about 20 rows that has the same pattern with a replacement. I have a table that has a column 'name' and a column 'url' which holds menu items for a website. Both columns are type varchar. 'url' has about 20 rows starting with 'disciplines/someurl' and I want to replace 'disciplines' with 'programs'. Is there a way to do this in mysql? I know I can do it in php, but it would be cool to do it, (and probably faster) to do it in mysql. I know how do use the regexp for SEARCHING, but can I do a replace on the same cmd with an UPDATE? thanks in advance, Craig. -- 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: wierd sort query, how do you do it? (sort by ip proximity guess)
select 8 ^ 5; ERROR 1064: You have an error in your SQL syntax near '^ 5' at line 1 i'm guessing that this means mysql 3.23 doesn't have the xor. On Thursday 19 June 2003 11:52, Nicholas Elliott wrote: Remember that this is a binary XOR, not a logical XOR. Mysql does have a binary XOR operator, the '^' operator. So 'ipAddress1 ^ ipAddress2' is the binary XOR between the two values. The binary AND is the '' operator and the binary OR is the '|'. Just don't confuse them with the AND operator and/or the OR operator. Got all that? =) Nick Elliott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: extending MySql
In the last episode (Jun 20), Prem Soman said: that was very useful for me. can these UDF's provide a better way to access the sever specific information such as the date and number of times the server was restarted The server does not know how many times it has been restarted. You can easily enough write a wrapper script that keeps count, though. As for the date, just call gettimeofday() or time() from C, or SELECT NOW() from MySQL. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with compiling MySQL 3.23.56 on FreeBSD
I try install MySQL 3.23.56 from sources on my FreeBSD 4.8-STABLE configure (./configure --enable-assembler --with-innodb) works fine, but when I say make, I get next error : -- Making all in extra /usr/local/bin/bash ../libtool --mode=link c -O3 -DDBUG_OFF -DHAVE_BROKEN_R EALPATH-o resolveip resolveip.o ../mysys/libmysys.a ../dbug/libdbug.a ../s trings/libmystrings.a -lz -lcrypt -lm -pthread gcc -O3 -DDBUG_OFF -DHAVE_BROKEN_REALPATH -o resolveip resolveip.o -pthread ../ mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lz -lcrypt -lm resolveip.o: In function `main': resolveip.o(.text+0x351): undefined reference to `__h_errno' *** Error code 1 Stop in /usr/home/admin/soft/mysql-3.23.56/extra. *** Error code 1 Stop in /usr/home/admin/soft/mysql-3.23.56. *** Error code 1 Stop in /usr/home/admin/soft/mysql-3.23.56. --- whats problem ? WBR, Mike. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
odd Date
Hi: I have the following problem: When I insert a date in my table, and after do the insert I select the column date to see if the date is right but it displays the date like follows: 2019-06-20 When the original insert is: 2003-06-19 I looked into the manual to figure out how mysql works with date types, and I didn't find anything. I hope that someone knows or someone has had a similar problem. Regards _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: wierd sort query, how do you do it? (sort by ip proximity guess)
On Fri, Jun 20, 2003 at 09:09:50AM -0500, Ray wrote: select 8 ^ 5; ERROR 1064: You have an error in your SQL syntax near '^ 5' at line 1 i'm guessing that this means mysql 3.23 doesn't have the xor. It was added in 4.0.2 according to the docs. Try this: mysql select version(); +-+ | version() | +-+ | 3.23.52-log | +-+ 1 row in set (0.00 sec) mysql select (5 | 8) ~(5 8); ++ | (5 | 8) ~(5 8) | ++ | 13 | ++ 1 row in set (0.00 sec) mysql select (5 | 7) ~(5 7); ++ | (5 | 7) ~(5 7) | ++ | 2 | ++ 1 row in set (0.00 sec) mysql Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: SQL query question
Rolf, You need to separate your functions. You are adding complexity to your world by storing irrelvant infromation in your database. Critical Data Handling (in a proper world) is ALWAYS handled separately from display. So in your example, You are storing all the html display formatting in your database. Bad idea. Not only does it complicate your SQL like you have found out... but selecting something that your looking for becomes unreadable. You should do the following. 1) Add a simple index to your table... i.e. an ever increasing number... that will always be unique to the line. Either that, or a short name that describes the line that you're looking for 2) Alter your database table to only store the critical information. Such as... ftp://cc278355-a.groni1.gr.home.nl/c64/games/--- The URL that alters.. --- The Filename --- The URLDesc --- The desc Then In the ASP, you say Select * from table1 WHERE (Either unique ID = X) or ( ShortName = 'GameName1' ); Then when you get the recordset out you handle it in asp with... % // Start ASPN insert data inline...% HTML FORMATTING HERE %=RS.(URL)% MORE HTML STUFF HERE LIKE P and FONT and ALIGN %=URLDESC% Etc Etc That would be proper programming form... Did that make sense? -Original Message- From: Rolf C [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:57 PM To: [EMAIL PROTECTED] Subject: SQL query question Hello all, I am a totally newby to MYSQL but here i go. I want to create an ASP page that shows an image (screendump of game) a game name a game description and an url. I created a database with the following table: filename, urldesc, desc Now i have to create an SQL query that will put this information in a webpage: this is what i got. SELECT ' img border=0 src=' filename '.gif /p td a href=ftp://cc278355-a.groni1.gr.home.nl/c64/games/' filename '.zip ' urldesc '/a td p ' desc ' /p td ' FROM table1; The zip file for the download and the gif file for the image have the same filename exept the extention. It nearly works but it won't show all the text in the description. Any ideas? _ Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/ -- 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: odd Date
[snip] When I insert a date in my table, and after do the insert I select the column date to see if the date is right but it displays the date like follows: 2019-06-20 When the original insert is: 2003-06-19 [/snip] Please show us your insert query. Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: odd Date
Hi: Here is the insert query: insert into OrdenServicio set folioOrdenServicio='', idCanal='1', idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no prende', idEntregaControl='1', numSerie='7349843', estaComponenteBase='1', observaciones='', idStatusOrden='7', idCanalLevantamiento='1', idTiendaLevantamiento='2545', idCentroServicioLevantamiento='0', idTallerLevantamiento='0', idTipoGarantia='1', idLinea='1', esReparacionInterna='', otroAccesorio='', idFalla='0', idTaller='1', idCentroServicio='0', fechaLevantamiento='2003-06-19', lada='', ubicacion='', colorProducto='', esGarantiaReparacion='1' Best Regards From: Jay Blanchard [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: odd Date Date: Fri, 20 Jun 2003 09:21:06 -0500 [snip] When I insert a date in my table, and after do the insert I select the column date to see if the date is right but it displays the date like follows: 2019-06-20 When the original insert is: 2003-06-19 [/snip] Please show us your insert query. Jay _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: linux and mysql socket
Hmmm I was having that issue when I shut my server down... i.e. the mysql daemon... did you turn off your machine, and not have mysql automatically boot up? -Original Message- From: azamka [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:07 PM To: [EMAIL PROTECTED] Subject: linux and mysql socket I installed mysql manually on red hat 9. It worked fine couple days but from yesterday i am getting a weird error when i tried to run the mysql. the error statement is Error 2002: Can't connect to local MySql server through socket '/tmp/mysql.sock'(2). I am new user of Linux and I am unable to figure out why is this happening. Please help me. thanks in advance. Kamran -- 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: odd Date
[snip] insert into OrdenServicio set folioOrdenServicio='', idCanal='1', idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no prende', idEntregaControl='1', numSerie='7349843', estaComponenteBase='1', observaciones='', idStatusOrden='7', idCanalLevantamiento='1', idTiendaLevantamiento='2545', idCentroServicioLevantamiento='0', idTallerLevantamiento='0', idTipoGarantia='1', idLinea='1', esReparacionInterna='', otroAccesorio='', idFalla='0', idTaller='1', idCentroServicio='0', fechaLevantamiento='2003-06-19', lada='', ubicacion='', colorProducto='', esGarantiaReparacion='1' [/snip] What is the data type of the column? Also could fechaLevantamiento=CURRENT_DATE() ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: odd Date
Here is the table description: mysql show create table OrdenServicio; | OrdenServicio |CREATE TABLE `OrdenServicio` ( `folioOrdenServicio` int(11) NOT NULL auto_increment, `idCanal` int(3) NOT NULL default '0', `idTienda` int(8) NOT NULL default '0', `idPedido` int(8) NOT NULL default '0', `idProducto` int(8) NOT NULL default '0', `fallaCliente` varchar(255) default NULL, `idEntregaControl` int(8) NOT NULL default '0', `numSerie` varchar(50) NOT NULL default '', `estaComponenteBase` int(2) NOT NULL default '0', `observaciones` varchar(255) default NULL, `idStatusOrden` int(8) NOT NULL default '0', `idCanalLevantamiento` int(11) NOT NULL default '0', `idTiendaLevantamiento` int(11) NOT NULL default '0', `idCentroServicioLevantamiento` int(8) NOT NULL default '0', `idTallerLevantamiento` int(9) NOT NULL default '0', `idTipoGarantia` int(2) NOT NULL default '0', `idLinea` int(8) NOT NULL default '0', `esReparacionInterna` tinyint(1) NOT NULL default '0', `otroAccesorio` varchar(255) NOT NULL default '', `idFalla` int(8) NOT NULL default '0', `idTaller` int(11) NOT NULL default '0', `idCentroServicio` int(11) NOT NULL default '0', `fechaLevantamiento` date NOT NULL default '-00-00', `lada` varchar(10) NOT NULL default '', `ubicacion` varchar(255) NOT NULL default '', `colorProducto` varchar(50) NOT NULL default '', `esGarantiaReparacion` tinyint(1) NOT NULL default '0', PRIMARY KEY (`folioOrdenServicio`), From: Jay Blanchard [EMAIL PROTECTED] To: Miguel Perez [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: odd Date Date: Fri, 20 Jun 2003 09:35:43 -0500 [snip] insert into OrdenServicio set folioOrdenServicio='', idCanal='1', idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no prende', idEntregaControl='1', numSerie='7349843', estaComponenteBase='1', observaciones='', idStatusOrden='7', idCanalLevantamiento='1', idTiendaLevantamiento='2545', idCentroServicioLevantamiento='0', idTallerLevantamiento='0', idTipoGarantia='1', idLinea='1', esReparacionInterna='', otroAccesorio='', idFalla='0', idTaller='1', idCentroServicio='0', fechaLevantamiento='2003-06-19', lada='', ubicacion='', colorProducto='', esGarantiaReparacion='1' [/snip] What is the data type of the column? Also could fechaLevantamiento=CURRENT_DATE() ? _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can someone interpert this log....
Here's the log. Retrying... Moving info for table LogOutputStats Setting fields and metadata. Using original table. Tracking field is ResRefID Starting transfer. As the Pharoh says... Ye who can interpert my dreams will become second greatest in the LAAANNND All the rest of you will get thrown to the lions oh wait... that was Babylon... lol.. either way... Howsa-Boutsa-Help? SQL main contains 1828128 records. Deleted 342644 from mySQL table. There was an error in updating table LogOutputStats. ERROR - java.sql.SQLException: Communication link failure: java.net.SocketException Removing records... Could not remove records. java.sql.SQLException: Communication link failure: java.net.SocketException NOTE This exception is a Comm failure with MySQL Moving info for table LoggingParameters There was an error in updating table LoggingParameters. ERROR - com.inet.tds.SQLException: No route to host: connect Removing records... Could not remove records. com.inet.tds.SQLException: No route to host: connect NOTE this filure is a comm failure wis MSSQL Moving info for table RuleIndexStats There was an error in updating table RuleIndexStats. ERROR - com.inet.tds.SQLException: No route to host: connect Removing records... Could not remove records. com.inet.tds.SQLException: No route to host: connect Moving info for table RuleStrengthStats There was an error in updating table RuleStrengthStats. ERROR - com.inet.tds.SQLException: No route to host: connect Removing records... Could not remove records. com.inet.tds.SQLException: No route to host: connect Complete. Total time 00:54:50 The connections are still live. You may enter additional fields or close the window. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: linux and mysql socket
azamka wrote: I installed mysql manually on red hat 9. It worked fine couple days but from yesterday i am getting a weird error when i tried to run the mysql. the error statement is Error 2002: Can't connect to local MySql server through socket '/tmp/mysql.sock'(2). I am new user of Linux and I am unable to figure out why is this happening. Please help me. thanks in advance. Kamran When you try to run the server you get this error, or when you try to connect to the server? Is the MySQL server running? ps -ax | grep mysqld If it is running, does the socket actually exist in /tmp? ls -al /tmp | grep mysql.sock If it is there, what are the permissions? If it isn't there, is it in /var/lib/mysql? ls -al /var/lib/mysql | grep mysql.sock -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: odd Date
* Miguel Perez I have the following problem: When I insert a date in my table, and after do the insert I select the column date to see if the date is right but it displays the date like follows: 2019-06-20 When the original insert is: 2003-06-19 You would get this result if you tried to insert the date as '19-06-2003': mysql use test; Database changed mysql create table datetest (d date); Query OK, 0 rows affected (0.12 sec) mysql insert into datetest set d='19-06-2003'; Query OK, 1 row affected (0.02 sec) mysql select * from datetest; ++ | d | ++ | 2019-06-20 | ++ 1 row in set (0.03 sec) I looked into the manual to figure out how mysql works with date types, and I didn't find anything. URL: http://www.mysql.com/doc/en/Using_DATE.html URL: http://www.mysql.com/doc/en/Date_and_time_types.html URL: http://www.mysql.com/doc/en/Date_and_time_functions.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mandrake 9.1 MySql++ ?
I am trying to install MySql++ (1.7.9) onto my Mandrake 9.1. Initially is indicated that it couldn;t find the mysql libraries and I assume is because I installed Mysql as one of the install options when installing Mandrake 9.1 as I believe it dosen't include the needed libraries for mysql++. I then tryed to install the latest MySql-devel from 'rpmfind' but it indicates that it didn't satisfy the already installed MySql and as a result failed. What do I need to do to get MySql++ installed on a Mandrake 9.1 system ? Pete -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: odd Date
Hi: The weird thing is that not always do the same, I mean I always introduce that insert query, but not always inserts a wrong date, sometimes the date is correct. Mikel From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: Miguel Perez [EMAIL PROTECTED] Subject: Re: odd Date Date: Fri, 20 Jun 2003 16:41:13 +0200 * Miguel Perez I have the following problem: When I insert a date in my table, and after do the insert I select the column date to see if the date is right but it displays the date like follows: 2019-06-20 When the original insert is: 2003-06-19 You would get this result if you tried to insert the date as '19-06-2003': mysql use test; Database changed mysql create table datetest (d date); Query OK, 0 rows affected (0.12 sec) mysql insert into datetest set d='19-06-2003'; Query OK, 1 row affected (0.02 sec) mysql select * from datetest; ++ | d | ++ | 2019-06-20 | ++ 1 row in set (0.03 sec) I looked into the manual to figure out how mysql works with date types, and I didn't find anything. URL: http://www.mysql.com/doc/en/Using_DATE.html URL: http://www.mysql.com/doc/en/Date_and_time_types.html URL: http://www.mysql.com/doc/en/Date_and_time_functions.html -- Roger _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: odd Date
[snip] insert into OrdenServicio set folioOrdenServicio='', idCanal='1', idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no prende', idEntregaControl='1', numSerie='7349843', estaComponenteBase='1', observaciones='', idStatusOrden='7', idCanalLevantamiento='1', idTiendaLevantamiento='2545', idCentroServicioLevantamiento='0', idTallerLevantamiento='0', idTipoGarantia='1', idLinea='1', esReparacionInterna='', otroAccesorio='', idFalla='0', idTaller='1', idCentroServicio='0', fechaLevantamiento='2003-06-19', lada='', ubicacion='', colorProducto='', esGarantiaReparacion='1' [/snip] I don't know if this is the problem, but you are mixing methods (INSERT and UPDATE). Should be... [show insert syntax] INSERT INTO table VALUES [end insert syntax] [show update syntax] UPDATE table SET columns = 'stuff' WHERE something is = to something [end update syntax] [example of insert] mysql INSERT INTO datetest (entry) VALUES ('2003-06-19'); Query OK, 1 row affected (0.00 sec) mysql select * from datetest; ++ | entry | ++ | -00-00 | | 2003-06-19 | ++ [/example] Try... INSERT INTO OrdenServicio (folioOrdenServicio, idCanal, idTienda, idPedido, idProducto, fallaCliente, idEntregaControl, numSerie, estaComponenteBase, observaciones, idStatusOrden, idCanalLevantamiento, idTiendaLevantamiento, idCentroServicioLevantamiento, idTallerLevantamiento, idTipoGarantia, idLinea, esReparacionInterna, otroAccesorio, idFalla, idTaller, idCentroServicio, fechaLevantamiento, lada, ubicacion, colorProducto, esGarantiaReparacion) VALUES('', '1', '107', '306', '503578', 'no prende', '1', '7349843', '1', '', '7', '1', '2545', '0', '0', '1', '1', '', '', '0', '1', '0', '2003-06-19', '', '', '', '1') HTH! Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't compile on NetBSD
Hello, I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded pthreads-1_60_beta6-mysql.tar.gz from your site and extracted it to mysql-3.23.57/ I ran ./configure --with-mit-threads in mysql-3.23.57 and everything went fine. However, when I run make, I get the following errors after a bunch of output: Making all in mit-pthreads make: don't know how to make all. Stop make: stopped in /usr/pkgsrc/distfiles/mysql-3.23.57/mit-pthreads *** Error code 1 Stop. make: stopped in /usr/pkgsrc/distfiles/mysql-3.23.57 *** Error code 1 Stop. make: stopped in /usr/pkgsrc/distfiles/mysql-3.23.57 when I use gmake, after cleaning everything up, I get the following errors after a bunch of output: Making all in mit-pthreads gmake[2]: Entering directory `/usr/pkgsrc/distfiles/mysql-3.23.57/mit-pthreads' GNUmakefile:44: config.flags: No such file or directory GNUmakefile:55: /root/pthreads/GNUmakefile.inc: No such file or directory GNUmakefile:56: /root/stdlib/GNUmakefile.inc: No such file or directory GNUmakefile:57: /root/stdio/GNUmakefile.inc: No such file or directory GNUmakefile:58: /root/string/GNUmakefile.inc: No such file or directory GNUmakefile:59: /root/gen/GNUmakefile.inc: No such file or directory GNUmakefile:60: /root/net/GNUmakefile.inc: No such file or directory GNUmakefile:61: /root/scripts/GNUmakefile.inc: No such file or directory gmake[2]: *** No rule to make target `/root/scripts/GNUmakefile.inc'. Stop. gmake[2]: Leaving directory `/usr/pkgsrc/distfiles/mysql-3.23.57/mit-pthreads' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/usr/pkgsrc/distfiles/mysql-3.23.57' gmake: *** [all] Error 2 config.log is attached. Thanks, Yasir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Complex SQL involving 10 checkboxes
On 19-Jun-2003 vernon wrote: OK, I've done this. Problem occurs when a user selects 1 and 9. The SQL statement I have reads like so: if (isset($HTTP_GET_VARS['check00'])) { $age00 = '00'; $s_age00 = penpals.agegroup = $age00 AND; } Problem is the AND statement. Some times the user will pick checkbox 1 and 5 but not 2,3,4,6, 7, 8, and 9. And then again there will be times when a user only uses one check box needing the AND statement on the end, but at other times the user will select more than one needing an OR statement between the two checkboxes. Make sense? Use an array. $agesel=implode(', ', $HTTP_GET_VARS['ageselect,]); $qry=SELECT * FROM foo WHERE penpals.agegroup IN ('$agesel'); Your HTML boxes will look like: input TYPE=CHECKBOX NAME=ageselect[] value=00 input TYPE=CHECKBOX NAME=ageselect[] value=10 input TYPE=CHECKBOX NAME=ageselect[] value=15 CHECKED input TYPE=CHECKBOX NAME=ageselect[] value=20 CHECKED input TYPE=CHECKBOX NAME=ageselect[] value=25 ... Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Same Problem about starting MySQL on a Mac
1. check if /usr/local/mysql/data has mysql user and r/w privileges 2. if /usr/local/mysql/data doesn't exist You have to launch mysql_install_db 3. See the your system.err file in /usr/local/mysql/data I wrote a sample tutotial for MacOS 10.2 at http://www.santinoc.com/mysql.html Santino Content-Transfer-Encoding: 7bit Content-Type: text/plain; delsp=yes; charset=US-ASCII; format=flowed Hello Everyone, I have been running MySQL on my Mac for almost a year now. suddenly I am unable to start the mysqld, I keep getting mysqld ended error. - [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe [5] 703 [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases from /usr/local/mysql/data 030618 11:50:09 mysqld ended [5]Done sudo ./bin/mysqld_safe - Can u tell me how/ where to view the error logs on MAC OS JAGUAR...? I have MySQL installed on my Win XP Pro Laptop as well and I am able to view the error log files within the 'data' dir. However when it comes to my Mac G4 , I am at a loss to understand why this happens ? [psg:/usr/local/mysql] psgarcha% ls -la total 10352 drwxr-xr-x 22 root wheel 748 Apr 4 11:38 . drwxr-xr-x 5 root wheel 170 Apr 4 11:38 .. -rw-r--r-- 1 root wheel19106 Mar 15 11:17 COPYING -rw-r--r-- 1 root wheel28003 Mar 15 11:17 COPYING.LIB -rw-r--r-- 1 root wheel 126466 Mar 15 10:47 ChangeLog -rw-r--r-- 1 root wheel 6811 Mar 15 11:17 INSTALL-BINARY -rw-r--r-- 1 root wheel 1937 Mar 15 10:47 README drwxr-xr-x 46 root wheel 1564 Apr 4 11:38 bin -rwxr-xr-x 1 root wheel 773 Mar 15 11:29 configure drwxr-x--- 13 mysql wheel 442 Jun 18 11:50 data drwxr-xr-x 51 root wheel 1734 Apr 4 11:38 include drwxr-xr-x 8 root wheel 272 Apr 4 11:38 lib drwxr-xr-x 3 root wheel 102 Apr 4 11:38 man -rw-r--r-- 1 root wheel 2676944 Mar 15 11:16 manual.html -rw-r--r-- 1 root wheel 2329252 Mar 15 11:16 manual.txt -rw-r--r-- 1 root wheel98233 Mar 15 11:16 manual_toc.html drwxr-xr-x 9 root wheel 306 Apr 4 11:38 mysql-test drwxr-xr-x 3 root wheel 102 Apr 4 11:38 scripts drwxr-xr-x 3 root wheel 102 Apr 4 11:38 share drwxr-xr-x 33 root wheel 1122 Apr 4 11:38 sql-bench drwxr-xr-x 11 root wheel 374 Apr 4 11:38 support-files drwxr-xr-x 21 root wheel 714 Apr 4 11:38 tests When I try to access the Data Dir within mysql, i get a permission denied error, Thanks --Pushpinder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connecting ASP
You can access MySQL databases from ASP by using MyODBC (now Connector/ODBC) just like you would any other ODBC datasource. I would suggest doing google searches on MyODBC and ASP in the same search, or adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ for examples. Also subscribe to the MyODBC list at lists.mysql.com Here's a sample linked to from the MyODBC FAQ: http://www.devarticles.com/art/1/50 Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Jorge Cornejo [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 1:44 AM To: [EMAIL PROTECTED] Subject: Connecting ASP Hi, I'm hosting a website in a Linux server. By now I'm learning PHP and it's amazing. How ever I need to create a online system and meanwhile I'll to do it in ASP (which I already handle). My host gives me MySQL and I use it ok. Now, what I'll like to do is to know how to connect my ASP page to a MySQL database? I can do it in my Win32 PC, but with MyODBC. So, how can I do it? Hope somebody helps me. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: search and replace.
On 20-Jun-2003 Craig Harding wrote: snip 'url' has about 20 rows starting with 'disciplines/someurl' and I want to replace 'disciplines' with 'programs'. Is there a way to do this in mysql? I know I can do it in php, but it would be cool to do it, (and probably faster) to do it in mysql. I know how do use the regexp for SEARCHING, but can I do a replace on the same cmd with an UPDATE? UPDATE foo SET url=REPLACE(url, 'disciplines/', 'programs/') WHERE url LIKE 'disciplines/%'; Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
basic 4.0.13 setup on RH9.0
I had MySQL 3.23.56 on my RedHat machine but developed some problems (that were probably my own fault) so I decided to upgrade to 4.0. I downloaded the source rpm and rebuilt it on my system (running a fully updated RedHat 9.0). I removed the old mysql by doing rpm -e on the components; then I installed 4.0.13-2 by doing rpm -ivh on the binaries. I have copied the my-large.cnf.sh (I think that was it) from the support-files folder to /etc/my.cnf. Now when I try to set the root password, or other things, I get this message: Unknown suffix '@' used for variable 'port' (value '@MYSQL_TCP_PORT@') mysqladmin: Error while setting value '@MYSQL_TCP_PORT@' to 'port' I noticed that several of the options apparently need to have values filled in. Where can I find some good documentation on how to set up the new version? Is the O'Reilly book a good resource? I had been using one of the Red Hat Linux Bible books and also MySQL Bible by Steve Suehring. Is there something more current that I could get? You may e-mail me directly if you wish: [EMAIL PROTECTED] (or, if you have problems, [EMAIL PROTECTED]) Thanks, Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting ASP
If I recall well MyODBC is used when you want to access ODBC compliant databases on a Linux based computer, however if you want to acces mySQL from ASP means that you are programming on a Windows based computer, and therefore you have ODBC client access built-in. What you need to do is to create a System Data Source Name using (at least when I did it) the Sybase driver. Best E - Original Message - From: Mike Hillyer [EMAIL PROTECTED] To: Jorge Cornejo [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 20, 2003 10:43 AM Subject: RE: Connecting ASP You can access MySQL databases from ASP by using MyODBC (now Connector/ODBC) just like you would any other ODBC datasource. I would suggest doing google searches on MyODBC and ASP in the same search, or adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ for examples. Also subscribe to the MyODBC list at lists.mysql.com Here's a sample linked to from the MyODBC FAQ: http://www.devarticles.com/art/1/50 Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Jorge Cornejo [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 1:44 AM To: [EMAIL PROTECTED] Subject: Connecting ASP Hi, I'm hosting a website in a Linux server. By now I'm learning PHP and it's amazing. How ever I need to create a online system and meanwhile I'll to do it in ASP (which I already handle). My host gives me MySQL and I use it ok. Now, what I'll like to do is to know how to connect my ASP page to a MySQL database? I can do it in my Win32 PC, but with MyODBC. So, how can I do it? Hope somebody helps me. 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: Connecting ASP
Sorry about my last comment, I check the documentation and the ODBC connector (also called MyODBC) is indeed the driver for ODBC in Windows. E! - Original Message - From: Ernesto Silva [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 20, 2003 1:27 PM Subject: Re: Connecting ASP If I recall well MyODBC is used when you want to access ODBC compliant databases on a Linux based computer, however if you want to acces mySQL from ASP means that you are programming on a Windows based computer, and therefore you have ODBC client access built-in. What you need to do is to create a System Data Source Name using (at least when I did it) the Sybase driver. Best E - Original Message - From: Mike Hillyer [EMAIL PROTECTED] To: Jorge Cornejo [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, June 20, 2003 10:43 AM Subject: RE: Connecting ASP You can access MySQL databases from ASP by using MyODBC (now Connector/ODBC) just like you would any other ODBC datasource. I would suggest doing google searches on MyODBC and ASP in the same search, or adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ for examples. Also subscribe to the MyODBC list at lists.mysql.com Here's a sample linked to from the MyODBC FAQ: http://www.devarticles.com/art/1/50 Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Jorge Cornejo [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 1:44 AM To: [EMAIL PROTECTED] Subject: Connecting ASP Hi, I'm hosting a website in a Linux server. By now I'm learning PHP and it's amazing. How ever I need to create a online system and meanwhile I'll to do it in ASP (which I already handle). My host gives me MySQL and I use it ok. Now, what I'll like to do is to know how to connect my ASP page to a MySQL database? I can do it in my Win32 PC, but with MyODBC. So, how can I do it? Hope somebody helps me. 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Distributed/Fault Tolerant DB operation... possible?
Rick, Sorry your request was taken in the wrong way, I get this request for various things all the time and they are serious about it. I also see on a regular basis people get two T1 connections from the same loop provider, to the same ISP and call it redundant. So the question remains, how many 9's do you need? I'd look at having two servers, one a master and another a slave, and some software that can tell when one of them goes down then promote the salave to master, and take over the IP address of the down system. -- Michael Conlen Rick Franchuk wrote: On Thu, 19 Jun 2003, Michael Conlen wrote: First get an acceptable outtage rate. Your only going to get so many nines, and your budget depends on how many. The system will fail at some point, no matter what, even if it's only for a few seconds. That's reality. Figure out what kinds of failures you can tolerate based on how many 9's you get and what kinds you have to design around. From there you can figure out a budget. 99.999% uptime is 5 minutes and 15 seconds per year of total downtime. 99.99% is 52.56 minutes and so on. At some point something will happen, and I've never seen anyone offer more than 5 9's, and IBM charges a lot for that. Then, figure out everything that could cause an outtage, figure out how to work around them and give them a budget. Watch how many 9's come off that requirement. Obviously my hyperbolic emphasis on uptime has brought out the pedant in some. I'm not expecting unrealistic results... I would have thought my 'breathless' expression of uptime requirement would be seen as a bit of exaggeration. I'll try to be more explicit in the future. If you have to use MySQL I'd ditch PC hardware and go with some nice Sun kit if you haven't already, or maybe a IBM mainframe. The code using mysql represents several thousand man hours of work, and although the database-using elements are somewhat abstracted there's guaranteedly mysql linguistic variants spread all throughout the code. It'd be substantial work converting... not impossible, but a pricey PITA. A mysql solution would be preferable under the circumstances. hand waving extreme commentary about the impossibilty of the situation and general hyperbole snipped There's a lot of issues to consider in there, and you probably want someone with a graduate degree in computer science to look over the design for you. (anything this critical and I get someone smarter than me to double check my designs and implementations). I'm sure more than one of the various graduates on our design team will do so, seeing how their code will likely need to be modified somewhat to take advantage of the new setup. On the other hand, if you have all this money, look at some of the etc and so on This is just a quick run down of immediate issues in a 24x7x365, it's not exhaustive. Think about every cable, every cord, every component, from a processor to a memory chip and think about what happens when you pull it out or unplug it, then make it redundant. Yes, we're quite aware of what 'redundancy' means. Thank you ever so much for pointing out the painfully obvious, much of which has already been taken care of inside the time, engineering and money constraints given us. Now, if you have some actual HELP to give regarding the viability of MySQL to the application of the problem at hand... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2013: Lost connection to MySQL server during query on LOAD LOCAL IN FILE
The bug is: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 257 to server version: 4.0.14-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use sqlreg3; Database changed mysql LOAD DATA LOCAL INFILE 'C:\\ProjetosD6\\MySQLBackup\\binario\\cfgimpressao.dat' INT O TABLE cfgimpressao; ERROR 2013: Lost connection to MySQL server during query mysql The Files of table are in FTP the names is: cfgimpressao.dat.zip - The zipped Data of File ( saved with the OUTFILE command, please unzip before run ! ) cfgimpressao.str - The Structure cfgimpressao.ref - The references cfgimpressao.idx - The Indexes The files are in support.mysql.com in the secret dir. My System is MySQL 4.0.14 + InnoDB running in Linux box kernel 2.4.21 with 768MB of ram - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 1647350 $ look into my eyes Phone : +55 041 296-2311 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql ended error
hello all, i hve been getting the 'mysql ended' error for over a wek now.when i look into the log file this is what I get This is from the error logs 030619 17:09:04 mysqld ended 030620 13:14:06 mysqld started 030620 13:14:09 InnoDB: Started 030620 13:14:09 Fatal error: Can't open privilege tables: Can't open file: 'user.MYI'. (errno: 145) 030620 13:14:09 Aborting 030620 13:14:09 InnoDB: Starting shutdown... 030620 13:14:11 InnoDB: Shutdown completed 030620 13:14:11 /usr/local/mysql-standard-4.0.12-apple-darwin6.4-powerpc/bin/mysqld: Shutdown Complete 030620 13:14:11 mysqld ended Please offer some insight into what migh tbe going on. I have tried to re-initialize the DB , but Nothing chnaged! Thanks -Pushpinder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it possible to refresh data in a mySQL data via a script?
Hi there, I'm just getting started with mySQL and PHP. I've used phpMyAdmin to create tables and insert data into them from a delimited text file. From there I'm creating a web page to view the data. Ideally this table would be refreshed every night as it is a data dump from our production server. Could anyone point me in the direction of any documentation on how to automate the data insertion routine? I have three books on mySQL, they all talk about how to construct SQL statements and I'm fine with that. What I can't figure out is how to get those statements to the right place without having to do it manually. Thanks, Barbara -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connecting ASP
True, I have a Windows PC, however to test this I'm doing something like this: In Notepad I create a file test.asp Write some ASP code into the file Save the File Upload the file to my remote host that works in Linux Run my ASP script See my script working ok /*So ASP can run in a Linux Server with a Perl mod*/ At my local PC I already have worked in ASP with IIS and made the connection to the MySQL database that is also on the remote Host, this I did with MyODBC. How ever when I upload, Linux as far as I know, doesn't have DNS, I'm right? So MyODBC is no longer needed because the remote server is, as I told, a Linux sever. So what is the code for ASP to talk with my remote host once it's also in the same remote host? Thanks -Mensaje original- De: Mike Hillyer [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 20 de Junio de 2003 10:44 a.m. Para: Jorge Cornejo; [EMAIL PROTECTED] Asunto: RE: Connecting ASP You can access MySQL databases from ASP by using MyODBC (now Connector/ODBC) just like you would any other ODBC datasource. I would suggest doing google searches on MyODBC and ASP in the same search, or adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ for examples. Also subscribe to the MyODBC list at lists.mysql.com Here's a sample linked to from the MyODBC FAQ: http://www.devarticles.com/art/1/50 Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Jorge Cornejo [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 1:44 AM To: [EMAIL PROTECTED] Subject: Connecting ASP Hi, I'm hosting a website in a Linux server. By now I'm learning PHP and it's amazing. How ever I need to create a online system and meanwhile I'll to do it in ASP (which I already handle). My host gives me MySQL and I use it ok. Now, what I'll like to do is to know how to connect my ASP page to a MySQL database? I can do it in my Win32 PC, but with MyODBC. So, how can I do it? Hope somebody helps me. 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: Can someone interpert this log....
No route to host is a TCP/IP connection thing. Check your settings. Curtis TheMechE said: Here's the log. Retrying... Moving info for table LogOutputStats Setting fields and metadata. Using original table. Tracking field is ResRefID Starting transfer. As the Pharoh says... Ye who can interpert my dreams will become second greatest in the LAAANNND All the rest of you will get thrown to the lions oh wait... that was Babylon... lol.. either way... Howsa-Boutsa-Help? SQL main contains 1828128 records. Deleted 342644 from mySQL table. There was an error in updating table LogOutputStats. ERROR - java.sql.SQLException: Communication link failure: java.net.SocketException Removing records... Could not remove records. java.sql.SQLException: Communication link failure: java.net.SocketException NOTE This exception is a Comm failure with MySQL Moving info for table LoggingParameters There was an error in updating table LoggingParameters. ERROR - com.inet.tds.SQLException: No route to host: connect Removing records... Could not remove records. com.inet.tds.SQLException: No route to host: connect NOTE this filure is a comm failure wis MSSQL Moving info for table RuleIndexStats There was an error in updating table RuleIndexStats. ERROR - com.inet.tds.SQLException: No route to host: connect Removing records... Could not remove records. com.inet.tds.SQLException: No route to host: connect Moving info for table RuleStrengthStats There was an error in updating table RuleStrengthStats. ERROR - com.inet.tds.SQLException: No route to host: connect Removing records... Could not remove records. com.inet.tds.SQLException: No route to host: connect Complete. Total time 00:54:50 The connections are still live. You may enter additional fields or close the window. -- 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 it possible to refresh data in a mySQL data via a script?
On Fri, 2003-06-20 at 12:16, Barbara Andrew wrote: snip I have three books on mySQL, they all talk about how to construct SQL statements and I'm fine with that. What I can't figure out is how to get those statements to the right place without having to do it manually. This would be the domain of some other tool, such as a shell script, or a commandline php/python/perl etc script that could be run nightly using a scheduling tool ie cron, at etc. You could also have mysql do the import: use databasename; drop table if exists myTable; create table myTable ( Field1 varchar(50) not null, field2 varchar(25) not null, PRIMARY KEY (Field1), KEY names(field2) ) TYPE=MyISAM; load data infile '/tmp/dataFile' into table myTable FIELDS TERMINATED BY '|'; put the above (or some variation) in a file (filename.mysql), and then have mysql execute those statements nightly: by putting the following into either a one line bash script, or having cron run it directly: mysql filename.mysql Of course, you will probably want to run some checks to make sure the data is in the file before you start Dropping tables etc. Check these out for reference: http://www.mysql.com/doc/en/mysqlimport.html http://www.mysql.com/doc/en/LOAD_DATA.html hth, gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql ended error
Pushpinder Singh Garcha wrote: hello all, i hve been getting the 'mysql ended' error for over a wek now.when i look into the log file this is what I get This is from the error logs 030619 17:09:04 mysqld ended 030620 13:14:06 mysqld started 030620 13:14:09 InnoDB: Started 030620 13:14:09 Fatal error: Can't open privilege tables: Can't open file: 'user.MYI'. (errno: 145) perror 145 Error code 145: Unknown error 145 145 = Table was marked as crashed and should be repaired. go to the mysql/mysql directory and run myisamchk on user.MYI. 030620 13:14:09 Aborting 030620 13:14:09 InnoDB: Starting shutdown... 030620 13:14:11 InnoDB: Shutdown completed 030620 13:14:11 /usr/local/mysql-standard-4.0.12-apple-darwin6.4-powerpc/bin/mysqld: Shutdown Complete 030620 13:14:11 mysqld ended Please offer some insight into what migh tbe going on. I have tried to re-initialize the DB , but Nothing chnaged! Thanks -Pushpinder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
my.cnf and passwords
Hello all, I'm pretty new to MySQL, but have managed to create a database that is accessed via PHP which then creates tables from the MySQL data. Currently, I am using the root user/password combo to grab the info (which means the password is plaintext in the PHP). I wanted to use the my.cnf to define the password, but no matter where I put the file (/etc/my.cnf, /var/lib/mysql/, /var/lib/mysql/[databasename], /root, /home/mysql/.my.cnf) my query won't seem to hit the my.cnf file which has the following in it: (note: it doesn't have a username defined.) [client] password=mypassword my database is called 'assets' and it's located in: /var/lib/mysql/assets I have a mysql user defined: mysql:x:100:101:MySQL server:/var/lib/mysql:/bin/bash The php stuff is located in a single directory: /var/www/html/assets Yet when I try to access the page (which works when the password is passed in the php), I get: Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /var/www/html/assets/fetch-new.php on line 6 Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) in /var/www/html/assets/fetch-new.php on line 6 fetch-new.php's line 6 (and 7) looks like this: $db = mysql_connect(localhost, root); mysql_select_db(assets,$db); I've checked out the mysql.com's documentation, and I've tried putting the my.cnf file in every place they reference, but it doesn't seem to work via this PHP. When I connect from the command line (on the Linux box), it *does* work, so it seems that the /etc/my.cnf file is being checked at that point, but isn't being checked in the php. Does anyone see/know a fix? I'm out of ideas. Thanks in advance, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Synchronising SQL Server and MySQL
Have you looked at using the MS DTS and MyODBC to perform your replication/synchronizing from Microsoft? -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:31 AM To: [EMAIL PROTECTED] Subject: Synchronising SQL Server and MySQL I need to synchronise an SQL Server 2000 back end with a MYSQL database on a different box (windows). Can anyone point me in the right direction. I have found a number of resources on synchronising 2 sql server databases but I cant find anything on SQLServer and MySQL. Thanks in Advance -- 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]
Building keys that simulate a key spanning multiple tables
I've distilled my problem down to this: I am trying to figure out how to build some indices on a couple of different tables so as to speed up a search that involves searching on multiple columns from each of the tables. Let's pretend I have two tables as follows and that I need to do a query that at its core basically involves a field from Table_A (Field_1) and a field from Table_B (Field_2): +---+ | Table_A | +---+ | Primary_Key_A | | Field_1 | +---+ +---+ | Table_B | +---+ | Primary_Key_A | | Field_2 | +---+ The query that I need would look something like this: SELECT * FROM Table_A, Table_B WHERE Table_A.Primary_Key_A = Table_B.Primary_Key_A AND Field_1 IN (...) AND Field_2 IN (...); What I am curious about is this: could MySQL make use of an index that uses the primary key for the table as the first part of the index (ie: Primary_Key_A, Field_1), and would that aid in this type of query? As long as the important columns in a query are all in one table, a simple index on all of those columns makes the query lightning fast, but I am unsure of how to go about speeding up this type of query. If I only search on Field_1 (or only on Field_2), I get tens of thousands of rows returned, however the end result of searching on both Field_1 and Field_2 is usually a hundred or less rows. So let's say that MySQL has used an index on Field_2 to obtain a set of rows from Table_B. This set of rows has in turn provided MySQL with a set of values for the Primary_Key_A field which it is now about to use to continue the search on Table_A. Can MySQL make use of an index on (Primary_Key_A, Field_1) to allow it to quickly get the rows from Table_A that match? Or will it only be able to use the primary key to match the rows, and then use the where condition to check the Field_1 value for each of those rows one at a time? Even if such an index is available, will it be disregarded because the primary key is a unique key and can therefore do an equality reference instead of just a normal reference match? Thanks in advance for any insight you guys might provide me, Dan Kroymann -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB file size...
From the InnoDB manual: Dropping a table or deleting all rows from it is guaranteed to release the space to other users, but remember that deleted rows can be physically removed only in a purge operation after they are no longer needed in transaction rollback or consistent read. Perhaps that helps. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: I-A.Kotopoulos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, 20 June, 2003 04:36 Subject: InnoDB file size... I am currently working on some experiments and have to deal with some millions of tuples. As you can imagine indexing is essentiall. However My InnoDB file has grown to over 3.6G and fragmentation is sometimes a big problem. Additionally the file keeps its size even after dropping the 'big' tables. So, any suggestions in order to optimize the space usage? thanx in advance aik_b -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]