Re: mysql listed as attach page by google?

overzealous? See: http://www.net-security.org/malware_news.php?id=1853 Not personally confirmed, but... -- Hassan Schroeder hassan.schroe...@gmail.com http://about.me/hassanschroeder twitter: @hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Best way to synchronize two database schemas

have similar features. FWIW, -- Hassan Schroeder hassan.schroe...@gmail.com twitter: @hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Possible new MySQL 0day

? -- Hassan Schroeder hassan.schroe...@gmail.com twitter: @hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Stopping DNS Lookups

reverse DNS lookups for some reason. Is there a quick way of disabling these calls to the DNS server? See http://dev.mysql.com/doc/refman/5.0/en/dns.html HTH, -- Hassan Schroeder [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

Re: insert utf8 character in Linux commind-line tool

wangxu wrote: I can't operate utf8 characters within command-line in linux operating system. Mysql doesn't support? I can enter utf8 characters using the mysql command-line client just fine -- SuSE 9.1, MySQL 4.1.13 on this system. FWIW! -- Hassan Schroeder

Re: Cleaning illegal characters from varchar field

Java. I don't know where to look for such a function. The java.sql and javax.sql sections of the JavaDoc would be a good place to start :-) /* hint: java.sql.PreparedStatement */ -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http

Re: Cleaning illegal characters from varchar field

certain characters automatically, the capability provided by PreparedStatements, implemented in this case by Connector/J, which *is* MySQL-specific :-) http://dev.mysql.com/doc/refman/5.0/en/cj-implementation-notes.html HTH, -- Hassan Schroeder - [EMAIL PROTECTED

Re: Cleaning illegal characters from varchar field

, this is a function of *PreparedStatement*s. You'll also find references to them as you research SQL injection attack :-) HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code

Re: Re-REQUEST: proper way to export with the --tab function???

the default settings? If so and you're seeing this problem, let's see some sample records that are failing. -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL

Re: Re-REQUEST: proper way to export with the --tab function???

- or line-handling options can specify an empty string (''). If not empty, the FIELDS [OPTIONALLY] ENCLOSED BY and FIELDS ESCAPED BY values must be a single character. /q FWIW, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http

Re: mysqldump for xml

is as simple as `mysqldump --xml {database} {table}` P.S. Don't hijack threads, please. -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List

Re: old_passwords

be helpful :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: How to start mysql on linux?

Jerry Swanson wrote: I have sudo access to Linux box. How to start mysql 4.0.14. For 4.1, but you can probably figure out the differences :-) http://dev.mysql.com/doc/refman/4.1/en/server-side-scripts.html -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design

Re: Mysql and JDBC connection time out.

:-) But the first one is OK, and shows that this has nothing whatsoever to do with MySQL; you'll have to find out why your XP machine is not apparently able to create outbound connections. Good luck, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567

Re: Mysql and JDBC connection time out.

, but not access the database, you need to add the appropriate permissions to the grant tables. HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General

Re: Mysql and JDBC connection time out.

with Mysql database at this point? I'd say it looks like an XP- (or at least that-particular-machine-) specific problem if you can connect from other systems :-) Good luck, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http

Re: float comparison?

this: select * from price where amount 3.44 and amount = 3.46 Or maybe ... where ROUND(amount,2) = 3.45; -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code

Re: Mysql privs via PHP? Problems - * Now with error message

MySQL install :: is, but: Entropy PHP 4.3.11 :: obviously this version of PHP is compiled against old libraries; time to recompile or find a newer binary :-) HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http

Re: multiple commands to mysql from regular command line

; show tables;' -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Relocation of database store

relocation methods indicated above cause EVERYTHING to be relocated, i.e. not only the hard files, but the socket file also. ?! I've relocated datadirs frequently and never seen it affect the location of the socket file. YMMV! -- Hassan Schroeder - [EMAIL PROTECTED

users are always the last to know :-)

