PHP MYSQL Admin question

2009-07-23 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Trying the latest phpMYAdmin on Mac OS X. Everything is set up correct but I get #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) And I am telling config.php where the mysql.sock file is located. Help. -- MySQL General Mailing List For l

JOomla Administrator

2009-07-20 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Hello, we are trying to move a Joomla Site and the administrator does nowrk. Using MySQL 5.1.36 on MAC OS X Server. How can I fix this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL Community Server 5.1.35 has been released

2009-06-06 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-35.html > > Enjoy! > > Timothy Smith > The MySQL build team at Sun Microsystems > > === > > This release of MySQL has two known outstanding issues for > Windows: > > *

Re: Upgrade Mysql

2009-05-20 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
On Wed, May 20, 2009 at 10:27:51AM +0200, Webmaster Studio Informatica wrote: > Hi, > > > > I need to upgrade Mysql 4 to Mysql 5 on Linux. > > > > I will uninstall version 4 and install version 5. > > > > > > With uninstallation usually database files remain in /var/lib/mysql/ > >

Problem compiling mysql-5.1.33

2009-04-04 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
make all-am Making all in mysql-test Making all in lib/My/SafeProcess g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -MT safe_process.o -MD -MP -MF .deps/safe_process.Tpo -c -o safe_process.o safe_process.cc In file included from safe_

BSD/OS and 5.1

2009-03-10 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
or 2 cd mysql-test ; \ /usr/bin/perl ./mysql-test-run.pl --mysqld=--binlog-format=mixed Logging: ./mysql-test-run.pl --mysqld=--binlog-format=mixed 090310 10:53:13 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 090310 10:53:13

Conficker

2009-02-17 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Does anyone know if Conficker is suppose to affect MySQL? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysq

Odd error

2008-05-20 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Customer has tested his site in Mysql 5.1 and we are running Mysql 4.1 . His test works but over here we get: Warning: DOMDocument::__construct() [function.DOMDocument---construct]: Malloc(88) in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 5 Warning: DOMDocument::__construct

Maximizing number of connections per client session

2007-06-11 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
REcently my mysql server has been overload with a lot of connections; in fact losing the mysql.user table and one whole database. How can this be prevented? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailin

Re: Suddenly : mysqld: Can't create/write to file PID

