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

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

How to SELECT something (CONCAT) and search the field

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! Thanks, Matt Babineau Criticalcode

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/[EMAIL

RE: Field property question!

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 being able to apply

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

Problem with SELECT SQL_CALC_FOUND_ROWS

.*, 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 p: 858.733.0160 e: [EMAIL

RE: Problem with SELECT SQL_CALC_FOUND_ROWS

= 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_query(); statement. Matt Babineau Criticalcode w: http

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

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

the 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

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

Re: Mysql + PHP - Search

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

RE: MySQL 4.0.2 is topping out at 1024 threads!

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 Thanks All! Matt

RE: MySQL 4.0.2 is topping out at 1024 threads!

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

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: 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 PROTECTED] Sent

Mysql 4.1 and the LIMIT sql statement

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

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 Criticalcode

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:

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

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

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

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 startup problem, that works fine. What happened was my php application stopped working. This server has multiple

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:

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

Vance Pattishall wrote: Can you post what the *.err file said? A key/value in /etc/my.cnf might be causing a startup problem. - Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 ---Original Message- --From: Matt

Re: Windows to Linux

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 On Mon, 2003-11-03 at 19:51, Matt Fletcher wrote: Hi there, I

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.

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

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

RE: GRANT problem

Have you tried: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%' IDENTIFIED BY 'password'; 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,

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:

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 install MySQL-client on my redhat

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

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

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

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

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 executing and its killing my cpu

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

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 MySQL 4.0.14 running on Redhat Linux