SOLVED: MySQL immediately closes connection on 3306 with no message at all
(I forgot to mention in my original message that I *had* commented out the skip-networking directive in /etc/mysql/my.cnf; the directive would have resulted in in the connection being refused; the problem here was that the connection was immediately and silently closed.) $ telnet localhost 3306 Trying 127.0.0.1... Connected to acheloos. Escape character is '^]'. Connection closed by foreign host. The connection is closed immediately; all 4 lines above are output in an instant. Nothing's written in the log files. Several of the newer daemons, including mysqld, are able to use the libwrap library and check the hosts.allow and hosts.deny files. Some operating systems, including Debian, have mysql compiled with that option enabled. If it follows from hosts.allow and hosts.deny that mysql should deny, it behaves as described above. Normally what needs to be done is add a line like the following in hosts.allow, and restart the server. mysqld: [allowed hosts/networks here]: ALLOW - 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 4.x for debian?
Hello, what is the status of MySQL 4.x for debian? Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? Best regards Gunnar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql uses 98% CPU
Thank you everybody for the info. I am considering switching to linux, do you think it is worth it? Does MySql perform better on linux than on a freebsd box overall? Much appreciated Toni Vall - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Nicolas MONNET (Tech) [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 04, 2002 4:07 PM Subject: Re: MySql uses 98% CPU On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote: We get the same thing on FreeBSD machines quite often, and it's not related to the actual work being done; MySQL can sit idle but use up all CPU. It happens after a few days/weeks of uptime. That's a known bug in FreeBSD's threading implementation. Disable name resolution and it'll go away. Some details are here: http://jeremy.zawodny.com/blog/archives/000203.html#000203 and http://jeremy.zawodny.com/blog/archives/000264.html#000264 Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 90 days, processed 1,874,326,961 queries (240/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySql uses 98% CPU
I like FreeBSD so it pains me to say it but the penguin has it. As threads are so important to MySQL Linux it just better at this at the moment (we will see what happens with V5 FreeBSD). MySQL was developed on Suns Slowlaris so it is a bit more native to Linux... Simon PS the devil will be back :-) -Original Message- From: Toni [mailto:toni;clad4.com] Sent: 06 November 2002 09:18 To: [EMAIL PROTECTED] Subject: Re: MySql uses 98% CPU Thank you everybody for the info. I am considering switching to linux, do you think it is worth it? Does MySql perform better on linux than on a freebsd box overall? Much appreciated Toni Vall - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Nicolas MONNET (Tech) [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 04, 2002 4:07 PM Subject: Re: MySql uses 98% CPU On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote: We get the same thing on FreeBSD machines quite often, and it's not related to the actual work being done; MySQL can sit idle but use up all CPU. It happens after a few days/weeks of uptime. That's a known bug in FreeBSD's threading implementation. Disable name resolution and it'll go away. Some details are here: http://jeremy.zawodny.com/blog/archives/000203.html#000203 and http://jeremy.zawodny.com/blog/archives/000264.html#000264 Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 90 days, processed 1,874,326,961 queries (240/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql does not start, what can I do?
Hello! I was few days avay from my office, and when I came back today, I got some emails, nobody can't connect to database server. When I tried to restart mysqld (3.23.46, debian (woody) initscript failed. Manually starting the server say: 021106 10:24:12 mysqld: Can't open file: 'user.MYD'. (errno: 145) Datadir value in /etc/mysql/my.cnf points to /var/lib/mysql. user group rights should be Okay: #ls -l /var/lib/ drwxr-xr-x9 mysqlmysql4096 loka 11 09:51 mysql #ls -l /var/lib/mysql/mysql -rw-rw1 mysqlmysql9148 syys6 13:00 user.frm -rw-rw1 mysqlmysql4096 marras 1 09:11 user.MYD -rw-rw1 mysqlmysql2048 marras 1 09:11 user.MYI If someone can help me, Thanks. -- --- Espoon Liiketalousinstituutti - Espoo institute of business ATK-tuki - Helpdesk Tuomas Järvinen Mail address Karapellontie 11 ZIp City 02610 ESPOO FINLAND mobile: +358 (0)50 5287522 E-mail: [EMAIL PROTECTED] WWW: http://www.elit.eskk.fi - 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
_rowid
What about the following info in the manual p. 55? Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version 3.23.11: If the PRIMARY or UNIQUE key consists of only one column and this is of type integer, one can also refer to it as _rowid Isn't _rowid some type of internal variable? What is its exact purpose and significance? In other words why did the designer of mySQL bother naming that specialized column as such. Thanks for comments. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 4.x for debian?
On Wed, 6 Nov 2002, von Boehn, Gunnar wrote: Hello, what is the status of MySQL 4.x for debian? Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? I think MySQL policy is to support generic packaging formats applicable to all platforms. Proprietary packaging formats such as those used by Debian, Red Hat, etc are not directly supported but contributed by others. regards, Andy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
default-character-set problem
Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon but the problem still exist. I have 3.23.49 ver on Red Hat Linux 7.2 Thanx list --- sql, query Do You Yahoo!? @yahoo.grhttp://www.otenet.gr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql does not start, what can I do?
On Wed, 06 Nov 2002 11:23:30 +0200 Tuomas Jrvinen [EMAIL PROTECTED] wrote: Hello! I was few days avay from my office, and when I came back today, I got some emails, nobody can't connect to database server. When I tried to restart mysqld (3.23.46, debian (woody) initscript failed. Manually starting the server say: 021106 10:24:12 mysqld: Can't open file: 'user.MYD'. (errno: 145) perror 145 145 = Table was marked as crashed and should be repaired Reapir the table with myisamchk Datadir value in /etc/mysql/my.cnf points to /var/lib/mysql. user group rights should be Okay: #ls -l /var/lib/ drwxr-xr-x9 mysqlmysql4096 loka 11 09:51 mysql #ls -l /var/lib/mysql/mysql -rw-rw1 mysqlmysql9148 syys6 13:00 user.frm -rw-rw1 mysqlmysql4096 marras 1 09:11 user.MYD -rw-rw1 mysqlmysql2048 marras 1 09:11 user.MYI If someone can help me, Thanks. -- --- Espoon Liiketalousinstituutti - Espoo institute of business ATK-tuki - Helpdesk Tuomas Jrvinen Mail address Karapellontie 11 ZIp City02610 ESPOO FINLAND mobile: +358 (0)50 5287522 E-mail: [EMAIL PROTECTED] WWW: http://www.elit.eskk.fi - 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 -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 4.x for debian?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 06 November 2002 11:20, andy thomas wrote: Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? I think MySQL policy is to support generic packaging formats applicable to all platforms. Proprietary packaging formats such as those used by Debian, Red Hat, etc are not directly supported but contributed by others. Actually, this is not a case - it's more a question of manpower and knowledge :) Yes, we plan to add more package formats apart from tarballs in the future, it's on my TODO. Debian packages are quite high on the priority list there, but I don't know, when I will be able to start with it - I have a lot of RPM background, but I need to read up on how to build DEBs. Do I need to have Debian installed? Or is it sufficient to install the required tools on another distribution? Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9yPJzSVDhKrJykfIRAkXQAJkBqudCfsQAymAZ1+JFY+QGIh54rwCeIvHW LM5S9IQwqVfnxLMsS7BaHl0= =2Hwz -END PGP SIGNATURE- - 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: PHP mysql
Hi Jeff, many thanks for your reply. I have checked my installation and all the things you suggested were already implemented. Today I re installed. still with no joy. The asp still works however so the server is OK. One difference I cannot find 'Method exclusions' in my configuration settings. Any other Ideas please? Regards Bob -Original Message- From: jeff [mailto:mylist;workingtitle.net] Sent: Tuesday, November 05, 2002 5:47 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: PHP mysql From: http://www.dynamic-webpages.de/php/install.iis.php - If you want to use the CGI binary, do the following: Under 'Home Directory', 'Virtual Directory', or 'Directory', click on the 'Configuration' button, and then enter the App Mappings tab. Click Add, and in the Executable box, type: c:\php\php.exe (assuming that you have unziped PHP in c:\php\). In the Extension box, type the file name extension you want associated with PHP scripts. Leave 'Method exclusions' blank, and check the Script engine checkbox. You may also like to check the 'check that file exists' box - for a small performance penalty, IIS (or PWS) will check that the script file exists and sort out authentication before firing up php. This means that you will get sensible 404 style error messages instead of cgi errors complaing that php did not output any data. You must start over from the previous step for each extension you want associated with PHP scripts. .php and .phtml are common, although .php3 may be required for legacy applications. Set up the appropriate security. (This is done in Internet Service Manager), and if your NT Server uses NTFS file system, add execute rights for I_USR_ to the directory that contains php.exe. In other words, you have to tell IIS to parse .php files with php.exe. Hope that helps! Jeff ** Hi guys, I hope you can show me where I am going wrong. I have ASP working with MySQL I have recently tried to install PHP. I am obviously missing a point. I am running IIS under win2000. Initially I tried to install manually from binary distribution and failed. To get it up and running I went back to Install Shield. The instructions say that just follow the instructions and start using PHP. The relevant PHP.INI was put into WINNT. I suspect I must modify it in some way? I have given privileges to IUSR (read/write) to IIS. I am testing with the following:- html head titlePHP Test/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body bgcolor=#FF text=#00 ?php echo Hello Worldp; ? /body /html Can't be much simpler. But it does not get parsed!! What have I missed? Thanks Bob G - 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
find longest string in column
Hi, How can I find the longest string in a column? I can probably write a PHP-script that checks the str_length recursively, but I would like to be able to do this within MySQL... I would like to have the value and the length of the string if this is possible. Is this possible or should I try to write the PHP-script? I couldn't find anything relevant in the documentation or the archives, but I hope I just missed it... TIA, Bram [sql, query] -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - 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: find longest string in column
Mertens Bram wrote: Hi, How can I find the longest string in a column? I can probably write a PHP-script that checks the str_length recursively, but I would like to be able to do this within MySQL... I would like to have the value and the length of the string if this is possible. Is this possible or should I try to write the PHP-script? I couldn't find anything relevant in the documentation or the archives, but I hope I just missed it... TIA, Bram [sql, query] Hi, You could try: SELECT string,length(string) as len FROM mytable ORDER BY len DESC LIMIT 1 regards, Joseph Bueno - 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: Access replacement...
I'm afraid to say it (but I will), but what you are asking for sounds like FileMaker Pro. It's available for Windows, Mac and Linux. If you really want to empower your users to create reports, databases, forms and the like, FileMaker is actually a lot easier than Access. For an experienced developer, FileMaker can be a frustrating experience though. FileMaker is designed with the end user in mind and puts ease of use first and foremost. It is more scalable than Access as far as supporting simultaneous users, mainly because it has a server component. I would not use FileMaker as a front end to a real database, although it can be done and is getting better in this area. There is a free 30 day (?) download available that I'm pretty sure only limits the number of records you can enter. Otherwise it's a full blown version. The most I've put into a FileMaker database is about 500,000 records. I had no performance problems at that level for simple searches. On Tuesday, November 5, 2002, at 09:14 PM, Brad wrote: MySQL provides a replacement for the database component but that still leaves: A programming environment; A database maintenance utility; A database query tool; A report builder Some of our users have had MSAccess training and are quite proficient in producing simple but usable applications involving: The creation of a database and tables; Forms to populate the database; Queries and reports to display the data. All this in a graphical interface without needing to know SQL or doing any serious programming. They would need to be able to continue doing this in the new Linux environment - is there a suitable Forms utility? -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - 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: find longest string in column
On Wed, 2002-11-06 at 14:39, Brent Baisley wrote: SELECT MAX(LENGTH(column)) FROM db Thx Brent! This works perfectly! That will give you the length of the longest string but won't tell you what the value is. To get the value also, you could do something like this, but I think there should be a better way: SELECT MAX(LENGTH(column)) AS length,column FROM db GROUP BY column ORDER BY length LIMIT 1 I had to edit this little bit because it returned the shortest string... Here's what works for me: SELECT MAX(LENGTH(column_name)) AS length,column_name FROM table_name GROUP BY column_name ORDER BY length DESC LIMIT 1; So the 'db' in your suggestion has been replaced by the table_name and I added the 'DESC' to get the longest string! Thx again! That query could get very slow on large databases since it can't use an index and traverses the entire database. Luckily the db is not that big at the moment ( only 3157 records)... On Wednesday, November 6, 2002, at 07:29 AM, Mertens Bram wrote: How can I find the longest string in a column? I would like to have the value and the length of the string if this is possible. Is this possible or should I try to write the PHP-script? -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - 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: My Database Manager
Yesterday, someone (I cannot recall who) posted a link for a piece of software called My Database Manager. I tried going to that link on and off for the last day and I'm always getting a 404. Has anyone successfully DL'd this app? If so, could you send me a copy? I'd be very interested in checking it out. Chris sql,query --- arrgh!! - 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
A way to get into the code to add functionality to FullText Searches
Hi Just I wondering the posibility of adding some functionality to MySQL MyISAM fulltext functionality, but I am quite confused. I read the ft_* files under $(MYSQL)/myisam, and there is nothing I can do. I'm wondering to add SGML support to FullText searches, so I need to exclude every thing between and for a start point. This way at least we can assume that HTML, XML and all the flavors of them can be correctly indexed for retrieval. This leads to an interesting matter: we may need to develop a dinamically update structure to hold the stopwords instead of the compiled in one. For now, I need the answer to a few things. a) am I in the right list? b) has anyone try to add it? c) where the hell registered a environmental variable? d) which is the function that actually build the index? Cheers, Leonardo Javier Belén. AFIP-AR - SQL, SQL, QUERY, MYSQL, SQL, SQL -- - Original Message - From: Lenz Grimmer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 7:44 AM Subject: Re: mysql 4.x for debian? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 06 November 2002 11:20, andy thomas wrote: Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? I think MySQL policy is to support generic packaging formats applicable to all platforms. Proprietary packaging formats such as those used by Debian, Red Hat, etc are not directly supported but contributed by others. Actually, this is not a case - it's more a question of manpower and knowledge :) Yes, we plan to add more package formats apart from tarballs in the future, it's on my TODO. Debian packages are quite high on the priority list there, but I don't know, when I will be able to start with it - I have a lot of RPM background, but I need to read up on how to build DEBs. Do I need to have Debian installed? Or is it sufficient to install the required tools on another distribution? Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9yPJzSVDhKrJykfIRAkXQAJkBqudCfsQAymAZ1+JFY+QGIh54rwCeIvHW LM5S9IQwqVfnxLMsS7BaHl0= =2Hwz -END PGP SIGNATURE- - 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
Character-sets
If I want to create a database with an arabic character-set, will only the data-cells be affected by this or will the table names, column names etc also be in arabic? Can I mix two character-sets (English and Arabic) in the same database, or does it have to be in two separate databases? Any thoughs? // Michelle (sql, query) __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access replacement...
I've been looking at a similar scenario Here is what I've arrived at so far: There is little that rivals the ease of use of MS Access - but most alernatives offer different features (like security, performance improvement, and other database related functions) that make the loss of ease of use bearable. The closest open source system to Access that I have seen is Openoffice - it isn't yet very well documented but there is a powerful database frontend system lying under the hood of that suite. You still need a separate database to store the info, but there is a form design tool and a query design tool similar to MS Access and something similar to reports can be made by using the mail merge function to pull info from the database. As for database backend, I've had trouble finding something that is as portable as MS Access. The main open source databases (MySQL and PostgreSQL) have replication functions to provide off-line access to the databases but they too have limitations (eg you have to set up the database server software, and maintin it, on the remote client as well as the central server). There are some db formats that save the data in a file that can be transferred to other systems, but then you lose some of the advantages as well (I haven't played with these systems) Keep us posted on what you find Brad ([EMAIL PROTECTED]) wrote*: I am thinking of a move from a Windows network to Red Hat Linux at my work. I am happy with OpenOffice for spreadsheets, word processing etc but the main problem is replacing MSAccess. MySQL provides a replacement for the database component but that still leaves: A programming environment; A database maintenance utility; A database query tool; A report builder Some of our users have had MSAccess training and are quite proficient in producing simple but usable applications involving: The creation of a database and tables; Forms to populate the database; Queries and reports to display the data. All this in a graphical interface without needing to know SQL or doing any serious programming. They would need to be able to continue doing this in the new Linux environment - is there a suitable Forms utility? We also have some serious applications written in MSAccess by outside professional programmers. This was partly done to allow the simpler changes (eg reports and screen layouts) to be made by the advanced users in order to reduce costs and delays. I would assume that a Forms utility would not provide enough features to be used here. Does this mean that development has to be done in the opensource equivalent of VB which may shut out the advanced users from making changes? Regards, Brad - 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
90.
mysql:ÄúºÃ! 90¿îÍøÉÏÓªÏúÈí¼þµÍ¼ÛתÈÃ. ±¾ÈËÒÔ400Ôª¹ºÈëȺ·¢Èí¼þ,ËÑË÷Èí¼þµÈ90¿îÍøÉÏÓªÏúÈí¼þ, ¼°1000Íò¸öEMAILµØÖ·,ÏÖÒò¹¤×÷±ä¶¯,ÒÔ50ÔªµÍ¼ÛתÈà QQ:8223613 0574-63133687 Ö Àñ! mike [EMAIL PROTECTED] 2002-11-06 - 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: load data infile syntax
I did my testing. If I use ESCAPED BY '\\', I got 1064, You have an error in your SQL syntax near ''' at line 2 Using ESCAPED BY '\', then no error and result is fine. If the data contains \, then database will automatically takes \ away and shift 1 byte left. My data will mass up. That is why I still need \ I posted my syntax before, but nobody helped me to figure out. So this time I did my test again and found out only need one \ for ESCAPED BY. At 10:43 PM 11/5/2002 -0600, you wrote: At 14:38 -0500 11/5/02, Vivian Wang wrote: The syntac ESCAPED BY of load data infile is wrong in http://www.mysql.com/doc/en/LOAD_DATA.html. the [ESCAPED by '\\'] should be: [ESCAPED BY '\'] Why do you say that? - 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
lost connection....
I try to update my linux to next version, and it was running a previous version of mysql and when I update to version 3.23.52-3 it works correct, but when I try to connect from a windows Workstation to server it broke with this message in mysql.log : Number of processes running now: 1 mysqld process hanging, pid 30326 - killed 021106 11:59:08 mysqld restarted /usr/libexec/mysqld: ready for connections and in workstation shows: Lost connection to MySql server during query Anybody knows what´s wrong ??? []´s flavio - 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
WinMySQLAdmin
When first used, the WinMySQLAdmin program puts up a box requesting Username and Password. Can anybody tell me what this is intended to do? Normally leave it blank, but when someone else did not do so, it created an unwanted user with a forgotten password in the database. Furthermore, when we uninstalled and reinstalled MySQL, the user/password came back. What does this name/password do? Where does WinMySQLAdmin hide it so that we can zap it if we need to? Thanks, Alec - 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: lost connection....
Flavio, If your running RedHat check https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 off topic question flavio. Did you ever work in New York City? -Mike On Wed, 2002-11-06 at 10:09, Flavio wrote: I try to update my linux to next version, and it was running a previous version of mysql and when I update to version 3.23.52-3 it works correct, but when I try to connect from a windows Workstation to server it broke with this message in mysql.log : Number of processes running now: 1 mysqld process hanging, pid 30326 - killed 021106 11:59:08 mysqld restarted /usr/libexec/mysqld: ready for connections and in workstation shows: Lost connection to MySql server during query Anybody knows what´s wrong ??? []´s flavio - 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: index question
At 1:19 -0600 11/6/02, D. Walton wrote: At 01:05 AM 11/6/2002 -0600, you wrote: Paul, the point was to have 'value' be part of the primary key for pure lookup speed (data file would not need be referenced), but not to have it effect the uniqueness of the 'id'/'date' key pair so that I could do an 'insert ignore' into the table with a 'value' of 0 and if a record with matching 'id'/'date' already existed with a 'value' of 4 then it would not create another record. I could do this with two indexes but using two indexes would more than negate the benefit of not having to lookup in the data file. Yet it's perfectly reasonable to have mysql use the same index for both of these index definitions, but from Jeremy's post it appears that mysql won't do this optimization. From Jeremy's post, no such thing appears. He answered your question correctly. You were just asking the wrong question. :-) Use a single three-column index. Drop the two-column one and create a new one with the third column added. Paul, I'm not sure I understand. Are you agreeing with Jeremy or are you saying there is a solution, but I didn't ask my original question correctly? I'm afraid I don't see how using a single three-column index solves this? If I use a single three-column unique index then I can potentially add two rows with the same 'id'/'date' pairs so long as they both have a different 'value'. I need for no two records to have the same 'id'/'date' yet I also need the 'value' in the index for maximum lookup speed. Okay, I didn't understand that last part properly. Sorry. If you want to enforce uniqueness at the id/date level, you will need a separate unique index on just those two columns, in addition to a three column index on id/date/value. There is no syntax for specifying that you want an index on a set of columns but to enforce a uniqueness constraint on just a subset of those columns. -Dan - 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: My Database Manager
People, now the site is running. Please, if anyone could get, send me suggestions and criticals. Ok I count with you. Alexander - Original Message - From: Chris Boget [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 11:13 AM Subject: Re: My Database Manager Yesterday, someone (I cannot recall who) posted a link for a piece of software called My Database Manager. I tried going to that link on and off for the last day and I'm always getting a 404. Has anyone successfully DL'd this app? If so, could you send me a copy? I'd be very interested in checking it out. Chris sql,query --- arrgh!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error (61)
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) any suggestions on this Jeremiah Ngure #254733684376 ___ Freeserve AnyTime, only £13.99 per month with one month's FREE trial! For more information visit http://www.freeserve.com/time/ or call free on 0800 970 8890 - 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: default-character-set problem
At 10:23 + 11/6/02, nick gatsis wrote: Hello there... I have a problem with sort order. I use greek and english characters. The manual says to put the following lines to my.cnf: [client] character-sets-dir=/usr/local/mysql/share/mysql/charsets default-character-set=greek i restart the demon but the problem still exist. I have 3.23.49 ver on Red Hat Linux 7.2 Thanx list --- sql, query The index entries are still stored in the order of the previous character set. You'll need to rebuild the indexes using the new character set. You can either: - dump, drop, and restore your tables - drop and recreate the indexes for each table - use myisamchk --recover --quick --set-character-set=greek for each table (take the server down if you do this) - use mysqlcheck --recover --quick for each table - use REPAIR TABLE ... QUICK for each table But in any case, you won't be able to sort using greek order sometimes and english order sometimes. Simultaneous character set support will be available in MySQL 4.1, though. - 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
Newbie: Intersecting entities
I'm trying to find some documentation on creating intersecting entities in MySQL, but haven't been able to track any info down on the MySQL site or on the web. At least we called them intersecting entities while I was in Oracle training (which was some time ago). I think I remember how to set them up, but I'd love to have something to refer to quickly before I start. Can anyone point me in the right direction? Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 - 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: load data infile syntax
At 10:03 -0500 11/6/02, Vivian Wang wrote: I did my testing. If I use ESCAPED BY '\\', I got 1064, You have an error in your SQL syntax near ''' at line 2 Using ESCAPED BY '\', then no error and result is fine. If the data contains \, then database will automatically takes \ away and shift 1 byte left. My data will mass up. That is why I still need \ I posted my syntax before, but nobody helped me to figure out. So this time I did my test again and found out only need one \ for ESCAPED BY. I think there's something else wrong with the statement. You do need to use two backslashes to specify an escape character of a single backslash. Can we see the entire LOAD DATA statement exactly as you specified it originally? At 10:43 PM 11/5/2002 -0600, you wrote: At 14:38 -0500 11/5/02, Vivian Wang wrote: The syntac ESCAPED BY of load data infile is wrong in http://www.mysql.com/doc/en/LOAD_DATA.html. the [ESCAPED by '\\'] should be: [ESCAPED BY '\'] Why do you say that? - 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: PHP mysql
So did you find the window with all the extension mappings? Here's what you need to do - Right click on your server root under IIS Manager Under Master Properties click 'Edit' Click on the 'Home Directory' tab Click on 'Configuration' towards the bottom of that window You should see a window with extensions in it [App Mappings] Click Add Under 'Executable' browse and find your php.exe Under 'Extension' put .php or .phtml - or to really throw off the crackers .asp If that doesn't do it for you - I'm out of ideas. :) Jeff - Original Message - From: Bob G [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 3:38 AM Subject: RE: PHP mysql Hi Jeff, many thanks for your reply. I have checked my installation and all the things you suggested were already implemented. Today I re installed. still with no joy. The asp still works however so the server is OK. One difference I cannot find 'Method exclusions' in my configuration settings. Any other Ideas please? Regards Bob -Original Message- From: jeff [mailto:mylist;workingtitle.net] Sent: Tuesday, November 05, 2002 5:47 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: PHP mysql From: http://www.dynamic-webpages.de/php/install.iis.php - If you want to use the CGI binary, do the following: Under 'Home Directory', 'Virtual Directory', or 'Directory', click on the 'Configuration' button, and then enter the App Mappings tab. Click Add, and in the Executable box, type: c:\php\php.exe (assuming that you have unziped PHP in c:\php\). In the Extension box, type the file name extension you want associated with PHP scripts. Leave 'Method exclusions' blank, and check the Script engine checkbox. You may also like to check the 'check that file exists' box - for a small performance penalty, IIS (or PWS) will check that the script file exists and sort out authentication before firing up php. This means that you will get sensible 404 style error messages instead of cgi errors complaing that php did not output any data. You must start over from the previous step for each extension you want associated with PHP scripts. .php and .phtml are common, although .php3 may be required for legacy applications. Set up the appropriate security. (This is done in Internet Service Manager), and if your NT Server uses NTFS file system, add execute rights for I_USR_ to the directory that contains php.exe. In other words, you have to tell IIS to parse .php files with php.exe. Hope that helps! Jeff ** Hi guys, I hope you can show me where I am going wrong. I have ASP working with MySQL I have recently tried to install PHP. I am obviously missing a point. I am running IIS under win2000. Initially I tried to install manually from binary distribution and failed. To get it up and running I went back to Install Shield. The instructions say that just follow the instructions and start using PHP. The relevant PHP.INI was put into WINNT. I suspect I must modify it in some way? I have given privileges to IUSR (read/write) to IIS. I am testing with the following:- html head titlePHP Test/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body bgcolor=#FF text=#00 ?php echo Hello Worldp; ? /body /html Can't be much simpler. But it does not get parsed!! What have I missed? Thanks Bob G - 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: load data infile syntax
This is my statement using python, db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n'); Is python problem? not sure. At 10:01 AM 11/6/2002 -0600, Paul DuBois wrote: At 10:03 -0500 11/6/02, Vivian Wang wrote: I did my testing. If I use ESCAPED BY '\\', I got 1064, You have an error in your SQL syntax near ''' at line 2 Using ESCAPED BY '\', then no error and result is fine. If the data contains \, then database will automatically takes \ away and shift 1 byte left. My data will mass up. That is why I still need \ I posted my syntax before, but nobody helped me to figure out. So this time I did my test again and found out only need one \ for ESCAPED BY. I think there's something else wrong with the statement. You do need to use two backslashes to specify an escape character of a single backslash. Can we see the entire LOAD DATA statement exactly as you specified it originally? At 10:43 PM 11/5/2002 -0600, you wrote: At 14:38 -0500 11/5/02, Vivian Wang wrote: The syntac ESCAPED BY of load data infile is wrong in http://www.mysql.com/doc/en/LOAD_DATA.html. the [ESCAPED by '\\'] should be: [ESCAPED BY '\'] Why do you say that? - 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: load data infile syntax
At 11:18 -0500 11/6/02, Vivian Wang wrote: This is my statement using python, db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n'); Is python problem? not sure. Looks like what's happening is that Python itself is processing escapes before passing the query to MySQL, and MySQL itself will then process escapes. You have to account for the extra level of escape processing. Try this: db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\\n'); At 10:01 AM 11/6/2002 -0600, Paul DuBois wrote: At 10:03 -0500 11/6/02, Vivian Wang wrote: I did my testing. If I use ESCAPED BY '\\', I got 1064, You have an error in your SQL syntax near ''' at line 2 Using ESCAPED BY '\', then no error and result is fine. If the data contains \, then database will automatically takes \ away and shift 1 byte left. My data will mass up. That is why I still need \ I posted my syntax before, but nobody helped me to figure out. So this time I did my test again and found out only need one \ for ESCAPED BY. I think there's something else wrong with the statement. You do need to use two backslashes to specify an escape character of a single backslash. Can we see the entire LOAD DATA statement exactly as you specified it originally? At 10:43 PM 11/5/2002 -0600, you wrote: At 14:38 -0500 11/5/02, Vivian Wang wrote: The syntac ESCAPED BY of load data infile is wrong in http://www.mysql.com/doc/en/LOAD_DATA.html. the [ESCAPED by '\\'] should be: [ESCAPED BY '\'] Why do you say that? - 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: _rowid
[EMAIL PROTECTED] wrote: Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version 3.23.11: If the PRIMARY or UNIQUE key consists of only one column and this is of type integer, one can also refer to it as _rowid Isn't _rowid some type of internal variable? What is its exact purpose and significance? In other words why did the designer of mySQL bother naming that specialized column as such. That has been explained to you already; _IF_ you have a primary key already (that's not internal, that's something _YOU_ create), _THEN_ _rowid exists as a pointer to that primary key, and _ONLY IF_ the primary key is one column and is an integer. Basically, _rowid is completely pointless except if you don't feel like remembering the name of the primary key column in your tables (which I always name 'ID'). Do you understand now? And _WHY_ do you care? What is wrong with using your own primary key (which _rowid _REQUIRES_ anyway)?? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: Re: find longest string in column
sql,query Hi, Joseph Bueno suggested the following syntax: SELECT column_name,length(column_name) as len FROM table_name ORDER BY len DESC LIMIT 1 When I tried this on a column that contains NULL values I get: +--+--+ | text | len | +--+--+ | NULL | NULL | +--+--+ 1 row in set (0.43 sec) (Where text is the column_name) On columns that don't contain NULL values it works fine, so I edited it to: SELECT column_name,length(column_name) as len FROM table_name WHERE column_name IS NOT NULL ORDER BY len DESC LIMIT 1 Which works even on the first column... Is it normal behaviour that NULL values are considered to be longer strings than non-NULL values? Regards -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # - 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: HP-UX10.20 binary distribution aborted, SRC compiler error
knauff, Tuesday, November 05, 2002, 9:26:29 AM, you wrote: kauduhdd I want to use MySQL on a HP9000/800 server mith HP-UX 10.20: kauduhdd + HP9000/839 K210, 1 Processor HPPA1.1 7200 (32 Bit), 256 MB RAM kauduhdd 1. Binary Distribution kauduhdd -- kauduhddVersion: mysql-3.23.53-hp-hpux10.20-hppa1.1 kauduhddInstallation: OK, my.cnf: small, medium kauduhddConfiguring/Running: ERROR -- Programm aborted kauduhdd# scripts/mysql_install_db [skip] kauduhdd021104 7:56:10 Warning: setrlimit couldn't increase number of open kauduhdd files to more than 60 kauduhdd021104 7:56:10 Warning: Changed limits: max_connections: 43 kauduhdd table_cache: 64 kauduhddMemory fault(coredump) kauduhdd^^ [skip] First possible cause is that your patch level and patch level used to make binaries are different. Memory and disk spaces are also may be a problem. Next, MySQL server can work on that HP-UX only with DCE threads. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: unique data sets
Petre, Tuesday, November 05, 2002, 9:26:08 PM, you wrote: PA just out of interest, PA How can I create unique data sets, or rather, set a set of data as PA unique, to prevent another entry in the table that meets the same PA criteria, PA for instance: PA id namesurname address PA 1 johndoe 1 street PA 2 maryjane2 lane PA 3 johndoe 3 ave PA 4 johndoe 1 street PA As you can see row one and row 4 is identical in all 3 collumns, so how PA would I prevent a write like this to the table? You can create UNIQUE key on these three fiels: http://www.mysql.com/doc/en/CREATE_INDEX.html http://www.mysql.com/doc/en/CREATE_TABLE.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Problem creating InnoDB tables.
David, Tuesday, November 05, 2002, 4:05:57 PM, you wrote: DAF I'm have trouble creating InnoDB tables. I'm using MySQL version DAF 3.32.51-max. I have innodb_data_file_path = ibdata1:30M:autoextend in my DAF my.ini file. According to the manual, I should be able to use and create DAF InnoDB tables. When I specify type = InnoDB in my table creation DAF statement, MySQL doesn't give me any errors, but when I use show table DAF status;, the tables show up as MyISAM. Any help would be appreciated. Use SHOW VARIABLES LIKE have_% to see if InnoDB is enabled. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: folders ibdata, iblogs
Arthur, Tuesday, November 05, 2002, 9:58:03 AM, you wrote: A Backpacker in the foot hills of mySQL A I have 4.04beta max-nt running on win 2k SP3 A I can create manipulate InnoDB tables happily. A What are Folders ibdataiblogs for? A Nothing ever appears in them. A my tables automatically get put in C:\MySQL\Bin\data\[DbName] I tested it and all worked perfect for me. Do you mean ibdata file is created in C:/MySQL/bin/data/.. or *.frm files created in that dir? To see InnoDB data home dir use SHOW VARIABLES LIKE innodb% A In my.cnf I have A innodb_data_file_path = ibdata1:400M A innodb_data_home_dir = c:/ibdata A innodb_flush_log_at_trx_commit=1 A innodb_log_archive=0 A innodb_log_group_home_dir = c:/iblogs A innodb_log_arch_dir = c:/iblogs -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: server no longer starts after data folder copy.
Steve, Tuesday, November 05, 2002, 7:47:34 PM, you wrote: SB I have messed up my server just a bit, it no longer starts ;) I have 2 SB servers one on a 98 machine for testing, and another on a 2000 box that is SB being set up for intranet applications at my company. I usually do changes SB etc on the 98 box then just stop both servers and copy the data folder from SB my 98 box to the 2000 box. This time when I wen't to restart the service on SB the 2000 box i get a message Fails to start the service, please wait 30 SB seconds and try again. I did and no go :( SB I'm new to mysql and db admin stuff so what I have been doing is probably SB not the best way to do this, but it has worked for me so far. SB So can anyone tell me what I can do to fix this? SB Also by simply stopping the service on the 2000 box am I actually shutting SB down the server? SB Is there another way I should be doing this kind of thing? SB I am running mysqld-max-nt on the 2000 box, with innodb. First of all you should run server in stanalone mode to see error message: mysqld-max-nt --standalone --console If you want to make backup of InnoDB tables look at: http://www.innodb.com/ibman.html#Backing_up -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: SQL question
John, Tuesday, November 05, 2002, 1:50:32 AM, you wrote: JJ I have a callers table and a citylist table. Both tables have a field JJ 'town' and both tables have a field called 'zipcode'. JJ The citylist is a list of cities and their zip codes. JJ citylist.city and citylist.zipcode JJ The callers table has the same 2 field names, but the zip code field is JJ empty. JJ How can I populate the callers.zipcode field by looking up the the zip JJ code in the cities table? JJ I know how to do simple selects and simple updates, but I do no know how JJ to match the callers.town with the cities.town, and then make JJ callers.zipcode equal the zipcode for the callers.town=cities.town match. John, multi-table updates is supported since 4.0.2. So, if you use MySQL server 4.0.2 or high you can just do: UPDATE callers, cities SET callers.zipcode=cities.zipcode WHERE callers.town=cities.town; Otherwise you can do it with programming language or like describen for DELETE here: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Mysql Problems
Aaron, Tuesday, November 05, 2002, 9:38:34 PM, you wrote: AA My main problem is that I am unable to run the mysql_install_db file. AA Below is what I have tried: AA I can start mysql by using the folowing option: AA shell BINDIR/safe_mysqld --skip-grant-tables AA shell BINDIR/mysql -u root mysql AA However, when start mysql and try to perform anything, it errors our AA with the following: AA ERROR 2013: Lost connection to MySQL server during query AA Here is the entry for the Alpha.err file:: AA Alpha.err AA 021105 12:41:27 mysqld started AA /usr/local/mysql/libexec/mysqld: ready for connections AA mysqld got signal 11; What about installing MySQL server from binaries? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: _rowid
Hello. On Wed 2002-11-06 at 10:59:36 +0100, [EMAIL PROTECTED] wrote: What about the following info in the manual p. 55? Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version 3.23.11: If the PRIMARY or UNIQUE key consists of only one column and this is of type integer, one can also refer to it as _rowid Isn't _rowid some type of internal variable? What is its exact purpose and significance? Well, as it has been implemented due to user request, searching the archives may help: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:39298:cnfpdcnkgalicmjgekef That's a bit long, but quite comprehensive. At the bottom is a list why a _user_ may want to have ROWID. And a view postings later, MySQL AB's view: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:39492:cnfpdcnkgalicmjgekef In other words why did the designer of mySQL bother naming that specialized column as such. My interpretation is this: Because a lot of people, coming from other database engines, are used to ROWID as the fastest access method. So from some point of view, it makes sense to assign _rowid to the fastest access method MySQL makes publically available (namely primary keys), instead of repeatedly explaining that MySQL has no such facitily and why it hasn't, which additionally requires knowledge of the internal details of MySQL. Regards, Benjamin. -- [EMAIL PROTECTED] - 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
Problem importing data from Access
When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the mystery character). I'm using the graphical interface to import data since it fails at the command line even though my version of MySql is a later one than the required 3.22.15. The GUI shows the mystery character as a bold pipe |. The command line seems to show a problem with the size of the field. The select * from table statements look like this on the command line: +--+ | Col 1 | +--+ | data | |ta| |dat| +--+ instead of this: +--+ | Col 1 | +--+ | data | | data | | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of line character to separate records, but maybe it is something else. Any ideas? Thanks, Brad - 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
hierarchical Structure in Mysql
Hi listErs! I need to design a database, under a hierarchical structure. This Mysql database aims to store a catalog in which I should be able to define: CATEGORIES - SubCategories - Sub-SubCategories - Product the only problem, is that I usually use cascaded indexes, but in this case I should use a different approach to allow the catalog for instance to hold products not only in final Sub-Subcategory, but under Subcategories or even directly under a category. What is more the same product should be appear in many different categories at the same time. I have no experience in designing such a structure, and I was wondering if someone can give me hint on how to start, basically if there is a tutorial, to be able to do it the best possible way, and If someone has an example, that would be much appreciated. well, I hope to have been clear enough thanx in advance - 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
Troubleshooting - Can't connect and won't shut down
I have been running a server for almost 2 years completely without incident. I have made no significant changes recently, but for the past month or so I have been having connection problems. Users cannot connect, but existing connections seem to be maintained. Here are some symptoms: I cannot stop the server using mysqladmin. It hangs (I've let it run for an hour) and cannot be interrupted with ctrl-c. The error log shows too many open files ps aux | grep mysql shows a constantly increasing number of mysql processes: mysqluser 11894 0.0 7.5 34692 9692 pts/1S 11:21 0:00 /usr/local/mysql/ There are 600 of them right now :( I'm at a loss as to how to effectively troubleshoot this. Does anyone have any suggestions? The version is 3.23.37 running on RedHat Regards, Gary H. - 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
DateTime comparation problems
Hello bugs, SELECT ... FROM table o WHERE o.date = 2002090100 AND o.date=2002110624 MySQL 3.23.xx - work (returns 0 rows) MySQL 4.0.4 - not work (returns 0 rows) P.S. also in 4.0.4 not work BETWEEN in this case (but as i can see it will be fixed in next release) Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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: load data infile syntax
I tried, db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\\n'); db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\n'); both no error, but my data still shift 1 byte to left. Also, I tried from mysql, mysqlload data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\\' lines terminated by '\n'; no error, but my data still shift to left. mysqlload data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n'; PAGER set to stdout ' ' - ; ERROR 1083: Field separator argument is not what is expected. Check the manual I don't want my data shift to left because the \. Can I change any settings? this python statement works ok for me now, not perfect. I really want escape \, but no shift. db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n'); At 10:26 AM 11/6/2002 -0600, Paul DuBois wrote: At 11:18 -0500 11/6/02, Vivian Wang wrote: This is my statement using python, db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n'); Is python problem? not sure. Looks like what's happening is that Python itself is processing escapes before passing the query to MySQL, and MySQL itself will then process escapes. You have to account for the extra level of escape processing. Try this: db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\\n'); At 10:01 AM 11/6/2002 -0600, Paul DuBois wrote: At 10:03 -0500 11/6/02, Vivian Wang wrote: I did my testing. If I use ESCAPED BY '\\', I got 1064, You have an error in your SQL syntax near ''' at line 2 Using ESCAPED BY '\', then no error and result is fine. If the data contains \, then database will automatically takes \ away and shift 1 byte left. My data will mass up. That is why I still need \ I posted my syntax before, but nobody helped me to figure out. So this time I did my test again and found out only need one \ for ESCAPED BY. I think there's something else wrong with the statement. You do need to use two backslashes to specify an escape character of a single backslash. Can we see the entire LOAD DATA statement exactly as you specified it originally? At 10:43 PM 11/5/2002 -0600, you wrote: At 14:38 -0500 11/5/02, Vivian Wang wrote: The syntac ESCAPED BY of load data infile is wrong in http://www.mysql.com/doc/en/LOAD_DATA.html. the [ESCAPED by '\\'] should be: [ESCAPED BY '\'] Why do you say that? - 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
InnoDB row level locking?
In the documentation it says that InnoDB supports row level locking. How can I ensure that rows are locked using ADO in a VB Applications communicating with MySQL through MyODBC? I have tried setting my Recordsets to adLockPessimistic, but that does not seam to work. Any help will be really appreciated. Thank you, JFernando ** sql ** - 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: HP-UX10.20 binary distribution aborted, SRC compiler error
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 05 November 2002 08:26, [EMAIL PROTECTED] wrote: scripts/mysql_install_db[292]: 28678 Memory fault(coredump) This is not supposed to happen. Does it happen with all binaries within the bin directory of the binary distribution? Have you tried running bin/mysqld directly? ### !!! /opt/dce/includeis not installed ### !!! Therefore I want to use the builtin MIT Threads. CFLAGS=-DHPUX \ CXXFLAGS=-DHPUX -felide-constructors -fno-exceptions -fno-rtti \ CXX=gcc \ CC=gcc \ ./configure \ --with-mit-threads \ --prefix=/usr/local/mysql \ --localstatedir=/usr/local/mysql/data \ --with-low-memory \ --with-mysqld-ldflags=-all-static \ --disable-shared \ --with-extra-charset=complex ( and some other options tried too ). There is the compile error: file pthread.h not found ( I use gmake 3.80 , hint of the manual) MIT pthreads is no longer part of the source distribution. If you want to compile with --with-mit-threads, you first need to download and extract them into the mysql source directory. You can obtain the package from here: http://www.mysql.com/Downloads/Contrib/pthreads-1_60_beta6-mysql.tar.gz Hope that helps - I will make sure that this info is added to the manual as well. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9yVStSVDhKrJykfIRAnhOAJ4oHlCJEZ3R2kufPo82H42iQJriXwCfRe++ TgnLZssSHAeZmtOQAKpqo70= =eSwQ -END PGP SIGNATURE- - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: load data infile syntax
At 12:38 -0500 11/6/02, Vivian Wang wrote: I tried, db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\\n'); db.query(load data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '' lines terminated by '\n'); both no error, but my data still shift 1 byte to left. What do you mean by shift 1 byte to left. What's an example of your input data and how it actually ends up in MySQL? Also, I tried from mysql, mysqlload data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\\' lines terminated by '\n'; no error, but my data still shift to left. mysqlload data infile '/data/winshare/experian/test' into table d_adds fields terminated by '' escaped by '\' lines terminated by '\n'; PAGER set to stdout ' ' - ; ERROR 1083: Field separator argument is not what is expected. Check the manual That last statement is illegal, because '\' needs to be '\\'. - 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: DateTime comparation problems
Try using dashes. -mm-dd -Original Message- From: Andrew Sitnikov [mailto:sitnikov;infonet.ee] Sent: Wednesday, November 06, 2002 9:39 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: DateTime comparation problems Hello bugs, SELECT ... FROM table o WHERE o.date = 2002090100 AND o.date=2002110624 MySQL 3.23.xx - work (returns 0 rows) MySQL 4.0.4 - not work (returns 0 rows) P.S. also in 4.0.4 not work BETWEEN in this case (but as i can see it will be fixed in next release) Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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
publishing mysql database to cd-rom
I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline the steps involved. Thanks in advance, Bob McPeak - 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: Problem importing data from Access
Hi, Are you sure that .txt file is OK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley (Contractor) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 7:06 PM Subject: Problem importing data from Access When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the mystery character). I'm using the graphical interface to import data since it fails at the command line even though my version of MySql is a later one than the required 3.22.15. The GUI shows the mystery character as a bold pipe |. The command line seems to show a problem with the size of the field. The select * from table statements look like this on the command line: +--+ | Col 1 | +--+ | data | |ta| |dat| +--+ instead of this: +--+ | Col 1 | +--+ | data | | data | | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of line character to separate records, but maybe it is something else. Any ideas? Thanks, Brad - 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: PHP mysql
Hi Jeff.Again thanks for your help. Yes, as I said I have done all the obvious (to me) things according to the windows install under win 2000. I am not using .ASP to test so no point in playing with that. You did not explain what or where is 'Method exclusions'. Thanks again Regards Bob -Original Message- From: jeff e [mailto:mylist;workingtitle.net] Sent: Wednesday, November 06, 2002 4:04 PM To: Bob G; [EMAIL PROTECTED] Subject: Re: PHP mysql So did you find the window with all the extension mappings? Here's what you need to do - Right click on your server root under IIS Manager Under Master Properties click 'Edit' Click on the 'Home Directory' tab Click on 'Configuration' towards the bottom of that window You should see a window with extensions in it [App Mappings] Click Add Under 'Executable' browse and find your php.exe Under 'Extension' put .php or .phtml - or to really throw off the crackers .asp If that doesn't do it for you - I'm out of ideas. :) Jeff - Original Message - From: Bob G [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 3:38 AM Subject: RE: PHP mysql Hi Jeff, many thanks for your reply. I have checked my installation and all the things you suggested were already implemented. Today I re installed. still with no joy. The asp still works however so the server is OK. One difference I cannot find 'Method exclusions' in my configuration settings. Any other Ideas please? Regards Bob -Original Message- From: jeff [mailto:mylist;workingtitle.net] Sent: Tuesday, November 05, 2002 5:47 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: PHP mysql From: http://www.dynamic-webpages.de/php/install.iis.php - If you want to use the CGI binary, do the following: Under 'Home Directory', 'Virtual Directory', or 'Directory', click on the 'Configuration' button, and then enter the App Mappings tab. Click Add, and in the Executable box, type: c:\php\php.exe (assuming that you have unziped PHP in c:\php\). In the Extension box, type the file name extension you want associated with PHP scripts. Leave 'Method exclusions' blank, and check the Script engine checkbox. You may also like to check the 'check that file exists' box - for a small performance penalty, IIS (or PWS) will check that the script file exists and sort out authentication before firing up php. This means that you will get sensible 404 style error messages instead of cgi errors complaing that php did not output any data. You must start over from the previous step for each extension you want associated with PHP scripts. .php and .phtml are common, although .php3 may be required for legacy applications. Set up the appropriate security. (This is done in Internet Service Manager), and if your NT Server uses NTFS file system, add execute rights for I_USR_ to the directory that contains php.exe. In other words, you have to tell IIS to parse .php files with php.exe. Hope that helps! Jeff ** Hi guys, I hope you can show me where I am going wrong. I have ASP working with MySQL I have recently tried to install PHP. I am obviously missing a point. I am running IIS under win2000. Initially I tried to install manually from binary distribution and failed. To get it up and running I went back to Install Shield. The instructions say that just follow the instructions and start using PHP. The relevant PHP.INI was put into WINNT. I suspect I must modify it in some way? I have given privileges to IUSR (read/write) to IIS. I am testing with the following:- html head titlePHP Test/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body bgcolor=#FF text=#00 ?php echo Hello Worldp; ? /body /html Can't be much simpler. But it does not get parsed!! What have I missed? Thanks Bob G - 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: Problem importing data from Access
I have seen this when Windows was involved. Windows word and note pads have a different new line character than Un*x type systems. Perhaps that's what's foiling the sql query. ~K Black -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 10:54 AM To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Are you sure that .txt file is OK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley (Contractor) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 7:06 PM Subject: Problem importing data from Access When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the mystery character). I'm using the graphical interface to import data since it fails at the command line even though my version of MySql is a later one than the required 3.22.15. The GUI shows the mystery character as a bold pipe |. The command line seems to show a problem with the size of the field. The select * from table statements look like this on the command line: +--+ | Col 1 | +--+ | data | |ta| |dat| +--+ instead of this: +--+ | Col 1 | +--+ | data | | data | | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of line character to separate records, but maybe it is something else. Any ideas? Thanks, Brad - 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: using libmysqld - can't connect to remote DB as client.
I'm using libmysqld so I can have an embedded mysql server in my application. It helps with performance because there is not socket communication and all I/O is done from the program directly to the files. Anyway, I have the need to also connect to a remote database in the same application. My code works fine with the local embedded mysql server, I can connect to the local server, create a database and manipulate the data, but when I try to connect to a remote database, it fails. The C function that I'm using is mysql_real_connect. The mysql_connect that you're talking about is just a wrapper function that I wrote. The mysql_real_connect() is down further in the code. Did you get my code? I sent it to the list, but the list bounced it because the list didn't allow attachments. Anyway, According to the docs for the mysqld library (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld) There is nothing that says that the mysql_real_connect should work any differently than the one in the normal library. So, I'm thinking that either the documentation is incorrect (mysql_real_connect *DOESN'T* include any socket-level capability in the mysqld lib like it does in the normal library) or I'm just doing something wrong when I try to connect to a remote database with mysql_real_connect. The man page for mysql_real_connect is here: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect - Steve --- Bernhard_Döbler [EMAIL PROTECTED] wrote: Have you looked thru the source to see if there are differences in the libmysql and libmysqld implementation of mysql_connect()? If mysql_connect does not work then you must see in the source why. Why do you link against libmysqld when you nee libmysql functionality? Bernhard - Original Message - From: Steven Webb [EMAIL PROTECTED] To: Mysql list [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002 8:19 PM Subject: Re: using libmysqld - can't connect to remote DB as client. Still nobody has answered my question. Has anyone here even tried linking with libmysqld.a before? - Steve --- Steven Webb [EMAIL PROTECTED] wrote: Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); Has anyone tried this. I'm using the 4.0.4 beta source tree. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual)
RE: using libmysqld - can't connect to remote DB as client.
From the mysql docs on the website (URL: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect) The proto 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 int client_flag); I'm calling it as: mysql_real_connect(db, host, user, passwd, dbname, 0, NULL, CLIENT_COMPRESS); That should work, yes? My code is almost the exact same as the libmysqld example source here (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld_example) except after making the local connection, I try a remote connection afterwards. I can send code to anyone if they want, but the mailing list bounced my attachment when I tried to send the code to the list. - Steve - Steve --- Luc Foisy [EMAIL PROTECTED] wrote: not sure if this applies here, its from the c++ api docs (but why switch it around) Do you have the parameters sent in the right order? // The full format for the Connection constructor is // Connection(cchar *db, cchar *host=, //cchar *user=, cchar *passwd=) I really know nothing about the c, c++ api's, just trying to help -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 3:58 PM To: Black, Kelly W [PCS]; Mysql list Subject: RE: using libmysqld - can't connect to remote DB as client. I am. See the original post: // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); --- Black, Kelly W [PCS] [EMAIL PROTECTED] wrote: So use the C syntx instead. :) -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 12:21 PM To: Black, Kelly W [PCS]; Mysql list Subject: RE: using libmysqld - can't connect to remote DB as client. Ok, but I'm writing this in C, not perl. - Steve --- Black, Kelly W [PCS] [EMAIL PROTECTED] wrote: I think your problem might be here - you have db_connect(my_blah_database); Try using something like my $dbh = DBI-connect(DBI:mysql:$dbname:hostname, $dbuser, $dbpasswd) || die can't connect: $DBI::errstr\n; Also make sure you include the || die can't connect: $DBI::errstr\n; as in this way you can get some useful error output about the connect. Not certain but at least I am trying to help :) Oh and don't forget sql query! :) ~Kelly W. Black -Original Message- From: Steven Webb [mailto:scumola;yahoo.com] Sent: Tuesday, November 05, 2002 11:20 AM To: Mysql list Subject: Re: using libmysqld - can't connect to remote DB as client. Still nobody has answered my question. Has anyone here even tried linking with libmysqld.a before? - Steve --- Steven Webb [EMAIL PROTECTED] wrote: Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); - 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 __ Do you Yahoo!? HotJobs - Search new jobs
mysqld_multi
Any opinions on running mysqld_multi? Our architecture, X-serve, 2GBs RAM,Dual Procs, 480 GB stogage as Master MySQL server replicated to a less impressive server. Seems logical to separate the heavy-hitter dbs to their own servers and take more advantage of the server's resources. Chris - 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: Problem importing data from Access
Hi, Is no difference but in *nix some text editors (like vi for example) put only the LineFeed(0Ah) character and not CarriageReturn and LineFeed like in Windows(0Dh,0Ah). Almost sure is something wrong with the .txt file.Few days a go i have a similar situation and it was from the the dump/.txt file.Data in the .txt file must be in the same order with the fields/columns from MySQL table. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Black, Kelly W [PCS] [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; Schroeder, Bradley (Contractor) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 9:04 PM Subject: RE: Problem importing data from Access I have seen this when Windows was involved. Windows word and note pads have a different new line character than Un*x type systems. Perhaps that's what's foiling the sql query. ~K Black -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 10:54 AM To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Are you sure that .txt file is OK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley (Contractor) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 7:06 PM Subject: Problem importing data from Access When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the mystery character). I'm using the graphical interface to import data since it fails at the command line even though my version of MySql is a later one than the required 3.22.15. The GUI shows the mystery character as a bold pipe |. The command line seems to show a problem with the size of the field. The select * from table statements look like this on the command line: +--+ | Col 1 | +--+ | data | |ta| |dat| +--+ instead of this: +--+ | Col 1 | +--+ | data | | data | | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of line character to separate records, but maybe it is something else. Any ideas? Thanks, Brad - 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: Problem importing data from Access
This is incorrect. !google new line character linux windows -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 11:33 AM To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Is no difference but in *nix some text editors (like vi for example) put only the LineFeed(0Ah) character and not CarriageReturn and LineFeed like in Windows(0Dh,0Ah). Almost sure is something wrong with the .txt file.Few days a go i have a similar situation and it was from the the dump/.txt file.Data in the .txt file must be in the same order with the fields/columns from MySQL table. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Black, Kelly W [PCS] [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; Schroeder, Bradley (Contractor) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 9:04 PM Subject: RE: Problem importing data from Access I have seen this when Windows was involved. Windows word and note pads have a different new line character than Un*x type systems. Perhaps that's what's foiling the sql query. ~K Black -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 10:54 AM To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Are you sure that .txt file is OK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley (Contractor) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 7:06 PM Subject: Problem importing data from Access When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the mystery character). I'm using the graphical interface to import data since it fails at the command line even though my version of MySql is a later one than the required 3.22.15. The GUI shows the mystery character as a bold pipe |. The command line seems to show a problem with the size of the field. The select * from table statements look like this on the command line: +--+ | Col 1 | +--+ | data | |ta| |dat| +--+ instead of this: +--+ | Col 1 | +--+ | data | | data | | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of line character to separate records, but maybe it is something else. Any ideas? Thanks, Brad - 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
publishing mysql database to cd-rom
I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline the steps involved. Thanks in advance, Bob McPeak - 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: Problem importing data from Access
The text file seems to be fine as far as I can tell. The columns are all in the correct order. It sounds like I need to look out for the line feed character, as well as the carriage return since I'm working on Windows. Anybody know how the line feed character is represented? -Original Message- From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] Sent: Wednesday, November 06, 2002 12:34 PM To: 'Gelu Gogancea'; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: RE: Problem importing data from Access This is incorrect. !google new line character linux windows -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 11:33 AM To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Is no difference but in *nix some text editors (like vi for example) put only the LineFeed(0Ah) character and not CarriageReturn and LineFeed like in Windows(0Dh,0Ah). Almost sure is something wrong with the .txt file.Few days a go i have a similar situation and it was from the the dump/.txt file.Data in the .txt file must be in the same order with the fields/columns from MySQL table. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Black, Kelly W [PCS] [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; Schroeder, Bradley (Contractor) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 9:04 PM Subject: RE: Problem importing data from Access I have seen this when Windows was involved. Windows word and note pads have a different new line character than Un*x type systems. Perhaps that's what's foiling the sql query. ~K Black -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 10:54 AM To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Are you sure that .txt file is OK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley (Contractor) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 7:06 PM Subject: Problem importing data from Access When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the mystery character). I'm using the graphical interface to import data since it fails at the command line even though my version of MySql is a later one than the required 3.22.15. The GUI shows the mystery character as a bold pipe |. The command line seems to show a problem with the size of the field. The select * from table statements look like this on the command line: +--+ | Col 1 | +--+ | data | |ta| |dat| +--+ instead of this: +--+ | Col 1 | +--+ | data | | data | | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of line character to separate records, but maybe it is something else. Any ideas? Thanks, Brad - 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: hierarchical Structure in Mysql
Your structure is going to be a lot like a message board: Message Board- Topic-Reply-Reply-... Where you can reply to someone else's reply or reply to the main topic. Your setup would have two tables, a category table and a product table. You get your cascade by each category having a field to indicate the parent category. If the field is NULL or ) or something you decide, then you've it a main category. The final subcategory then has the product id field populate which links to the product table. ProductCategories -- RecordID ParentID (contains the RecordID of another record) ProductID Products ProductID Product Categories --- CategoryID Category This structure will give you unlimited levels, although it will be harder to query since you have to traverse the tree to get all your information. It ends up being about 1 query for each sublevel. You can do it in one query with joins and table aliases, but that gets limiting as your levels grow. On Wednesday, November 6, 2002, at 12:43 PM, Walter D. Funk wrote: I need to design a database, under a hierarchical structure. This Mysql database aims to store a catalog in which I should be able to define: CATEGORIES - SubCategories - Sub-SubCategories - Product -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 4.x for debian?
On Wed, Nov 06, 2002 at 11:44:03AM +0100, Lenz Grimmer wrote: Yes, we plan to add more package formats apart from tarballs in the future, it's on my TODO. Debian packages are quite high on the priority list there, but I don't know, when I will be able to start with it - I have a lot of RPM background, but I need to read up on how to build DEBs. Do I need to have Debian installed? Or is it sufficient to install the required tools on another distribution? Actually, you should work with the current mysql maintainer for Debian. I'm sure he'd be thrilled to have official help from MySQL AB. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 92 days, processed 1,930,683,020 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems dumping from mysql 3.23 to 4.0
hi having some issues dumping from mysql 3.23 to 4.0 getting table error messages trying to import back into 4.0 sometimes i've had to change the cell names ie group to groups somehow having a cell name group was causing error :| sql - 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: Problem importing data from Access
ASCII table is the same for ALL OS. In my understanding to be a new line character is to have a different representation.. So ...always: the LineFeed is 0Ah and CarriageReturn is 0Dh Windows use 0A,0D and some *nix editors use only 0A to make new line. This is means only the rule for breaking lines in a sequential file is different. The characters which are used in this rule are the same. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Black, Kelly W [PCS] [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; Schroeder, Bradley (Contractor) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 9:33 PM Subject: RE: Problem importing data from Access This is incorrect. !google new line character linux windows -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 11:33 AM To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Is no difference but in *nix some text editors (like vi for example) put only the LineFeed(0Ah) character and not CarriageReturn and LineFeed like in Windows(0Dh,0Ah). Almost sure is something wrong with the .txt file.Few days a go i have a similar situation and it was from the the dump/.txt file.Data in the .txt file must be in the same order with the fields/columns from MySQL table. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Black, Kelly W [PCS] [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; Schroeder, Bradley (Contractor) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 9:04 PM Subject: RE: Problem importing data from Access I have seen this when Windows was involved. Windows word and note pads have a different new line character than Un*x type systems. Perhaps that's what's foiling the sql query. ~K Black -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 10:54 AM To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Are you sure that .txt file is OK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley (Contractor) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 7:06 PM Subject: Problem importing data from Access When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the mystery character). I'm using the graphical interface to import data since it fails at the command line even though my version of MySql is a later one than the required 3.22.15. The GUI shows the mystery character as a bold pipe |. The command line seems to show a problem with the size of the field. The select * from table statements look like this on the command line: +--+ | Col 1 | +--+ | data | |ta| |dat| +--+ instead of this: +--+ | Col 1 | +--+ | data | | data | | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of line character to separate records, but maybe it is something else. Any ideas? Thanks, Brad - 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: Problem creating InnoDB tables.
- Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 11:47 AM Subject: re: Problem creating InnoDB tables. David, Tuesday, November 05, 2002, 4:05:57 PM, you wrote: DAF I'm have trouble creating InnoDB tables. I'm using MySQL version DAF 3.32.51-max. I have innodb_data_file_path = ibdata1:30M:autoextend in my DAF my.ini file. According to the manual, I should be able to use and create DAF InnoDB tables. When I specify type = InnoDB in my table creation DAF statement, MySQL doesn't give me any errors, but when I use show table DAF status;, the tables show up as MyISAM. Any help would be appreciated. Use SHOW VARIABLES LIKE have_% to see if InnoDB is enabled. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -End Original Message- I did that, and across from have_innodb it says NO. How could I enable InnoDB? - 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: Problem importing data from Access
Hi, You must use a HEX editor to see this characters which are not printable.I use DOS NAVIGATOR...it's free and you can download it from the INTERNET. You must view the file in HEX and find the characters 0A,0D on the end of line. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley (Contractor) [EMAIL PROTECTED] To: 'Black, Kelly W [PCS]' [EMAIL PROTECTED]; 'Gelu Gogancea' [EMAIL PROTECTED]; Schroeder, Bradley (Contractor) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 9:41 PM Subject: RE: Problem importing data from Access The text file seems to be fine as far as I can tell. The columns are all in the correct order. It sounds like I need to look out for the line feed character, as well as the carriage return since I'm working on Windows. Anybody know how the line feed character is represented? -Original Message- From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] Sent: Wednesday, November 06, 2002 12:34 PM To: 'Gelu Gogancea'; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: RE: Problem importing data from Access This is incorrect. !google new line character linux windows -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 11:33 AM To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Is no difference but in *nix some text editors (like vi for example) put only the LineFeed(0Ah) character and not CarriageReturn and LineFeed like in Windows(0Dh,0Ah). Almost sure is something wrong with the .txt file.Few days a go i have a similar situation and it was from the the dump/.txt file.Data in the .txt file must be in the same order with the fields/columns from MySQL table. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Black, Kelly W [PCS] [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; Schroeder, Bradley (Contractor) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 9:04 PM Subject: RE: Problem importing data from Access I have seen this when Windows was involved. Windows word and note pads have a different new line character than Un*x type systems. Perhaps that's what's foiling the sql query. ~K Black -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 10:54 AM To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Are you sure that .txt file is OK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley (Contractor) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 7:06 PM Subject: Problem importing data from Access When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the mystery character). I'm using the graphical interface to import data since it fails at the command line even though my version of MySql is a later one than the required 3.22.15. The GUI shows the mystery character as a bold pipe |. The command line seems to show a problem with the size of the field. The select * from table statements look like this on the command line: +--+ | Col 1 | +--+ | data | |ta| |dat| +--+ instead of this: +--+ | Col 1 | +--+ | data | | data | | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of line character to separate records, but maybe it is something else. Any ideas? Thanks, Brad - 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:
publishing mysql database to cd-rom
I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline the steps involved. Thanks in advance, Bob McPeak - 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: hierarchical Structure in Mysql
IIRC, SQL For Smarties has some excellent advice on how to handle tree structures in an SQL database efficiently, by treating nodes as sets (set in the mathematical sense). You can efficiently do queries along the lines of get me everything in category X or any of it's sub(-sub)-categories. -JF -Original Message- From: Brent Baisley [mailto:brent;landover.com] Sent: Wednesday, November 06, 2002 11:44 AM To: Walter D. Funk Cc: [EMAIL PROTECTED] Subject: Re: hierarchical Structure in Mysql Your structure is going to be a lot like a message board: Message Board- Topic-Reply-Reply-... Where you can reply to someone else's reply or reply to the main topic. Your setup would have two tables, a category table and a product table. You get your cascade by each category having a field to indicate the parent category. If the field is NULL or ) or something you decide, then you've it a main category. The final subcategory then has the product id field populate which links to the product table. ProductCategories -- RecordID ParentID (contains the RecordID of another record) ProductID Products ProductID Product Categories --- CategoryID Category This structure will give you unlimited levels, although it will be harder to query since you have to traverse the tree to get all your information. It ends up being about 1 query for each sublevel. You can do it in one query with joins and table aliases, but that gets limiting as your levels grow. On Wednesday, November 6, 2002, at 12:43 PM, Walter D. Funk wrote: I need to design a database, under a hierarchical structure. This Mysql database aims to store a catalog in which I should be able to define: CATEGORIES - SubCategories - Sub-SubCategories - Product -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - 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: problems dumping from mysql 3.23 to 4.0
Group is a reserved word. GROUP BY Dan Rossi wrote: hi having some issues dumping from mysql 3.23 to 4.0 getting table error messages trying to import back into 4.0 sometimes i've had to change the cell names ie group to groups somehow having a cell name group was causing error :| sql - 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: publishing mysql database to cd-rom
I saw something mentioned here once about a product called Microweb. I have never used it nor do I know anyone that has used it. For what it's worth, I think the website is here http://www.indigostar.com/microweb.htm. Duncan --- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -Original Message- From: ROBERT MCPEAK [mailto:RMCPEAK;jhuccp.org] Sent: Wednesday, November 06, 2002 3:03 PM To: [EMAIL PROTECTED] Subject: publishing mysql database to cd-rom I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline the steps involved. Thanks in advance, Bob McPeak - 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: publishing mysql database to cd-rom
This is a good lead. Thanks. Salada, Duncan [EMAIL PROTECTED] 11/06/02 03:40PM I saw something mentioned here once about a product called Microweb. I have never used it nor do I know anyone that has used it. For what it's worth, I think the website is here http://www.indigostar.com/microweb.htm. Duncan --- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -Original Message- From: ROBERT MCPEAK [mailto:RMCPEAK;jhuccp.org] Sent: Wednesday, November 06, 2002 3:03 PM To: [EMAIL PROTECTED] Subject: publishing mysql database to cd-rom I've got a web-based mysql database solution that I'd like to publish to cd-rom. It's a catalog solution using PHP and mySQL. Is it possible to publish a website such as this to a cd-rom as a stand-alone application? Could somebody point me towards some resources for doing this or outline the steps involved. Thanks in advance, Bob McPeak - 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: problems dumping from mysql 3.23 to 4.0
thats the thing group is a cell name, it should be totally seperate from the query command , it obviously worked in 3.23 but when moving over to 4 it causes errors, this is not good, how are we supposed to move over an entire hosting site with client databases if some fields are going to cause errors , its impossible to change them or it'll break their sites -Original Message- From: gerald_clark [mailto:gerald_clark;suppliersystems.com] Sent: Thursday, November 07, 2002 7:19 AM To: Dan Rossi Cc: [EMAIL PROTECTED] Subject: Re: problems dumping from mysql 3.23 to 4.0 Group is a reserved word. GROUP BY Dan Rossi wrote: hi having some issues dumping from mysql 3.23 to 4.0 getting table error messages trying to import back into 4.0 sometimes i've had to change the cell names ie group to groups somehow having a cell name group was causing error :| sql - 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: Problem importing data from Access
I figured it out. Thanks for all the tips everyone. I didn't know there were 2 characters at the end of a line in Windows. For anyone who has this problem: Use \r\n to separate records Use \t instead of a comma to deliminate fields -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 1:02 PM To: Schroeder, Bradley (Contractor); 'Black, Kelly W [PCS]'; [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, You must use a HEX editor to see this characters which are not printable.I use DOS NAVIGATOR...it's free and you can download it from the INTERNET. You must view the file in HEX and find the characters 0A,0D on the end of line. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley (Contractor) [EMAIL PROTECTED] To: 'Black, Kelly W [PCS]' [EMAIL PROTECTED]; 'Gelu Gogancea' [EMAIL PROTECTED]; Schroeder, Bradley (Contractor) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 9:41 PM Subject: RE: Problem importing data from Access The text file seems to be fine as far as I can tell. The columns are all in the correct order. It sounds like I need to look out for the line feed character, as well as the carriage return since I'm working on Windows. Anybody know how the line feed character is represented? -Original Message- From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] Sent: Wednesday, November 06, 2002 12:34 PM To: 'Gelu Gogancea'; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: RE: Problem importing data from Access This is incorrect. !google new line character linux windows -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 11:33 AM To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Is no difference but in *nix some text editors (like vi for example) put only the LineFeed(0Ah) character and not CarriageReturn and LineFeed like in Windows(0Dh,0Ah). Almost sure is something wrong with the .txt file.Few days a go i have a similar situation and it was from the the dump/.txt file.Data in the .txt file must be in the same order with the fields/columns from MySQL table. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Black, Kelly W [PCS] [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; Schroeder, Bradley (Contractor) [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 9:04 PM Subject: RE: Problem importing data from Access I have seen this when Windows was involved. Windows word and note pads have a different new line character than Un*x type systems. Perhaps that's what's foiling the sql query. ~K Black -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Wednesday, November 06, 2002 10:54 AM To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, Are you sure that .txt file is OK? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Schroeder, Bradley (Contractor) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 7:06 PM Subject: Problem importing data from Access When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the mystery character). I'm using the graphical interface to import data since it fails at the command line even though my version of MySql is a later one than the required 3.22.15. The GUI shows the mystery character as a bold pipe |. The command line seems to show a problem with the size of the field. The select * from table statements look like this on the command line: +--+ | Col 1 | +--+ | data | |ta| |dat| +--+ instead of this: +--+ | Col 1 | +--+ | data | | data | | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of
mysqladmin shutdown leaving stray processes
Hi all. This is a re-post of a problem I originally had under MySQL-4.0.3, which I thought might be due to me compiling with K6 flags, but I have recompiled using i686 flags (and using MySQL-4.0.4) and still get stray processes running: bash-2.05# ps ax | grep mysql 11565 ?S 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --enable-loc 11601 ?S 0:01 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25789 ?S 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --enable-loc 25825 ?S 0:01 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25827 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25828 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25829 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25830 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25831 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25832 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25833 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25834 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25835 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27319 ?S 0:04 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27334 ?S 0:06 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27374 ?S 0:02 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27492 ?S 0:05 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27524 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27536 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27548 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27554 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27581 pts/15 S 0:00 grep mysql bash-2.05# I then do a: bash-2.05# kill -9 11565 11601 which fixes it: bash-2.05# ps ax | grep mysql 25789 ?S 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --enable-loc 25825 ?S 0:01 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25827 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25828 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25829 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25830 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25831 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25832 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25833 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25834 ?S 0:01 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 25835 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27334 ?S 0:07 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27374 ?S 0:02 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27524 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27536 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27554 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27583 ?S 0:05 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27588 ?S 0:01 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27592 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27598 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27601 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27618 ?S 0:04 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27654 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27784 ?S 0:00 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27787 ?S 0:01 /usr/local/mysql-4.0.4/libexec/mysqld --basedir=/usr/ 27796 pts/15 S 0:00 grep mysql bash-2.05# There is nothing in any of the logs about this (the hostname.err log or the hostname.xxx log from --log-update). Does anyone know what is causing this? I haven't noticed any corruption yet, but I still don't feel very good about it. I have ensured all clients have closed all connections before shutting MySQL down (this happens at midnight when I do a mysqldump backup). Also the problem only happens about 50% of the time - I haven't figured out any conditions which trigger it yet. Thanks in advance! -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before
Re: problems dumping from mysql 3.23 to 4.0
Dan Rossi wrote: thats the thing group is a cell name, it should be totally seperate from the query command , it obviously worked in 3.23 but when moving over to 4 it causes errors, this is not good, how are we supposed to move over an entire hosting site with client databases if some fields are going to cause errors , its impossible to change them or it'll break their sites Use the command-line flag '--quote-names' with mysqldump. It will surround table/column names with a quote character, which should prevent this problem. -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: performace question
On Wed, Nov 06, 2002 at 12:28:00AM -0500, Murad Nayal wrote: thanks jeremy for the reply Jeremy Zawodny wrote: any idea why is it that the mysqld daemon is not using the CPUs and/or why is this taking so long?? You might benefit from a larger key buffer. Can you show us the output of vmstat 1 for 10 or 20 seconds? What would be an appropriate key_buffer_size. Well, as big as you can afford while you're doing the massive index builds. How about 1GB? other 'typical' operations I would need to perform are joins of say 15-20 tables each about 1,000,000 rows or so. of course the plan is to index all the join columns. the end result of the joins should be the same size as an individual table. i.e. for each row of first table there should be only one matching row of the second and so on. should the key_buffer_size be roughly the size of all the index files of these tables combined? If you can afford it, that'd be great. But it may not be practical either. It seems that poor performance related to my earlier question was due to disk io delays after all. IRIX has a 'sar' command that probably does the same thing as vmstat. here is the output (half way through the index building: the 50% idle is due to the second processer. 00:22:13 %usr %sys %intr %wio %idle %sbrk %wfs %wswp %wphy %wgsw %wfif 00:22:1815 3 03348 099 0 0 1 0 00:22:23 9 2 04149 0 100 0 0 0 0 Yeah, I'm guessing that %wio means percent of time waiting on I/O or something close to that. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 92 days, processed 1,932,691,988 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GROUP BY - CONCAT query question?
Hi all. 3 tables. Ticket Pipeline_Dept, and Ticket_Matrix. Ticket_Matrix matches tickets to pipeline depts. A ticket can be posted to multiple pipeline depts. I want to select all tickets and the pipeline departments they are posted to but only one row per ticket. So: SELECT t.ticketID, p.pipelineName FROM Ticket t LEFT JOIN Ticket_Matrix tm ON t.ticketID = tm.ticketID LEFT JOIN Pipeline_Dept p ON p.pipelineID = tm.pipelineID This is what I want: +--+--+ | ticketID | pipelineName | +--+--+ | 163 | IT, Adv.Tech, RD| | 164 | IT, RD | | 165 | Video, Multimedia| | ... | ... | +--+--+ This is what I get now: +--+--+ | ticketID | pipelineName | +--+--+ | 163 | IT | | 163 | Adv.Tech | | 163 | RD | | 164 | IT | | 164 | RD | | 165 | Video| | 165 | Multimedia | | ... | ... | +--+--+ I cannot do it with PHP because my query depends on LIMIT and returning a set number of rows. If I use PHP to do the concat-ing, the number of rows may be LIMIT. I appreciate any help. kp - This mail sent through IMP: http://horde.org/imp/ - 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/courier-imap/postfix socket problem
Hi, I try to get courier-imap, mysql, postfix installed. I followed all the howto's I could find, but I have still some problems. Perhaps anybody ideas. I know the problem may not origin from an sql problem, but you never know. I use debian woody 3.0 and installed with apt-get the packages, also postfix-mysql for creating the mysql mappings. I receive the following problems : postfix/trivial-rewrite[5498]: warning: connect to mysql server localhost: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Nov 7 00:34:56 spiderke postfix/trivial-rewrite[5498]: fatal: transport table lookup problem Nov 7 00:34:57 spiderke postfix/master[5487]: warning: process /usr/lib/postfix/trivial-rewrite pid 5498 exit status 1 It is a bit strange, that I receive this message, since the file /etc/courier/authmysqlrc I find MYSQL_SOCKET/var/run/mysqld/mysql.sock For the rest there are a lot of other mysql databases, and they work fine. So I want to find out why the heck he uses mysqld.sock and not mysql.sock. I already tried with ln -s /var/run/mysqld/mysql.sock /var/run/mysqld/mysqld.sock But that didn't help. Anybody any ideas ? Greetz, Johan - 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: timestamp updated on select
Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. - 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: using libmysqld - can't connect to remote DB as client.
At 11:09 -0800 11/6/02, Steven Webb wrote: I'm using libmysqld so I can have an embedded mysql server in my application. It helps with performance because there is not socket communication and all I/O is done from the program directly to the files. Anyway, I have the need to also connect to a remote database in the same application. My code works fine with the local embedded mysql server, I can connect to the local server, create a database and manipulate the data, but when I try to connect to a remote database, it fails. The C function that I'm using is mysql_real_connect. The mysql_connect that you're talking about is just a wrapper function that I wrote. The mysql_real_connect() is down further in the code. Did you get my code? I sent it to the list, but the list bounced it because the list didn't allow attachments. Anyway, According to the docs for the mysqld library (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld) There is nothing that says that the mysql_real_connect should work any differently than the one in the normal library. Nothing there, perhaps. But the general description of the embedded server points out that it does no networking. You cannot use an embedded app to connect to remote servers, nor can external clients connect to the embedded server. (This is one reason the manual says embedded servers can't be used in replication.) So, I'm thinking that either the documentation is incorrect (mysql_real_connect *DOESN'T* include any socket-level capability in the mysqld lib like it does in the normal library) or I'm just doing something wrong when I try to connect to a remote database with mysql_real_connect. The man page for mysql_real_connect is here: http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect - Steve - 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: mysqld_multi
At 13:22 -0600 11/6/02, Raymer, Chris wrote: Any opinions on running mysqld_multi? Our architecture, X-serve, 2GBs RAM,Dual Procs, 480 GB stogage as Master MySQL server replicated to a less impressive server. Seems logical to separate the heavy-hitter dbs to their own servers and take more advantage of the server's resources. What's this got to do with mysqld_multi, which is used for running multiple servers on the *same* machine? Chris - 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: Newbie: Intersecting entities
if a succinct statement is possible, perhaps you could give us an idea of its nature? somebody may be familiar with the concept under a different name. I'm trying to find some documentation on creating intersecting entities in MySQL, but haven't been able to track any info down on the MySQL site or on the web. At least we called them intersecting entities while I was in Oracle training (which was some time ago). I think I remember how to set them up, but I'd love to have something to refer to quickly before I start. Can anyone point me in the right direction? Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem importing data from Access
try this: 1. export the data from ms access to a file on the windows box. 2. fire up ftp from the command line and set it to ascii mode. 3. ftp the file from the windows box to the linux box. if the eol is the problem, the ftp protocol will insure that the eol is correctly translated when moved to the new system. When I import data from the text file I exported out of Access it works correctly except that MySql seems to append and/or prepend some sort of mystery character to the fields it imports. So, I can get the data into the database, but I can't get it out (since the SQL statement can't match the mystery character). I'm using the graphical interface to import data since it fails at the command line even though my version of MySql is a later one than the required 3.22.15. The GUI shows the mystery character as a bold pipe |. The command line seems to show a problem with the size of the field. The select * from table statements look like this on the command line: +--+ | Col 1 | +--+ | data | |ta| |dat| +--+ instead of this: +--+ | Col 1 | +--+ | data | | data | | data | +--+ My guess is that there is a problem with the end of line character being exported to the text file from Access. I chose \n as the end of line character to separate records, but maybe it is something else. Any ideas? Thanks, Brad -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: timestamp updated on select
At 23:47 + 11/6/02, Nikolas Galanis wrote: Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. You're saying that performing a SELECT on the table causes the TIMESTAMP column to *change*? That shouldn't happen. - 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: timestamp updated on select
Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated. On Wed, 6 Nov 2002, Paul DuBois wrote: At 23:47 + 11/6/02, Nikolas Galanis wrote: Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. You're saying that performing a SELECT on the table causes the TIMESTAMP column to *change*? That shouldn't happen. - 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: problems dumping from mysql 3.23 to 4.0
thanks man = Original Message From Mark Matthews [EMAIL PROTECTED] = Dan Rossi wrote: thats the thing group is a cell name, it should be totally seperate from the query command , it obviously worked in 3.23 but when moving over to 4 it causes errors, this is not good, how are we supposed to move over an entire hosting site with client databases if some fields are going to cause errors , its impossible to change them or it'll break their sites Use the command-line flag '--quote-names' with mysqldump. It will surround table/column names with a quote character, which should prevent this problem. -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Complicated (to me) query
Hello All, I have a SQL query I need help with: Here are my tables: mysql desc file; +-+-+--+-+-+ ---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+ ---+ | file_name | char(255) | | PRI | | | | required_security_level | tinyint(1) unsigned | | | 0 | | | checked_out_by | char(20)| YES | | NULL| | | date_checked_out| datetime| YES | | NULL| | +-+-+--+-+-+ ---+ 4 rows in set (0.00 sec) mysql desc staff; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | username | char(20)| | PRI | | | | last_name | char(30)| | | | | | first_name | char(30)| | | | | | security_level | tinyint(1) unsigned | | | 0 | | ++-+--+-+-+---+ 4 rows in set (0.00 sec) What I want to do is display to the user a list of files that require a security level that is less than or equal to the user's security level, with formatted last name and first name and date if the file is checked out. Checked out by is a foreign key refering to username in the staff table, and the security level and required security level are also related. This is my attempt: SELECT file_name, CONCAT(last_name, ', ', first_name) AS name, DATE_FORMAT(date_checked_out,'%b %D, %Y (%r)') AS date FROM file LEFT JOIN staff ON file.checked_out_by = staff.username WHERE staff.username = 'mike' AND staff.security_level file.required_security_level; Anyway, any help with this query would be greatly appreciated. Thank You, Mike Hillyer - 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 Closing Bug
Description: If I launch MySQL 3.23.38, everything is fine. If I open tables, creat db, add records whatever, no problem. When I close MySQL my hard drive is ? alot and I can do nothing except a hard reboot. I have tried quitting immediatly after launching MySQLadmin and then there is no problem. but after I have connected and disconnected a few times and done stuff to my database this problem happens. How-To-Repeat: win98SE machine I guess Fix: uninstall Synopsis: synopsis of the problem (one line) On quitting MySQL my HD goes nuts and I cant do anything except re-boot, Then my HD has erros and I cant run ScanDisk. Submitter-Id: submitter ID Originator: Mike Organization: Coast Research MySQL support: email support? Severity: critical - have to uninstall MySQL and try to fix the HD! Priority:high Category:mysql Class: sw-bug Release:mysql-3.23.38 Exectutable: [mysqld, mysqld-shareware, mysqld-nt or mysqld- opt] Environment: e-machines 400mhz System:Win98SE Regards Mike - 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 hangs, restarts on odbc connect
I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0 gHz. MySQL works perfectly fine when connecting from the localhost. However, I have another machine that needs to connect via ODBC. The ODBC client can connect, but as soon as it does, the connection is suddenly closed. The same thing happens if I try to telnet to port 3306 on the host machine. Every time this happens, I find the following entry in mysqld.log: Number of processes running now: 1 mysqld process hanging, pid 906 - killed 021106 15:51:41 mysqld restarted /usr/libexec/mysqld: ready for connections I have no idea what is causing this. Does anyone have any suggestions as to what might be the cause, or at least what I should double-check? - 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: FW: php J2EE .NET
Peter Lovatt wrote: Hi There is an article on sitepoint.com about benchmarking J2EE and .NET and some controversy over the result http://www.sitepoint.com/newsletters/viewissue.php?fid=3id=3issue=52 If you're knowledgable about J2EE, and go read the benchmark, you see that the J2EE 'Expert' implementors did a pretty lousy job, and ended up comparing Oranges to Apples. That being said, in my experience, MS (pre .Net, and most likely post .Net), J2EE and PHP all scale similarly when implemented _correctly_, especially for most people's needs. Not everyone is going to be having 1000's of users per second, unless they get themselves listed on /. If you routinely have that kind of load, it doesn't matter what technology you're using, it has to be implemented intelligently, correctly, and robustly, otherwise you'll run into problems. In my mind, it really comes down to what toolset you and your team are most comfortable with, and how the toolset fits into your organizations overall development strategy. That's a debate for another day and another forum ;) -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
statement doesnt work onMySQL
Hi, I have the following SQL statement that works fine on Access but it doesn't work on MySQL... select MarketData.* FROM MarketData where MarketData.CustID IN (SELECT ContactID from Contacts where CustID =1) Any advise please?? Regards, Sam - 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: statement doesnt work onMySQL
Sub-Selects do not work on MySQL Yet. Wait for Version 4.1. I am waiting! In the mean time you could do this SELECT * FROM MarketData INNER JOIN Contacts ON MarketData.CustID = Contacts.CustID WHERE Contacts.CustID = 1; HTH JFernando ** sql *** Original Message: - From: [EMAIL PROTECTED] Date: Wed, 6 Nov 2002 20:59:06 EST To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: statement doesnt work onMySQL Hi, I have the following SQL statement that works fine on Access but it doesn't work on MySQL... select MarketData.* FROM MarketData where MarketData.CustID IN (SELECT ContactID from Contacts where CustID =1) Any advise please?? Regards, Sam - 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 mail2web - Check your email from the web at http://mail2web.com/ . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: statement doesnt work onMySQL
[EMAIL PROTECTED] wrote: Hi, I have the following SQL statement that works fine on Access but it doesn't work on MySQL... select MarketData.* FROM MarketData where MarketData.CustID IN (SELECT ContactID from Contacts where CustID =1) Any advise please?? Regards, Sam Try something like: select MarketData.* from MarketData inner join Contacts on MarkerData.CustID=Contacts.ContactID where Contacts.CustID=1 MySQL doesn't currently support sub-selects. It will in version 4.1, which I've been told will be out later this year. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access replacement...
Only the Filemaker server is available for Linux. The client is Windows and Mac only. You will need to use ODBC to get Filemaker to talk to MySQL. Even then it's pretty limited. like FileMaker Pro. It's available for Windows, Mac and Linux. If you really want to empower your users to create reports, databases, forms and the like, FileMaker is actually a lot easier than Access. Richard Czerwonka, Partner, FYI Systems, Perth, Western Australia, Delphi development Mobile 0412 104 042 - 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
ActiveX error Visual Basic Integration MySQL
Hi, I'm attempting to get the MySQL ODBC Drive to work with Visual Basic 6.0 Leaning version I'm getting the following error: Run-time error '429': ActiveX component can't create object On the following line cnMySql.CursorDriver = rdUseOdbc Does anyone have any idea what I might be doing wrong? Oliver - 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
How MySQL Works?
Hi Guys, I wanna know what the steps MySQL perform when we do INSERT in Database? Anyone can explain? Or anyone here have some reference about how MySQL works? Thanks, Han Lin - 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: timestamp updated on select
At 2:09 +0200 11/7/02, Galanis Nikolas wrote: Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated. That seems fairly strange. Let's see an example. On Wed, 6 Nov 2002, Paul DuBois wrote: At 23:47 + 11/6/02, Nikolas Galanis wrote: Hello I have a column of type timestamp(14) and I thought it would not be updated on a query with simple select statements, though it does! I read in the manual that it shouldn't, what could be wrong? Thanks. You're saying that performing a SELECT on the table causes the TIMESTAMP column to *change*? That shouldn't happen. - 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