2007-04-18 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
On Wed, Apr 18, 2007 at 12:42:56PM -0500, Gerald L. Clark wrote: > Dave Shariff Yadallee - System Administrator a.k.a. The Root of the > Problem wrote: > >I am suddenly seeing this in my error log: > > > >070418 08:43:57 mysqld started > >070418 8:43:57 [ERRO

Suddenly : mysqld: Can't create/write to file PID

2007-04-18 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
I am suddenly seeing this in my error log: 070418 08:43:57 mysqld started 070418 8:43:57 [ERROR] /usr/contrib/libexec/mysqld: Can't create/write to file '/usr/contrib/var/doctor.nl2k.ab.ca.pid' (Errcode: 13) 070418 8:43:57 [ERROR] Can't start server: can't create PID file: Undefined error: 0 0

Re: Upgrade issue

2006-10-23 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
On Mon, Oct 23, 2006 at 01:49:14PM +0100, Ben Clewett wrote: > MySQL, > > I am trying to upgrade from 4.1 to 5.1. > > Your manual states I should run mysql_upgrade. > > But there is no such program in our pre-compiled binary, only a man page! > > $ find . -name "mysql_upgrade*" > ./mysql-5.1.11

Re: Drupal and MySQL

2006-08-30 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
On Thu, Aug 31, 2006 at 09:52:37AM +1000, Colin Charles wrote: > Dave Shariff Yadallee - System Administrator a.k.a. The Root of the > Problem wrote: > >Has anyone heard of drupal breaking under a minor upgrade from > >Mysql 4.1.1X to 4.1.2X ? > MySQL 4.1.18 to 4.1.21 &g

Drupal and MySQL

2006-08-30 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Has anyone heard of drupal breaking under a minor upgrade from Mysql 4.1.1X to 4.1.2X ? I have a weird one. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Compiling MySQL to work with OpenSSL

2006-08-27 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Question, I specify with openssl is with --wth-openssl=/usr/contrib and the config script chokes. What is this happening? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://li

Re: Chemistry search

2006-08-24 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
On Thu, Aug 24, 2006 at 12:43:56AM -0400, Rhino wrote: > > - Original Message - > From: "Dave Shariff Yadallee - System Administrator a.k.a. The Root of the > Problem" <[EMAIL PROTECTED]> > To: > Sent: Wednesday, August 23, 2006 10:15 PM > Subject:

Chemistry search

2006-08-23 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Has anyone come up with searching a chemicals based database using mols or smilies? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

Re: Search Engine type search

2006-08-22 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
On Tue, Aug 22, 2006 at 10:42:52AM +, Neil Tompkins wrote: > On my website I'm looking to add a search box. > > I have a number of different database fields. Does anyone have any > recommendations about how I can perform a search engine type search including > the text fields. > Have you

Re: non-text data

2006-08-14 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
On Mon, Aug 14, 2006 at 02:29:41PM +1000, Chris wrote: > Dave Shariff Yadallee - System Administrator a.k.a. The Root of the > Problem wrote: > >On Mon, Aug 14, 2006 at 10:42:50AM +1000, Chris wrote: > >>Dave Shariff Yadallee - System Administrator a.k.a. The Root of t

Re: non-text data

2006-08-13 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
On Mon, Aug 14, 2006 at 10:42:50AM +1000, Chris wrote: > Dave Shariff Yadallee - System Administrator a.k.a. The Root of the > Problem wrote: > >I use SELECT all from * ... and one row is a gif. > > > >How do I get that gif to appear as a gif and not text? > >

non-text data

2006-08-12 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
I use SELECT all from * ... and one row is a gif. How do I get that gif to appear as a gif and not text? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

mysql@lists.mysql.com

2006-06-05 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2006-01-25 Thread root
alias -ansi_args -fast -inline speed -speculate all' CXX='cxx' CXXFLAGS='-O2 -pthread -ansi_alias -fast -inline speed -noexceptions -nortti' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Jul 2 2004 /lib/libc.a -> ../ccs/lib/libc.

Err NO. 152 need help

2005-06-30 Thread root
Hi List , what does error no 152 mean , could not find anything useful from the manual , was trying to drop a foreign key from an innodb table which has its corresponding P Key in another table. Table T_Dropdown (Foreign Key ) references Table T_Questionnaire ( T_QID ) > mysql >alter table T_Dr

Openssl 0.9.8 and Mysql

2005-06-12 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
Will MySQL 4.0 + bt OpenSSL 0.9.8 compliant? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: No Longer Receiving Emails

2005-05-27 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
On Fri, May 27, 2005 at 08:48:38PM +0200, Rob Cochrane wrote: > Works > > Rob > > > Tucker, Gabriel wrote: > > >Hi > > > >I have not received anything from this list for a couple of days. I just > >tried to "re-register", and that did not help. > > > >If anyone reads this, please reply to ME

1 table or 2?

2005-05-10 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
I am trying to set up a chem structures table. column 1 is the key, column 2 is the description, column 3 is the structure which is a blob. In PHP the first 2 columns comes out as text as expected, but the 3rd I am trying to tell PHP please ignore this initially since this is a blob. Should I be

PArtial help needed

2005-05-08 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
I was able to set up a table no problem. On one of the blobs, it is coming up on the web page like a mess and not like an interpreted object as one would expect. Using Mysql 3.23.58 with php 4.3.9 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

Setting up a Chemical database

2005-04-04 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
I have a customer who has sent my close to 300 chemical products in word format? How do I translate this into mysql tables? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Character set information not found

2005-03-30 Thread root
rting >How-To-Repeat: Any time I try to start mysql >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none] >Synopsis: english character set not found on startup >Severity: >Priority: >Category: mysql &g

mysql

2004-11-09 Thread m-root
MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql_fix_privilege_tables again

2004-10-03 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
On Sat, Oct 02, 2004 at 08:25:49PM -0500, Paul DuBois wrote: > At 16:31 -0600 10/2/04, "Dave Shariff Yadallee - System > Administrator a.k.a. The Root wrote: > >New error WITH password implemented: > > Apparently the ownership of the mysql database and/or the files in &g

mysql_fix_privilege_tables again

2004-10-02 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
the more secure passwords in 3.23 If you get 'Access denied' errors, you should run this script again and give the MySQL root user password as an argument! Converting all privilege tables to MyISAM format ERROR 1036 at line 1: Table 'user' is read only ERROR 1036 at line 2: Tab

Problem with mysql_fix_privelege_tables

2004-10-02 Thread Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
I am trying to convert from 3.23 to 4.0 This is what I am getting with or with root: Script started on Sat Oct 2 16:11:30 2004 doctor.nl2k.ab.ca//usr/contrib/var$ man su SU(1)BSD Reference Manual SU(1) NAME su

mysql 4.1.4i gamma C api free_root() bug

2004-09-08 Thread root
C api mysql 4.1.4 ,select many select error! free_root fail. >Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >S

