RE: Storing huge amount of binary data

Sometimes, the easiest way to do this is to use the file system of the linux machine to store the files, and make reference to them in the DB...storing not data in the DB and getting rid of all your possible problems. Thanks, Matt Babineau Criticalcode 858.733.0160 [EMAIL PROTECTED] http

Some query help

220) ORDER BY distance ASC So I hope you can see what I am trying to get after. Basically I need to fins a distance that can fit each of the numbers in the list. So if 2200 is in the list, 2250 works. If 400 is in the list, 622 works. Thanks for the help on this! Thanks, Matt Babineau Criticalc

Thanks for the help

Thanks for the help, I'll give some of these examples a try~!!! Thanks, Matt Babineau Criticalcode 858.733.0160 [EMAIL PROTECTED] http://www.criticalcode.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

How to SELECT something (CONCAT) and search the field

e closest I found to try and do what I want to do. I alread tried this: SELECT concat(first_name, ' ', last_name) as fullname FROM user... This did not work. If anyone has any ideas on how to search for users when the first_name and last_name fields are broken up I'm all ears!

RE: Field property question!

ay 10, 2005 10:58 AM To: Matt Babineau; mysql@lists.mysql.com Subject: RE: Field property question! [snip] Can I setup a table so that no matter how data is entered into it (web form, command line) The data in one of the columns ALWAYS gets converted to uppercase? I remeber MSSQL had this feature of

Field property question!

Can I setup a table so that no matter how data is entered into it (web form, command line) The data in one of the columns ALWAYS gets converted to uppercase? I remeber MSSQL had this feature of being able to apply a function to a field in its configuration. Thanks! Matt

RE: using between

query that way. MySQL should beable to reduce the amount of rows it needs to look at pretty quickly this way. Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: [EMAIL PROTECTED] -Original Message- From: Rob Brooks [mailto:[EMAIL PROTECTED] Sent: Friday, March 25

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

database starts growing but, my query is solid, and I am only returning a few rows at a time, so hopefully over a couple hundred queries wont make this thing die! :) Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: [EMAIL PROTECTED] -Original Message- From

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

Ok I installed PHP 4.3.10 and it still has not fixed the problem. If I remove the SQL_CALC_FOUND_ROWS from the query, it works no problems! This is very strange behavior! Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: [EMAIL PROTECTED] -Original Message

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

Weird thing is that I am running PHP 4.3.9I guess I can upgrade and see what happens? Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: [EMAIL PROTECTED] -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 12

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

taBulk ON propertyData.id = propertyDataBulk.propertyID WHERE state = '$state' limit $stRow, $rows"; $search = mysql_query($sql); echo $sql; $sql = "SELECT FOUND_ROWS()"; $ctTotalResults = mysql_fetch_row(mysql_query($sql)); It errors out on the first $search = mysql_que

Problem with SELECT SQL_CALC_FOUND_ROWS

WS propertyData.*, propertyDataBulk.propertyDesc FROM propertyData LEFT JOIN propertyDataBulk ON propertyData.id = propertyDataBulk.propertyID WHERE state = 'CA' limit 0, 5 Very odd that this happens, I am running MySQL 4.1.9 Thanks, Matt Babineau Criticalcode w: http://www.criticalcode.com

Re: Mysql + PHP -> Search

e total number of records when browsing through a list. ------ Matt Babineau Criticalcode w: http://www.criticalcode.com p: 858.733.0160 e: [EMAIL PROTECTED]

MySQL + PHP -> Search Engine question!

Hi All - I'm building a search engine and what I would like to do is run a search and get the number of results, but still use the LIMIT command so I am not returning a ton of rows all at once. Is this the best way to go about searching? Thanks, Matt Babineau Criticalcode w:

Mysql 4.1 and the LIMIT sql statement

pecify LIMIT -1, but apparently this functionality doesn't seem to work in 4.1??? Thanks, Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com

RE: Trying to dump from GUI client

