Re: Configure prob with FreeBSD/Linuxthreads

On Tue, 28 Jan 2003, Jesse Sheidlower wrote: > > I've been trying to install MySQL 4.0.9 on FreeBSD 4.7, and > have been getting stuck in the configure phase. I'd be > grateful for any suggestions. > > I'm running FreeBSD 4.7 on a single-processor 1.4GHz PIII, > using gcc 2.95.4, and trying to com

RE: Access XP crashes regularly when linked to MySQL via MyODBC

Have you done all the office (or at least Access) XP updates? If not, it is possible that one of them my resolve your crash problem. I have been testing Access XP with the same versions of MyODBC and MySQL for a few weeks now and have yet to see a crash. About the only problem I have ran into is

Re: sql query using select and row functions

On Tue, 2003-01-28 at 12:26, Christopher Lyon wrote: > I am trying to do an sql query and am trying to select the last x rows > from the database. I see the limit function but that seems like that is > from the first row down. I want to start from the last row to the first > row. So, selecting the

Re: Help with SELECT, JOIN and WHERE query

Victor, good shot! I thought of this one in the first place: SELECT u.user_id FROM user_profile u LEFT JOIN team_member t ON u.user_id = t.user_id WHERE t.team_id <> 2 But unfortunately, it will yield: +-+-+ | user_id | team_id | +-+-+ |1000 | 1 | |

restart or not?

When granting someone permissions are these permissions dynamic or do I have to reload mysql? Also we have a developer who stated he cannot access the database remotely. I've granted him privileges as follows since he works on the entire system both locally and remotely. There is only one database

Help - Convert Date from longtext to MySQL date format

Hi I have a few tables in a database Z, namely table a b c In table a, the columns are my_date - longtext num - int(11) eg: mysql> select * from a; +--+--+--+ | my_date | x| +--+--+ | 08/06/2002 |1 | | 08/07/2002 |2 | +--+--+--

Re: Access XP crashes regularly when linked to MySQL via MyODBC

M Wells wrote: Hi All, My MySQL Server is 3.23.53-max-nt. I'm linking to it via MyODBC 3.51.05.00 and accessing its tables via Access XP linked tables. For some reason, Access XP crashes regularly in this setup. No meaningful error messages, just crashes and reloads after a repair. Even more od

Re: mysql dump for remote db

Please don't hijack threads. In the last episode (Jan 28), Mark Stringham said: > Does anyone have a suggestion as to how I could run a periodic mysql > dump for a db that is hosted remotely - IE a web host. I do know that > this host does not support crons. Just cron "mysqldump -h webhostmachine

Re: Replication error: 'Could not initialize master info'

Hi list, My original post concerning this issue is below - it was a week or so ago. No replies were forthcoming, but I'm pleased and a bit embarrassed (so simple) to say that I have figured it out, and my slave is now replicating from the master. The problem was that the mysql data directory wa

Re: sql query using select and row functions

On 1/28/03 12:26 PM, "Christopher Lyon" <[EMAIL PROTECTED]> wrote: > I do have a timestamp field would I be better off using that? Granted it > might not be the same amount of rows every time but how would that work? > > > Select * from tbl_name where TIMESTAMP ( ) -3 hours; > Well, that is no

Re: mysql dump for remote db

On Tue, Jan 28, 2003 at 10:19:19AM -0700, Mark Stringham wrote: > Does anyone have a suggestion as to how I could run a periodic mysql dump > for a db that is hosted remotely - IE a web host. I do know that this host > does not support crons. > > Any help is appreciated. If you have access to a

Re: mysql dump for remote db

The biggest problem is if you want to do this from a remote pc, that pc will need access to the server itself and the mysql client tools. It sounds as if this pc is not on your LAN and I doubt the hosting service will be willing to expose there database to the internet so you can do a backup. If yo

Re: Help with SELECT, JOIN and WHERE query

WHERE team_member.user_id IS NULL William R. Mussatto wrote: Hi, I got a difficult problem with a SELECT query: In my application there are two tables, one for all users (user_profile) one for a user-in-team relation. I want to know, which user is still not in a speciffic team. Users can be