it plans to negotiate to extend the deal between Innobase and MySQL when it needs to be renewed next year. http://www.bizjournals.com/sanjose/stories/2005/10/03/daily52.html?hbx=e_du -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567

Re: Can we run linux commands from inside the msql client

Wolfram Kraus wrote: can we execute shell commands inside mysql client Use \! Whoa. I didn't know that. Is that controlled in any way by GRANT? Or by conf/startup options? It seems like something you might (strongly!) want to disallow in a shared environment :-) -- Hassan Schroeder

Re: Can we run linux commands from inside the msql client

[EMAIL PROTECTED] wrote: The system commands you execute through the MySQL client are not performed at the server ... Ah, OK, got it. Of course. I plead temporary under-caffeination :-) Thanks for the clarification. -- Hassan Schroeder - [EMAIL PROTECTED

Re: strange order by problem

| 2005-09-22 | +--++ HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: strange order by problem

| +--++ HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Adding InnoDB support

Obantec Support wrote: I found upgrading info but no info on how to install a second mysql server. `tar xvfz` works the same for one or many :-) Do you have a specific question? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567

Re: Adding InnoDB support

it and yes, configure it to use a different port and socket. I always have multiple versions installed on my dev and production machines for testing. FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

Re: HTML in MySQL?

clint lenard wrote: can anyone help me with this question? (about using Smarty) No doubt -- but that anyone would likely be on a Smarty-specific (or at least PHP-oriented) mailing list, eh? :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1

Re: searching through a mysql db/tbl

, what language/environment your server is using, eh? :-) There's a nice JSP Taglib in the Sandbox for exactly this purpose: http://jakarta.apache.org/taglibs/sandbox/doc/datagrid-doc/intro.html :: if you're using Java, for example. FWIW! -- Hassan Schroeder - [EMAIL

Re: mysqldump: Error 2013

difference. Does the size of the contents of that field exceed your defined max_allowed_packet size? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General

Re: mysqldump: Error 2013

, and see if it fails on the same row every time. HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http

Re: Create Index with DESC not working on v5

storage. Currently they are parsed but ignored; index values are always stored in ascending order. HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL

Re: ORDER by Question

| | The | | | ++ Quick test: SELECT REPLACE(name,'^The ','woohoo') FROM names; -- :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream

Re: ORDER by Question

(LEADING The FROM name); But I guess when simplicity just won't do... :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list

Re: upgrade mysql 3.23.58 to 4.1

or whatever. It will be *so* much simpler to switch between the old and new, or run them simultaneously as needed. FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code

Re: ORDER by Question

... ORDER BY Subscriber ASC, TRIM(LEADING The FROM Name) ASC; :: should work :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list

Re: starting mysql 4.1.12 on Ubuntu Linux

! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: starting mysql 4.1.12 on Ubuntu Linux

smoothly when I issue a manual /etc/init.d/mysql start. It looks like a bug in Ubuntu distro. Yes to both; again, look in the MySQL log files, and possibly your system log files as well to see if there's something relating to this. HTH, -- Hassan Schroeder - [EMAIL

Re: PHP,Apache and MYSQL

recompile PHP using the newer MySQL client libraries. HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http

Re: no /tmp/mysql.sock

directory -- it sounds like you were trying to run it from ./scripts, which makes a big difference in the interpretation of the 'current working directory' :-) HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

to connect with your new client. HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

with FC3, and it's first in your path; try: prompt# which mysql :: and see if it's the 4.1 version you installed. I'll bet it's not :-) If so, remove it or set your PATH appropriately. HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567

Re: ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client

