Re: mysql listed as "attach page" by google?

2011-09-26 Thread Hassan Schroeder
gle being 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

Re: Best way to synchronize two database schemas

2010-01-23 Thread Hassan Schroeder
ised if other comparable (i.e., Rails clone) platforms 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

2010-01-06 Thread Hassan Schroeder
On Wed, Jan 6, 2010 at 5:47 PM, Daevid Vincent wrote: >  <http://intevydis.com/> Intevydis has published a flash video showing what > appears to be a new 0day exploit against MySQL 5.x. Gah. Is there a text description available that doesn't require sitting through some #%#$ v

Re: Stopping DNS Lookups

2008-10-22 Thread Hassan Schroeder
t the server is performing "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 Gene

Re: Cleaning illegal characters from varchar field

2005-12-21 Thread Hassan Schroeder
escape the percent sign? Again, 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 ===

Re: Cleaning illegal characters from varchar field

2005-12-21 Thread Hassan Schroeder
We're talking about escaping 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 ---

Re: Cleaning illegal characters from varchar field

2005-12-21 Thread Hassan Schroeder
certain methods or calls. > > I use 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] Webtu

Re: insert utf8 character in Linux commind-line tool

2005-12-21 Thread Hassan Schroeder
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! --

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

2005-12-20 Thread Hassan Schroeder
u tried 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

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

2005-12-19 Thread Hassan Schroeder
27;#*#*#' Any of the field- 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. FWIW, -- Hassan Schroeder - [EMAIL PROTECTED] Webtui

Re: mysqldump for xml

2005-11-28 Thread Hassan Schroeder
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 Maili

Re: How to start mysql on linux?

2005-11-22 Thread Hassan Schroeder
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] W

Re: old_passwords

2005-11-22 Thread Hassan Schroeder
les.html> :: might 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/mysq

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Hassan Schroeder
this issue, the system administrator has to > be involved? Or say, it has nothing to do 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 --

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Hassan Schroeder
n't help there. If you *can* reach that port, 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

Re: Mysql and JDBC connection time out.

2005-11-02 Thread Hassan Schroeder
s not surprising that didn't work :-) 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

Re: float comparison?

2005-10-29 Thread Hassan Schroeder
0001'. > > Try something like 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 ==

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

2005-10-27 Thread Hassan Schroeder
o idea what: > 10.4's default 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

Re: multiple commands to mysql from regular command line

2005-10-21 Thread Hassan Schroeder
-e 'show databases; use test; 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://l

Re: Relocation of database store

2005-10-10 Thread Hassan Schroeder
location > It appears that both 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 "fil

users are always the last to know :-)

2005-10-07 Thread Hassan Schroeder
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-93

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

2005-09-28 Thread Hassan Schroeder
[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 PRO

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

2005-09-28 Thread Hassan Schroeder
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 :-) -- Ha

Re: strange order by problem

2005-09-27 Thread Hassan Schroeder
09-26 | > | SWAP3| 2005-09-23 | > | SWAP3| 2005-09-22 | > | SWAP5| 2005-09-21 | > | SWAP5| 2005-09-26 | > | SWAP5| 2005-09-23 | > | SWAP5| 2005-09-22 | > +--++ HTH! -- Hassan Schroeder - [EMAIL PROTECTED] W

Re: strange order by problem

2005-09-27 Thread Hassan Schroeder
t; | SWAP5| 2005-09-21 | > | SWAP5| 2005-09-26 | > | SWAP5| 2005-09-23 | > | SWAP5| 2005-09-22 | > +--++ HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com

Re: HTML in MySQL?

2005-09-12 Thread Hassan Schroeder
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 Desig

Re: Adding InnoDB support

2005-09-12 Thread Hassan Schroeder
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: Adding InnoDB support

2005-09-12 Thread Hassan Schroeder
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: searching through a mysql db/tbl

2005-09-10 Thread Hassan Schroeder
ults... That would depend on, among other things, 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 exampl

Re: mysqldump: Error 2013

2005-08-29 Thread Hassan Schroeder
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: h

Re: mysqldump: Error 2013

2005-08-29 Thread Hassan Schroeder
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: Create Index with DESC not working on v5

2005-08-09 Thread Hassan Schroeder
ing index value 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. c

Re: ORDER by Question

