Speeding up Queries

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

Master (pc) Slave (laptop) Replication

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

Re: Master (pc) Slave (laptop) Replication

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 contents

Problem Editing mysql Text field

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

Re: Problem Editing mysql Text field

| || | |+- | | | | To: [EMAIL PROTECTED], Daniel Negron/KBE [EMAIL PROTECTED

Re: ACCESS to MySQL

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

Is Table Name 'PURGE' ALLOWED

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

Re: Is Table Name 'PURGE' ALLOWED

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

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

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| || curt.soderber| || [EMAIL

Splitting a Table

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

Re: no subject

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 BWhen you installed your

Installing MySQL via RPM on RH72 (Involves Compiling PHP)

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)

| ||| |+ -| | | | To: Daniel Negron/KBE [EMAIL PROTECTED], [EMAIL PROTECTED

Re: mysql forum

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 Gloria | || jgloriame@yah| ||

Invalid Argument ??? Not sure how to debug this

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 |-| |

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

on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I

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

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

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

| ||| |+ -| | | | To: 'Daniel Negron/KBE' [EMAIL PROTECTED], [EMAIL PROTECTED]| | cc