Re: Case tools

zign/index.html -- <-----> Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso Application Development // Filemaker Pro / SQL Development // Sonic Solutions Creator Authoring //

Re: Keeping MySQL Databases Heathly

led >without one, it prints to STDOUT. Here's my code: Cool. I will give it whirl to see what information it reveals. -- <-> Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lass

Keeping MySQL Databases Heathly

. -- <-> Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso Application Development // Filemaker Pro / SQL Development // Sonic Solutions Creator Authoring // Apple DVD Studio Pro Authoring // Macr

help sorting by a column name

$a["name"]); } ?> I want it so it displays them like this: Processors - Reviews listed here Motherboards Reviews listed here the categories are stored under the column name "category", for reference. Thanks! -Alex "Big Al" Be

need some help...

parse error on the page for the $retval. = line Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited

output to a file

icurl"],$a["picurl"],$a["title"]) ; } ?> Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599

Re: problem with '

Thanks Peter, you gave me a lot work with I'm going to experiement with it all. Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 6

Re: problem with '

27;,'$url','$author','$email','$category','$num','$i nfo')"); Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Pho

Re: problem with '

Is it possible to have my script do this automatically if it detects a ' in the data being inserted? would you know the command to do this, I would assume it would be PHP based. -mysql Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROT

problem with '

MS-6153. Is it possible to use a different type of column so these characters are allowed? it is a for a review so I need it be all grammatically correct with the apostrophes. How do I get around this error? sql Thanks! ---- -Alex "Big Al" Behrens

Re: primary key

Sorry I meant without deleting the table or affecting any present data. is this possible? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fa

primary key

Hey Guys, Is it possible to remove a primary key from a mysql table that has already been created without whipping out the table? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)

column names

Hey Guys, What is the command to display the names of all the columns in a table? -mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fa

Re: limiting a select

Thanks guys I got it to work. Also, thanksPaul for the PHP reference as well, I'm going to tool around with both as a learning experience. Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (

limiting a select

lumn? my query is this: $r = mysql_query("SELECT * FROM hwureviews LIMIT (MAX(num)-7),7"); Does this work or am I way off? Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Pho

Re: hits

Ok thanks guys. Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: htt

Re: hits

Yeah, but thats not what I'm asking, how can I get this info from the table? Does mysql have a built-in feature that stoes the hit information and if so, how do I pull this info from the table? Thanks! ---- -Alex "Big Al" Behrens E-mail: [

hits

or, E-mail, Number, Category, Description I want to be able to track the amount of hits per category and I the same categories for displaying all reviews in the table. Does mysql integrate a function like this? Thanks! ---- -Alex "Big Al" Behrens

Re: sql where exists

ual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Alex Kita

Re: SELECT frmo two tables

mysql_fetch_array($numberquery)){ printf ("Total groundballs for $position: %s",$number["grounders"]); } Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-877

Re: SELECT frmo two tables

ySQL result resource" Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: ht

SELECT frmo two tables

quot;SELECT SUM(groundballs) AS grouders FROM stats WHERE (position = '$position') FROM rahs"); is it possible to do a WHERE command with a FROM command? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [E

Re: Unix Jobs?

try: http://www.justunixjobs.com http://www.dice.com -amen PS> If you know php, you can learn asp easy. On Fri, 22 Mar 2002, Jonathan Hilgeman wrote: > I'm currently working as a e-commerce web programmer specializing in PHP, > MySQL, and Apache systems. I've had experience on FreeBSD and L

Re: List users?

select distinct User from mysql.user where User <> '' Mike Yrabedra wrote: > How would I list all users via the command line? > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://l

Re: SubSelect Problem

Ok, no support for it (d'oh), so, how do I go about breaking it down into a join or something like that? - Original Message - From: "Alex Speed" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 12:13 AM Subject: SubSelect Probl

SubSelect Problem

thanks for any help! Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To uns

mysql.user to be used as application login password table

password table. Is it ok to use this table to control the access right of a PHP program instead of creating another one for that. Thanks for any suggestion. Alex Lui - Before posting, please check: http://www.mysql.com/manual.php

Re: Couldn╢t Performe the edit because another user changer

The record you want to update is locked by another client. Check return value of your update() What you have to do is approx. the following: while( record_locked) { sleep(...) if( update(...) == OK ) break; } Roberto Freitas Alexandre wrote: > MySQL > > Hi all, > > I am rece

[bug] MySQLGUI 1.7.5-1 crash with "year" column type

Heya, I've managed to repeatably crash mysqlgui by running a query that returns a column of type "year." Though it dumps core, gdb does not provide a useful stack trace. Though this is not a serious bug, it is a bit of an annoyance. - Alex Vandiver -- Networking -- only

Multiple charsets

I'm very much interested to know how do you manage multiple language support with mySQL. I haven't found how i can define different character sets for different tables or even for separate databases. Do i have to run several mySQL servers, one per each charset? Maybe, it is the solution for yo

Re: Help with selects

Even though I don't know how to fix my problem, I know yours is possible because its just a different form type not any different in the code I'm using. I hope this helps. Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] U