2005-06-27 Thread Hassan Schroeder
same result as: SELECT * FROM names ORDER BY TRIM(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

Re: ORDER by Question

2005-06-27 Thread Hassan Schroeder
rder | Xylophone | | Zyxel | | The | | The | | The | | The | | | +----+ Quick test: SELECT REPLACE(name,'^The ','woohoo') FROM names; -- :-) -- Hassan Schroeder -

Re: ORDER by Question

2005-06-26 Thread Hassan Schroeder
atever the second word is. SELECT... 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

Re: upgrade mysql 3.23.58 to 4.1

2005-06-26 Thread Hassan Schroeder
mysql-4.1.12 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

Re: starting mysql 4.1.12 on Ubuntu Linux

2005-06-25 Thread Hassan Schroeder
on linux start up but wake up 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 -

Re: starting mysql 4.1.12 on Ubuntu Linux

2005-06-25 Thread Hassan Schroeder
your distro has a confusingly named startup file in /etc/init.d. HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List F

Re: PHP,Apache and MYSQL

2005-05-13 Thread Hassan Schroeder
u should 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 archiv

Re: no /tmp/mysql.sock

2005-05-06 Thread Hassan Schroeder
o run the script from the MySQL *base* install 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] Webt

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

2005-05-04 Thread Hassan Schroeder
, /usr/local/mysql/bin/mysqld_safe). Then try 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 l

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

2005-05-02 Thread Hassan Schroeder
d using a script called `mysqld_safe` 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 Sch

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

2005-05-02 Thread Hassan Schroeder
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 Desi

Re: Seeking advice on currency type

2005-04-29 Thread Hassan Schroeder
the impact of using 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-05

Re: Seeking advice on currency type

2005-04-29 Thread Hassan Schroeder
TEGER? -- 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.mysq

Re: Seeking advice on currency type

2005-04-29 Thread Hassan Schroeder
1500.99 I 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 Ma

Re: Size of BLOB types?

2005-04-16 Thread Hassan Schroeder
ave this information 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

Re: Size of BLOB types?

2005-04-16 Thread Hassan Schroeder
a TINYTEXT? :: 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/

Re: please help : linux version

2005-04-11 Thread Hassan Schroeder
what version is on the server so 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 Mailin

Re: Counting number of values in a SET column

2005-03-30 Thread Hassan Schroeder
ng I'd have my number but I don't know of anyway to that within MySQL. I believe SELECT LENGTH(REPLACE(BIN(mySetCol+0),0,'')) FROM projects will give you what you want... HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-9

Re: show all running queries on linux

2005-03-18 Thread Hassan Schroeder
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

Re: phpmyadmin can't connect via browser

2005-03-13 Thread Hassan Schroeder
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

Re: phpmyadmin can't connect via browser

2005-03-13 Thread Hassan Schroeder
ation. -- 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: phpmyadmin can't connect via browser

2005-03-13 Thread Hassan Schroeder
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: Stop the Server in Control Center not working

2005-03-13 Thread Hassan Schroeder
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: Using Different Database Groups On the Same Computer

2005-02-17 Thread Hassan Schroeder
reating two config files will make it a *lot* easier to get this going :-) FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For lis

Re: Using Different Database Groups On the Same Computer

2005-02-17 Thread Hassan Schroeder
ay /etc/alt.cnf, 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

Re: Using Different Database Groups On the Same Computer

2005-02-17 Thread Hassan Schroeder
ld, I 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... -- H

Re: New to MySQL on Linux

2005-02-11 Thread Hassan Schroeder
p of the list 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. -- M

Re: php conection problems

2005-02-11 Thread Hassan Schroeder
27;ve installed, 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 - [

Re: innodb SuSE 9.2

2005-01-30 Thread Hassan Schroeder
. :-) 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: Problem with query and password

2005-01-29 Thread Hassan Schroeder
"pass" field above is too 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.mysq

Re: SuSE 9.2 Professional, Runlevel editor via telnet & innodb

2005-01-29 Thread Hassan Schroeder
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: Date Conversion on Mysql 4.0.2

2005-01-28 Thread Hassan Schroeder
1.1." 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.m

Re: Sum on Float type

2004-12-24 Thread Hassan Schroeder
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://webtuiti

MySQL Query Browser

2004-12-08 Thread Hassan Shaikh
" Can anyone please explain? Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Upgrading bundled ver of mysql included with php 4.3.1

2004-11-29 Thread Hassan Schroeder
_4.1.7 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://lists

Re: Which MySQL software is useful for the clients?

2004-11-26 Thread Hassan Schroeder
ient -- why is this challenging? Note: if you installed 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://web

