Speeding up Queries

2003-08-01 Thread Daniel Negron/KBE
I have an osCommerce Site along with another Dating site on a completely different server. on the oscommerce site I have 1200 products and the server queries the records very slowwly. I have enabled gzip compression to try and speed this up. Only very slightly has the oscommerce site been sped

Problem Editing mysql Text field

2003-02-13 Thread Daniel Negron/KBE
Hi all, I was wondering if anyone could help me with this issue. I have a TEXT field in my database, It contains HTML, when I edit the field through a web browser it updates fine with no problems. But If I manually edit with MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I h

Re: Problem Editing mysql Text field

2003-02-13 Thread Daniel Negron/KBE
| 11:22 AM | || | |+-> >| | | | To: <[EMAIL PROTECTED]>, "Daniel Negron/KBE" <[EMAIL PROTECTED]>

Master (pc) Slave (laptop) Replication

2003-03-11 Thread Daniel Negron/KBE
I have set up replication and have it working properly for the most part. If I update the master the slave follows suit. But my slave is a laptop, that I use for testing but would like that data to stay up to date withthe master. Overnight if 'live changes take place on the Master, while the slav

Re: Master (pc) Slave (laptop) Replication

2003-03-11 Thread Daniel Negron/KBE
>It is automatic. >Next time you connect your laptop to the network, >and start mysqld on your laptop, it will catch up to the master >provided the bin logs are still on the master. The reason i am asking is because it is not updating a couple of records. But if I create a new db with some conten

Some PHP - mySQL help please ... new to both

2002-03-08 Thread Daniel Negron/KBE
I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run throu

RE: Some PHP - mySQL help please ... new to both

2002-03-08 Thread Daniel Negron/KBE
;<><> |+> || "Todd | || Williamsen" | || | ||| || 03/08/02 12:32| || PM| ||| |+> >-------------| |

Re: Some PHP - mySQL help please ... new to both

2002-03-09 Thread Daniel Negron/KBE
ly drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou > -Original Message- > From: Daniel Negron/KBE [m

Invalid Argument ??? Not sure how to debug this

2002-03-17 Thread Daniel Negron/KBE
Hi all and Good Morning. I have been struggling with this code: I was wondering if someone could lend me a hand. I am working with this code and can't get the error to disappear. After running I get |-| | W

Re: mysql forum

2002-04-02 Thread Daniel Negron/KBE
you can try http://phpnuke.org Thank You <><><><><><><><><><><><><><><><> Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com <><><><><><><><><><><><><><><><> |+> || Javier

Installing MySQL via RPM on RH72 (Involves Compiling PHP)

2002-04-18 Thread Daniel Negron/KBE
Hi All having a problem with install for PHP. I am trying to compile using --with-mysql=/dir/name I used an RPM to install mysql. during configure I get an error saying that it can not find the header files for mysql. I have used '=/shared' and every directory where there is mysql and mysqld.

Re: Installing MySQL via RPM on RH72 (Involves Compiling PHP)

2002-04-18 Thread Daniel Negron/KBE
+> || Jim Philips | || | ||| || 04/18/02 10:36| || AM| ||| |+> >-------------| |

Re:

2002-04-22 Thread Daniel Negron/KBE
I just had the same exact error two days ago. td> checking for termcap functions library... checking for tgetent in -lncurses... no td> checking for tgetent in -lcurses... no td> checking for tgetent in -ltermcap... no td> configure: error: No curses/termcap library found When you installed you

Splitting a Table

2002-05-09 Thread Daniel Negron/KBE
Hi All, mysql newbie here, this may be a silly question, but I couldn't figure out how to word it for a google search I want to take a table that someone created, a break it up so that one table is NOT 125 fields large. I want to separate the table into user info, product info and product defin

Re: problem inst ...bench... rpm

2002-05-16 Thread Daniel Negron/KBE
http://rpmfind.net Thank You <><><><><><><><><><><><><><><><> Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com <><><><><><><><><><><><><><><><> |+> || Curt Söderberg| |

Is Table Name 'PURGE' ALLOWED

2002-06-11 Thread Daniel Negron/KBE
Does mysql allow you to name your tables anything. I created a table called 'purge' and insert 3 field purgeday, purgemonth, purgeyear. ALL of the fields are set to INT or INT NOT NULL. When I try to add a record to this table I get and error 'SELECT * FROM purge LIMIT 0,50' Anyone have a clu

Re: Is Table Name 'PURGE' ALLOWED

2002-06-11 Thread Daniel Negron/KBE
I get the ID-10-T award of the day. http://www.mysql.com/doc/R/e/Reserved_words.html To answer my own question yes this work is reserved. PEBKAC Thank You /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\ Does mysql allow you to name your table

Re: ACCESS to MySQL

2002-06-12 Thread Daniel Negron/KBE
Has anyone tried before to import data from an Access Table to a MySQL Table? Actually, I just need to insert some of the columns and doing it by hand seems quite a long thing to do? I followed these instructions and it worked to a T http://www.sbu.ac.uk/authoring/mysql/convert.shtml Thank Yo