Re: Configure prob with FreeBSD/Linuxthreads

On Tue, Jan 28, 2003 at 01:17:30PM -0800, Jeremy Zawodny wrote: > On Tue, Jan 28, 2003 at 12:21:37PM -0500, Jesse Sheidlower wrote: > > > > I've been trying to install MySQL 4.0.9 on FreeBSD 4.7, and > > have been getting stuck in the configure phase. I'd be > > grateful for any suggestions. > >

Re: Configure prob with FreeBSD/Linuxthreads

In the last episode (Jan 28), Jesse Sheidlower said: > I've been trying to install MySQL 4.0.9 on FreeBSD 4.7, and > have been getting stuck in the configure phase. I'd be > grateful for any suggestions. > > I modified Jeremy's command to eliminate some of the obvious > things I didn't need, and s

Server crash selecting from merge table

>Description: Certain queries on merge tables reliably fail or crash the server as the script below demonstrates. >How-To-Repeat: Run this script: #! /bin/bash # This script demonstrates a bug in the way MySQL handles merge tables. The bug depends on # the index; it doesn't manifes

Re: Configure prob with FreeBSD/Linuxthreads

On Tue, Jan 28, 2003 at 12:21:37PM -0500, Jesse Sheidlower wrote: > > I've been trying to install MySQL 4.0.9 on FreeBSD 4.7, and > have been getting stuck in the configure phase. I'd be > grateful for any suggestions. > > I'm running FreeBSD 4.7 on a single-processor 1.4GHz PIII, > using gcc 2.9

mysql/innob optimizer problem with != and selecting other than primary key

I ran into a problem a few weeks ago with a query that would take up to 2 minutes to return 0 rows found when selecting anything other than the primary key (0 rows is correct). When I selected just the primary_key, the query would take less than 3 seconds. The 2 columns involved in the where par

RE: sql query using select and row functions

In a relational database your data can be stored differently than the way the data is entered. ... If all is the same, one of the three examples should work for you. -Original Message- From: Christopher Lyon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 2:28 PM To: Victor Pend

RE: sql query using select and row functions