MySQL 4.1.7 on Windows ME

2004-11-23 Thread Hassan Shaikh
Hi, How do I install MySQL 4.1.7 on Windows Millenium so that it start automatically on startup? >mysqld --install ... does not work on Win9x setups. Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

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

2004-11-22 Thread Hassan Schroeder
E kinda guy :-) Have 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.

Re: Moving innodb from Linux to Windows

2004-11-12 Thread Hassan Schroeder
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 ===

Re: mysql 4.1 + debian

2004-10-31 Thread Hassan Schroeder
e. Why not just 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 unsub

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

2004-10-08 Thread Hassan Schroeder
tore" 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

Re: Adding hypertext data element into record ...

2004-09-26 Thread Hassan Schroeder
lists twelve attributes (plus [%coreattrs, %i18n, %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://we

Re: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Hassan Schroeder
and the compile install > 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 d

Re: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Hassan Schroeder
d does anything show 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

Re: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Hassan Schroeder
'marvin' are the values 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

Re: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Hassan Schroeder
he MySQL client? -- 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: bugzilla not working now after MySQL re-installed

2004-07-01 Thread Hassan Schroeder
need 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 P

Re: Import Strategies

2004-06-12 Thread Hassan Schroeder
se the tools that come 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.co

Re: New 4.1.2 Startup Trouble

2004-06-01 Thread Hassan Schroeder
t; ...about problems with 10.3.4 :-) 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/mysq

Re: Stop Scrolling

2004-06-01 Thread Hassan Schroeder
way, per: <http://dev.mysql.com/doc/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 ar

Re: FW: create database in specified character set

2004-05-25 Thread Hassan Schroeder
alhost/test?useUnicode=true&characterEncoding=UTF-8 -- 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.co

Re: create database in specified character set

2004-05-24 Thread Hassan Schroeder
e directory. The CHARACTER SET clause specifies ..." That's "4.1.1" -- time to upgrade. :-) HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. c

Re: Random Record Retrieval

2004-05-22 Thread Hassan Schroeder
mly access 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 Mailin

Re: Mac Developer Question

2004-05-22 Thread Hassan Schroeder
loaner for a project, so you probably want to confirm that with some testing. Or ask on a Mac-oriented dev list. HTH, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code.

Re: Mac Developer Question

2004-05-22 Thread Hassan Schroeder
. Note: On my Powerbook, mysql data files (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&#x

Re: HTML in MySQL Tables

2004-05-21 Thread Hassan Schroeder
t 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 dr

Re: HTML in MySQL Tables

2004-05-21 Thread Hassan Schroeder
gt; probably manipulate the "tags" 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. c

Re: BLOB's - General Guidance

2004-05-19 Thread Hassan Schroeder
file 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.mysq

Re: BLOB's - General Guidance

2004-05-19 Thread Hassan Schroeder
retrieve as SELECT img , 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

MySQL Audit Checklist/Program

2004-04-24 Thread Hassan Shaikh
Hi, Is there any recommended MySQL Auditing guideline available somewhere on the Net? (Anything other then the recommededation mention in the official documentation). If there's any IT Auditor out there who would like to share his/her work? Thanks. Hassan -- MySQL General Mailing Lis

Patches

2004-04-23 Thread Hassan Shaikh
Where can I download patches for MySQL 4.0.17 from? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

2004-03-25 Thread Hassan Schroeder
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

Re: Query across two databases on the same server

2004-03-25 Thread Hassan Schroeder
FROM db1.table, db2.table 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 Lis

Re: Newbie - Please help with createing database

2004-03-13 Thread Hassan Schroeder
ories. 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://web

Re: Newbie - Please help with createing database

2004-03-13 Thread Hassan Schroeder
code 13: Permission denied 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

Re: Uninstall MySQL for Panther?

2004-03-12 Thread Hassan Schroeder
g_permissions.html> 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

Re: Help with a query

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

Re: Concat. operator ||

2004-02-24 Thread Hassan Shaikh
SPACE,ONLY_FULL_GROUP_BY transaction-isolation=SERIALIZABLE Thanks. Hassan Paul DuBois wrote: At 12:50 -0600 2/23/04, Paul DuBois wrote: At 15:59 +0200 2/23/04, Victoria Reznichenko wrote: Hassan Shaikh <[EMAIL PROTECTED]> wrote: I am running MySQL in ANSI standard mode. However the following s

  1   2   >