I'm not sure what the answer here is but check your user's permissions on the database to make sure it has the necessary items GRANTED to it. Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com -Original Message- From: Eve Atley [mailto:[EMAIL PROTEC

RE: MySQL 4.0.2 is topping out at 1024 threads!

FIXED! Ok Thanks to Eric on this one, the wait_timeout configuration was what fixed my sleepy connection problems! Thanks ERIC! Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com -Original Message- From: Eric Gunnett [mailto:[EMAIL PROTECTED] Sent

RE: MySQL 4.0.2 is topping out at 1024 threads!

eping too long? I already have a connection_timeout in the my.cnfis there another option? Matt Babineau Web Developer Criticalcode - http://www.criticalcode.com -Original Message- From: Alvaro Avello [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 17, 2004 11:28 AM To: Matt Babine

RE: MySQL 4.0.2 is topping out at 1024 threads!

Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout Thank

MySQL 4.0.2 is topping out at 1024 threads!

Help! I can't figure out a way to stop my server from topping out at 1024 threads. This is a very strange behavoir. I have tons of legit use on my database server but I don't think the threads are dying does anyone have any suggestions for this? Thanks, Matt Babineau Web Developer Cr

RE: Query to emulate what mysqldump does

On Wed, 2003-12-03 at 15:22, Jay Blanchard wrote: > [snip] > I thought about that Jay, but the mysql server is not on the webserver > machine. Any other suggestions? > [/snip] > > phpmyadmin will allow you to connect to the remote MySQL server and do > dumps What if I don't have phpmyadmin availa

RE: Query to emulate what mysqldump does

On Wed, 2003-12-03 at 15:13, Jay Blanchard wrote: > [snip] > Are there any query equivalencies to mysqldump? I am looking for a way > to get a complete database dump via php and I don't have access to the > system CLI to run mysql dump. > [/snip] > > Run mysqldupmp in a php file using exec...see >

Query to emulate what mysqldump does

Hey All- Are there any query equivalencies to mysqldump? I am looking for a way to get a complete database dump via php and I don't have access to the system CLI to run mysql dump. TIA- Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

Re: Mysql just stopped working on my server - any way to track down the problem?

nt you toward the fix. > > > Matt > > > - Original Message - > From: "Matt Babineau" > Sent: Tuesday, November 11, 2003 3:28 PM > Subject: RE: Mysql just stopped working on my server - any way to track > down the problem? > > > > Its not a sta

RE: Mysql just stopped working on my server - any way to track down the problem?

688 > > > -->-----Original Message- > -->From: Matt Babineau [mailto:[EMAIL PROTECTED] > -->Sent: Tuesday, November 11, 2003 1:16 PM > -->To: [EMAIL PROTECTED] > -->Subject: Mysql just stopped working on my server - any way to track > down > -->the pro

Mysql just stopped working on my server - any way to track down the problem?

Hi All- I am running 4.0.15-standard on RH9. My mysql database just stopped working, is there a way I can log information about why it stops like this? the *.err was unhelpful. Any help here is appreciated. Thanks -Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: Windows to Linux

ort that? > > --- > > > Quoting Matt Babineau <[EMAIL PROTECTED]>: > > > Check out SQLYog, could can connect and copy databases...pretty much > > like MSSQL Enterprise manager. They have a trial version on their site: > > http://www.webyog.com/sqlyog > >

Re: Windows to Linux

Check out SQLYog, could can connect and copy databases...pretty much like MSSQL Enterprise manager. They have a trial version on their site: http://www.webyog.com/sqlyog On Mon, 2003-11-03 at 19:51, Matt Fletcher wrote: > Hi there, > I have taken the plunge and dropped windows in favour of linux

RE: GRANT problem

Have you tried: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @'%' IDENTIFIED BY ''; FLUSH PRIVILEGES; On Thu, 2003-10-23 at 21:03, Nathaniel Mallet wrote: > I was having the same problems trying to get a user added to a new DB, so > here's are the commands I used: > > GRANT INSERT, DELETE, UPD

Re: Improving Query speed - any suggestions?

Thanks everyone for your input, I'll try the ramdisk idea, I read about someone else who tried that and had some success. Beyond, that I'm gonna take the long route and redesign the database to be a bit more conventional. Thanks! Matt On Thu, 2003-10-23 at 20:28, Peter Buri wrote: > Hello, > > a

Improving Query speed - any suggestions?

Hey All- I am trying to improve the speed of a website and was wondering if anyone had any ways I can rewrite these queries so that they actually run with some descent speed. Its a really nasty query and I'm not sure where to start, I'd like to now have to redo the tables and I already put some i

Config problems - logging

Hey all- I've been trying to track down some slow queries but I cant get the logging turned on properly, for some reason my server just wont create a slow query log and then when I tried mysqldumpslow, it gave me an error that I have no basedir setup. Has anyone had any similar problem that can sh

Re: libmysqlclient.so

Thanks everyone! I installed MySQL-shared-X and it worked! On Tue, 2003-10-21 at 15:48, Kelley Lingerfelt wrote: > the mysql-devel rpm installs it. > > Kelley > > > Matt Babineau wrote: > > > Any ideas what packages install this library? I used the RPM to try and

libmysqlclient.so

Any ideas what packages install this library? I used the RPM to try and install MySQL-client on my redhat machine, but the libmysqlclient did not show up in /usr/lib - so I am wondering which RPM I need to get this file? Thanks, Matt -- MySQL General Mailing List For list archives: http://lists

Re: just messed up my index on my table....ugh

s with the same row_id as widget so I also want to pull those out of the table too. I hope this makes some sense... Thanks, Matt On Fri, 2003-10-03 at 20:14, Jeremy Zawodny wrote: > On Fri, Oct 03, 2003 at 04:23:56PM -0400, Matt Babineau wrote: > > now the query isn't finishing exe

just messed up my index on my table....ugh

now the query isn't finishing executing and its killing my cpu... any idea how to rebuild the index on a table? or how to get out of this mess? :-) Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

just messed up my index on my table....ugh

now the query isn't finishing executing and its killing my cpu... any idea how to rebuild the index on a table? or how to get out of this mess? :-) Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PRO

Re: setting the wait_timeout option - doesn't work?

Yeah mysql is reading the config file, because I have set other options like query_cache_size...so I'm not sure :-( On Thu, 2003-10-02 at 18:09, Jeremy Zawodny wrote: > On Thu, Oct 02, 2003 at 02:02:34PM -0400, Matt Babineau wrote: > > Hey All-- > > > > I have MySQ

setting the wait_timeout option - doesn't work?

Hey All-- I have MySQL 4.0.14 running on Redhat Linux and it won't accept my change to the wait_timeout config option! In the my.cnf file I have a line wait_timeout = 60 but when I restart mysql and go into the server and type SHOW VARIABLES; it says the wait_timeout is still 28800 whi