mysql@lists.mysql.com

2004-03-14 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

Can't seem to get to run properly - Checked by Vexira -

2004-03-04 Thread root
>Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.54 (Source distrib

Re: web hosting quesiong (slightly off topic)

2004-01-07 Thread System Administrator a.k.a. The Root of the Problem
On Wed, Jan 07, 2004 at 08:09:50AM -0600, Chris W wrote: > I was wondering if anyone could recommend a good web hosting company for > an Apache - php - MySQL project. I don't need much bandwidth or disk > space to start out, but may need more if the site gets big. I would > also like to have s

Crashes / Overloads on OpenBSD 3.3 / 3.4

2003-12-11 Thread root
20010125 (prerelease, propolice) Compilation info: CC='gcc' CFLAGS='-Wbounded' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: -r--r--r-- 1 root bin 1223580 Dec 6 15:08 /usr/lib/libc.a -r--r--r-- 1 root bin 656756 Dec 6 15

[jstarnaud@zenderford.com: sql error]

2003-08-26 Thread System Administrator a.k.a. The Root of the Problem
What should I do to correct his? Looks like a slippage in MySQl. Using phpMyAdmin to correct this error. - Forwarded message from - Hi Dave, we get an error when we try to post or reply to any post on our forums,,www.gamershaven.ca/Forums mySQL query error: INSERT INTO ib

Restricting user access to databases

2003-08-25 Thread System Administrator a.k.a. The Root of the Problem
Just wondering, how do I limit a user to one database but let the administrator have universal access? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL unsuccesfully installed. Need help!

2003-07-11 Thread root
hi there, I've tried to install mysql-3.23.55.tar.gz but failed. Firstly, I've created directory /home/users/mysql and add group for mysql. Those are the command that I've used previously: shell>groupadd mtsqlid shell>mkdir /home/users shell>useradd -d /home/users/mysql -s /bin/false -g mysqlid m

Need help with an update

2003-06-11 Thread System Administrator a.k.a. The Root of the Problem
Here is the scenario. I was running 3.23.39 that came with BSD/OS 4.3 , All the databases were running active. I upgraded to BSD/OS 5.0 which has Mysql 3.23.49 and suddenly NO databases are seen. Everything is where is is supposed to be, but the mysqld is not seeing the DBs that were running w

FRom MYsql 3.23.39 to mysql 3.23.49

2003-06-10 Thread System Administrator a.k.a. The Root of the Problem
I installed from the BSDOS distribution. However, with the upgrade, nysql may not be seeing the Databases. Why? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Recent crash with 3.23.56

2003-03-17 Thread root
82ec0 = SELECT challenge FROM ladder_rules WHERE ladder='dartpros' thd->thread_id=1915 I should note that ladder_rules is actually a symlinked file to another file on an NFS share. We do this on all machines that are "read-only" queries for that table. >Fix:

mysql@lists.mysql.com

2003-03-17 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2003-03-12 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2003-03-09 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

Install issue

2003-03-07 Thread root
>Description: Message indicates to use /usr/bin/mysqladmin to set root password at end of installation, but this is not included in the distribution >How-To-Repeat: RedHat 8.0 - rpm --install -p MySQL-3.23.55-1.i386.rpm >Fix: >Submitter-Id:

make test fails - strack trace included

2003-03-04 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: make test fails - strack trace included >Severity:

invalid aggregate function value for 0 row results (from a full join)

2003-03-03 Thread root
='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 May 20 2002 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x1 root root 1285788 Apr 2 2002 /lib/libc-2.2.4.so -rw-r--r--1 root root 27332668 Apr

update/delete bug, please fix, thank you!

2003-03-01 Thread root
>Description: Dear sir, When I execute the command "select * from user_info where regdate < now()- interval 9 day and phone_confirmed is null and email is null and last_onlineHow-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organiz

mysql@lists.mysql.com

2003-02-23 Thread root
from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='i386-slackware-linux-gcc' CFLAGS='-O3 -march=i486 -mcpu=i686' CXX='gcc' CXXFLAGS='-O3 -march=i486 -mcpu=i686 -felide-constructors -fno-exceptions -f

mysql@lists.mysql.com

2003-02-05 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2003-02-03 Thread root
rame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 13 06:54 /lib/libc.so.6 -> libc-2.2.5.so -rwxr-xr-x1 root root 1260480 Oct 10 17:16 /lib/libc-2.2.5.

Error inserting data in MySQL 4.1

2003-01-31 Thread root
0 | 0 | phpss | Successful |user login | | 3 | 2003-01-31 12:07:51 | 0 | 0 | 0 | phpss | Successful |user login | ++-+++---++---+ 3 rows in set (0.00 sec) Timothy M. Crider >How-To-Re

mysql@lists.mysql.com

2003-01-19 Thread root
>Description: I can connect on my database at localhost, but not at real hostname. Example when i want to change the password : darkvador:/usr/bin# /usr/bin/mysqladmin -u root -h darkvador password 'newpassword' /usr/bin/mysqladmin: connect to server at 'darkvador' faile

mysqldb is hanging.

2003-01-15 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: <2013 Error - DB Hanging during a Query (one line)&

mysql@lists.mysql.com

2003-01-11 Thread root
c64-linux --enable-languages=c,c++,f77 --enable-__cxa_atexit --disable-nls --prefix=/opt/ppc64 Thread model: posix gcc version 3.2.1 Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrw

mysql@lists.mysql.com

2003-01-02 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2003-01-01 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

I execute safe_mysqld and it deads

2002-12-29 Thread root
itter-Id: [EMAIL PROTECTED] >Originator:root >Organization: >MySQL support: none >Synopsis: >Severity: serious >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.54-max (Official MySQL-max binary) >Environment: Sys

Bad system call received during mysql_install_db

2002-12-05 Thread root
.1 19990816 (release) Compilation info: CC='cc -pthread' CFLAGS='-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all' CXX='cxx -pthread' CXXFLAGS='-O4 -ansi_alias -fast -inline speed -speculate all -noexceptions -nortti' LDFLAGS='' L

mysql@lists.mysql.com

2002-12-03 Thread Charlie Root
src/sys/compile/RADSTATS i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.4 20020320 [FreeBSD] Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='cc' CXXFLAGS='-O -pipe

mysql@lists.mysql.com

2002-11-25 Thread root
from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 sie 21 23:34 /lib/libc.so.6 -> li

Errors

2002-11-20 Thread Charlie Root
Hi Support Team, I'm quite a novice in installing Mysql. I needed to do this because of a task i had to accomplish by installing webtts for which mysql was a pre-requisite. during the installation process of webtts, i had the following errors "install_driver(mysql) failed: Can't load '/usr/local/l

Newbie Replication Issues

2002-11-18 Thread Rick Root
I have a few questions about Replication. I've already read the basic replication page here: http://www.mysql.com/doc/en/Replication_HOWTO.html I am running MySQL-MAX 3.23.53 for Linux on my master server, and the same version on Windows 2000 for the slave. #1 - Can I replicate from Linux to

[it's only a test]

2002-11-15 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

The mysql.db table

2002-11-14 Thread Rick Root
he proper way to REMOVE a user from the system to delete them from the mysql.user table? Ie, "delete from user where user='foo'"? Thanks! Rick Root - Before posting, please check: http://www.mysql.com/manua

MySQL and Open Directory RDF Data (UTF-8)

2002-11-14 Thread Rick Root
Has anyone here tried to put Open Directory RDF data (ie, www.dmoz.org) into MySQL? I've done this fairly successfully with the exception of the non-English characters (primarily the stuff in the "World" category). The data is in UTF-8 which is a character set that MySQL doesn't seem to suppo

Upgrading MySQL from 3.23.41 to 3.23.53a

2002-11-13 Thread Rick Root
? I tried using the RPM facility to install and upgrade the new packages I just downloaded but I get conflicts... ie... [root@frodo MySQL]# rpm --install MySQL-3.23.53a-1.i386.rpm error: failed dependencies: MySQL conflicts with mysql-3.23.41-1 MySQL-server conflicts with mysql

Moving a MySQL database

2002-11-13 Thread Rick Root
I need to move a whole bunch of web sites from one server to another. This means moving cold fusion, MySQL, qmail, etc.. fun stuff. What's the best way to move *ALL* of the MySQL databases on my system? Do I basically just shut down the database, tar up the /var/lib/mysql directory and move it t

Re: [reidbryn@doctor.nl2k.ab.ca: Re: help]

2002-11-09 Thread System Administrator a.k.a. The Root of the Problem
st I do to correct his?? On Sat, Nov 09, 2002 at 08:04:45AM -0700, System Administrator a.k.a. The Root of the Problem wrote: > Looks as if security got tightened and now next to no databases with > Web/php are geting accessed. What needs to be fixed? > > Customers are yelling. &g

[reidbryn@doctor.nl2k.ab.ca: Re: help]

2002-11-09 Thread System Administrator a.k.a. The Root of the Problem
Looks as if security got tightened and now next to no databases with Web/php are geting accessed. What needs to be fixed? Customers are yelling. Rectification needed ASAP! forwarded message -- Hi , I corrected the core mysql tables (there was nothing in them) Your root password for

[Installed 4.0.3 but startup caused a minor error]

2002-11-03 Thread root
nor misconfiguration in your distribution. Thanks and have a good day-- and appreciate all your excellent programming efforts!! John Whitten [EMAIL PROTECTED] >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: Wizard.Org >MySQL support: [n

mysql@lists.mysql.com

2002-10-22 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2002-10-18 Thread root
>Description: MySQL segfaults after recieving TCP/IP connections. Connections to the local socket work great. >How-To-Repeat: Connect via TCP/IP >Fix: Unknown >Submitter-Id: >Originator:root >Organization: Critical Distinction, Inc. >MySQL support: [none | li

MySQL-3.23.53 and Redhat-7.3

2002-10-14 Thread root
d >How-To-Repeat: RedHat-7.3 and MySQL-3.23.53 >Fix: >Submitter-Id: >Originator:root >Organization: CVO Group Ltd. >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: critical >Priority:

mysql@lists.mysql.com

2002-10-07 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

RE: .Optimize mySQL memory usage ? 41MB threads ??

2002-10-07 Thread root
On Mon, 7 Oct 2002, Jon Shoberg wrote: > Ok, > > So how do I optimize memory usage? Where to start ? > > -Jon > > -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 07, 2002 9:16 PM > To: Jon Shoberg > Cc: [EMAIL PROTECTED] > Subject: Re: .

mysql instla

2002-09-27 Thread root
I tried to start it with safe-mysqld --u=mysql &when I ran the mysqltest I get cannot connect to local mysql server through socket '/var/lib/mysql/mysql.sock'>  Any idea ... - Before posting, please check: http

MySQL supports no ¤ (Euro currency) char?

2002-09-21 Thread root
>Description: While trying to login to the MySQL database (as root), I failed for no apparent reason. I believe this migth be because my password includes the ¤ (Euro / European currency) char. It works _perfectly_ if I remove that one char or replace it with anot

mysql@lists.mysql.com

2002-08-27 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2002-08-21 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2002-08-16 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

database create fails with error 28

2002-08-08 Thread root
cal/mysql/var to recommended values shell> safe_mysqld --user=mysql shell> mysqladmin -u root password 'mypassword' shell> mysqladmin -p create SomeDatabase ** failed: errno=28 What the hell is error 28? Where can I find description? mysqlcheck --all-databases # says everything is ok

Repetitive link error when making

2002-08-03 Thread root
ada --enable-long-long --enable-multilib --with-gnu-as --with-gnu-ld --with-system-zlib --with-slibdir=/lib --without-x i686-pld-linux Thread model: posix gcc version 3.1 20020408 (prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFL

mysql@lists.mysql.com

2002-07-22 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2002-07-17 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

Permissions problems

2002-07-16 Thread System Administrator a.k.a. The Root of the Problem
USually all the databases sets up fine BUT recently, I have had to adjust databases to 0777 in order to get them to work and change the ownership. I prefer the more secure model of mysql. How can I fix this? -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED]

Stored Procedures

2002-07-15 Thread root
dear all, Does Mysql support stored procedures ? best regards Menrit - Before posti

mysql@lists.mysql.com

2002-07-12 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2002-07-12 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2002-06-27 Thread root
sr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Á.¤. 7 18:50 /lib/libc.so.6 -> lib

mysql 3.23.49 crashing with netbsd 1-6BETA1

2002-06-27 Thread root
: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.49 (Source distribution) >Environment: System: NetBSD pauk 1.6_BETA1 NetBSD 1.6_BETA1 (pauk.4sc

Full-text Search phrases in boolean mode

2002-06-25 Thread root
GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux-gnu/2.96/specs gcc version 2.96 2731 (Mandrake Linux 8.1 2.96-0.62mdk) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root

mysql@lists.mysql.com

2002-06-15 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2002-06-11 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

mysql@lists.mysql.com

2002-06-11 Thread root
from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-O3 -march=i486' CXX='gcc' CXXFLAGS='-O3 -march=i486 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: l

Re: Apache 2.0

2002-06-09 Thread System Administrator a.k.a. The Root of the Problem
On Sun, Jun 09, 2002 at 11:55:29AM -0400, Jeff Whitman wrote: > Dear Sir or Ms. > > Is there a stable version of MySQL that runs on Apache 2.0? > > Thanks for your time. > Question is is httpd-2.0.X stable?? > > Jeff Whitman > Managing Member > JW NetSource, LLC > >

  1   2   3   >