Help with selects

array($stats)): printf ("$stat: %s",$stats2["playerstat"]); endwhile; } else { I know this code is only part of it, but its the only part that needs work. I have a working model here: http://www.3d-unlimited.com/rahslax/test6.php Can someone help me get it to work? Thanks!

Reset the root Password in MySQL

Hi all, I have just installed MySQL recently. I already set the root password and some databases testing and everything worked fine. However, I accidentally changed the root to anonymous yesterday. After that, I couldn't add new users and do some administration tasks even change password myself.

Re: adding up row values....

Thanks for hte help with both the SUM and ABG mysql fuction, can you take a look at my last e-mail too and see if you can help me implement this code into my site? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-ma

Re: adding up row values....

hanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Original Mes

adding up row values....

002-03-01 | +-++--+-+-+---+- -+---++ I want to add all of the values for the groundballs, shots, and faceoffs, how do I make it add up row values? Thanks! ---- -Alex "Big Al" Beh

Re: need help debugging! (more!)

this error: Warning: printf(): too few arguments how do I fix this? I checked the number of "%s" and the number of $num arguments and they shuld match. what am I doing wrong? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Ur

Re: need help debugging!

what do you mean by checking each query manually? how do I do this? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 IC

Re: need help debugging!

how do I fix it so mysql doesn't returns a 0? is my syntax wrong somewhere? Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 6

need help debugging!

ot;groundballs"],$num["shots"],$num ["faceoffs_won"],$num["faceoffs_lost"],$num["date"]); } ?> it says this error: Warning: Supplied argument is not a valid MySQL result resource on line 17 line 17 would be this line: while($num=mysql_fetch_array($se

Re: using a datetime def in a column...

I forgot that mysql reverses the month and day so I was trying to input yesterdays date (02-28-2002) so it gave me hte default zero value since 28 isn't a valid month number! oops thanks guys. Thanks! ---- -Alex "Big Al" Behrens E-mail: [

using a datetime def in a column...

what is the proper way to insert data into a row like this so it will show up with the date that I want it to show up as? what is the proper input for MYSQL to use this type of column? Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgen

Re: dumb (re)newbie question...

Awesome thanks, I thought it was under the INSERT command at first, but I guess its the ALTER command, thanks bro! I'll check out the online manual some more! Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [

dumb (re)newbie question...

her a whole new row (or maybe column) or the table. like if you have 7 values for the table, I want to be able to add an 8th value. Please advise... Thanks! ---- -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (

Re: WIN/Linux Compatibility

> > I don't believe this is possible, but I couldn't find any posts and wanted > > to confirm. I realize that we may need to import through an SQL query. > > I believe itis, you can just copy the files over. > > Thanks for the tips! I will let the list know

Fw: WIN/Linux Compatibility

to confirm. I realize that we may need to import through an SQL query. Thanks in advance. Alex Charlton [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Re: Distributed Fulltext?

Wednesday, from David Axmark: > > Your other point about exact vs. approximate answers is unclear, I expect > > that Google's answers are exact for their currently available indexes at any > > given time. But even if they are approximate, I'd be happy with that too. > > The scoring on a FULLTEXT

Re: Distributed Fulltext?

Wednesday, from Mike Wexler: > I don't think that would be appropriate. My example, is our site (tias.com) has > lots of antiques and collectibles. One popular categories is jewelry. If > somebody does a search for "gold jewelry" and the search engine interprets this > as anything that mentions go

Re: Distributed Fulltext?

Hi, I also will explain how we made FTS "fast". (sorry for my bad english) First some DATA: The table which has to be indexed has ~60 entries. There are articles inside it, which are in average 3-4 kb each (which says nothing!) with about 300 words each (this number is very important!). Thi

RE: long query on php

Yesterday, from savaidis: > The obious question is: (before I test it) > This is concatenation to $query that is a string type, no? Yea. The following works either: mysql_query("create bla". "bla". "bla bla blabla ". "bla" ."bla" ); > So the limit isn't

Re: FULL-TEXT Index / Searching Question (fwd)

Tuesday, from Matt Rudderham: > Hello, I have two tables in my database as such: > > CREATE TABLE `skill_names` ( > `id` bigint(20) NOT NULL auto_increment, > `name` varchar(30) NOT NULL default '', > PRIMARY KEY (`id`) > ); > > CREATE TABLE `skills` ( > `skills_id` int(11) NOT NULL aut

Re: Distributed Fulltext?

Yesterday, from Brian DeFeyter: > Has anyone made a suggestion or thought about ways to distribute > databases which focus on fulltext indexes? > > fulltext indexes do a good job of indexing a moderate amount of data, > but when you get a lot of data to be indexed, the queries slow down > signifi

Re: long query on php

Yesterday, from Nathan: > Since PHP ignores whitespace, I think this is also acceptable: PHP doesn't ignore whitespace in a quote. But your code is of course correct. > $query = "CREATE TABLE query > tabledef for col a, > tabledef for col b, > lots more table defs, > . > welcome t

Re: Distributed Fulltext?

Yesterday, from Brian DeFeyter: > Has anyone made a suggestion or thought about ways to distribute > databases which focus on fulltext indexes? > > fulltext indexes do a good job of indexing a moderate amount of data, > but when you get a lot of data to be indexed, the queries slow down > signifi

Re: FULL-TEXT Index / Searching Question (fwd)

Tuesday, from Matt Rudderham: > Hello, I have two tables in my database as such: > > CREATE TABLE `skill_names` ( > `id` bigint(20) NOT NULL auto_increment, > `name` varchar(30) NOT NULL default '', > PRIMARY KEY (`id`) > ); > > CREATE TABLE `skills` ( > `skills_id` int(11) NOT NULL aut

Re: long query on php

Yesterday, from Nathan: > Since PHP ignores whitespace, I think this is also acceptable: PHP doesn't ignore whitespace in a quote. But your code is of course correct. > $query = "CREATE TABLE query > tabledef for col a, > tabledef for col b, > lots more table defs, > . > welcome t

RE: long query on php

Yesterday, from savaidis: > The obious question is: (before I test it) > This is concatenation to $query that is a string type, no? Yea. The following works either: mysql_query("create bla". "bla". "bla bla blabla ". "bla" ."bla" ); > So the limit isn't

Re: Fulltext problems 4.0.1 part two (fwd)

I found out, that the fulltext engine is misbehaving with less than 5 entries. Seems to me, that this is exactly the same case... Perhaps a flush inside the engine or so isn't made with such less entries? The bug is also in 3.23 gamma. Workaround: Enter more rows to fix it. :) I send this bug

Attention ! Ce Email est une bombe !!!

envoyer à qui vous voulez par simple Email. C’est ça Internet ! Bref, une vrai ressource pour s’éclater entre potes et bien se marrer. Aurez-vous le courage de cliquer ici ? http://www.sexportail.com/ 100% des gagnants ont essayé... Alex. Un ami qui vous veut vraiment du bien

How to check disk space used for a mysql account

How to check disk space been used for all of the tables of a specific mysql account? Thanks in advance for all answer! Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

job application

Yours, Alex Duras. RESUME Alex Duras 7A Grygorenko St., apt.83 02068 Kyiv, Ukraine phone: +380 44 572 4082 email: [EMAIL PROTECTED] Objective

job application

Yours, Alex Duras. RESUME Alex Duras 7A Grygorenko St., apt.83 02068 Kyiv, Ukraine phone: +380 44 572 4082 email: [EMAIL PROTECTED] Objective

Date Field + Time Field = Datetime Field?

ng? I'd really appreciate any hints you could give. FYI, I'm running MySQL 3.23.37. Thanks, Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

How Query and Fetch work?

nding, mysql_query() will definately to its job with MySQL server. But how about the latter? Does it just fetch data from client/local buffer, which is previously put in by mysql_query(), or still has to goto server side to fetch data?

Re: [SLE] Kylix frustrated me...!!!

ing just a plain vi editor you can write just any kind of code in Perl, C/C++, Java e.t.c. If you addicted to graphical environments you can use free Quanta+ editor and others. Just a suggestion, please don't take me wrong. Alex --- > Dear Friends, > > I am trying t

Query Behaviour

e traffic I also posted this message to PHP list. I am not sure if it is a MySQL question. Thanks for all reply in advance! Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lis

Re: Time Weirdness

I was using float...but even when I changed it to time, MySQL still gave me odd values on those rows. What type should I use? Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual

Time Weirdness

start & finish. Is this a bug in MySQL 3.23.37? Could it have something to do with my OS (OpenBSD 2.9)? Or am I doing something wrong with the statement "update time_worked set total = start - finish;"? Thanks, Alex Kirk --

Re: Time Difference Function

urs worked on a particular project, where I'm entering in start and end times; if there's a function like period_diff for time, that'd be perfect. Thanks in advance for your help. Alex Kirk - Before

Backup and Restore

restored back to the table. I just want to know if there is any built-in functionality in MySQL to do this. Yes I know with combination of normal sql statements this job can be done but I still like to know if we can make things simple. Alex

Search & Replace

What is the best way to do a search & replace on a MySQL database? I just want to wipe a particular character from each field it occurs in; the REPLACE command, at least in the documentation on www.mysql.com, doesn't appear to be the best bet for doing this. Thanks,

Selecting unknown columns

them. How would I go about selecting out these fields? Even if I can only get those with one answer, I'd be immensley appreciative. Thanks, Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php

Re: MySQL on Win2000

Okay, I will try MySQL GUI later BTW, do I have to use ODBC if I use PHP? I'm told PHP has its own very API for MySQL... Alex - Original Message - From: "Miguel Angel Solórzano" <[EMAIL PROTECTED]> To: "Alex Shi" <[EMAIL PROTECTED]>; <[EMAIL

MySQL on Win2000

on Windows, please help me out if anyone is familiar with this issue. Thanks in advance! Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Why MySQL GUI download don't work?

I tried to download MySQL GUI from these links: http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip and http://www.mysql.com/Downloads/mysqlgui/mysqlgui-linux-static-1.7.5-1.tar.gz But all these don't work. Alex - Original Message - From: "Matthew Darc

MySQL can not tell differences among some of the Chinese characters

hpmyadmin, terminal and php script, and got same result. Please, if anyone here happen to know this issue, help me out. Thanks in advance! Regards, Alex Shi - Before posting, please check: http://www.mysql.com/manua

Re: queries on particular table produce errors

On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote: > At 15:55 -0700 2001/12/05, Alex Pukinskis wrote: >>> group is a reserved word, use groups as table name >> >> That being the case, how do I drop or rename a table called "group"? >

Re: queries on particular table produce errors

On Wednesday, December 5, 2001, at 03:44 PM, Philippe Parmentier wrote: > group is a reserved word, use groups as table name That being the case, how do I drop or rename a table called "group"? -Alex -- Alex Pukinskis Internet Consultant aboutChange http://aboutch

queries on particular table produce errors

| 0 | | | name | varchar(30) | YES | | NULL| | +---+-+--+-+-+---+ 2 rows in set (0.01 sec) I'm using mysql-3.23.32 on Mac OS X Server 10.1.1. Thoughts? -Alex -- Alex Pukinskis Internet Consultant aboutChange http://ab

RE: Question on auto_increment

If the colum is set to unique, it will fill in 2. If not, it'll automatically goto 4 (or vice versa if I'm mistaken). > -Original Message- > From: Jack [mailto:[EMAIL PROTECTED]] > Sent: November 23, 2001 7:46 AM > To: Mysql List > Subject: Question on auto_increment > > > I knew that if

Re: users@localhost problems

how up with equivalent resutls. Hmmm...that seems OK to me...but then again, I can't really say much, since I don't really know. Any further tests I should run? Thanks, Alex Kirk - Before posting, please check:

users@localhost problems

; in mysql, they show up, with the appropriate values in the host and user columns. When I attempt to grant priviliges to them, though, I get this error: mysql> grant all on testdb.* to alex@localhost; ERROR 1133: Can't find any matching row in the user table Like I said, though, I *know*

Can't connect via IP, but can via hostname

Dear Sirs, My MySQL is not configured properly... I can connect using localhost with -h flag , but when I'm using IP instead of hostname it doesn't connects at all... What'd I do? Thank you. - Before posting, please check:

multiple cpus

Hello, Will a single instance of MySQL use multiple CPU's? I didn't see anything about it in the docs... Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

127.0.0.1 problem

Hello, Are there any obvious reasons why mysql -h localhost works and mysql -h 127.0.0.1 does not. It says : ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (110) /etc/hosts contain : 127.0.0.1 localhost as a first line. -- Best regards, Alex

Addendum: DBI Handle Has No Magic

about the wrong version when I first tried this). Is there any way I can just delete everything associated with DBI and start fresh? I really need to get Perl to interface with MySQL. Alex Kirk - Before posting, please check

DBI Handle Has No Magic

d DBI 1.15; ran 'make uninstall', and then installed DBI 1.20 * OpenBSD 2.9 Any ideas what I might to do correct this? Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the

Selling MySQL to Government

). Since I'm sure this sort of thing has come up before, I'm wondering if you can point me to any good resources, particularly as they might relate to the US Gov't, banks, or direct mailing agencies. Thanks in advance for any help you can provide. Alex Kirk -

Re: DBI Background (fork) CGI causes Error 2013

ect for DBD::mysql::db (DBI::db=HASH(0x103ac834)~0x103ac8a0) imp_dbh->svsock: 103a0868 On Fri, 5 Oct 2001, Jani Tolonen wrote: > Alex Menendez writes: > > Hello, All > > Hi Alex, > > > I built a spammer cgi some time ago that sends opt-in email to a list > &

Re: DBI Background (fork) CGI causes Error 2013

To this matter even if the actual insert text for this message is under 16M? I actually did increase it to 10M but according to your suggestion...this is not enough. thanx again, -amen On Fri, 5 Oct 2001, Jani Tolonen wrote: > Alex Menendez writes: > > Hello, All > > Hi

Help!

> My big problem is the rollback, every time when I try to use a rollback > command I get this error: > ERROR 1196: warning: some non-transaction changed tables couldn´t be rolled > back > > Do you know why ? > > thanks for help -

DBI Background (fork) CGI causes Error 2013

Hello, All I built a spammer cgi some time ago that sends opt-in email to a list of recipients stored in a member account db. It has ran fine in the past. However, recently it is generating 2013 errors (Lost connection to Mysql server during query) . The script works by accepting news letter qu

strange replication problems

>Description: Hi, I have 28 linux boxes configured identically, 27 as slaves, one as master. On all 27 slaves, everything works fine, but only on one I have strange errors in the logs: 011002 17:49:49 Slave: received 0 length packet from server, apparent master shutdown: (0) 011002 1

Q: problem with MySQL syntax in Apple WebObjects

s not understand it. It needs a space between the table and fields. This command will work INSERT INTO test (ID, abc, def, ghi) VALUES (129, '', 'test', 'test') Is this MySQL or WO's problem? Best, Alex --

Error 1045

10, connection UNIX Socket running on RH Linux 7.0. The regular SELECT, UPDATE etc. are running correctly, only the dump does not. Can you help me with this, or where I should dig into documentation? Thanks a lot! Alex Sofronie [EMAIL PROTECTED]

Re: shadow tables?

ed this, and it didn't solve the problem. I also tried creating a new database (with a different name) and new tables by hand. The new database has the same problems. -Alex -- Alex Pukinskis Web and Internet Consultant Satori Design and Development http://satoridesign.

shadow tables?

to actually remove them from the mysql database. Is there another command that completely removes databases? Thanks, -Alex -- Alex Pukinskis Web and Internet Consultant Satori Design and Development http://satoridesign.com [EMAIL PROTECTED] Release: mysql-3.23.39 (Source distribution) Syste

ColdFusion, talking to a mySQL database, on Solaris 7

e entries are passing the same user/pass now, but still, can't access the DB through CF. Suggestions anyone? -ALEX Web Designer, LibertyLiveWire 323-603-2118 [EMAIL PROTECTED] - Before posting, please check: http://www.mysq

even weirder case issues

mysql> SELECT * FROM Employee -> \g ++---++--+-+--+- -+---+ | ID | FirstName | LastName | Email| WorkgroupID | SSN4 | age | Ethnicity | ++---++--+-----+--+- -+---+ | 1 | Alex | Pukinskis | [EMAIL PROTECTED] |

Error with mysql_install_db

error # more solaris7web1.err 010816 13:42:03 mysqld started ld.so.1: /usr/mysql/libexec/mysqld: fatal: libz.so: open failed: No such file or directory 010816 13:42:03 mysqld ended Suggestions? -ALEX Web Designer, LibertyLiveWire 323-603-2118 [EMAIL PROT

<    1   2   3   4   5   >