` or `safe_mysqld` ; look in the 'bin' directory of your MySQL install... You may also find it useful to run something like: prompt# find / -type f -name 'mysql*' -print :: to see what-all's scattered around your system :-) HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive

Re: Seeking advice on currency type

can't imagine any reason to use a type other than DECIMAL for a currency value. YMMV! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list

Re: Seeking advice on currency type

? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Seeking advice on currency type

DECIMAL instead of INTEGER for currency? I'd just wonder if it's enough to make up for all the required conversions going on in the app layer :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

Re: Size of BLOB types?

? :: which is nope :-) FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Size of BLOB types?

at the very begining of the cited page. I'd have probably put it there in plain English (and numbers) too, but no one asked me :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream

Re: please help : linux version

you can get the corresponding package(s) for your own system(s)? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http

Re: Counting number of values in a SET column

(REPLACE(BIN(mySetCol+0),0,'')) FROM projects will give you what you want... HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list

Re: show all running queries on linux

Reinhart Viane wrote: How can I see the running queries on a linux comp? If you have a fairly standard config, with a log file defined -- prompt grep '^log=' /etc/my.cnf | sed 's/log=//g' | xargs tail -f If there's no log file in /etc/my.cnf, start by putting one there :-) HTH! -- Hassan Schroeder

Re: Stop the Server in Control Center not working

and reinstall. `mysql` is the *client* executable, most definitely *not* a symlink to `mysqld_safe`. -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing

Re: phpmyadmin can't connect via browser

Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo() show? -- Hassan Schroeder

Re: phpmyadmin can't connect via browser

installation. -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: phpmyadmin can't connect via browser

Mark Sargent wrote: I'm figuring you wanted to know if php was working, yes..? No, I wanted to know if your PHP was compiled with MySQL support. It doesn't have to be, and in your case seems it probably *isn't*. But we still don't know :-) -- Hassan Schroeder - [EMAIL

Re: Using Different Database Groups On the Same Computer

can run only one instance at a time, it will exit without running a new instance if it detects one already running. FWIW, `/etc/init.d/mysql` and `safe_mysqld` are just shell scripts. Hence you can copy and change them easily to run multiple versions or instances of most software... -- Hassan

Re: Using Different Database Groups On the Same Computer

, and use that to configure the second process. That way you can be relatively sure there aren't any overlapping resources. HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code

Re: Using Different Database Groups On the Same Computer

this going :-) FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: php conection problems

, or with the Apache httpd -- phpinfo() is showing you what MySQL libraries *PHP* was compiled with. If you want PHP to use newer (4.x) client libraries, either find a binary distribution that suits you or compile it yourself. -- Hassan Schroeder - [EMAIL PROTECTED

Re: New to MySQL on Linux

on the MySQL downloads page :-) Linux (x86, glibc-2.2, static, gcc) Standard 4.1.9 26.9M HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing

Re: innodb SuSE 9.2

. :-) FWIW, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: SuSE 9.2 Professional, Runlevel editor via telnet innodb

Ed Patterson wrote: First I am looking for a way to shutdown and or restart MySQL via telnet. mysqld -restart returns You want `mysqladmin [command]` -- try `mysqladmin --help` for a quick list of available commands. HTH! -- Hassan Schroeder - [EMAIL PROTECTED

Re: Problem with query and password

small? :-) FWIW, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Date Conversion on Mysql 4.0.2

, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Sum on Float type

field, what type should I use? For currency fields, I use DECIMAL. See: http://dev.mysql.com/doc/mysql/en/Numeric_type_overview.html HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

Re: Upgrading bundled ver of mysql included with php 4.3.1

, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Which MySQL software is useful for the clients?

from the tar file distribution rather than using RPMs, you'd have everything you need to start with... FWIW, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL

Re: Ok now connector/J doesn't work.

you thought of trying this from a standalone Tomcat? Wouldn't take long to install and test... FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General

Re: Moving innodb from Linux to Windows

find tables with uppercase letters in their name. That would be great, though I've solved the problem for myself by abandoning Windows as a dev platform in favor of Linux :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http

Re: mysql 4.1 + debian

use that? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: How to extract Particular Tables from a Dump file taken with mysqldump

it to the original machine as a different name, and copy the target table back to the original DB. HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List

Re: Adding hypertext data element into record ...

, %events]) for the anchor tag *in addition to* href; how would you propose to determine those values? :-) FWIW, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General

Re: bugzilla not working now after MySQL re-installed

besides the error message above? It appears that MySQL isn't running. Have you *tried* accessing it from the command-line client, using the username/password set in your localconfig? That would be the first logical step... -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive

Re: bugzilla not working now after MySQL re-installed

? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: bugzilla not working now after MySQL re-installed

in bugzilla's config file; can you log in from the MySQL client using them instead of the root user/pwd? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General

Re: bugzilla not working now after MySQL re-installed

up in the MySQL logs when bugzilla runs (or tries to)? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http

Re: bugzilla not working now after MySQL re-installed

is there? I run RedHat but I'm not that much of an RPM fan; tried it a few times and got tired of wierd installation defaults... :-) It's certainly possible the RPM was compiled with different options than the configure/make defaults, though. -- Hassan Schroeder

Re: Import Strategies

with the program :-) FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Stop Scrolling

/mysql/en/mysql_Commands.html FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: New 4.1.2 Startup Trouble

:-) FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: FW: create database in specified character set

-- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: create database in specified character set

specifies ... That's 4.1.1 -- time to upgrade. :-) HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http

Re: Mac Developer Question

(including .err, .pid) are located at /sw/var/mysql -- and I think they were installed there by default, because I'd never have chosen that :-) And the file name on my system is the actual hostname'.pid', *not* just 'localhost.pid', in case that reference is literal... HTH! -- Hassan Schroeder

Re: Mac Developer Question

on a Mac-oriented dev list. HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Random Record Retrieval

records from a table? SELECT ID,quote,author from quotes ORDER BY RAND() LIMIT 1 HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List

Re: HTML in MySQL Tables

with PHP in many different ways. Uh, many, yeah; put the coffee on. :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives

Re: HTML in MySQL Tables

that can only be done with XML? No, but 1) it works well for this kind of application, and 2) there are lots of tools available... -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream

Re: BLOB's - General Guidance

, SUBSTRING(img,4,3) AS width , SUBSTRING(img,8,3) AS height FROM images WHERE LEFT(img,2) = 'ak' You can put that into your own function and write the entire image tag out with the proper width and height, in one swell foop :-) FWIW! -- Hassan Schroeder

Re: BLOB's - General Guidance

names -- then generate your links from the DB data. -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Query across two databases on the same server

where db1.table.someotherfield = db2.table.someotherfield -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http

Re: mysql.user does not reflect privileges granted correctly?

Bing Du wrote: I did: mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; But mysql select * from user where user='ltmuser'\G; shows: :: that 'ltm' != 'ltmuser' :-) Or is the example a typo? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design

Re: Newbie - Please help with createing database

prompt$ In this case, it indicates the *MySQL process* doesn't have proper file system permissions to create the new database; you need to fix that... HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

Re: Newbie - Please help with createing database

. Depending on how you installed MySQL, you may want to read this page also: http://www.mysql.com/doc/en/Changing_MySQL_user.html HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

Re: Uninstall MySQL for Panther?

HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Help with a query

, it needs to be escaped, historically (*) by prefixing it with ''. * might be specified by the RFC, don't recall at the moment... /historitrivia -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

Re: Bash script to MySql

/path/to/msyql -umack -ptheknife -e use serialDB; select serial from serials; Not tested with cron, but ... HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL

Re: Please help with syntax for mysqldump

I'm not sure how a path with spaces -- My Documents -- is going to work, but experiment (or pick another location). :-) HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code

Re: select lock - How reliable?

LAST_INSERT_ID() is connection specific, so it is safe from the concurrency issue. Note: safe may not apply if you're using connection pooling :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

Re: select lock - How reliable?

for *multiple* end users over a single connection? If so, how would LAST_INSERT_ID() be able to guarantee that another end user's INSERT hadn't preceded it? Or am I totally OTL? :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http

Re: select lock - How reliable?

connection? Or is that connection-pool-implementation dependent? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http

  1   2   >