Re: export table?
simplist way i know and use, is through mysqlfront www.mysqlfront.de - Original Message - From: Chip Wiegand [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, July 08, 2002 1:11 PM Subject: export table? Where is info on exporting a table? I checked the mysql docs and the only reference to export has nothing to do with exporting a table. I want to copy a table from one server to another, should be simple enough, right? -- Chip [EMAIL PROTECTED] www.wiegand.org - 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
ANNOUNCE: moodss-16.4
### CHANGES ### --- version 16.4 --- - added support for MySQL database server version 3.23.51 to mystatus module - added Windows support to snmp module (read snmp module documentation for required software) - in snmp module: - improved end of table detection - formatted data of time ticks type as ??d??h??m??s?? - improved error message when -t(--table) is used on a non table identifier - dynamically loading a module would reset the poll time increased by the user - in a dashboard with several pages, if an inner page was deleted, the saved configuration lacked pages indexes, which would prevent the dashboard from being properly restored, with viewers eventually becoming invisible - updated help tool bar icon - all dialog boxes are now proper transient windows of the main window - made widget tips (balloons) a little wider so that descriptions in SNMP MIBs keep their original formatting - successfully tested with Tcl/Tk 8.4b1 ### README ### This is moodss (Modular Object Oriented Dynamic SpreadSheet) version 16.4. Moodss won in the Best System Admin Technology category (Tcl Tips and Tricks, Valuable Real World Programming Examples) at the O'Reilly Tcl/Tk 1999 Conference. Linux Magazine calls it a lifesaver. Tucows gives it 5 stars (cows or penguins :-). Moodss is a modular application. It displays data described and updated in one or more modules, which can be specified in the command line or dynamically loaded or unloaded while the application is running. Data is originally displayed in tables. Graphical viewers (graph, bar, 3D pie charts, ...), summary tables (with current, average, minimum and maximum values) and free text viewers can be created from any number of table cells, originating from any of the displayed viewers. The display area can be extended by adding pages with notebook tabs. Thresholds can be set on any number of cells. Moomps (shipped with moodss) is a monitoring daemon which works using configuration files created by moodss. Thresholds, when crossed, create messages in the system log, and eventually trigger the sending of email alert messages. Specific modules can easily be developed in the Tcl, Perl and Python scripting languages or in C. A thorough and intuitive drag'n'drop scheme is used for most viewer editing tasks: creation, modification, type mutation, destruction, ... and thresholds creation. Table rows can be sorted in increasing or decreasing order by clicking on column titles. The current configuration (modules, tables and viewers geometry, ...) can be saved in a file at any time, and later loaded at the user's convenience, thus achieving a dashboard functionality. The module code is the link between the moodss core and the data to be displayed. All the specific code is kept in the module package. Since module data access is entirely customizable (through C code, Tcl, Perl, Python, HTTP, ...) and since several modules can be loaded at once, applications for moodss become limitless. For example, thoroughly monitor a dynamic web server on a single dashboard with graphs, using the Apache, MySQL, ODBC, cpustats, memstats, ... modules. If you have replicated servers, dynamically add them to your view, even load the snmp module on the fly and let your imagination take over... Along with a core trace module, arp, cpustats, diskstats, interrupts, kernmods, memstats, minimal, mounts, netdev, pci, ps, random, route, sensors, system modules for Linux, MySQL (myerrorlog, myhealth, myprocs, myquery, myreplication, mystatus, myvars), odbcquery, ping, snmp, snmptrap for UNIX, apache and apachex, Minimal and Random Perl modules, minipy and randpy Python modules are included. Running wish moodss ps cpustats memstats mimics the top application with a graphic edge and remote monitoring capability. Thorough help is provided through menus, widget tips, a message area, a module help window and a global help window with a complete HTML documentation. Moodss is multi-langual thanks to Tcl internationalization capabilities. So far only English and partially French are supported. Help with other languages will be very warmly welcomed. Development of moodss is continuing and as more features are added in future versions, backward module code compatibility will be maintained. I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML libraries enough for their great work. In order to run moodss, you need to install the following packages (unless you can use the rpm utility, see below): Tcl/Tk 8.3.1 or above, at (or at a mirror near you) http://dev.scriptics.com/ or ftp://ftp.scriptics.com/ the latest tkTable widget library at: http://tktable.sourceforge.net/ the latest BLT library at: ftp://tcltk.sourceforge.net/pub/tcltk/blt/ eventually the latest tclperl library for writing modules in Perl, or the latest tclpython library for writing modules in Python at: http://jfontain.free.fr/ (see the INSTALL file for complete instructions, for UNIX and
php +newlines+mysql
I have a problem in php page: i want to insert into mysql database value $string with newlines: $string=-line1\n -line2 \n-line3; $result2 = db_query(update table1 set column1= '$string' where ID = '$IDcurent') or db_die(); When i try to view in a textarea control the new value from column1, the newlines disappear! ps.column 1 have type text or varchar(100) Is a problem of type? tx in advance for any help adi - 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
php +newlines+mysql
I have a problem in php page: i want to insert into mysql database value $string with newlines: $string=-line1\n -line2 \n-line3; $result2 = db_query(update table1 set column1= '$string' where ID = '$IDcurent') or db_die(); When i try to view in a textarea control the new value from column1, the newlines disappear! ps.column 1 have type text or varchar(100) Is a problem of type? tx in advance for any help adi - 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
serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Hi friends. I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, kernel 2.2.19. When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld defunct] this happens somtimes, but table are'nt coruppted. I have checked it. It is dangerous for my system, that server MySQL is sometimes defunct (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, all is allright. server is running as usual (no zombie). Regards Irek. - 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
php +newlines+mysql
I have a problem in php page: i want to insert into mysql database value $string with newlines: $string=-line1\n -line2 \n-line3; $result2 = db_query(update table1 set column1= '$string' where ID = '$IDcurent') or db_die(); When i try to view in a textarea control the new value from column1, the newlines disappear! ps.column 1 have type text or varchar(100) Is a problem of type? tx in advance for any help adi - 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
Remote Host Connection/Software on Web : Accessing mySQL
Hi, Basically we have created a Software in Visual Basic. Now the software uses mySQL on the internet as Backend. However, our server does not allow Remote Host Connection, which means we cannot access our mySQL Database on the Internet by our Software on a local client. We need the mySQL Database on the Internet because basically everything will be available on a website later through PHP Pages. Now, my problem is how to connect to my mySQL DB on the Internet, via my Software, when my Server Company doesn't allow Remote Host Connection to mySQL. What is suggested to me is to place the Software on the Internet. I have no clue how to do that. Because if i place an .exe file on the net, it will just start downloading instead of running. How then can i accomplish this? The software feeds in Data in the mySQL DB on the internet, and then the PHP pages access the mySQL DB to show data to users on the Website. It's something like that. The software involves a lot of processing, decryption, conversion etc. to convert a .dat data into usable mySQL Tables Data. Hope somebody can help. Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.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
advice on porting using same databse on windows and linux
Hello . situation : mysql server on RH 7.2 (don't know what version - realy doesn't matter) mysql server on windows 98 (don't know what version - realy doesn't matter) three partitions : p1 - fat32 p2 -fat32 p3-linux . I want to share the database(s) between mysql on windows and mysql on linux . I've put the data dir on partiotion 2(fat32) so both mysql servers can access it . My only problem is that the database files are read-only under linux vecause of the fat32 file system of the partition . What can i do so i can access the database files both under linux and windows (except runing mysql as root) ? - 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
time stamp ......
hi guyz
im trying to save user uploaded files each with a unique name
now
1. for some strange reason this piece of code aint working :S
if (is_uploaded_file($HTTP_POST_FILES['$userfile']['$name'])) {
copy($HTTP_POST_FILES['$userfile']['$name'],c:/tmp uploadz/);
} else {
echo Possible file upload attack. Filename: .
$HTTP_POST_FILES['$userfile']['$name'];
}
neither does this :
move_uploaded_file($HTTP_POST_FILES['$userfile']['$name'], c:/tmp
uploadz/);
i get a msg:
file submitted .NeedsUPDATED.doc. file sixe .23552. file type
.application/msword. Possible file upload attack. Filename:
and nothing gets saved on disk
2. while this works fine
$name = $firstName.$lastName.$title.$cat.$lang.$unique_id;
if (copy($userfile, c:/tmp uploadz/ . $unique_id.-.$name))
echo(b file successfully uploaded /b);
else //(!$userfile_size)
echo( Either you did not upload any file, or you uploaded an empty
file! );
whats with the first code
3. i want the file to be save as $name but it doesnt do dat
it either saves the file as its original name or it saves it as its original
name :(
4. the most horribale thing
1026114031-getStart.zip
this is the horrid time stamp i get fo my file name
whats wrong with it i cant make anything outta it
where m i messing up now
n YES its related to THIS list ... since i ve to store the uploaded file in
mysql database
id really appriciate any help with this
stuck as usual
toby ..
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.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: Deep Nesting
Ben, The description of your project is as clear as mud or as clear as astrology in general, but it seems to me that you could put all data into one table? However, a bigger number of tables is no problem for MySQL. Using MyIsam tables each table will be equivalent to 3 files. With ReiserFS you should be able to create 10 of them without running into trouble. Don't try this with ext2. Thomas On Sun, 7 Jul 2002, Ben Ocean wrote: Hi; I'm trying to programmatically create tables which are nested so deeply that I fear I'll be creating a gargantuan number of them. I'm seeking a means to limit this, if possible. I'm creating what I call *open source metaphysics*. Here's the scenario: The tables will be used to enable users to enter comments concerning what they believe happens at individual conjunctions. For example, in astrology, let's say one enters a comment of what happens when the Moon enters Scorpio. These comments can then be called by other users and rated with an accreditation system similar to Amazon's rating of books (and those who rate them). The problem occurs with granulation. Let's say, instead, that our above example is when the Moon enters Scorpio while the Sun is in the fifth degree of Aries and Mars is in the twentieth degree of Gemini while the natal chart reflects that this nativity has an ascendant at the seventh degree of Cancer, etc. Indeed, it's actually far more involved than that, because I'd like to cross-reference other metaphysical systems (Tzolkin, I Ching, etc.) several of which have nativities as well as transient elements. I can see tables literally in the thousands (or much higher) with no way to avoid this proliferation. Any suggestions? TIA, BenO sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Hi friends. I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, kernel 2.2.19. When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld defunct] this happens somtimes, but table are'nt coruppted. I have checked it. It is dangerous for my system, that server MySQL is sometimes defunct (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, all is allright. server is running as usual (no zombie). Regards Irek. - 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
Query question
Hello all, I am trying to build a relatively complex query to get the average and standard deviation of various testing variables which ultimately will be filtered/grouped by age and other parameters. Item #1 shows the original query and output: select count(Test1000.OID) as N, avg(Accuracy) as AccAvg, std(Accuracy) as AccStd, avg(AvgRespT) as RTAvg, std(AvgRespT) as RTStd , from Test1000,ROrders,ptProt,protocols,RPtDemog WHERE ROrders.OID=Test1000.OID AND ptProt.protID=protocols.protID AND ptProt.PID=ROrders.PID AND ptProt.PID=RPtDemog.PID AND Language=1 AND Trusted='Yes' - N AccAvg AccStd RTAvg RTStd 402 92.9680 9.7709 445.2773121.2830 Item #2 is the same query but has an added Age Bracket field to be grouped by: [if its hard to read, age is computed as the (date the person was enrolled in a clinical trial - their DOB)/365 and this Age is separated into brackets - This part works fine...] select count(Test1000.OID) as N, if (round((to_days(dateStart)-to_days(DOB))/365)30,'30', if (round((to_days(dateStart)-to_days(DOB))/365)=30 AND round((to_days(dateStart)-to_days(DOB))/365)50,'30-50', if (round((to_days(dateStart)-to_days(DOB))/365)=50 AND round((to_days(dateStart)-to_days(DOB))/365)70,'50-70','70+'))) as Bracket, avg(Accuracy) as AccAvg, std(Accuracy) as AccStd, avg(AvgRespT) as RTAvg, std(AvgRespT) as RTStd from Test1000,ROrders,ptProt,protocols,RPtDemog WHERE ROrders.OID=Test1000.OID AND ptProt.protID=protocols.protID AND ptProt.PID=ROrders.PID AND ptProt.PID=RPtDemog.PID AND Language=1 AND Trusted='Yes' Group By Bracket --- N Bracket AccAvg AccStd RTAvg RTStd 121 30-50 96.2500 0. 406.36670. 59 50-70 94.2542 0. 435.76270. 129 70+ 88.0833 0. 533.52780. 93 30 93.6250 0. 396.40910. MY QUESTION:What happened to the standard deviation columns between the first and second query?I would appreciate any insights anyone could offer!Thanks in advance.Judy SimonWebmaster DB Systems EngineerNeuroTrax Israel LTD, Shilat, Israel Tel: +972-8-976-3067 Fax: +972-8-976-3068 - 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:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Ireneusz Piasecki [EMAIL PROTECTED] wrote on 08.07.2002 11:22:23: Hi friends. I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, kernel 2.2.19. When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld defunct] this happens somtimes, but table are'nt coruppted. I have checked it. It is dangerous for my system, that server MySQL is sometimes defunct (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, all is allright. server is running as usual (no zombie). Regards Irek. Hi Irek, do you have something in the logs (i.e. /var/lib/mysql/yourhostname.log) when this happens? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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
Drop keys does not stop indexes being created
Description Having followed the instructions in section 5.2.8 to create a table using LOAD DATA INFILE *without* its indexes, the indexes are *still* created at the end of the LOAD DATA INFILE statement How-To-Repeat: The following shell script demonstrates the problem. There are two directory listings, before and after the load. In the second one BestGuess.MYI should be unchanged at 1024 bytes but it isn't because the indexes have been created even though myisamchk -k 0 has been executed Script assumes: /tmp is available databases are in /usr/local/var (line 1) start script MYSQLDIR=/usr/local/var cat /tmp/bgdata EOF 1|1|'Fordham'|'Emma'|344|'12'|'94'|'7ka3hn5qhtDRbPkJ1uWX/A'|''|1|3|'Lexdon Winstree'|'N' 2|1|'Fordham'|'Enoch'|625|'22'|'318'|'Daf1Dt+XH3aq47D8gigWDw'|''|1|3|'Wakefi eld'|'N' 3|1|'Fordham'|'George'|500|'12'|'164'|'i1L5pD8Q8gI+CFfqkkOWzQ'|''|1|3|'Saffr on Walden'|'N' 4|1|'Fordham'|'Henry'|548|'14'|'144'|'Md3MtuwgcJtjGs5rKcU8pg'|''|1|3|'Saint Ives'|'N' 5|1|'Fordham'|'Henry'|209|'3'|'43'|'EpyvpR6wK4tXDCg0dUWThA'|''|1|3|'Edmonton '|'N' 6|1|'Fordham'|'John'|116|'14'|'7'|'SE1U6ewpSZkU0wA0WRe/pg'|''|1|3|'Cambridge '|'N' 7|1|'Fordham'|'Lewis'|348|'14'|'68'|'JeHwC7Jnhx6VNFabWRCwQA'|''|1|3|'Linton' |'N' 8|1|'Fordham'|'Stephen'|268|'6'|'359'|'LS/iLpTXxrfqwlfAVoJdyQ'|''|1|3|'Hatfi eld Welwyn'|'N' 9|1|'Fordham'|'female'|416|'14'|'89'|'s91dCImO+HeyIy6rXxldGA'|''|1|3|'Newmar ket'|'N' 10|2|'FOTHERGILL'|'ROBERT'|206|'25'|'289'|'UIOL6Q5/8cMoeA/k/DmlZg'|''|1|3|'E astWard'|'N' EOF mysql -D test EOF drop table BestGuess; EOF mysql -D test EOF create table BestGuess ( RecordNumber INT UNSIGNED NOT NULL AUTO_INCREMENT, ChunkNumber INT UNSIGNED NOT NULL, Confirmed VARCHAR( 1 ), Surname VARCHAR( 50 ) NOT NULL, GivenName VARCHAR( 50 ) NOT NULL, AgeAtDeath VARCHAR(50), DistrictNumber SMALLINT UNSIGNED NOT NULL, District VARCHAR( 50 ) NOT NULL, DistrictFlag TINYINT UNSIGNED NOT NULL, Volume VARCHAR( 50 ) NOT NULL, Page VARCHAR( 50 ) NOT NULL, Hash CHAR(22) NOT NULL, RecordTypeID TINYINT NOT NULL, QuarterNumber SMALLINT NOT NULL, PRIMARY KEY (RecordNumber), INDEX (ChunkNumber), INDEX (Surname(10),GivenName(10),QuarterNumber), INDEX (Surname(10),GivenName(10),DistrictNumber), INDEX (Surname(10),QuarterNumber), INDEX (Surname(10),DistrictNumber), INDEX (GivenName(10),QuarterNumber), INDEX (Volume,Page,QuarterNumber), INDEX (DistrictNumber,QuarterNumber) ); EOF ls -l $MYSQLDIR/test/BestGuess.M* mysqladmin flush-tables myisamchk -k 0 -rq $MYSQLDIR/test/BestGuess mysql -D test EOF LOAD DATA INFILE '/tmp/bgdata' IGNORE INTO TABLE BestGuess FIELDS TERMINATED BY '|' ENCLOSED BY ' (RecordNumber, ChunkNumber,Surname,GivenName, DistrictNumber,Volume,Page,Hash, AgeAtDeath,RecordTypeID,QuarterNumber, District,Confirmed) EOF ls -l $MYSQLDIR/test/BestGuess.M* end script Fix: Unknown Submitter-Id: barrie Originator:Barrie Archer Organization: FreeBMD (http://freebmd.rootsweb.com) MySQL support: none Synopsis: drop keys does not inhibit creation of indexes on load Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.51 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.51, for unknown-freebsdelf4.2 on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.51 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 5 days 6 hours 7 min 19 sec Threads: 2 Questions: 2215677 Slow queries: 22 Opens: 300 Flush tables: 16 Open tables: 1 Queries per second avg: 4.880 Environment: System: FreeBSD sump.inv.thebunker.net 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Wed Feb 7 18:04:50 GMT 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/SUMP i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1169076 Nov 20 2000 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Feb 6 2001 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559196 Nov 20 2000 /usr/lib/libc.so.4 Configure command: ./configure --with-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 - Before posting, please check:
Re: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Hi. No, the log serwer.err is clear. No errors. mysql serwer is running from may 2002 , before i have mysql 3.23.49. Sometimes he also was as zombie process. Now a have 3.23.51. The problem still exists, system working, so i don't know, it is dangerous sytuation ? regards, Irek. - Original Message - From: Oliver Six [EMAIL PROTECTED] To: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, July 08, 2002 11:38 AM Subject: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine Ireneusz Piasecki [EMAIL PROTECTED] wrote on 08.07.2002 11:22:23: Hi friends. I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, kernel 2.2.19. When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld defunct] this happens somtimes, but table are'nt coruppted. I have checked it. It is dangerous for my system, that server MySQL is sometimes defunct (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, all is allright. server is running as usual (no zombie). Regards Irek. Hi Irek, do you have something in the logs (i.e. /var/lib/mysql/yourhostname.log) when this happens? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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
password mysql with kylix
Dear all, I got problem, I want to build application with Kylix + MySql. These problem is when this password to connection mysql Null that application running OK, but if i fill password then message error on Kylix Error mapping failed', if I click again then message Unable to execute query. I was Update new patch Driver to connection mysql(libsqlmy23.so.1) Adhi.. - 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 User Lookup
sajiddalvi, Sunday, July 07, 2002, 8:04:02 PM, you wrote: s Is there a way to check which my sql user (who has logged into the database) s has inserted a row in a table? s I could add a logged_in_user column but that seems redundant. Take a look at functions: USER(), SYSTEM_USER(), SESSION_USER(): http://www.mysql.com/doc/M/i/Miscellaneous_functions.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: Licensing--web site is schizophrenic
Paul, Sunday, July 07, 2002, 11:05:18 PM, you wrote: PS At one place on the MySQL site I see: PS http://www.mysql.com/support/arrangements.html PS which says the client library is under the LGPL. PS At another place I see: PS http://www.mysql.com/doc/C/o/Copyright.html PS which says the entire codebase, including the client, is released under PS the GPL. PS Does this mean newer versions of MySQL client libraries are GPL'd? I'll PS be disappointed if this is true, because there are plenty of open source PS licenses which are incompatible with the GPL. This means that none of PS those other open source projects can use or include support for MySQL. PS Which is a shame. 3.23.XX API is under LGPL, 4.X API is under GPL instead of LGPL. For more question about licensing go to : [EMAIL PROTECTED] -- 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:Re: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Ireneusz Piasecki [EMAIL PROTECTED] wrote on 08.07.2002 11:59:08: Hi. No, the log serwer.err is clear. No errors. mysql serwer is running from may 2002 , before i have mysql 3.23.49. Sometimes he also was as zombie process. Now a have 3.23.51. The problem still exists, system working, so i don't know, it is dangerous sytuation ? regards, Irek. - Original Message - From: Oliver Six [EMAIL PROTECTED] To: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, July 08, 2002 11:38 AM Subject: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine Ireneusz Piasecki [EMAIL PROTECTED] wrote on 08.07.2002 11:22:23: Hi friends. I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, kernel 2.2.19. When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld defunct] this happens somtimes, but table are'nt coruppted. I have checked it. It is dangerous for my system, that server MySQL is sometimes defunct (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, all is allright. server is running as usual (no zombie). Regards Irek. Hi Irek, do you have something in the logs (i.e. /var/lib/mysql/yourhostname.log) when this happens? Bye Oliver -- Hi Irek, IMHO a zombie is never a good thing. Maybe the log is in another directory (depending on your compile options)? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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
Query Optimization
Hi All The Query below took around 175 Secs to return 22 Rows..Any way this query can be optimized SELECT Distinct(C.Company_Name) ,U.UserID , IF(U.CompanyID IS NULL , NULL ,C.Company_Name) as Company_Name, U.COMPANYID, U.PASSWORD, U.INDIVIDUAL_COMPANY_NAME, U.USER_NAME,U.FIRST_NAME, U.LAST_NAME, U.MIDDLE_NAME, U.EMAIL,U.PROMOTION_CODE,U.TITLE, U.DESIGNATION, U.USER_STATUS, U.USER_APP_STATUS, U.PHONE,U.ADDRESS, U.CREATED_ON,U.FAX, U.ZIP, U.DEPARTMENT, U.MODIFIED_ON, U.CITY,U.STATE, U.INDUSTRYID, U.COUNTRYID, U.CERTIFICATIONID,U.TECHNOLOGY_AREAID, U.HORIZONTAL_STANDARDS_EXP, U.ROLEID,U.ROLE_OTHER, U.YEARS_OF_EXP, U.OTHER_CERTIFICATION2, U.PROF_MEMBERSHIP1, U.OTHER_CERTIFICATION3, U.PROF_MEMBERSHIP2,U.OTHER_CERTIFICATION1, U.HOURLY_RATE, U.PROF_MEMBERSHIP3,U.WORK_PREFERENCE, U.OTHER_CERTIFICATION4, U.ADDITIONAL_COMMENTS,U.WELCOME_MESSAGE, I.Industry_Name,T.Technology_Area, R.Role FROM User_Type_Details UTD, User_Type_Details B , Users U ,TempGeneralSearch1 T1,Users A LEFT JOIN Company C on (U.CompanyID = C.CompanyID) LEFT JOIN Expert_Info EI on (U.UserID = EI.UserID) LEFT JOIN User_Horizontal_Market UHM on (U.UserID = UHM.UserID) LEFT JOIN Industry I on (U.IndustryID = I.IndustryID) LEFT JOIN Technology_Area T on (U.Technology_AreaID = T.Technology_AreaID) LEFT JOIN Role R on (U.RoleID = R.RoleID ) WHERE U.UserID = UTD.UserID AND U.User_Status='ACT' AND U.User_App_Status='APP' AND UTD.User_TypeID IN (4,0,2,3) AND T1.TempID=117 - 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: MERGE FULLTEXT, two years later.
Hi! On Jul 08, Sander Pilon wrote: I searched the archives and in December 2000 it did 'not yet' work. ( http://listarchive.nextrieve.com/mysql//200012/msg00539.html ) Will MERGE tables and FULLTEXT indexes work together in 4.x? Two-and-a-half years later? Most probably, yes. All the hooks are already in. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: Query Optimization
Pada Mon, 8 Jul 2002 16:07:04 +0530 Arul [EMAIL PROTECTED] menulis : Hi All The Query below took around 175 Secs to return 22 Rows..Any way this query can be optimized try to use group by instead of distinct i usually found group by is faster ;-) anyway ... performance of query is more related to : - table definition - indexing - mysql parameter values - OS and hardware spec/limitation -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 17 days, Queries : 365.147 per second (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
Re: Query Optimization
Hi I Found Group By to be a bit faster...but still it takes 30 secs to execute a query... What could be done..I have Indexing on almost all the tables.. -Arul - Original Message - From: Dicky Wahyu Purnomo [EMAIL PROTECTED] To: Arul [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 08, 2002 4:25 PM Subject: Re: Query Optimization Pada Mon, 8 Jul 2002 16:07:04 +0530 Arul [EMAIL PROTECTED] menulis : Hi All The Query below took around 175 Secs to return 22 Rows..Any way this query can be optimized try to use group by instead of distinct i usually found group by is faster ;-) anyway ... performance of query is more related to : - table definition - indexing - mysql parameter values - OS and hardware spec/limitation -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 17 days, Queries : 365.147 per second (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
RE: MERGE FULLTEXT, two years later.
-Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 12:53 To: Sander Pilon Cc: [EMAIL PROTECTED] Subject: Re: MERGE FULLTEXT, two years later. Hi! On Jul 08, Sander Pilon wrote: I searched the archives and in December 2000 it did 'not yet' work. ( http://listarchive.nextrieve.com/mysql//200012/msg00539.html ) Will MERGE tables and FULLTEXT indexes work together in 4.x? Two-and-a-half years later? Most probably, yes. All the hooks are already in. Cool! I got a snapshot from mysqldevelopers.com, but it seems that this is not yet committed to bitkeeper, right? (Snapshot has been running stable otherwise.) Regards, -S - 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: Licensing--web site is schizophrenic
Victoria Reznichenko [EMAIL PROTECTED] wrote on 08.07.2002 12:01:01: Paul, Sunday, July 07, 2002, 11:05:18 PM, you wrote: PS At one place on the MySQL site I see: PS http://www.mysql.com/support/arrangements.html PS which says the client library is under the LGPL. PS At another place I see: PS http://www.mysql.com/doc/C/o/Copyright.html PS which says the entire codebase, including the client, is released under PS the GPL. PS Does this mean newer versions of MySQL client libraries are GPL'd? I'll PS be disappointed if this is true, because there are plenty of open source PS licenses which are incompatible with the GPL. This means that none of PS those other open source projects can use or include support for MySQL. PS Which is a shame. 3.23.XX API is under LGPL, 4.X API is under GPL instead of LGPL. For more question about licensing go to : [EMAIL PROTECTED] -- 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 Hi, does this mean that whenever I write a program in msc which makes use of the libmysql.dll in conjunction with MySQL 4.x I have to make this program GPL? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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: Query Optimization
On Monday, 8. July 2002 12:37, Arul wrote: Hi All The Query below took around 175 Secs to return 22 Rows..Any way this query can be optimized For analyzing your problem, you should send your table definition and an output of the EXPLAIN statement. Regards Georg mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query question
Hello all, I am trying to build a relatively complex query to get the average and standard deviation of various testing variables which ultimately will be filtered/grouped by age and other parameters. Item #1 shows the original query and output: select count(Test1000.OID) as N, avg(Accuracy) as AccAvg, std(Accuracy) as AccStd, avg(AvgRespT) as RTAvg, std(AvgRespT) as RTStd , from Test1000,ROrders,ptProt,protocols,RPtDemog WHERE ROrders.OID=Test1000.OID AND ptProt.protID=protocols.protID AND ptProt.PID=ROrders.PID AND ptProt.PID=RPtDemog.PID AND Language=1 AND Trusted='Yes' - N AccAvg AccStd RTAvg RTStd 402 92.9680 9.7709 445.2773121.2830 Item #2 is the same query but has an added Age Bracket field to be grouped by: [if its hard to read, age is computed as the (date the person was enrolled in a clinical trial - their DOB)/365 and this Age is separated into brackets - This part works fine...] select count(Test1000.OID) as N, if (round((to_days(dateStart)-to_days(DOB))/365)30,'30', if (round((to_days(dateStart)-to_days(DOB))/365)=30 AND round((to_days(dateStart)-to_days(DOB))/365)50,'30-50', if (round((to_days(dateStart)-to_days(DOB))/365)=50 AND round((to_days(dateStart)-to_days(DOB))/365)70,'50-70','70+'))) as Bracket, avg(Accuracy) as AccAvg, std(Accuracy) as AccStd, avg(AvgRespT) as RTAvg, std(AvgRespT) as RTStd from Test1000,ROrders,ptProt,protocols,RPtDemog WHERE ROrders.OID=Test1000.OID AND ptProt.protID=protocols.protID AND ptProt.PID=ROrders.PID AND ptProt.PID=RPtDemog.PID AND Language=1 AND Trusted='Yes' Group By Bracket --- N Bracket AccAvg AccStd RTAvg RTStd 12130-5096.2500 0. 406.3667 0. 5950-7094.2542 0. 435.7627 0. 12970+ 88.0833 0. 533.5278 0. 93 30 93.6250 0. 396.4091 0. MY QUESTION:What happened to the standard deviation columns between the first and second query? I would appreciate any insights anyone could offer! Thanks in advance. Judy Simon Webmaster DB Systems Engineer NeuroTrax Israel LTD, Shilat, Israel Tel: +972-8-976-3067 Fax: +972-8-976-3068 - 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 primary key question!
hello, i hope some database guru can help me with this! i need to set up an auto_increment field inside mysql. for various reasons, the maximum size is 3. but i don't want this to be ONLY integers because that limits me until 999 numbers only. since i have all flexibility for these three digits or letters, i want to include numbers and some characters into it as well. e.g., m78 23a 1pt 1~8 !76 ...etc can all be valid keys for me. how can i generate such numbers on the fly? if not inside mysql, then inside php? AND...be sure that the key so generated has not been used before as an id field in my data? any ideas would be very welcome! thanks very much in advance/erick __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.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: impossible WHERE noticed after reading const table
Mike, Saturday, July 06, 2002, 10:20:49 PM, you wrote: M If I do a SELECT * from TABLE I get all the records in the DB (as it M should) M If I do a SELECT id from TABLE all the id's in the table are M retrieved except id's 113-119 for some reason M To use record 117 as an example: M If I do a SELECT * from TABLE WHERE id=117 it returns no records, but M when I do the SELECT * from TABLE the record with id=117 shows up. M id is an auto-increment int field M EXPLAIN SELECT * from TABLE WHERE id=117 says impossible WHERE M noticed after reading const table M what would cause this? The records that it can't find are recently M added records. But I've added some since then using the same software M and there's no issues. M MySQL version 3.23.49-max-nt Re-create indexes with myisamchk and try again. M Thanks in advance, M Mike Tiffee -- 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: export table?
Chip, Monday, July 08, 2002, 8:11:20 AM, you wrote: CW Where is info on exporting a table? I checked the mysql docs and the CW only reference to export has nothing to do with exporting a table. I CW want to copy a table from one server to another, should be simple CW enough, right? What about mysqldump? http://www.mysql.com/doc/m/y/mysqldump.html You can make dump file of your table, copy from one server to another and restore table or mysqldump database_name table_name | mysql -hhost_name -uuser_name database_name -- 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: php +newlines+mysql
adi, Monday, July 08, 2002, 10:05:56 AM, you wrote: a I have a problem in php page: a i want to insert into mysql database value $string with newlines: a $string=-line1\n -line2 \n-line3; a $result2 = db_query(update table1 set column1= '$string' where ID = a '$IDcurent') or db_die(); a When i try to view in a textarea control the new value from column1, the a newlines a disappear! a ps.column 1 have type text or varchar(100) a Is a problem of type? You should escape some chars: http://www.mysql.com/doc/S/t/String_syntax.html Take a look at php functions: mysql_escape_string(), mysql_real_escape_string(), addslashes() -- 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: Join problem in MYSQL
Defryn, Monday, July 08, 2002, 5:09:51 AM, you wrote: D Can anyone have a look at my join. D It returns errors D Select O.name, O.amount , P.Productname, P.price D From Orders AS O D JOIN Products AS P ON O.product=P.Productid D Where O.cluster= 'ANP'; D It works fine when I use D Select O.Name, O.amount, P.productname , P.price D From Orders as O, Products as P D Where O.product=P.productid D AND O.cluster = 'ANP'; D When I use the first example with INNER JOIN it works as well. D The book I use as study guide is a few years old so maybe the syntax has changed ?? Yeah, your JOIN syntax incorrect, you can't use ON in simple JOIN clause. Take a look at: http://www.mysql.com/doc/J/O/JOIN.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: Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Hi, When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld defunct] this happens somtimes, but table are'nt coruppted. I have checked it. I think this is normal. When child process exits, parent process has to 'clean that up'. It takes some time if parent is doing some other stuff. If zombie processes stay in the process list for a long time, then you have a problem probably with parent process. Someone correct me if I'm wrong. Regards, Terry - 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:Re: Licensing--web site is schizophrenic
Hi, This is a good question.But who give us an clearly answer ? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Oliver Six [EMAIL PROTECTED] To: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, July 08, 2002 2:03 PM Subject: Re:Re: Licensing--web site is schizophrenic Victoria Reznichenko [EMAIL PROTECTED] wrote on 08.07.2002 12:01:01: Paul, Sunday, July 07, 2002, 11:05:18 PM, you wrote: PS At one place on the MySQL site I see: PS http://www.mysql.com/support/arrangements.html PS which says the client library is under the LGPL. PS At another place I see: PS http://www.mysql.com/doc/C/o/Copyright.html PS which says the entire codebase, including the client, is released under PS the GPL. PS Does this mean newer versions of MySQL client libraries are GPL'd? I'll PS be disappointed if this is true, because there are plenty of open source PS licenses which are incompatible with the GPL. This means that none of PS those other open source projects can use or include support for MySQL. PS Which is a shame. 3.23.XX API is under LGPL, 4.X API is under GPL instead of LGPL. For more question about licensing go to : [EMAIL PROTECTED] -- 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 Hi, does this mean that whenever I write a program in msc which makes use of the libmysql.dll in conjunction with MySQL 4.x I have to make this program GPL? Bye Oliver -- Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% attention to detail. Oliver Six, CEO CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 - 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
Moving a DB from one Server to another
Is there a quick and simple way to move a MySQL DB from one server to another MySQL server? Can I just copy the tables? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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
Compile guide / needed /recommended versions solaris 8 Sparc
hi, I am trying to build the best version of mysql on solaris 8 for Sparc. Can anyone please recommend 1.) The best version of Mysql to use (I am told there is a payfor version with transactions) 2.) The suggested version of GCC to use (I am using sun freewares GCC 3.1) 3.) The needed / suggested software on the Solaris machine to make Mysql run well compile well 4.) a good compile and install guide as I have done it many times on Linux however I remember having problems on solaris 2.6 and I would like this install to go well. 5.) Any other advice would be greatfully appriciated. 6.) Is it worth compiling mysql in 64 bit mode ? I am not new to Solaris or Linux, and I have used mysql on Linux for a year or 2 now (not in deapth) However I would like to get this first time runnign Mysql on Solaris done well Thanks for your time and help on this. It is much appriciated. Matt. - 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 primary key question!
Hi, My opinion: You can't use auto_increment in this way.For sure you must do some functions in php to check flexibility conditions of the digits which are using for new ID of entire row.The ID field from your table must be CHAR(). E.g: You need 3 variables; set @a:=;--initialize variable a; set @b:=;--initialize variable b; set @c:=;--initialize variable c; select @a:=some_peculiar_for_gen_the_id from your_table where your_conditions; select @b:=other_peculiar_for_gen_the_id from your_table where your_conditions; select @c:=other_peculiar_for_gen_the_id from your_table where your_conditions; insert into table_for_insert_data SET ID_FIELD=CONCAT(@a,@b,@c) and ...others data; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Erick Papadakis [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, July 08, 2002 2:30 PM Subject: mysql primary key question! hello, i hope some database guru can help me with this! i need to set up an auto_increment field inside mysql. for various reasons, the maximum size is 3. but i don't want this to be ONLY integers because that limits me until 999 numbers only. since i have all flexibility for these three digits or letters, i want to include numbers and some characters into it as well. e.g., m78 23a 1pt 1~8 !76 ...etc can all be valid keys for me. how can i generate such numbers on the fly? if not inside mysql, then inside php? AND...be sure that the key so generated has not been used before as an id field in my data? any ideas would be very welcome! thanks very much in advance/erick __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.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 - 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: serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
On Mon, Jul 08, 2002 at 09:46:08AM +0200, Ireneusz Piasecki wrote: I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, kernel 2.2.19. When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld defunct] this happens somtimes, but table are'nt coruppted. I have checked it. It is dangerous for my system, that server MySQL is sometimes defunct (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, all is allright. server is running as usual (no zombie). Not all that abnormal, and in fact, these are common UNIX semantics. If a child process terminates (on Linux these are threads), they are marked defunct/zombie until the parent process gets around to reaping them. Which is why they're absent from a second process listing. See fork(2) and wait(2), waitpid(2), etc. -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [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
Re: Re:Re: Licensing--web site is schizophrenic
Either that, or buy a commercial MySQL License - Original Message - From: Oliver Six [EMAIL PROTECTED] To: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, July 08, 2002 12:03 PM Subject: Re:Re: Licensing--web site is schizophrenic Hi, does this mean that whenever I write a program in msc which makes use of the libmysql.dll in conjunction with MySQL 4.x I have to make this program GPL? Bye 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
RE: Moving a DB from one Server to another
If the OS is the same on each server (including patches just to make sure) and the MySQL version is the same, then yes, you can simply copy the data directories from one server to another Make sure you FLUSH everything first and take MySQL off-line. -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: 08 July 2002 13:39 To: [EMAIL PROTECTED] Subject: Moving a DB from one Server to another Is there a quick and simple way to move a MySQL DB from one server to another MySQL server? Can I just copy the tables? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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 - 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: Moving a DB from one Server to another
Take a dump - Original Message - From: Todd Cary [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 08, 2002 1:38 PM Subject: Moving a DB from one Server to another Is there a quick and simple way to move a MySQL DB from one server to another MySQL server? Can I just copy the tables? Todd - 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: Moving a DB from one Server to another
Todd Cary writes: Is there a quick and simple way to move a MySQL DB from one server to another MySQL server? Can I just copy the tables? for as far i know, you can just copy the directory ( DB ) from one server to the other. i've done it a couple times. and it stil works :) Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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 - 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: Moving a DB from one Server to another
yap . you can coopy the database file although i'd say do dump of the database (with mysqldump) . eventuly to make things faster drop the indexes and recreate them on the target machine - Original Message - From: Todd Cary [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 08, 2002 3:38 PM Subject: Moving a DB from one Server to another Is there a quick and simple way to move a MySQL DB from one server to another MySQL server? Can I just copy the tables? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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 - 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
Keyfile size
I have a MySQL server that has hit it's keyfile size limit (apparently 64M). I can't believe that a value this low would be the absolute limit, but I can't find any documentation about increasing this size. How do I do it? * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
Re: mysql primary key question!
IMHO you can INCREMENT only numbers . :) . Why only three numbers ? Anyway i'd see a solution like this : table : idfield [1..n] Select (@max_number:=max(id)) from table; Insert into table(id,field1,fieldn) values (@max+0.1,'xxx','xxx'); that's kindof solution . - Original Message - From: Erick Papadakis [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, July 08, 2002 2:30 PM Subject: mysql primary key question! hello, i hope some database guru can help me with this! i need to set up an auto_increment field inside mysql. for various reasons, the maximum size is 3. but i don't want this to be ONLY integers because that limits me until 999 numbers only. since i have all flexibility for these three digits or letters, i want to include numbers and some characters into it as well. e.g., m78 23a 1pt 1~8 !76 ...etc can all be valid keys for me. how can i generate such numbers on the fly? if not inside mysql, then inside php? AND...be sure that the key so generated has not been used before as an id field in my data? any ideas would be very welcome! thanks very much in advance/erick __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.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 - 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: Query Optimization
On 8 Jul 2002, at 16:07, Arul [EMAIL PROTECTED] wrote: FROM User_Type_Details UTD, User_Type_Details B , Users U ,TempGeneralSearch1 T1,Users A LEFT JOIN Company C on (U.CompanyID = C.CompanyID) LEFT JOIN Expert_Info EI on (U.UserID = EI.UserID) LEFT JOIN User_Horizontal_Market UHM on (U.UserID = UHM.UserID) LEFT JOIN Industry I on (U.IndustryID = I.IndustryID) LEFT JOIN Technology_Area T on (U.Technology_AreaID = T.Technology_AreaID) LEFT JOIN Role R on (U.RoleID = R.RoleID ) WHERE U.UserID = UTD.UserID AND U.User_Status='ACT' AND U.User_App_Status='APP' AND UTD.User_TypeID IN (4,0,2,3) AND T1.TempID=117 You seem to have some tables in the FROM part of your query that aren't being used (Users aliased to A, User_Type_Details aliased to B) and another that isn't joined to anything (T1, but that may be okay since it looks like you may be getting only one record from it because of the TempID=117). Eliminate the unused tables (which could be resulting in a huge number of duplicated records), and your speed should improve greatly. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - 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
My Slave stopped replicating. SHOW SLAVE STATUS *** 1. row *** Master_Host: 209.217.92.34 Master_User: repslave2 Master_Port: 3306 Connect_retry: 60 Log_File: QBSLXDB1-bin.049 Pos: 56605370 Slave_Running: No Replicate_do_db: qbslive Replicate_ignore_db: Last_errno: 1054 Last_error: error 'Unknown column 'PrinintLe' in 'field list'' on query 'UPDATE PRINTJOBDATA SET ID_PRINTJOB = '55986', ID_PRINTERCODE = '1', PrinintLe = ' 26/06 32440615:27 Doris 37 5330 Canotek 1794 Woodward ECO4.95 ', Sequence = '35' WHERE PRINTJOBDATA.ID = 5328541' Skip_counter: 0 -- When replication receives stuff like 'Unknown column' errors, can't it just go back and try it again? It probably just lost some data on the transfer. MySQL doesn't log erroneous queries ( does it? ) so it should know that there was some kind of transfer error. 'PrinintLe' should be 'PrintLine'. It seems to have moved 'in' back a few characters. I restarted the slave and off it went, doing its merry little chore :) I don't know what I am hoping for here, just griping about it :) Luc Foisy Technical Magic - www.technical-magic.com 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 721-8850 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - 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 with AUTO_INCREMENT and UNIQUE
Hi,
I'm having trouble trying to INSERT rows into a table which has an
AUTO_INCREMENT PRIMARY KEY column plus a UNIQUE constraint on two other
columns.
For each INSERT I specify NULL for the AUTO_INCREMENT column to let the
database assign a value automatically, but I frequently get the error:
Duplicate entry '1' for key 1
Bizarrely, if I remove the UNIQUE constraint on the other two columns
then it all behaves itself!!!
Is there some sort of bug here? I can't see anything wrong with what
I'm doing -- it is the database itself which chooses what value to
INSERT into the AUTO_INCREMENT column, but keeps erroneously choosing
the value '1' and then complaining that the value is already used!!!
I've reduced my database and software down to the bare minimum that
illustrates the problem. Here is the database definition:
--
CREATE DATABASE test;
CREATE TABLE foo (
id INT NOT NULL AUTO_INCREMENT,
num INT NOT NULL,
str VARCHAR(10) NOT NULL,
PRIMARY KEY (id),
UNIQUE (str, num)
) TYPE=BDB;
--
If I run two instances of the following Perl program on the above
database then one of them quickly exits with the error Duplicate entry
'1' for key 1; I'm sure it shouldn't do this:
--
use strict;
use warnings;
use DBI;
my $dbh = DBI-connect(
'dbi:mysql:test', 'root', '',
{AutoCommit = 0, PrintError = 0, RaiseError = 1}
);
for (my $i = 1; $i = 1; $i++) {
my $id;
eval {
my $sth1 = $dbh-prepare(SELECT id FROM foo WHERE num = 0);
$sth1-execute();
my $rows1 = $sth1-fetchall_arrayref();
$sth1-finish();
die Unexpectedly found something!\n if @$rows1;
my $str = $$ . ':' . time();
$dbh-do(INSERT INTO foo (id, num, str) .
VALUES (NULL, $i, '$str'));
my $sth2 = $dbh-prepare(SELECT LAST_INSERT_ID());
$sth2-execute();
my $rows2 = $sth2-fetchall_arrayref();
$sth2-finish();
die Unexpectedly found nothing!\n unless @$rows2;
die Unexpectedly too much!\n if @$rows2 1;
$id = $rows2-[0][0];
$dbh-commit();
};
if ($@) {
if ($DBI::err == 1213) {
print $i: $$: Deadlock! Retrying ...\n;
$dbh-rollback();
redo;
}
else {
print $i: $$: Error! ($@) Exiting ...\n;
last;
}
}
else {
print $i: $$: Success! INSERTed ID $id\n;
}
}
$dbh-disconnect();
--
All this program does is the following transaction 1 times over
(retrying a transaction if it fails due to deadlock):
SELECT the 'id' column WHERE the 'num' column is zero (which should
always find nothing)
INSERT a new row, assigning the 'id' column value automatically
SELECT the LAST_INSERT_ID()
COMMIT the changes
The first SELECT statement serves no purpose in this test program (a
SELECT at this point is required in the real software that I'm writing),
but if I remove it then I don't get the error any more!!!
What is going on?
Any help would be greatly appreciated.
- Steve
---
OS: Windows NT4 SP6
MySQL: 3.23.51 Max
Perl: 5.6.1
DBI: 1.28
DBD::mysql: 2.1017
-
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
Is this a bug?
mysql version 3.23.50 Field kwData_wydania is of type date. As you can see, dates are different that expected. Is this a bug? Select ksiazka_wyd.kwId,kwData_wydania - from ksiazka_wyd - LEFT JOIN serie ON ksiazka_wyd.srId=serie.srId and - kwData_Wydania - between '2002-07-01' and '2002-07-31' - limit 5; +--++ | kwId | kwData_wydania | +--++ | 241 | 1998-01-01 | | 242 | 1998-04-12 | | 243 | 1996-01-01 | | 245 | 1993-01-01 | | 247 | -00-00 | +--++ 5 rows in set (0.00 sec) TIA Rafal table,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Moving a DB from one Server to another
* Todd Cary Is there a quick and simple way to move a MySQL DB from one server to another MySQL server? There are many ways to do that. How simple it is depends on a lot of things... many people prefer to use some kind of tool, like phpMyAdmin or MysqlFront. URL: http://www.phpmyadmin.net/ URL: http://www.anse.de/mysqlfront/ I find it easier to use the command line... one way is to do the export and import in one go. This should be done from the old server: $ mysqldump -u user -ppassword olddb | mysql -h newserver -u user -ppassword newdb URL: http://www.mysql.com/doc/m/y/mysqldump.html Another way is to do the export first (using mysqldump), copy the files to the new server (using ftp, scp or whatever), and import on the new server, using the standard mysql client. Can I just copy the tables? Yes, if the servers are not running, and server versions are compatible. This is probably the fastest way to do it. Just copy the content of the mysql/data/olddb directory (*.frm, *.MYD and *.MYI files). Beware that InnoDB tables are stored in a separate file (or 'tablespace'), which may be more difficult to move to another server, espescially if you have other InnoDB tables on the new server which you wish to keep. Use mysqldump to avoid this problem. -- Roger - 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
SET problem (bug ?) on JOIN
Can anyone shed any light as to why in the following query the tv field shows up twice in the returned set ? The first occurance is correct, the second spurious one at the end is empty and is unfortunately the one my code picks up. The tv field occurs only in the shows table. Thanks, John mysql SELECT * from boxrec.shows USE INDEX (date) - , boxrec.schedule USE INDEX (show_id) - where - boxrec.schedule.show_id = boxrec.shows.show_id and - shows.date = '2002-06-08' - ; +-++-+++---+ --+---+-++-- --+--++---+- -++-++ | show_id | date | country | region | towncity | venue | location | tv| bout_id | boxer_a_id | boxer_b_id | rounds_scheduled | time_stamp | comment | user | division | show_id | tv | +-++-+++---+ --+---+-++-- --+--++---+- -++-++ | 212405 | 2002-09-05 | EN | London | Bethnall Green | York Hall | | ESPN2,HBO,HBOPPV,SHOWTIME,SKY | 2 | 025713 | 005785 | 12 | 20020704185424 | | John | Heavyweight | 212405 | 0 | | 212405 | 2002-09-05 | EN | London | Bethnall Green | York Hall | | ESPN2,HBO,HBOPPV,SHOWTIME,SKY | 3 | 006685 | 115515 | 8 | 20020704185941 | this is a test| John | Light Welterweight | 212405 | 0 | | 212405 | 2002-09-05 | EN | London | Bethnall Green | York Hall | | ESPN2,HBO,HBOPPV,SHOWTIME,SKY | 4 | 050128 | 00 | 10 | 20020704191452 | | John | Middleweight | 212405 | 0 | | 212405 | 2002-09-05 | EN | London | Bethnall Green | York Hall | | ESPN2,HBO,HBOPPV,SHOWTIME,SKY | 5 | 004601 | 00 | 4 | 20020704191728 | | John | Featherweight | 212405 | 0 | | 212406 | 2002-07-06 | JP | Tokyo || Korakuen Hall | | | 6 | 014700 | 076527 | 12 | 20020704192405 | Japanese super bantamweight title | John | Super Bantamweight | 212406 | 0 | | 212406 | 2002-07-06 | JP | Tokyo || Korakuen Hall | | | 7 | 019202 | 028943 | 0 | 20020704192451 | | John | Featherweight | 212406 | 0 | | 212406 | 2002-07-06 | JP | Tokyo || Korakuen Hall | | | 8 | 120002 | 120003 | 0 | 20020704192518 | | John | | 212406 | 0 | +-++-+++---+ --+---+-++-- --+--++---+- -++-++ 7 rows in set (0.00 sec) mysql - 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:Re: Licensing--web site is schizophrenic
- Original Message - From: Oliver Six [EMAIL PROTECTED] To: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Monday, July 08, 2002 6:03 AM Subject: Re:Re: Licensing--web site is schizophrenic Victoria Reznichenko [EMAIL PROTECTED] wrote on 08.07.2002 12:01:01: Paul, Sunday, July 07, 2002, 11:05:18 PM, you wrote: PS At one place on the MySQL site I see: PS http://www.mysql.com/support/arrangements.html PS which says the client library is under the LGPL. PS At another place I see: PS http://www.mysql.com/doc/C/o/Copyright.html PS which says the entire codebase, including the client, is released under PS the GPL. PS Does this mean newer versions of MySQL client libraries are GPL'd? I'll PS be disappointed if this is true, because there are plenty of open source PS licenses which are incompatible with the GPL. This means that none of PS those other open source projects can use or include support for MySQL. PS Which is a shame. 3.23.XX API is under LGPL, 4.X API is under GPL instead of LGPL. For more question about licensing go to : [EMAIL PROTECTED] -- 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 Hi, does this mean that whenever I write a program in msc which makes use of the libmysql.dll in conjunction with MySQL 4.x I have to make this program GPL? Bye Oliver If you _distribute_ it, yes. That's when GPL license clauses come into effect. -Mark - 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
Manipulating flat files
Greetings everyone, Is there any way to manipulate flat files in the same directory by using mySQL? 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: SET problem (bug ?) on JOIN
sql,query No worries, problem solved. - 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
DB backup
I'm trying to do a backup of my DB using mysqldump and mysqlhotcopy but both fuctions are sending me an error in SQL syntax. Could anyone tell me the correct syntax for this functions? thanks HL _ Supercharge your e-mail with a 25MB Inbox, POP3 Access, No Ads and NoTaglines -- LYCOS MAIL PLUS. http://www.mail.lycos.com/brandPage.shtml?pageId=plus - 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: Moving a DB from one Server to another
On Mon, 8 Jul 2002 [EMAIL PROTECTED] wrote: Todd Cary writes: Is there a quick and simple way to move a MySQL DB from one server to another MySQL server? Can I just copy the tables? for as far i know, you can just copy the directory ( DB ) from one server to the other. i've done it a couple times. and it stil works :) I use mysqldump to create dumps of all the databases/tables, ftp or sftp them to the other server, create new databases there using mysqladmin and then pipe the dump into mysql, eg: cat database.dump | mysql -u root -p database 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
Re: Keyfile size
On Mon, Jul 08, 2002 at 09:38:56AM -0500, Paul DuBois wrote: : At 8:45 -0500 7/8/02, Philip Molter wrote: : I have a MySQL server that has hit it's keyfile size limit (apparently : 64M). I can't believe that a value this low would be the absolute : limit, but I can't find any documentation about increasing this : size. How do I do it? : : What do you mean by keyfile? The index file for a MySQL table? : Or do you mean one of the server's memory caches? I mean the keyfile. If I do a CHECK TABLE on that able i get this back: mysql check table log; +--+---+--++ | Table| Op| Msg_type | Msg_text || +--+---+--++ | peace_keeper.log | check | warning | 5 clients is using or hasn't closed the table |properly | | peace_keeper.log | check | warning | Keyfile is almost full, 67107839 of 67107839 |used | | peace_keeper.log | check | error| Found 1940729 keys of 1940740 || | peace_keeper.log | check | error| Corrupt || +--+---+--++ 4 rows in set (1 min 14.16 sec) I need to know how to make that keyfile bigger than 64M in size. I have keyfiles on other (newer) systems that have keyfiles above 200M, and the file size limit on the system is at least 2GB. I can't find any documentation on how to change that value, just on how to fetch that value. And yes, it's corrupt because the keyfile is at its limit. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
Re: Keyfile size
In the last episode (Jul 08), Philip Molter said: I have a MySQL server that has hit it's keyfile size limit (apparently 64M). I can't believe that a value this low would be the absolute limit, but I can't find any documentation about increasing this size. How do I do it? The keyfile size limit for Mysql 3.23 is 4GB. What error are you getting that suggests otherwise? -- Dan Nelson [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
Re: Keyfile size
On Mon, Jul 08, 2002 at 09:50:43AM -0500, Dan Nelson wrote: : In the last episode (Jul 08), Philip Molter said: : I have a MySQL server that has hit it's keyfile size limit : (apparently 64M). I can't believe that a value this low would be the : absolute limit, but I can't find any documentation about increasing : this size. How do I do it? : : The keyfile size limit for Mysql 3.23 is 4GB. What error are you : getting that suggests otherwise? See my response to Paul. The keyfile limit, at least for the table in question, is definitely 64M. The version of MySQL was 3.23.21. I upgraded to 3.23.51 and the index was still limited to 64M. I'm in the process of reconstructing the table to see if that will end this problem. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
RE: Compile guide / needed /recommended versions solaris 8 Sparc
We can supply MySQL box set with manuals and releases for all supported platforms plus some goodies. The price is £35.00 plus VAT (if applicable) you can find details on our website at www.bpenet.net. The price above is a concessionary price. Michael Johnson Managing Director Humphrey Consulting Limited BPEnet Tel: +44 (0)1323 438975 Fax: +44 (0)1323 738355 email: [EMAIL PROTECTED] websites: www.humphreyconsulting.co.uk www.bpenet.lnet -Original Message- From: MySQL DBA [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 6:33 PM To: [EMAIL PROTECTED] Subject: Compile guide / needed /recommended versions solaris 8 Sparc hi, I am trying to build the best version of mysql on solaris 8 for Sparc. Can anyone please recommend 1.) The best version of Mysql to use (I am told there is a payfor version with transactions) 2.) The suggested version of GCC to use (I am using sun freewares GCC 3.1) 3.) The needed / suggested software on the Solaris machine to make Mysql run well compile well 4.) a good compile and install guide as I have done it many times on Linux however I remember having problems on solaris 2.6 and I would like this install to go well. 5.) Any other advice would be greatfully appriciated. 6.) Is it worth compiling mysql in 64 bit mode ? I am not new to Solaris or Linux, and I have used mysql on Linux for a year or 2 now (not in deapth) However I would like to get this first time runnign Mysql on Solaris done well Thanks for your time and help on this. It is much appriciated. Matt. - 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] com 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
Feching results, and Timestamp
Hello all, I´m sure this is a pretty basic question, but I´m quite a beginner so please bear with me. I built a simple client with VC++ 6.0, and I´m accessing a mySQL DB using myODBC 3.51. When trying to select a row from a table, I use a query like that: SELECT * FROM datav WHERE (date_time = ? AND date_time = ? ) ORDER BY date_time It´s prepared execution, and both ? are supposed to be dates, whatever format. date_time is a timestamp(14) column. I tried to bind the ?´s to variables like starttime (and endtime) below, which are taken from CString´s in the convenient format -MM-DD hh:mm:ss : SQLTIMESTAMP starttime = (SQLTIMESTAMP)(LPCTSTR)m_strStartTime; (m_strStartTime is the CString.) I also tried the MMDDhhmmss format for the CString. Still, the freaking query wont work, unless I manually input the ? values, but I need this to be a prepared execution, not direct Exec. In sum, the question is: How do I add time constrains to a query with Prepared Execution? What formats must my variables have so that query can work? Thanks in advance, Mateus Begossi - 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 primary key question!
* Erick Papadakis
i need to set up an auto_increment field inside mysql. for various
reasons, the maximum size is 3.
Could you say something about these reasons...?
but i don't want this to be ONLY integers
because that limits me until 999 numbers only.
Well... using three _bytes_, the unsigned range for mediumint is 0 -
16777215.
If you want to restrict the _visual_ width of the column to be three
characters, then you are right, the limit for integers are 999.
auto_increment works with integers only.
since i have all
flexibility for these three digits or letters, i want to include numbers
and some characters into it as well. e.g.,
m78
23a
1pt
1~8
!76
...etc can all be valid keys for me.
how can i generate such numbers on the fly? if not inside mysql, then
inside php?
I don't think you can do this in an efficient way inside mysql, but using
PHP you should be able to calculate a number into a three character string.
One way may be to use a base 36 integer... in python it would be something
like this:
import string
def base36(x):
... d = string.digits+string.lowercase
... a = x/(36*36)
... b = (x-(a*36*36))/36
... c = x-(a*36*36)-(b*36)
... return d[a]+d[b]+d[c]
...
base36()
'7pr'
int('7pr',36)
The max value would be 46655:
base36(46655)
'zzz'
You could use a SMALLINT (2 bytes only) and auto_increment, and convert the
integer value to the base36() value before you display it on the screen.
This would ensure max three characters in this column.
--
Roger
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: UDF, Can anyone please help?
Hi Miles, Could you explain the same thing with a some sample data? I does not need to be your data. I think that what you want to do is this but I am not sure. Field1 Field2 A 1 A 1 A 2 A 3 B 1 B 1 B 2 C 2 C 2 C 4 C 4 When you say last do you mean this in ms access? Select Field1, Last( Field2 ) From MyTable Group by Field1 Maybe I am not understanding your question, but why don't you do this? Select Field1, Max( Field2 ) From MyTable Group by Field1 Bye and good luck. P.S. One tip about the volume of emails. Check them dialy and delete the ones that you are not interested in. If you are not subscribeb to the mail-list, how are you going to help other people? :-) --- Miles Roper [EMAIL PROTECTED] wrote: Hi, I've being trying for the last couple of months to convert a MS Access to Mysql. I pull out data extract from around 100 + queries. These took about 5 months of solid work to develop and are extremely complex. I can convert these to mysql, but have one big problem. There is no last function in mysql. I know you can do a descending sort by ID and grab the first row to get the same thing. This will not work as I need to do it over several thousand different groups. So I need the last row per group. I have been trying to write a aggregate last UDF function in mysql, and would consider this to be very simple, however, I can't get it to work. I don't really know how to program in C and my understanding of it is quite vague. I really need some help to do this from someone in the community. I have posted several times in the past and haven't heard anything from anyone. I am getting quite frustrated and are about ready to flag this exercise as a great waste of time. I have successful so far got the UDF to compile, and installed. I had to recompile mysql for HPUx to get it to support UDFs in the first place. It has taken me 50+ hours to export several hundred meg of data from access to mysql. I have even written quite a bit of code/scripts to get it to the point where I can start fixing things. So, please, can anyone help me with this. I don't expect someone to do this all for me, but just a LITTLE help would be nice. I will quite happily post this back into the community if I can get it to work. I have removed myself off the mailing digest as the volume is too high. If you could please email me at [EMAIL PROTECTED] Yours Gratefully Miles - 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!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.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
Problem with DB backup
I'm trying to do a backup of my DB using mysqldump and mysqlhotcopy but both functions are sending me an error on SQL syntax. Could someone tell me what's the correct syntax for this functions. HL - Net-M@sters S.A. Plaza Credicorp Bank Calle 50, Oficina 703 tel. (507)-210-1518 fax. (507)-210-1506 [Hora Local: GMT-5] Apdo. Postal 0833-0045, Plaza Panama http://www.netmasters.com.pa - 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: Moving a DB from one Server to another
hi Stop MySql on both servers to avoid changes to database during the move Copy the whole directory to the new server restart both Mysql servers Grant permissions on new server Done :) HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: 08 July 2002 13:39 To: [EMAIL PROTECTED] Subject: Moving a DB from one Server to another Is there a quick and simple way to move a MySQL DB from one server to another MySQL server? Can I just copy the tables? Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [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 - 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
data migration between different computers with mysql
Hi, I am new to the database world, so I wanted to get some facts straight. I have built an application which runs with MySQL. I want to distribute the application along with the data. The target computers would also have MySQL. I have observed that I can zip up the data directory under mySQL and then unzip it in the target computer and it works. What I want to know is whether, this is the best and easiest way. (the other being to import/export to text files, XML etc.) or are they are chasms which I fail to see? thanks. ps: It would be great if you could cc your replies to this one prashantpaiAThotmailDOTcom - 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
BIG TABLES
I've upgraded to MySQL 3.2.49 do I still need to pass the big-tables option on the command line when starting MySQL. Thanks, Ian - 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: DB backup
hi, you should be using the c: prompt to run command and not the mysql prompt. Hasan - Original Message - From: Horacio Lam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 08, 2002 7:30 PM Subject: DB backup I'm trying to do a backup of my DB using mysqldump and mysqlhotcopy but both fuctions are sending me an error in SQL syntax. Could anyone tell me the correct syntax for this functions? thanks HL _ Supercharge your e-mail with a 25MB Inbox, POP3 Access, No Ads and NoTaglines -- LYCOS MAIL PLUS. http://www.mail.lycos.com/brandPage.shtml?pageId=plus - 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: watch batch?
If I want to run a batch (shell mysql batch-file | more) and have the script echoed out to the terminal as it runs so that I can more easily locate my error(s), how can I do that? Normal operation just shows errors and that's not enough to uniquely identify the problem in this case, there must be a way, some sort of shell command? I know I can just comment out or run in pieces, but thought I'd ask Thanks, -billb - 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 hanging
I've been having some problems with MySQL-4.0.1-2 on RedHat 7.2 rpms MySQL-Max-4.0.1-2 MySQL-4.0.1-2 MySQL-shared-4.0.1-2 MySQL-devel-4.0.1-2 Occasionally the server enters into a strange state where it will refuse to do much of anything. Commands hang in the mysql client. Commands such as drop database, flush tables etc. show processlist, show variables still work. Output from the binary log typically shows the drop database command as the last item and then all further output to the binary log ceases. Binary error log snipit # at 299584 #020704 15:52:30 server id 1 Query thread_id=18874 exec_time=0 error_code=0 SET TIMESTAMP=1025819550; INSERT INTO edrsystem(edrsystemid,fieldname,value) VALUES (15,'country','Canada'),(16,'metricsystem','yes'),(17,'timezone','MST'),(18,'daylightsavings','yes'),(19,'editpipetally','no'),(20,'viewfillstrokes','no'),(21,'viewholefill','no'),(22,'depthdatainc','.2'),(23,'nominaldepthinc','1.0'),(24,'pushtimes','01000100'),(25,'rigsize','single'),(26,'lang','en'),(27,'padrig','no'); # at 300013 #020704 15:52:30 server id 1 Query thread_id=18876 exec_time=0 error_code=0 SET TIMESTAMP=1025819550; INSERT INTO hub(hubid,address,name) VALUES (2,'[EMAIL PROTECTED]','Canadian Data hub'); # at 300129 #020704 15:52:31 server id 1 Query thread_id=18887 exec_time=0 error_code=0 SET TIMESTAMP=1025819551; DROP DATABASE IF EXISTS edr; # at 300187 #020704 18:05:27 server id 1 Rotate to mysql-bin.002pos=4 # at 300227 #020704 18:05:27 server id 1 Stop A show processlist shows 3 instances of the drop database Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18893 to server version: 4.0.1-alpha-Max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show processlist; +---+--+---+--+-+--+---+-+ | Id| User | Host | db | Command | Time | State | Info| +---+--+---+--+-+--+---+-+ | 18887 | root | localhost | NULL | Query | 3564 | NULL | DROP DATABASE IF EXISTS edr | | 1 | root | localhost | NULL | Query | 2444 | NULL | DROP DATABASE IF EXISTS edr | | 18890 | root | localhost | NULL | Query | 2387 | NULL | DROP DATABASE IF EXISTS edr | | 18893 | root | localhost | NULL | Query | 0| NULL | show processlist| +---+--+---+--+-+--+---+-+ 4 rows in set (0.00 sec) mysql Typically this hanging of the drop database command happens on the order of several times/day. It is extremely repeatable. Annoying in the extreme. Included in this email is output from lsof (in case of some file resource conflict) and output from show variables. Lately we had an interesting error message that may or may not be a clue: I tried to 'mysqladmin shutdown', but it blocked. When I hit CTRL-C, it printed the following: dmurray@dmurray2:/home/dmurray mysqladmin shutdown -u root Warning; Aborted waiting on pid file: '/opt/pason/data/mysqldb/mysqld-master.pid' after 13 seconds I sent an email regarding a similar problem in May but I don't think any one had any thoughts back then either. I've included the text of the original email below: May 29: --- I have an application database that I'm unable to drop after a period of running several applications against that are using the MySQL++ api. Wondering if anyone has seen this, if it's a known bug and/or if there is a fix. mysqladmin -uroot -p drop db and rm -rf /var/lib/mysql/dbname do succesfully remove the database it's just the mysql client has the problem. drop database returns ok but the database is still there (both show databases and ls -al /var/lib/mysql/dbname say so). Logging in to mysql with mysql -uroot -p to do the drop so it shouldn't be a user permission issue. The directory permissions and file permissions within seem fine too -rw---1 mysqlmysql dirname The database is largely unpopulated (10Mb) with about 50 tables (most of which are MyISAM with 2 or 3 HEAP tables). Linux redhat 7.2 rpms MySQL-Max-4.0.1-2 MySQL-4.0.1-2 MySQL-shared-4.0.1-2 MySQL-devel-4.0.1-2 MySQL-client-4.0.1-2 lsof output -- mysqld_sa 3837root cwdDIR3,24096 2 / mysqld_sa 3837root rtdDIR3,24096 2 / mysqld_sa 3837root txtREG3,2 519964 81746 /bin/bash mysqld_sa 3837root memREG3,2 485171 635289 /lib/ld-2.2.4.so mysqld_sa 3837root memREG3,2 340 342057 /usr/lib/locale/en_CA/LC_IDENTIFICATION mysqld_sa 3837root memREG3,2 28 619030
Re: Problem with DB backup
They are not SQL statements. They are both command line tools. You don't run them from inside the mysql client. hlam wrote: I'm trying to do a backup of my DB using mysqldump and mysqlhotcopy but both functions are sending me an error on SQL syntax. Could someone tell me what's the correct syntax for this functions. HL - Net-M@sters S.A. Plaza Credicorp Bank Calle 50, Oficina 703 tel. (507)-210-1518 fax. (507)-210-1506 [Hora Local: GMT-5] Apdo. Postal 0833-0045, Plaza Panama http://www.netmasters.com.pa - 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
relocatable mysql?? - off topic??
i use mysql on a number of different systems, all of which are sun hardware running solaris. i compile mysql from source myself, and create software packages using sun's utilities. i now have need on some systems to put mysql in /usr/local and in /opt on others. i only want to compile mysql once, and use relocatable packages. is this possible? second, i have other programs, such as perl dbi, which use the mysql libs. how can i compile once, create a relocatable package, and still have my supported programs function properly? thanks, shon stephens - 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
actual database filesizes
can anyone think of a reason that the .MYD and .MYI files would overnight grow to sizes over 5 gigs. and which file holds what data? any help would be greatly appreciated. i included a copy of the text returned from ls. 12 -rw-rw1 mysqlmysql8662 Sep 21 2001 track_log.frm 5940028 -rw-rw1 mysqlmysql6076641280 May 4 08:02 track_log.MYD 5725520 -rw-rw1 mysqlmysql5857197056 May 5 04:02 track_log.MYI //mikezero/ //radiotakeover - 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: Setting up hostname
Hi there Thanks for your reply. check your system configuration ... just run from shell script : hostname and what does it show you ... WHen i run 'hostname' i get my ip address shown to me. and then check your /etc/hosts and /etc/resolv.conf my /etc/hosts has the following in it: # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 testbox localhost.localdomain localhost my /etc/resolv.conf has the following in it: nameserver 137.82.1.1 nameserver 137.82.22.12 after you sure your hostname has been configured properly (on OS side), then restart your mysqld ;-) should be work by then ... I'm not too too sure how to make sure that my hostname has been configured properly. I'm still in the works of getting a domain name, so no domain name has been set up to look up the ip of my box. When I do register a domain name, I know i have to modify my httpd.conf to get apache to work, but do i have to do anything for any other system, mysql, php, or apache files? Thanks Desmond _ Chat with friends online, try MSN Messenger: http://messenger.msn.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: actual database filesizes
mike0 MYI is the index's MYD is the data Can't think why it would suddenly grow in size. Try the CHECK TABLE command to get more detail. David -Original Message- From: //mikezero/ [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 12:37 PM To: [EMAIL PROTECTED] Subject: actual database filesizes can anyone think of a reason that the .MYD and .MYI files would overnight grow to sizes over 5 gigs. and which file holds what data? any help would be greatly appreciated. i included a copy of the text returned from ls. 12 -rw-rw1 mysqlmysql8662 Sep 21 2001 track_log.frm 5940028 -rw-rw1 mysqlmysql6076641280 May 4 08:02 track_log.MYD 5725520 -rw-rw1 mysqlmysql5857197056 May 5 04:02 track_log.MYI //mikezero/ //radiotakeover - 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: MERGE FULLTEXT, two years later.
Hi! On Jul 08, Sander Pilon wrote: -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 12:53 To: Sander Pilon Cc: [EMAIL PROTECTED] Subject: Re: MERGE FULLTEXT, two years later. On Jul 08, Sander Pilon wrote: I searched the archives and in December 2000 it did 'not yet' work. ( http://listarchive.nextrieve.com/mysql//200012/msg00539.html ) Will MERGE tables and FULLTEXT indexes work together in 4.x? Two-and-a-half years later? Most probably, yes. All the hooks are already in. Cool! I got a snapshot from mysqldevelopers.com, but it seems that this is not yet committed to bitkeeper, right? What is not committed ? MERGE tables does not support fulltext searches yet. But they will eventually. It is in the TODO. I meant that it will be not that difficult, as all the hooks, for plugging MERGE tables into fulltext engine (or vice-versa :)) are already in the code. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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: UDF, Can anyone please help?
Hi Frank, Good idea, but I actually need the last value, ie IDField Field1 Field2 1A1 2A4 3A2 4A3 5B7 6B10 7B3 8B8 9C1 10 C2 11 C4 12 C1 The answer would be select field1, last(field2) from table1 group by field1 Feild1 Field2 A3 B8 C1 Select Field1, Max( Field2 ) From MyTable Group by Field1 Would produce a wrong answer Feild1 Field2 A4 B10 C4 I'm keeping an eye on the mailing list via the net. :o) I get to many emails as it is :o) Hope this makes sense :o) Thanks for you help. Cheers Miles -Original Message- From: Francisco Reinaldo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 9 July 2002 03:38 To: Miles Roper; '[EMAIL PROTECTED]' Subject: Re: UDF, Can anyone please help? Hi Miles, Could you explain the same thing with a some sample data? I does not need to be your data. I think that what you want to do is this but I am not sure. Field1 Field2 A 1 A 1 A 2 A 3 B 1 B 1 B 2 C 2 C 2 C 4 C 4 When you say last do you mean this in ms access? Select Field1, Last( Field2 ) From MyTable Group by Field1 Maybe I am not understanding your question, but why don't you do this? Select Field1, Max( Field2 ) From MyTable Group by Field1 Bye and good luck. P.S. One tip about the volume of emails. Check them dialy and delete the ones that you are not interested in. If you are not subscribeb to the mail-list, how are you going to help other people? :-) --- Miles Roper [EMAIL PROTECTED] wrote: Hi, I've being trying for the last couple of months to convert a MS Access to Mysql. I pull out data extract from around 100 + queries. These took about 5 months of solid work to develop and are extremely complex. I can convert these to mysql, but have one big problem. There is no last function in mysql. I know you can do a descending sort by ID and grab the first row to get the same thing. This will not work as I need to do it over several thousand different groups. So I need the last row per group. I have been trying to write a aggregate last UDF function in mysql, and would consider this to be very simple, however, I can't get it to work. I don't really know how to program in C and my understanding of it is quite vague. I really need some help to do this from someone in the community. I have posted several times in the past and haven't heard anything from anyone. I am getting quite frustrated and are about ready to flag this exercise as a great waste of time. I have successful so far got the UDF to compile, and installed. I had to recompile mysql for HPUx to get it to support UDFs in the first place. It has taken me 50+ hours to export several hundred meg of data from access to mysql. I have even written quite a bit of code/scripts to get it to the point where I can start fixing things. So, please, can anyone help me with this. I don't expect someone to do this all for me, but just a LITTLE help would be nice. I will quite happily post this back into the community if I can get it to work. I have removed myself off the mailing digest as the volume is too high. If you could please email me at [EMAIL PROTECTED] Yours Gratefully Miles - 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!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.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
NEWBIE - trouble creating Databases Acess Denied...
I keep getting Access Denied Errors when I try to login to MySql after running mysql_install_db script. I ran the mysql_install_db script, made suer the mysql process is running(checked it using netstat -a), changed the ownership on the binaries and then tried to gain access using the command: mysql -u root mysql, which didnt work and, I also tried using the command: mysqladmin -u root password new_password which didnt work. Both commands still prompt me for a password, when I try to enter a password, I then get the Access Denied Error. Can someone point me in the direction please? Any insight would be GREATLY appreciate as I have been stuck on this for over a week now! Thanks, DK David Kramer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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
hundreds of undefined references from innobase when linking mysql
Description: While attempting to build mysql with Innobase, the final link step encounters hundreds (thousands?) of undefined references such as: ../innobase/srv/libsrv.a(srv0srv.o): In function `srv_get_n_threads': /home/wbarber/flow/contrib/mysql-3.23.51/innobase/srv/srv0srv.c:520: undefined reference to `mutex_enter_func' ../innobase/srv/libsrv.a(srv0srv.o): In function `srv_init': /home/wbarber/flow/contrib/mysql-3.23.51/innobase/srv/srv0srv.c:1614: undefined reference to `mem_alloc_func' ../innobase/srv/libsrv.a(srv0srv.o): In function `srv_suspend_mysql_thread': /home/wbarber/flow/contrib/mysql-3.23.51/innobase/srv/srv0srv.c:2030: undefined reference to `thr_get_trx' ../innobase/srv/libsrv.a(srv0start.o): In function `srv_parse_data_file_paths_and_sizes': /home/wbarber/flow/contrib/mysql-3.23.51/innobase/srv/srv0start.c:153: undefined reference to `ut_strlen' ../innobase/dict/libdict.a(dict0boot.o): In function `dict_hdr_create': /home/wbarber/flow/contrib/mysql-3.23.51/innobase/dict/dict0boot.c:132: undefined reference to `buf_frame_get_page_no' How-To-Repeat: ./configure --prefix=/home/wbarber/mysql --with-debug=full --with-innodb --with-low-memory --enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static make Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Bill Barber Organization: Los Alamos National Laboratory MySQL support: [none | licence | email support | extended email support ] Synopsis: undefined reference errors during mysql link step. Severity: serious Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.51 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux crackerjack 2.4.16-686-smp #1 SMP Wed Nov 28 10:00:01 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jun 20 10:38 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Apr 28 03:57 /lib/libc-2.2.5.so -rw-r--r--1 root root 2390922 Apr 28 03:58 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 28 03:58 /usr/lib/libc.so Configure command: ./configure --prefix=/home/wbarber/mysql --with-debug=full --with-innodb --with-low-memory --enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static - 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 - trouble creating Databases Acess Denied...
Hi, Try this : mysql -u root -h 127.0.0.1 -p (if you have set password) Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: David Kramer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 09, 2002 12:04 AM Subject: NEWBIE - trouble creating Databases Acess Denied... I keep getting Access Denied Errors when I try to login to MySql after running mysql_install_db script. I ran the mysql_install_db script, made suer the mysql process is running(checked it using netstat -a), changed the ownership on the binaries and then tried to gain access using the command: mysql -u root mysql, which didnt work and, I also tried using the command: mysqladmin -u root password new_password which didnt work. Both commands still prompt me for a password, when I try to enter a password, I then get the Access Denied Error. Can someone point me in the direction please? Any insight would be GREATLY appreciate as I have been stuck on this for over a week now! Thanks, DK David Kramer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - 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: Deep Nesting
Hello, With a decent database design, you won't need as many tables. Let me try: Tables for each basic object: (1) One table for stellar objects (2) One table for user comments (3) One table for ratings (4) One table for conjunctions (5) One table for users Link tables: One table to link them all: some USER gives a COMMENT about a STELLAR OBJECT in a particular CONJUNCTION or a RATING about such a comment, along with a comment about the comment, or the rating :) Maybe this is a bit too easy, but it shows that there are ways not to end up with hundreds of tables. Your link table will have many thousand rows, but you can optimise that by using some more tables to have better link granularity. Anyway, we have just transformed a great number of tables into a great number of rows... ;) -Message d'origine- De : Thomas Spahni [mailto:[EMAIL PROTECTED]] Envoye : lundi 8 juillet 2002 10:30 A : Ben Ocean Cc : [EMAIL PROTECTED] Objet : Re: Deep Nesting Ben, The description of your project is as clear as mud or as clear as astrology in general, but it seems to me that you could put all data into one table? However, a bigger number of tables is no problem for MySQL. Using MyIsam tables each table will be equivalent to 3 files. With ReiserFS you should be able to create 10 of them without running into trouble. Don't try this with ext2. Thomas On Sun, 7 Jul 2002, Ben Ocean wrote: Hi; I'm trying to programmatically create tables which are nested so deeply that I fear I'll be creating a gargantuan number of them. I'm seeking a means to limit this, if possible. I'm creating what I call *open source metaphysics*. Here's the scenario: The tables will be used to enable users to enter comments concerning what they believe happens at individual conjunctions. For example, in astrology, let's say one enters a comment of what happens when the Moon enters Scorpio. These comments can then be called by other users and rated with an accreditation system similar to Amazon's rating of books (and those who rate them). The problem occurs with granulation. Let's say, instead, that our above example is when the Moon enters Scorpio while the Sun is in the fifth degree of Aries and Mars is in the twentieth degree of Gemini while the natal chart reflects that this nativity has an ascendant at the seventh degree of Cancer, etc. Indeed, it's actually far more involved than that, because I'd like to cross-reference other metaphysical systems (Tzolkin, I Ching, etc.) several of which have nativities as well as transient elements. I can see tables literally in the thousands (or much higher) with no way to avoid this proliferation. Any suggestions? TIA, BenO sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
NIS problems upgrading from 3.23.36 to 3.23.49a
I've been running MySQL 3.23.36 on RedHat 7.2 for several months. Recently, I tried moving to 3.23.49a (from MySQL rpms). I run the MySQL daemon as user mysql which exists in a NIS database. When I moved to .49a, and attempted to start the database, I got Fatal error: Can't change to run as user 'mysql'; Please check that the user exists. I can su to the mysql user and start the database up that way with no problems. NIS stuff otherwise works fine and as expected. If I reinstall .36, everything works fine again. Has anyone seen this before? Any suggestions? Thanks, Marc - 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: export table?
On Mon, 2002-07-08 at 04:42, Victoria Reznichenko wrote: What about mysqldump? http://www.mysql.com/doc/m/y/mysqldump.html You can make dump file of your table, copy from one server to another and restore table or mysqldump database_name table_name | mysql -hhost_name -uuser_name database_name Thanks, if I'd known export was called mysqldump, I would've searched on that instead of export. Seems there should be a reference to export that would point to mysqldump in the manual or online docs somewhere, IMO. (but then again, maybe I'm the only person to ever search for export.) :-) Thanks for the help, -- Chip -- 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
How to optimize/index merged tables
Hello, I have _a lot_ of http log data to throw into a mysql db (currently over 1.5 billion rows). New data is coming in all the time, so I don't want to lock myself into one set of big tables that are over 100 gigs each. I'd rather arrange this data into smaller chunks, then merge the tables together so it looks like one big table when my users perform sql queries. My biggest concern is speed right now, and the most common search on these tables will be 'count' queries. Currently 'count' queries take over a minute to perform. I'd love to get that number down. Here are some questions: 1) I've need multiple indexes in my tables (for instance, one table has 24 fields, 18 of which should have keys). Should I index each table separately, or do I index the big merged virtual table? 2) When creating the merged table, do I define keys, or do I not bother, since the individual tables are already indexed? Common sense says I should be indexing once over ALL tables, since the searches people perform are always going to span multiple tables. Any experiences you can throw out at me regarding 'merge' would be greatly appreciated. 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
problems with replication in mac os x
Hi, I've got a replication setup with 3.23.51 on two boxes running Mac OS X. For some reason, ALTER TABLE statements, and DELETE FROM TABLE statements (with no where or limit clause), don't seem to be replicated to the slave. Has anyone else experienced problems like this? sql,query -- Gabriel Ricard [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
possible bug: alter table trashed foreign key constraints in innodbtables
sql query In version 3.23.49a when using an innodb table, alter table appears to corrupt foreign key constraints. Try the following test case: create table test_base ( base_id int not null, primary key (base_id) ) type = innodb; create table test_ref ( base_id int not null, ref_id int not null, primary key (base_id, ref_id), foreign key (base_id) references test_base (base_id) ) type = innodb; insert test_base (base_id) values (1); insert test_ref (base_id, ref_id) values (1, 1); alter table test_base add column value int not null; insert test_ref (base_id, ref_id) values (1, 2); The final insert fails with mysql insert test_ref (base_id, ref_id) values (1, 2); ERROR 1216: Cannot add a child row: a foreign key constraint fails which suggests that the foreign key constraint has become hosed? Chuck - 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
Storing images in MySQL bad idea, performance-wise?
I'm working on a simple content management system that uses PHP and MySQL for updating a web site's text (stored in a MySQL database). (The PHP scripts that do the updating (my stuf) live on one web server, the actual DB data to be updated (my client's stuff) live on another.) So far, I've only had to he able to update the text content of a site--therefore, I've only had to bother to store textual data in the client's DB. But now the client wants to be able to upload/change/delete certain pictures on their web site--using my CMS tool--so I am faced with the following problem: Do I store all such images in the DB? (Which I understand reduces performance.) Or do I--somehow--store the images as files on the client's web server? And if so, how? (Because my PHP scripts are being executed on a different server.) ...Rene --- René Fournier, [EMAIL PROTECTED] Toll-free +1.888.886.2754 Tel +1.403.291.3601 Fax +1.403.250.5228 www.smartslitters.com SmartSlitters International #33, 1339 - 40th Ave NE Calgary AB T2E 8N6 Canada - 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: Storing images in MySQL bad idea, performance-wise?
Rene: I think a good deal depends on the size of the image files themselves. There are a number of apps that store small files (i.e.: icons, small gif's, etc.), which seems to make sense. Larger files may be problematic. There was quite a discussion on this issue here just last week ... do a search of the list archive for 'blob versus file' and read some informed opinions. Gerald Jensen - Original Message - From: René Fournier [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, July 08, 2002 5:34 PM Subject: Storing images in MySQL bad idea, performance-wise? I'm working on a simple content management system that uses PHP and MySQL for updating a web site's text (stored in a MySQL database). (The PHP scripts that do the updating (my stuf) live on one web server, the actual DB data to be updated (my client's stuff) live on another.) So far, I've only had to he able to update the text content of a site--therefore, I've only had to bother to store textual data in the client's DB. But now the client wants to be able to upload/change/delete certain pictures on their web site--using my CMS tool--so I am faced with the following problem: Do I store all such images in the DB? (Which I understand reduces performance.) Or do I--somehow--store the images as files on the client's web server? And if so, how? (Because my PHP scripts are being executed on a different server.) ...Rene --- René Fournier, [EMAIL PROTECTED] Toll-free +1.888.886.2754 Tel +1.403.291.3601 Fax +1.403.250.5228 www.smartslitters.com SmartSlitters International #33, 1339 - 40th Ave NE Calgary AB T2E 8N6 Canada - 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
performance bug? using binlog disables group commits
sql query I'm using innodb tables with transactions flushed on commit, version 3.23.49. It looks to me that when binlogs are being generated (which are required for the hotbackup feature or for replication), then group commits are effectively disabled. Basically, there is a coarse granularity lock being held in sql/log.cc -- the LOCK_log lock. Chuck [apologies if a previous version of this email somehow made it to the list -- I didn't see it on the list and was using an incorrect address...] - 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
minor enhancement request -- adding files to innodb
As a minor enhancement, the innodb database could look at improving its handling of data files. Specifically: 1) Provide mechanisms to allow data and log files to be filled with zeroes while normal operations occur, thus minimizing downtime when the database is grown. 2) Don't store the list of data and log files in the my.cnf configuration file, but provide separate commands to add and remove files or partitions from these lists, and store the list within the database. 3) Provide more robust error recovery so that when we, say, run out of disk space while initializing the data and log files, we don't have to delete all the files and re-create them. Chuck sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
minor enhancement request - multiple servers
The current mysql interfaces don't support multiple servers in a fantastic fashion -- either multiple servers on a single machine or multiple servers on multiple machines. It may be there is no great way to do this, but... Sybase provides an interfaces file (that needs to be propagated to at least every client machine), which basically allows one to specifiy a server name that is mapped to an ip address and port number. This seems slightly easier to use than having individual users build their own translations. Chuck - 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
mysqlhotcopy / perl problem
Description: The mysqlhotcopy script fails with recent versions of perl. How-To-Repeat: Invoke mysqlhotcopy with perl 5.6.1. (I'm on a NetBSD box.) The script fails, complaining it can't create the target directory. Fix: In the section of the script that creates the target folder (line 400 or so) add this line to remove the trailing slash: $tgt_dirpath =~ s/\/$//; Submitter-Id: submitter ID Originator:Scott Lahteine Organization: Critical Path Software MySQL support: none Synopsis: The mysqlhotcopy script fails Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.49 (Source distribution) Environment: i386 NetBSD System: NetBSD wwwdev.criticalpath.com 1.5.2 NetBSD 1.5.2 (WWWDEV) #0: Thu Nov 15 10:26:08 PST 2001 [EMAIL PROTECTED]:/usr/src/sys/arch/i386/compile/WWWDEV i386 Some paths: /usr/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='cc' CFLAGS='-I/usr/pkg/include -O2' CXX='c++' CXXFLAGS='-I/usr/pkg/include -I/usr/pkg/include -O2' LDFLAGS='-L/usr/pkg/lib -Wl,-R/usr/pkg/lib/mysql -Wl,-R/usr/pkg/lib' LIBC: -r--r--r-- 1 root wheel 1204396 Aug 23 2001 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 15 Aug 23 2001 /usr/lib/libc.so - libc.so.12.62.1 lrwxr-xr-x 1 root wheel 15 Aug 23 2001 /usr/lib/libc.so.12 - libc.so.12.62.1 -r--r--r-- 1 root wheel 616052 Aug 23 2001 /usr/lib/libc.so.12.62.1 Configure command: ./configure --localstatedir=/var/mysql --with-named-z-libs=z --without-libwrap '--with-named-curses-libs=-lcurses -ltermcap' --without-readline --without-docs --without-debug --without-bench --with-low-memory --without-server --host=i386--netbsdelf --prefix=/usr/pkg - 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
Password mysql running in kylix
Dear all, I got problem, I want to build application with Kylix + MySql. These problem is when this password to connection mysql Null that application running OK, but if i fill password then message error on Kylix Error mapping failed', if I click again then message Unable to execute query. I was Update new patch Driver to connection mysql(libsqlmy23.so.1) thanks for your help.. regards, Adhi Eka P - 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: UDF, Can anyone please help?
So if below is actually what your data looks like, what about: Select Field1, Field2, MAX(IDField) From MyTable Group by Field1 That might get the correct answer for you, but it does however have an extra field in the result (which may or may not be a problem). cheers, noel filter word:mysql On Tuesday, July 09, 2002 7:03 AM, Miles Roper [SMTP:[EMAIL PROTECTED]] wrote: Hi Frank, Good idea, but I actually need the last value, ie IDField Field1 Field2 1A1 2A4 3A2 4A3 5B7 6B10 7B3 8B8 9C1 10 C2 11 C4 12 C1 The answer would be select field1, last(field2) from table1 group by field1 Feild1 Field2 A3 B8 C1 Select Field1, Max( Field2 ) From MyTable Group by Field1 Would produce a wrong answer Feild1 Field2 A4 B10 C4 I'm keeping an eye on the mailing list via the net. :o) I get to many emails as it is :o) Hope this makes sense :o) Thanks for you help. Cheers Miles - 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
Conditional join SQL syntax help?
I'm trying to get the name of a booth or tradeshow depending on the customer_link_type (which is an ENUM) combined with the customer_link_table_id which tells me the index/id of the correct table to look in. I've tried this SQL command, but it doesn't work right. I get multiple permutations still. Is this even possible to do with mySQL? Or do I have to make two queries (one for 'booth' and one for 'tradeshow' and store them in a PHP array or something) SELECT customer_id, customer_name, customer_link_type, customer_link_table_id, tradeshow_name, booth_name FROM Customer_Table, TradeShow_Table, Booth_Table WHERE ((customer_link_table_id = tradeshow_id AND customer_link_type = 'tradeshow') OR (customer_link_table_id = booth_id AND customer_link_type = 'booth')) AND customer_mail_list = 1 ORDER BY customer_date DESC, customer_link_type Here are the three relevant tables and fields (some removed for space saving): CREATE TABLE Customer_Table ( customer_id INT(10) UNSIGNED DEFAULT '0' NOT NULL PRIMARY KEY auto_increment, customer_link_table_id INT(10) UNSIGNED DEFAULT '0' NOT NULL, customer_link_type enum(booth, tradeshow) NOT NULL, customer_name varchar(30), customer_mail_list tinyint(1) UNSIGNED DEFAULT '0', ); CREATE TABLE TradeShow_Table ( tradeshow_id int(10) unsigned NOT NULL auto_increment, tradeshow_name varchar(100) NOT NULL default '' ) CREATE TABLE Booth_Table ( booth_id int(10) UNSIGNED DEFAULT '0' NOT NULL PRIMARY KEY auto_increment, booth_name varchar(30) NOT NULL ); - 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