I would think they would be the same no? It turns out in the database that they are the same. > -Original Message- > From: Victor Pendleton [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 12:23 PM > To: Christopher Lyon; [EMAIL PROTECTED] > Subject: RE: sql query using sele

RE: sql query using select and row functions

Do you mean the last five rows in the database or the last five rows entered into the database? Either way, Last five rows select [someColumn] from [someTable] ORDER BY [someColumn] DESC LIMIT 0, 5 If the total number of rows is known select [someColumn] from [someTable] ORDER BY [someColum

RE: sql query using select and row functions

Try ordering the records backwards, e.g ORDER BY id DESC and then limit 0, 5 HTH JFernando * sql * -Original Message- From: Christopher Lyon [mailto:[EMAIL PROTECTED]] Sent: January 28, 2003 11:26 To: [EMAIL PROTECTED] Subject: sql query using select and row functions I am trying to do

Re: sql query using select and row functions

On 1/28/03 8:26 AM, "Christopher Lyon" <[EMAIL PROTECTED]> wrote: > I am trying to do an sql query and am trying to select the last x rows > from the database. I see the limit function but that seems like that is > from the first row down. I want to start from the last row to the first > row. So,

problems creating fulltext index

Hello everyone, I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686. I'm trying to create a fulltext index on an existing myisam table and running up against an error. From what I can tell, I'm using the alter table command correctly, but I keep getting errno 140. Can anyone point

RE: sql query using select and row functions

Why not just reverse your order by clause and use Limit 5? Mike Hillyer -Original Message- From: Christopher Lyon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 9:26 AM To: [EMAIL PROTECTED] Subject: sql query using select and row functions I am trying to do an sql query an

In eWeek: Rhode Island uses MySQL

Hi all, Just read my copy of eWeek, and it seems that a state government has used MySQL for a public access rules and regulations database: http://www.eweek.com/article2/0,3959,808852,00.asp quote: "Rhode Island put itself on the cutting edge of hot-technology uptake last year when it became on

RE: Access XP crashes regularly when linked to MySQL via MyODBC

I have seen this behavior reported several times in regards to the MySQL being accessed via MyODBC and MS Access, (various versions). Are you detailing that Access crashes and you have to repair the MySQL tables? If so, is there an error being written to the MySQL error log? -Original Message-

file-descriptor limits for linux

Hi, Does anyone know what the story is for file-descriptor limits on Linux ? I read in http://www.xenoclast.org/doc/benchmark/HTTP-benchmarking-HOWTO/node7.html that root needs to set /proc/sys/fs/file-max to a high value in order that "ulimit -n " will work. However, on a Debian Woody

Re: 3.23 thread error - help/advice please

Hi, yes, thats where i added the line. i used "ulimit -u". ulimit is a build-in bash command. "man bash" says: -u The maximum number of processes available to a single user My section looks like this: if test -n "$open_files" then ulimit -n $open_files ulimit -u 1505# <- That

Weird locking/blocking issues

Heya Folkth: I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads (2.2.3) and still encounter the 'strange threading' behavior described in J. Zawodny's blog. Here's the situation... 1/ there are three threads which lock and then write to two different tables...the locks are got

Please explain the EXPLAIN to me

Hi folks, I used the EXPLAIN-statement to optimize one of my querys (Its been the first time I used it...). I don't understand one of the results given by SELECT. At first, my statement: SELECT zutaten.id, zutaten.name, hersteller.name, einheiten.lang, zutaten_gruppen.name FROM zutaten JO

Re: question about date range

You may want to strongly consider converting the data to a timestamp field type, but that's for down the road. You want to do you search like any other range search you would do. select * from orderheadr where orderid between "2003012400" and "2003012499" You're saying you want to searc

mysql dump for remote db

Does anyone have a suggestion as to how I could run a periodic mysql dump for a db that is hosted remotely - IE a web host. I do know that this host does not support crons. Any help is appreciated. thanks MS sql, query - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECT

Configure prob with FreeBSD/Linuxthreads

I've been trying to install MySQL 4.0.9 on FreeBSD 4.7, and have been getting stuck in the configure phase. I'd be grateful for any suggestions. I'm running FreeBSD 4.7 on a single-processor 1.4GHz PIII, using gcc 2.95.4, and trying to compile with Linuxthreads. I've been using the instructions J

Re: Help with SELECT, JOIN and WHERE query

> Hi, > > I got a difficult problem with a SELECT query: > > In my application there are two tables, one for all users (user_profile) > one for a user-in-team relation. > > I want to know, which user is still not in a speciffic team. Users can > be in more than one team, but we don't care about tha

Connect to Mysql from java(linux)

Hi: I am new to Mysql. I have installed mysql3.23.55 on linux RH7.1. Now mysql is running successfully on my system. When I try connecting thru java(mysql-connector-java-3.0.1) I am getting an Access Denied error. It says mysql@machinename access denied. Now i tried from command line: mysql -u my

Re: 3.23 thread error - help/advice please

What kind of limit did you set? I think I've found the area in safe_mysqld you referred to. Is this correct? -- # If we are root, change the err log to the right user. touch $err_log; chown $user $err_log if test -n "$open_files" then ulimit -n $open_files fi if test -n "$

RE: Help with SELECT, JOIN and WHERE query

SELECT u.user_id FROM user_profile u LEFT JOIN team_member t ON u.user_id = t.user_id WHERE t.team_id <> 2 -Original Message- From: heiko mundle [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 8:08 AM To: [EMAIL PROTECTED] Subject: Help with SELECT, JOIN and WHERE query Hi, I

Error with mysqlImport

Hi I'm trying an import of a 'comma delimited' file and I get this error. The command -=-=--=-=-=-=-= mysqlimport -c user_id,user_id_lower,passwd_lower,fname,lname,address1,city,state,zip,country,email,email_lower,user_num,team_name,team_city,team_canonical,public_email,league_name,league_pwd,l

sql query using select and row functions

I am trying to do an sql query and am trying to select the last x rows from the database. I see the limit function but that seems like that is from the first row down. I want to start from the last row to the first row. So, selecting the last 5 rows for instance? Can this be done? -

RE: SELECT & UPDATE

It may be possible since you used a MATCH ... AGAINST() search your hits were zero. Let me know if you do not understand my reply. -Original Message- From: Daniele Lo Re [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 8:24 AM To: [EMAIL PROTECTED] Subject: SELECT & UPDATE Hi e

Re: 3.23 thread error - help/advice please

Hi, i had a problem like this, too. in my case it wasnt mysql restricting the number of threads but my OS (Linux/Debian). Usually mysql does not run as root, but as user "mysql" or something else. Debian restricts normal users to a number of running processes to prevent an overloaded. i solved my

Help with SELECT, JOIN and WHERE query

If you have mySql 4 use a sub-query select user_id from user_profile where user_id not in (select user_id from team_member where team_id = 2) Hi, I got a difficult problem with a SELECT query: In my application there are two tables, one for all users

error 1129

We have been receiving this error frequently from our mysql server about our webserver. 1129: Host 'ip-adress' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' This is getting anyoing. Can someone tell me if there is a way to disable this feature for a certain

RE: SELECT & UPDATE

Did the update work? I would expect it did and is just reported that you have not added or taken away any rows. Simon -Original Message- From: Daniele Lo Re [mailto:[EMAIL PROTECTED]] Sent: 28 January 2003 14:24 To: [EMAIL PROTECTED] Subject: SELECT & UPDATE Hi everybody. I got a really

Re: Help with SELECT, JOIN and WHERE query

Hi, a query like this should do the job select user_profile.user_id from user_profile left join team_member on (team_member.user_id=user_profile.user.id and team_member.team_id=2) where team_member.user_id is NULL; Dobromir Velev [EMAIL PROTECTED] www.websitepulse.com - Original Message ---

Access XP crashes regularly when linked to MySQL via MyODBC

Hi All, My MySQL Server is 3.23.53-max-nt. I'm linking to it via MyODBC 3.51.05.00 and accessing its tables via Access XP linked tables. For some reason, Access XP crashes regularly in this setup. No meaningful error messages, just crashes and reloads after a repair. Even more odd (and I only hav

Re: simple problem, no tcp port openning - Solved

after digging around more, i found Debian's MySQL has 'skip-networking' in the /etc/mysql/my.cnf further down On Monday 27 January 2003 17:08, you wrote: > installed mysql onto debian using a deb file. it is running locally fine, > but it isn't openning a TCP port for remote connections to it. >

Problem starting MySQL with chroot option

When I try to start the server with the following options mysqld --chroot=/servers/mysql/ --user=mysql (options that are not relevant) I get an error [1] 379 Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 030128 13:02:21 Aborting 030128 13:02:21 ./mysqld:

Re: Mysql 4.0.9 and Jconnector 3.0.5

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 avaj avaj wrote: [snip] java.sql.SQLException: Syntax error or access violation, message from server: " You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT i

SELECT & UPDATE

Hi everybody. I got a really weird behaviour from Mysql, while doing some select and update queries. I made a select, something like: SELECT Something FROM WHERE and the result was not empty. But when I tried to make an update: UPDATE..WHERE , with THE SAME WHERE clause, result wa

Help with SELECT, JOIN and WHERE query

Hi, I got a difficult problem with a SELECT query: In my application there are two tables, one for all users (user_profile) one for a user-in-team relation. I want to know, which user is still not in a speciffic team. Users can be in more than one team, but we don't care about that. Example:

3.23 thread error - help/advice please

I tweaked my.cnf on a server. Changed wait_timeout from 80 to 75 and increased key_buffer to 1280M from 1024M max_connections is set to 500 Max_used_connections was reported at 370 (from 'mysqladmin variables') thread_cache is set to 48 I ran 'mysqladmin flush-hosts' as the mysql root user and go

Re: my.ini

Vicente, > language=spanish You could try "language=c:/mysql/share/spanish". With my 4.0.7 on Win2K, both works. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 797

Re: smallest dumpfiles in Windows in one step?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Benjamin, et al -- ...and then Benjamin Pflugmann said... % % On Mon 2003-01-27 at 21:45:54 -0500, [EMAIL PROTECTED] wrote: % > % > ...and then Stefan Hinz, iConnect (Berlin) said... % > % ... % > % c:\mysql\bin> mysqldump --all-databases --add-dro

Re: question about primary key

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Vincente, et al -- ...and then Vicente Valero said... % % Hello, I need help. Hi! That's why the list is here :-) % % I want to create a table with a numeric primary key as index in my sql. I Good. % want this % index will be automatic. I've

Real size of disc space used for database?

Hi All! I have strange problem. DB MySQL 3.23.55, MyISAM table about 70 mln. record. Index file approx 50 Mb. I have delete about 40 mln. records and run optimize table. show table status get me size for this table approx 300Mb. But file on harddisk approx 1Gb. Does MySQL don't waste unused space

TARGETED UNIQUE SEARCH ENGINE TRAFFIC

WE DELIVER TARGETED UNIQUE SEARCH ENGINE TRAFFIC TO YOUR WEB SITE BOTTOM LINE >> IF YOUR POTENTIAL CUSTOMERS CAN'T FIND YOUR WEB SITE YOU JUST LOST MONEY! IT'S THAT SIMPLE! Improving search engine TRAFFIC means: MORE HITS MORE BUSINESS MORE SUCCESS The most important advertising dol

re: Can I set a default value to a function?

On Tuesday 28 January 2003 05:04, Carlin Anderson wrote: > I am running mysql 3.23, and want to know if I can set the default value > of a column to to_days(now()), or the equivelant. I have tried this, > and the default gets translated to 0. Nope. Default column value must be constant. -- F

re: question about primary key

On Monday 27 January 2003 10:27, Vicente Valero wrote: > I want to create a table with a numeric primary key as index in my sql. I > want this > index will be automatic. I've tried an auto_increment column, but if insert > a non-correlative value then all new entries continue from this > non-corre

Re: MySQL error (Errcode: 13)

Dhanashri, > ALTER TABLE `timesheet` ADD `phase_desc` VARCHAR( 50 ) > Error on rename of '.\etime\timesheet.MYI' to '.\etime\#sql2-64c-19.MYI' > (Errcode: 13) I had the same kind of problem with ALTER TABLE and MySQL < 4.0.5 under Win2K. Errorcode 13 means it's a permission problem. I never solve

Re: Mysql 4.0.9 and Jconnector 3.0.5

avaj avaj wrote: Hello. Iam porting an application that previously run on InstantDB to Mysql. This application makes use of transaction and isolation level(Read Committed). I previously tried using mysql 3.23.54 max with the old mm.mysql driver but encountered a problem in setting the Isolati

my.ini

Hi, This is my 'my.ini' file where I specified 'language=spanish' but the sql errors appear in English yet. I don't see another line after this that changes the value. Can somebody help me? # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long o

Re: smallest dumpfiles in Windows in one step?

On Mon 2003-01-27 at 21:45:54 -0500, [EMAIL PROTECTED] wrote: > Stefan -- > > ...and then Stefan Hinz, iConnect (Berlin) said... > % > ... > % backing up my MySQL databases on a Win2K box at home to a Linux box in > ... > % hand, I have only 128 MBit upstream from my Win machine, and maybe you >

Re: Can I set a default value to a function?

On Mon, Jan 27, 2003 at 10:04:07PM -0500, Carlin Anderson wrote: > I am running mysql 3.23, and want to know if I can set the default value > of a column to to_days(now()), or the equivelant. I have tried this, > and the default gets translated to 0. You cannot. -- Jeremy D. Zawodny | Perl,

Re: Properly shutting down mysql

Hi. On Mon 2003-01-27 at 16:31:48 -0800, [EMAIL PROTECTED] wrote: > If I manually shut down mysql, I usaully use the mysqladmin shutdown > command. However, I noticed that the "red hat" way of stopping mysql in > its init scripts is by issuing a "kill" command to the pid. U, is > this wise?

Mysql 4.0.9 and Jconnector 3.0.5

Hello. Iam porting an application that previously run on InstantDB to Mysql. This application makes use of transaction and isolation level(Read Committed). I previously tried using mysql 3.23.54 max with the old mm.mysql driver but encountered a problem in setting the Isolation level. I got ho