max() can't work
select * from table_name where movid = max(movid); why the sql above can't work? Shall I use a sub-select instead? select * from table_name where movid = (select max(movid) from table_name) ? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
optimize mysql table's physical storage
Hello, My mysql table has been created for long time, it increases day by day, and become huge. Right now a full scan to the table for the first time is very slow. So I was thinking to optimize it. This table is stored in many non-sequential disk fragments I think. I want to make this table to be stored in disk with the sequential fragments.That will increase the scan speed. Is there any tool to do it? Thanks in advance. --ken Get the name you always wanted with the new y7mail email address. www.yahoo7.com.au/y7mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help with a sql statement
hello, I try to execute this sql in mysql shell,but got error as: mysql select * from (select uin,count(*) as dd from active_users where date = date_add(curdate(),interval -30 day) group by uin) where dd =3; ERROR 1248 (42000): Every derived table must have its own alias But I can execute the sql statement of select uin,count(*) as dd from active_users where date = date_add(curdate(),interval -30 day) group by uin successfully. How to fixup it? thanks! Get the name you always wanted with the new y7mail email address. www.yahoo7.com.au/y7mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: help with a sql statement
Add an alias for the subquery select * from ( select ) my_alias where dd = 3; Better, use a having clause and eliminate the subquery. Odds are it will be more efficient in MySQL. How to replace the original one with a having statement? Thanks again. Get the name you always wanted with the new y7mail email address. www.yahoo7.com.au/y7mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql connection problems
Hello members, I have two mysqld run on the same host (redhat linux OS with 2.4 kernel). the two mysqld are in different versions, one is 4.0.20,another is 5.0.45. the mysql 4.0.20 uses /etc/my.cnf as its config file,listening on default 3306 port. the mysql 5.0.45 uses /etc/mysql5.cnf as its config file,listening on 3307 port. I start them on command line: /usr/local/mysql/bin/mysqld_safe # for mysql4 /opt/mysql5/bin/mysqld_safe --defaults-file=/etc/mysql5.cnf # for mysql5 All run fine.I didn't see exceptions in mysql's error logs. But, when I try to connect to mysql5, with the command, mysql -uroot -P3307 -h127.0.0.1 Sometime I login it successfully,but most time I can't. The connection seems be blocked. (I don't run any iptables or firewall on this host). This let me really be confused. please help. Thanks! --Ken National Bingo Night. Play along for the chance to win $10,000 every week. Download your gamecard now at Yahoo!7 TV. http://au.blogs.yahoo.com/national-bingo-night/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: run out of memory
try: uname -a to see if your OS is 64bit or not. Gu Lei -原始邮件- 发件人: Jen mlists [mailto:[EMAIL PROTECTED] 发送时间: 2007年8月15日 9:46 收件人: mysql@lists.mysql.com 主题: Re: run out of memory 2007/8/15, B. Keith Murphy [EMAIL PROTECTED]: What operating system are you running and is it 32 or 64 bit? Thanks for the reply. Here is my OS info: $ uname -r 2.6.9-42.ELsmp $ cat /etc/redhat-release Red Hat Enterprise Linux AS release 4 (Nahant Update 4) Yes I think it's 64bit OS. The CPU is something like: $ cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R) Xeon(R) CPU E5345 @ 2.33GHz stepping: 7 cpu MHz : 2327.567 cache size : 4096 KB physical id : 0 siblings: 4 core id : 0 cpu cores : 4 fdiv_bug: no hlt_bug : no f00f_bug: no coma_bug: no fpu : yes fpu_exception : yes cpuid level : 10 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm pni monitor ds_cpl est tm2 xtpr bogomips: 4657.86 I don't know whether it's 64bit or not.Do you mean my CPU have to be 64bit too? I built Mysql from source (mysql-5.0.45.tar.gz). Thanks again. --jen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB per-table-space backup and move
Hi, We'd like to be able to move certain innodb databases between machines (some, but not all). This would help greatly with resyncing slaves and for fast backups. I know that we can create table-spaces on a per-table basis as described here. http://dev.mysql.com/doc/refman/5.0/en/multiple-tablespaces.html It also says that we cannot freely move tables between database directories like in MyISAM, but we can restore backups of .ibd files. Is there any way to move the .ibd files from one machine to another? Is there dependency on the shared tablespace and the corresponding .ibd file? i.e. can we copy a .ibd file to another machine and import tablespace on it? Any input would be appreciated. thanks! Brandon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Professional Enterprise Storage
Enterprise Storage Enhance | Technology February 2005 vol. 1 The Enhance Technology 3U 16-drive storage systems are the true enterprise class systems within the peer group. The UltraStor RS3160SA opens the door to the world of high performance computing by integrating emerging SATA disk technologies with next generation Ultra320 SCSI or Fibre 2G interface connectivity. UltraStor now features over 2TB volume support and includes new Smart-drive disk management utilities, making it the number one choice in professional storage. INTRO PRICE $4,995.00 UltraStor RS3160A RAID System Hybrid Serial ATA disk-based storage system Optional remote monitoring management over TCP Dual Ultra320 SCSI or 2G Fibre ports host interface Carrier grade enclosure facilitates regular maintenance 3U modular rack design for easy integration MSRP:$5,195.00 INTRO PRICE $2,195.00 TeraStor JS3160 Disk Array System Dual-channel, Ultra320 SCSI disk array 3U, 16-drive industry standard 19 rackmount Superior drive and enclosure cooling opt for 15K disks Next generation cable-less enclosure design Compatible with leading SCSI and SCSI RAID HBA MSRP:$2,395.00 Compatible with: Windows 98SE/ME/2000/XP, Mac OS 9.1/OS X, Linux (Kernal 2.4 or later) FOR ORDER INFORMATION CALL: 562-777-3488 OR VISIT http://www.enhance-tech.com/ To unsubscribe from the newsletter, click here and send email back without any content. ® 2005 Enhance Technology, Inc. All rights reserved. | 12221 Florence Ave., Santa Fe Springs, CA, 90670 USA
Problems compiling NDB-Cluster mysql-4.1.2
Hello all, i want to compile the development tree source from bk://mysql.bkbits.net/mysql-4.1 on SuSE 8.2 Linux. The compiling of the mysql-4.1 without the ndb-cluster works fine. When set the configuration-option --with-ndbcluster, the compilation fails with the error: ha_ndbcluster.o(.text+0x3b5c): In function `packfrm(void const*, unsigned, void const**, unsigned*)': : undefined reference to `my_compress' ha_ndbcluster.o(.text+0x3c34): In function `unpackfrm(void const**, unsigned*, void const*)': : undefined reference to `my_uncompress' collect2: ld returned 1 exit status make[4]: *** [mysqld] Error 1 make[4]: Leaving directory `/home/Steffen/mysql-4.1/sql' I've tried to set the CXX and/or CC environment-variable to gcc, but the compilation fails with the same error. Installed Software Versions: Kernel: 2.4.22-33 gcc/cpp : 3.3-23 bison: 1.875 autoconf: 2.53 automake: 1.5 libtool: 1.5 Thanks Steffen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
delete help
I hope someone can help, I am a newbe as sql and need a some help I can by using this command at mysql prompt |select ACCTSESSIONID from radiuslog where ACCTSESSIONTIME='0';| get a list that I then need to delete but when I used the following I keep get errors delete from radiuslog where ACCTSESSIONID = any (select ACCTSESSIONID from radiuslog where ACCTSESSIONTIME='0'); I can not delete the record by just deleting the record with the 0 ACCTSESSIONTIME as this would only delete the Stop and not the start record with the same ACCTSESSIONID from this radiuslog http://netwinsite.com/dbabble/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: delete help
Thank you for taking the time to reply I am using version 4.1 as can be seen from the out put below mysql Ver 13.5 Distrib 4.1.0-alpha, for portbld-freebsd5.1 (i386) Also I am unsure of the syntax for what you suggest Are you aware that you are using a nested sql query which isn't available until version 4.1? Try splitting the delete into multiple steps 1) populate a temp table with the id's you want to delete then 2) use the temp table data to delete the rows. - Original Message - From: tech [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 08, 2003 3:16 AM Subject: delete help I hope someone can help, I am a newbe as sql and need a some help I can by using this command at mysql prompt |select ACCTSESSIONID from radiuslog where ACCTSESSIONTIME='0';| get a list that I then need to delete but when I used the following I keep get errors delete from radiuslog where ACCTSESSIONID = any (select ACCTSESSIONID from radiuslog where ACCTSESSIONTIME='0'); I can not delete the record by just deleting the record with the 0 ACCTSESSIONTIME as this would only delete the Stop and not the start record with the same ACCTSESSIONID from this radiuslog http://netwinsite.com/dbabble/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] http://netwinsite.com/dbabble/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Redhat 8.0 MySQL 3.23.52-3 Replication Problems
I have been having a lot of trouble configuring mysql to do just the simplest replication. Its a standard RedHat 8.0 install, I have followed the directions on http://www.mysql.com/doc/en/Replication_HOWTO.html to the letter half a dozen times now and still, the slave server crashes repeatedly as soon as I enter SLAVE START command. Number of processes running now: 1 mysqld process hanging, pid 26754 - killed 030113 17:54:33 mysqld restarted /usr/libexec/mysqld: ready for connections Number of processes running now: 1 mysqld process hanging, pid 26778 - killed 030113 17:54:34 mysqld restarted /usr/libexec/mysqld: ready for connections Above is what is logged. I eventually have to kill the process and try again. I have tried entering master login/bin-log information in my.cnf and using CHANGE MASTER TO... while logged into slave mysql server. Neither method works. Was wondering if anyone had some insight into this problem. I would be happy to provide more information. Thanks all. -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
2013 Error
Hi, Having a problem with accessing the mysql database from a remote machine. I am typing in mysql -h ???.??.???.?? -u ?? -p. It asked for password .. do that then the reply message is ERROR 2013: Lost connection to MySQL server during query. Have even tryed replacing IP with a host name and get the same error. Would appreciate any advice Regards Troy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Source RPM Compile Error
i downloaded mysql-4.0.8-0.src.rpm off of the mysql web-site and have tried to compile it on several different redhat 8.0 boxes. the same error happens whether compiling latest mysql 3.23 or 4.0 source rpms. the build moves along for about fifteen minutes (long after i begin to believe it will succeed without error). i don't know if it is redhat specific or not. anyone have any suggestions or ideas about how to resolve the error below? thanks all. automake: strings/Makefile.am: Assembler source seen but `CCAS' not defined in `configure.in' automake: strings/Makefile.am: Assembler source seen but `CCASFLAGS' not defined in `configure.in' error: Bad exit status from /var/tmp/rpm-tmp.37688 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.37688 (%build) -chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql
automake: strings/Makefile.am: Assembler source seen but `CCAS' not defined in `configure.in' automake: strings/Makefile.am: Assembler source seen but `CCASFLAGS' not defined in `configure.in' error: Bad exit status from /var/tmp/rpm-tmp.37688 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.37688 (%build) i downloaded mysql-4.0.8-0.src.rpm off of the mysql web-site and have been trying to compile it. does anyone have any suggestions or ideas about how to resolve the above error. thanks all. -chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbinlog segfaults with host args
$ mysqlbinlog --host=mysqlserver --table=sometable --database=somedb \ --user=someuser --password=somepassword Segmentation fault. $ strace mysqlbinlog --host=mysqlserver --table=sometable \ --database=somedb \ --user=someuser --password=somepassword (...) old_mmap(NULL, 1203040, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) = 0x40119000 mprotect(0x40235000, 39776, PROT_NONE) = 0 old_mmap(0x40235000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 3, 0x11c000) = 0x40235000 old_mmap(0x4023b000, 15200, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4023b000 close(3)= 0 mprotect(0x40051000, 49152, PROT_READ|PROT_WRITE) = 0 mprotect(0x40051000, 49152, PROT_READ|PROT_EXEC) = 0 munmap(0x40038000, 99141) = 0 --- SIGSEGV (Segmentation fault) --- +++ killed by SIGSEGV +++ This happens with any version I have installed on Linux 2.4.x, either Suse or Gentoo, gcc 2.95.3 or 3.2.1, MySQL version 3.23.x or 4.0.4 and 4.0.6. -- Nicolas MONNET (Tech) [EMAIL PROTECTED] Carpe Diem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What is relay-bin log?
On Mon, 2002-10-21 at 14:25, Michael Widenius wrote: Which log files is it that you want to delete ? (Please give an example for this) If you have a problem that old relay logs are not deleted, try to upgrade to MySQL 4.0.4 ; We recently fixed a bug in this code. This is still happening with 4.0.5a (Std, with InnoDB). # grep relay /service/svc-mysql/run --relay-log=/mysql/logs/relay \ --relay-log-info-file=/mysql/logs/relay.info \ --relay_log_space_limit=500M \ # ls -al (...) -rw-rw1 mysqlmysql541557913 Dec 16 17:04 relay.001 (...) # mysqladmin processlist (...) | 2 | system user | none | | Connect | 539| Waiting for relay log space to free | (...) # mysqladmin shutdown nothing happens # svc -t /service/svc-mysql nothing still # svc -k /service/svc-mysql ; rm relay.* this works ... # mysql --version mysql Ver 12.16 Distrib 4.0.5a-beta, for pc-linux (i686) # /usr/local/libexec/mysqld --version /usr/local/libexec/mysqld Ver 4.0.5a-beta for pc-linux on i686 -- Nicolas MONNET (Tech) [EMAIL PROTECTED] Carpe Diem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What is relay-bin log?
On Mon, 2002-12-16 at 16:20, Nicolas MONNET (Tech) wrote: (...) Nevermind. This was due to an error in the replication; but nonetheless, it is impossible to shutdown mysqld cleanly if it's waiting for relay logs to be freed. -- Nicolas MONNET (Tech) [EMAIL PROTECTED] Carpe Diem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4.0.5: can't disable any logs!
No matter what I do on the command line for mysqld, or in my.cnf, ALL logs get activated! I'm using the Gentoo ebuilds, with mysqld started from an svscan run script for supervision. Any ideas? I'm lost here! -- Nicolas MONNET (Tech) [EMAIL PROTECTED] Carpe Diem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Hardware p4 or pIII ?
On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote: --- Simon Green [EMAIL PROTECTED] wrote: MySQL uses memory and HDD the most and so processor speed is not so important. Well, processor speed is also important, on some of our servers processors are almost 100% occupied. If your bottleneck is memory speed, you will see 100% CPU usage even if the CPU actually spend 99% of its time idle, waiting for data to come in. I'm not too up to date on the latest RAM technology, but I hear there's several types of DDR, the most expensive one being significantly faster. Or is it? Anyone care to share some insight on this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 'Persistant' temporary tables
On Mon, 2002-11-18 at 15:06, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: On Sun, 2002-11-17 at 00:08, Dan wrote: So I'd like to either keep the connection open across multiple php pages if possible, or just create normal tables and then delete them when I'm done. But the 2nd way would mean I'd have to check for the existance of the table before making it, in case someone else is logged in and already has their own tmp tables... But I don't know how to check for the existance of tables. How should I go about this? Thanks in advance! Here's how I would do it: CREATE TABLE temptablelist ( id INTEGER NOT NULL auto_increment, creation DATETIME, userVARCHAR(100) ); Then name your tables mytemptable_$id, and DROP them in a cron every so often if they're more than $some_max_age old. HTH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Info about XA support
I'm trying to configure a XA datasource on Bea WebLogic 6.1, i'm using the Connector/J. If i use two different database in an atomic transaction i'm not able to commit and i receive a rollback signal. I have reade in a generic forum that actually MySql does not support XA is it true? Thanks Fabrizio Marini E-mail: [EMAIL PROTECTED] E-mail: [EMAIL PROTECTED] K-Tech S.r.l. Company Partner Via Tibullo, 13 00193 - Rome (RM) - Italy Phone: +39 (0) 6 68301467 http://www.k-tech.it http://www.javaportal.it - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql uses 98% CPU
On Mon, 2002-11-04 at 11:58, Dicky Wahyu Purnomo wrote: Pada Mon, 4 Nov 2002 11:55:59 +0100 Toni [EMAIL PROTECTED] menulis: Hello I've got mysql 3.23.47 running on a freebsd 4.5 box for long time without problems, until now that consumes nearly all available CPU. Also, I am unable to stop the server using mysqladmin -u root shutdown (the process freezes) neither can restart it. If I kill -9 the process it restarts and keeps using all my resources. Aparently there isn't any other active process on the machine. I have checked at mysql.com but I couldn't find any related information. ¿Where could this problem come from? ¿Any solution? Check the running queries show processlist ... or mysqladmin -p processlist ... or even better use mytop / mtop for some condition (high cpu usage), optimize your tables, or mysqlcheck -or -A -p You should avoid kill -9 (safe_mysqld/mysql) ... it's only for desperate move ... :D We get the same thing on FreeBSD machines quite often, and it's not related to the actual work being done; MySQL can sit idle but use up all CPU. It happens after a few days/weeks of uptime. Switching to Linux fixed it ;) The difference with what Dicky describes is that for us the MySQL servers still works; it just looks like there's a rogue thread running around doing nothing. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Looking for tool to pretty print table structures
Hi there, Does any of you know of a utility to pretty print mysql table structures? I have a pretty big and messy DB I need to work on, and I would like to be able to print the table structures with nice tables. Any pointers? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 db as filesystem.
On Fri, 2002-10-11 at 17:07, Ed Carp wrote: Should'nt be too hard to do thanks to PODFUK® AKA uservfs: Just goes to show you that Linux is so flexible, any hare-brained idea can be implemented in software sigh. But you didn't answer my question - why would you want to do such a thing? How could it possibly be useful? Adding yet another layer of complexity to ext2fs (or ext3fs, which makes even less sense) is insane, unless you're doing it just to say you can (same goes for the idiotic idea of building an interface into MySQL to produce XML output), or for a *very* specialized application. But, as Jeff Goldblum said in the movie Independence Day, (paraphrase) Just because you can doesn't mean you should. A good reason to do it would be for example to be able to use preexisting file-based tools on the database. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 db as filesystem.
On Fri, 2002-10-11 at 10:06, Ed Carp wrote: At 12:58 +0200 10/10/02, Alex Polite wrote: Is there any way I could display a MySQL database as a filesystem under Linux? What does that mean? I think he wants to mount a MySQL database as a filesystem, like CFS with the loopback driver. The answer is almost certainly no - why would you want to do such a thing? sql, query Should'nt be too hard to do thanks to PODFUK® AKA uservfs: http://uservfs.sf.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [MyODBC]Access denied for user: 'ODBC@localhost'
ok, rebooting didn't fix it, reinstalling myodbc didn't fix it, creating a user ODBC@localhost fixed it. all off a sudden i need a user named ODBC@localhost, and last i checked, i'm the only one here that knows anything about how to use mysql here at the office. so what might have been changed that would cause this. MyODBC has the correct username/password for the databases it uses. MS Access can open the ODBC databases without any problems (before i created the ODBC@localhost) its only the web server that seems to need the user. (ColdFusion PHP) and how do i change it back to not need the odbc@localhost user anymore (again)? and it turns out (just to mislead me even more...) Mozilla 1.0 running on linux isn't working correctly with phpmyadmin using cookie auth. (don't know if its just me, or just mozilla...) after login in, it shows me 2 frames, both with login screens. On Thursday 06 June 2002 8:39, you wrote: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S1000 (General error) [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:39). Date/Time: 06/06/02 06:34:43 Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 it was working fine yesterday... what is probably the problem? also i can't use phpMyAdmin anymore from the same machine. i can use the command line mysql just fine though. its running off of a win2k machine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- To one large turkey add one gallon of vermouth and a demijohn of Angostura bitters. Shake. -- F. Scott Fitzgerald, recipe for turkey cocktail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: is there a whoami for mysql?
mysql select user(); +---+ | user()| +---+ | [EMAIL PROTECTED] | +---+ mysql show grants for [EMAIL PROTECTED]; ERROR 1141: There is no such grant defined for user 'root' on host '192.168.0.17' mysql show grants for user(); ERROR 1064: You have an error in your SQL syntax near 'user()' at line 1 mysql select user,host from mysql.user where user='root'; +---+---+ | user | host | +---+---+ | root | % | | root | 192.168.0.0/255.255.255.0 | | root | localhost | +---+---+ in theory i should be logged in [EMAIL PROTECTED]/255.255.255.0, but i've been wrong before... is there a way to just get which user/host set is being used? On Monday 03 June 2002 9:28, you wrote: Hi Ray, You can see what user you is with: select user(); Ray wrote: is there a show grants self or a whoami type command? i'm trying to setup security, but i'm not show who i'm login in as? root@% or [EMAIL PROTECTED]/255.255.255.0 i am logging in just fine, but i don't really want to delete root@% until i know i'm getting the right login. \s just shows me Current user: [EMAIL PROTECTED] but show grants for [EMAIL PROTECTED]; says there are no grants for this account. also, i could see this coming up for debugging as a big help. note: all ips and usernames have been changed to protect the incredably insecure, and maybe a bit paranoid. 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 -- The best cure for insomnia is to get a lot of sleep. -- W. C. Fields - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
smaller mysql docs?
is there a place to get the manual that is split a bit more then the current manual_split. these are the 2 pages i end up reading the most even though its usually for just the grant, create, insert syntax (human in need of memory upgrade) 416k Sep 26 2001 manual_MySQL_Database_Administration.html 312k Sep 26 2001 manual_Reference.html i'm not sure what's wrong with my computer, but loading the pages takes a while from the local harddrive, or maybe its rendering the page... either way, the larger pages are annoyingly slow. or is there a cheat sheet page? (syntax, links into the manual, not much else) -- Bill Dickey is learning me his experience. -- Yogi Berra in his rookie season. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Auto increment (Newbie)
manual_Reference.html#CREATE_TABLE
create_definition:
col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
[PRIMARY KEY] [reference_definition]
create table MyTestTable(cno int AUTO_INCREMENT, name varchar(20));
can't seem to find the ref right now, but
insert into MyTestTable(555,'Ryan');
insert into MyTestTable (name) values ('Ryan');
or
insert into MyTestTable values (null, 'Ryan');
On Thursday 30 May 2002 3:43, you wrote:
Hey there,
I know this might sound like a stupid question to a lot of you guys out
there but please keep in mind I come from an oracle background and am new
to this:
I am accessing MySql from PHP, I have two questions regarding
Auto_Increment
1) how to create an auto_increment?
create table MyTestTable(cno int, name varchar(20));
works fine, but I want cno as an auto_increment, what statement to use?
2)to insert int into my example I will use
insert into MyTestTable(555,'Ryan');
How would I do it if I was entering data and the cno was an auto increment?
I have glossed through the manual, but frankly after 6 hours of PHP
programming i'm feeling braindead so PLEASE dont ask me to RTFM, if you
have links to the specific topic in the manual no problem, just tired of
searching.
Cheers all,
-Ryan.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 there local outfile?
is there a way or possibly a command line tool for querying a remote file and having it dump the select into a local outfile. it does exacly what i want from the server, but only to create a file on the server. and just adding local doesn't/hasn't work. and mysqldump outputs sql, which isn't what i'm looking for either. SELECT blah, blah2, blah3 . INTO LOCAL OUTFILE 'blubering.txt' FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '' FROM chatter_table; -- If there are self-made purgatories, then we all have to live in them. -- Spock, This Side of Paradise, stardate 3417.7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: data compare and duplicate entries..
hi, I was looking for an SQL statement or script that whould allow me to compare data when it was entered into a mysql-php field on a web page so that it checks whether the data entered has not been used before in the database.. In short, when data needs to be entered, the statement/script must check in the database whether the data is not already entered into the database and if its there, return with an error.. and not allow the data to be entered... if the data is not there, then it may be entered.. Thanx Willem Pretorius - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-3.23.49-pc-linux-gnu-i686
Hello, The binary distribution of mysql 3.23.49 seems to be non-functional under slackware 8.0, unable to find the user the database is configured to run as Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! root@mysql:~# id mysql uid=27(mysql) gid=27(mysql) groups=27(mysql) root@mysql:~# mysql 3.23.48 binary distribution (and lower) works fine, and a 3.23.49 compiled from source also works fine regards Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
User/database permissions
This is going to be a very basic question, so please excuse me. I have a MySQL server running, but when I added users I inadvertently gave them all permissions to everything. They can all access every one else's databases and make what ever changes they want and even delete. How do I lock it down where they only have rights to their own? I don't even know how to view what users are there, much less change their rights. I've been looking in the documentation online, but it seems to assume that I know more than I do. Thank you in advance. -MWhitaker - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connect VB to mysql over net
I want to build a VB application that connects to mysql (over the internet) running on linux. i have mysql currently running on LAMP system fine, but do i just need to install MyODBC for linux on the mysql server or what? also, are there any major security issues to this i should know about? any help is appreciated..thanks in advance. -d - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Transaction Support in MySQL
What sort of support for transactions and table/record locking is there in MySQL right now? I had heard that only table locking was supported, and limited support for transactions. Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't compile mysqlgui because edfile.o missing (fwd)
I'm trying to compile the mysqlgui source currently available on mysql.com (version 1.7.5). I've successfully compiled/installed the packages fltk-1.0.11 and flek-0.1.1 (as suggested by the doc/README.TXT file supplied with mysqlgui), as well as the fl_editor-0.4 package. The test programs supplied with fl_editor work fine, so I suspect it compiled completely. However, the installation instructions supplied with mysqlgui claim I must copy the file edfile.o from the directory where fl_editor was compiled, yet that file (or edfile.c, or any edfile*) doesn't exist in the v0.4 fl_editor distribution. To make things more difficult, the link to Instructions compiling MySQL GUI with FL_Editor on the mysqlgui page is broken. Could anyone provide help in locating this edfile.o? Thanks. -- Ben West KWUR 90.3 FM [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
Newbee Question !
Dear lists members, I gonna download MySQL and PHP to install on my machine. But the problem is that I don't know which tarballs are required to do from mysql.com and php.net. I mean I would like to manage databases using HTML interface (MySQL/PHP). Any points or links to the web sites are highly appreciated. Thank you very much indeed. TK Tech (Linux Newbee) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbee Question !
Oh...Yeah I forgot to mention it. It's Red Hat kernel 2.2.16. Apache x.x.19. Browser Mozilla/Netscape. I would like also to verify all users to give their Username/Password to access my database. This Computer gonna be both Server for my team project and Client for me. I mean I'll test and manage the databases too. Thanks again. On Thu, 25 Jan 2001, Jorma Jakowitsch wrote: It would be best to know what kind of Linux you have? SuSE? Mandrake? whatever.. What kind of Computer? Depending on this information it IS very easy to find the required tarballs Hope it helps - Jim -Original Message- From: Khuon Tech [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 10:10 AM To: MySQL forum Subject: Newbee Question ! Dear lists members, I gonna download MySQL and PHP to install on my machine. But the problem is that I don't know which tarballs are required to do from mysql.com and php.net. I mean I would like to manage databases using HTML interface (MySQL/PHP). Any points or links to the web sites are highly appreciated. Thank you very much indeed. TK Tech (Linux Newbee) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbee Question !
Oh...Yeah I forgot to mention it. It's Red Hat kernel 2.2.16. Apache x.x.19. Browser Mozilla/Netscape. I would like also to verify all users to give their Username/Password to access my database. This Computer gonna be both Server for my team project and Client for me. I mean I'll test and manage the databases too. Thanks again. On Thu, 25 Jan 2001, Jorma Jakowitsch wrote: It would be best to know what kind of Linux you have? SuSE? Mandrake? whatever.. What kind of Computer? Depending on this information it IS very easy to find the required tarballs Hope it helps - Jim -Original Message- From: Khuon Tech [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 10:10 AM To: MySQL forum Subject: Newbee Question ! Dear lists members, I gonna download MySQL and PHP to install on my machine. But the problem is that I don't know which tarballs are required to do from mysql.com and php.net. I mean I would like to manage databases using HTML interface (MySQL/PHP). Any points or links to the web sites are highly appreciated. Thank you very much indeed. TK Tech (Linux Newbee) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
