A while ago we chatted about a better MySQL search engine. So,
I wrote a script to turn the list emails into web pages, and
set these into a directory, then installed the Alkaline search
engine, and added www.mysql.com to the list of sites to index.
the url is here
Hi,
I know, it sounds a bit like a stupid question, but can I run a slave mysqld
server on the same machine? The idea of just running a slave for the purpose
of bringing it down, each night, to make a backup, is quite appealing. I now
use the hotcopy method.
Thanks!
- Mark
Is it the same in all database servers?
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Octavian Rasnita [EMAIL PROTECTED]
Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; MySQL
[EMAIL PROTECTED]
Hi,
I am a beginner in this MySQL thing, and i am trying to figure out how i
can split, for example, some news articles i already have in a table, into
several pages.
On the site i am building, i get the 10 first news and display them. I use
SELECT FROM NEWS ... ORDER BY DATE DESC LIMIT
Hello,
Probably a question that has been asked a million times before, I searched
google and it
has been brought up before but there didn't seem to be that many solutions
and alot fo the
time it would just Start working.
Anyway,I have just set up my mysql server
Server version:
This one is relatively simple:
Drop the WHERE evtphoto.phtusage = 1.
SELECT it and then GROUP ON it.
--
Loren McDonald AKA MisterrMac
Gods Of Music Reviewer/Editor
[EMAIL PROTECTED]
http://www.GodsOfMusic.com
-Original Message-
From: Hoffman, Geoffrey [mailto:[EMAIL PROTECTED]]
Iwhat am I doing wrong:
After downloading the binary for mysql 4.09-max for Mac OS 10.2 safe_mysql
complains:
% sudo bin/mysqld_safe
The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there
Melinda
Is there a default socket entry in your php.ini (mysql.default_socket) that
is pointing to /tmp?
Rich
-Original Message-
From: Melinda Taylor [mailto:[EMAIL PROTECTED]]
Sent: 25 January 2003 00:25
To: [EMAIL PROTECTED]
Subject: permission or config error
Hello,
Probably a
A while ago we chatted about a better MySQL search engine. So I wrote a
script to turn the list into web pages, and indexed these and www.mysql.com
using the alkaline search engine.
the url is http://workinout.com:9998/workinout/search.html
Over time I will add improvements
a. produce
when 2 arguments are specified for LIMIT then the first argument is the
offset and the second is the max number of rows
e.g. below
select * from mytable limit 10,10
select * from mytable limit 20,10
Rich
-Original Message-
From: Pag [mailto:[EMAIL PROTECTED]]
Sent: 25 January 2003 05:10
Dobrý den,
sexta-feira, 24 de janeiro de 2003, 22:41:47, napsal jste:
WRM Since you obviously aren't going to search the images themselves there is
WRM no reason to put them into a database. File systems are designed for
WRM this. I might suggest using an Id field and then split them into
WRM
Hi!
On Jan 24, Stefan Hinz wrote:
Dear gurus,
does someone have background information on the following problem (How
does MySQL do this?):
CREATE TABLE myisamFixed (col VARCHAR(10)) TYPE=MyISAM ROW_FORMAT=FIXED;
CREATE TABLE myisamDynamic (col CHAR(10)) TYPE=MyISAM
ROW_FORMAT=DYNAMIC;
Hi Sergei,
I just finish to compile the latest source code (Jan 25) from
http://mysql.bkbits.net/mysql-4.1
The problem persist.
Georg has right i was trying to alter table when the primary key was already
defined and i was trying:
ALTER TABLE cmdlivrare MODIFY IDCMD INT(9) AUTO_INCREMENT;
From
Greetings
I'm currently upgrading mySQL v3.23 to mySQL v4.0, the installation of
v4.0 was a success,I tried to execute mysql_fix_privilege_tables
c:\mysql\binmysql -e mysql_fix_privilege_tables
but i keep on getting the error:
ERROR 1064 at line 1: You have an error in your SQL
Hello,
While reading this you may think this is off-topic... but please read on..
I'll get on-topic in the end :-))
First of all I have Web Server on which I have a Paradox table with 320
records.
I also have a CGI Script (or program if you like) I made in Borland Delphi
which I use to access
Hi!
I need to make a select which is the combined result of 2 selects.
I assume I could do this in v4 using UNION or in v3 by running 2 select
into statements, however I'd prefer to do it in v3.23 and if possible
with just one select and just read permissions.
The table is like this :
mysql
Hello,
i just installed MySQL 3.23.55 on a SuSE Linux 8.1 system (compiled
myself), and after firing up mysqld and starting a scan (via nmap; my
server has no firewall) from another server, i get the following message:
/usr/local/mysql/3.23.55/bin/safe_mysqld: line 280: 1757 Segmentation
Gelu Gogancea writes:
Hi Sergei,
I just finish to compile the latest source code (Jan 25) from
http://mysql.bkbits.net/mysql-4.1
The problem persist.
Georg has right i was trying to alter table when the primary key was already
defined and i was trying:
ALTER TABLE cmdlivrare MODIFY IDCMD
Sounds weird. Can you e-mail us a 'mysqldump' of the table defination with
the data?
Thanks,
Bhavin.
- Original Message -
From: Thomas Kvamme [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 7:36 AM
Subject: How to speed things up in MySQL ?
Hello,
While
Darren,
Where does the mysql client store the query history information?
.mysql_history in your home directory, for example. Under Win it doesn't
get stored, AFAIK.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169 Berlin
Lewell,
ERROR 1064 at line 1: 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 'mysql_fix_privilege_tables' at line 1
The script your speaking of is a Unix shell script, and there is nothing
like that in
Chuck,
select * from orderheader where orderid like '$date' ;
The $date variable equals 20030124%
Am I right to suppose your query doesn't work? Did you try something
like:
$sql = select * from orderheader where orderid like '$date';
print $sql;
in your application?
If have not enough
Pag,
as Rich said:
select * from mytable limit 10,10
select * from mytable limit 20,10
In your PHP (?) application, you would have this like:
select * from mytable limit $start,$range
You could set up range (e.g. in config.inc.php) to whatever you want for
the site, and you would add $range
Mike,
example birthday=1972/02/14
How do i tell mysql to order by the day (14) only so that I can list
same
birthday in a month in acending order.
If your birthdays are stored in a DATE column, your example would be
1972-02-14. In this case, you can use the date functions of MySQL.
Here are
Darren,
Is the InnoDB table type available on Windows?
Yes. If you want it to be the default table type, start the server
with --default-table-type=innodb. Note that you will have to use a newer
version of MySQL ( 3.23.somewhat). In 3.23.x, you will have to enable
InnoDB, in 4.0.x, it's enabled
Hi all,
I have mysql 4.0.9 gama for Windows installed and I have a problem because I
cannot set a password for a username.
I've tried:
mysql grant all on *.* to 'teddy@localhost' identified by 'password';
All went right but I can't access mysql using this newly created account.
I can see this
Yes, InnoDB is available in the compiled version for Windows.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: Darren Young [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 12:03 AM
Subject: Windows InnoDB
Is the
Hi Sinisa,
I guess is no need because the problem it's solved now.I don't wish to
happened like the last time...and now, i'm little more carrefully.
You have right.The data on table was corrupt becuase of previous source code
(bk pull on Jan 22).I make ten's of test whith this code based on this
OK,
I have a mysql server running on my home server. The main os is Redhat8.
I know that Mysql is running on port 3306 as its showing as listening. I
ahve opened the tcp port for boh internal and external connections - fione.
I ahve also disbaled it to test aswell.
Anyway - I have loaded
On Fri, 2003-01-24 at 20:27, Hoffman, Geoffrey wrote:
I have an SQL query that LEFT JOINs four different tables to a main table,
based on several foreign keys.
It's returning only stories in a section that have photos,
but I need it to return all the stories in a section whether
it has a
I've run into this if a previous build attempt aborted due to a bad
LD_(LIBRARY|RUN)_PATH where I fixed the LD variable, and re-tried the build.
Starting with a fresh copy of the source (not distclean, fresh from
tarfile), always solved my problem.
-=| Ben
- Original Message -
From:
Hi.. as of Solaris 8 you should NEVER use LD_*, use crle(1) instead!
As to the problem mentioned in my original post, I was able to compile
mysql 3.23.54a using an older compiler under Solaris 8 and 9. (and posted
that update later that day..)
On Sat, Jan 25, 2003 at 01:26:07PM -0500, Ben
Hi,
If you start the mysql daemon with option --log then you will find the
file with all querys which was executed, in the data directory.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi.
On Sat 2003-01-25 at 13:36:01 +0100, [EMAIL PROTECTED] wrote:
[...]
mysql select count(id) as Films, ProductionYear from DVD
- group by ProductionYear
- order by ProductionYear desc;
[...]
39 rows in set (13.32 sec)
mysql
***
How is this
On Sat 2003-01-25 at 14:11:06 +0100, [EMAIL PROTECTED] wrote:
[...]
What I want is the combined output of selects like these (example with 2
users) :
SELECT timecode,
sum(cpuusage) AS jfn
FROM process
WHERE systemid = '2'
AND username = 'jfn'
AND timecode now() - INTERVAL 1 DAY
GROUP
Oopssorry. That should have been GROUP BY and not GROUP ON
That's what I get for answering a post at 2am. :)
--
Loren McDonald AKA MisterrMac
[EMAIL PROTECTED]
This one is relatively simple:
Drop the WHERE evtphoto.phtusage = 1.
SELECT it and then GROUP ON it.
--
Loren McDonald
On Sat 2003-01-25 at 14:16:35 +0100, [EMAIL PROTECTED] wrote:
Hello,
i just installed MySQL 3.23.55 on a SuSE Linux 8.1 system (compiled
myself), and after firing up mysqld and starting a scan (via nmap; my
server has no firewall) from another server, i get the following message:
Look into a product called SQLPorter.
http://www.realsoftstudio.com
I used it once for a MySQL to MSSQL migration project, but you could go
in the other direction. If I remember correctly, I think it includes a
scheduling feature.
-bill
On Tue, Jan 21, 2003 at 01:15:01PM -, John Lodge
Unfortunately I tried to implement what you suggested, but in my case it
didn't work.
I have stories that can have zero or more photos, one or more author, one or
more sections, and one or more active dates.
Trying to join all those items together using your suggestion actually did
return
Hi,
I am upgrading mysql from 3.23.23 to .55 on a brand new server and I don't how to move
over the users/password and privileges so all the logins are the same. Can anyone help?
thanks,
Mogenns
---
Registration Resources
Online Event Registration
This msg keeps bouncing off the list.
First off, thanks for the hint on displaying several pages of news. :-)
Am having a bit of a weird problem with a SELECT on my MYSQL database:
If i use this:
SELECT * FROM tablehere WHERE userid = '$uid' AND password = '$pwd'
with $uid and $pwd
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: sábado, 25 de enero de 2003 21:38
To: Jesper Frank Nemholt
Cc: [EMAIL PROTECTED]
Subject: Re: How to combine two selects into one ???
[clip]
If I understand you correcty, the following should do what
Scott,
most probably, you've got a glibc problem on your Red Hat box. Try
upgrading to a newer version of glibc, and if the problem (mysqld dies
when trying to connect from anywhere else than localhost) has gone, I
was right :)
(There was a very similar question a couple of days ago on this
Well it all depends which version of mysql you are using... versions prior to 4 don't
support sub-select..
-- Stijn Van Rompaey [EMAIL PROTECTED] writes:
Return-Path: [EMAIL PROTECTED]
Received: from mx11.nyc.untd.com (mx11.nyc.untd.com [10.140.24.71])
by
Hi.
On Sat 2003-01-25 at 14:25:14 -0400, [EMAIL PROTECTED] wrote:
On Fri, 2003-01-24 at 20:27, Hoffman, Geoffrey wrote:
[...]
It's returning only stories in a section that have photos,
but I need it to return all the stories in a section whether
it has a photo or not.
I think the
Hi Bhavin.
Thanks for taking interest in my problem...
Here is the table definition as requested.
I'm sorry I could take a full dump... Each record consist of approx 600 KB
(just as in the Paradox table) so the file would be very big. (200 MB).
Kind Regards
Thomas Kvamme
[EMAIL PROTECTED]
Hello,
I have, for the first time, a website to do in several languages.
I'll do a variable replacement whereever needed, with several lang files (as
I've seen so many times in open source PHP applications)
but I am wondering how in sql I could do for translating items' names..
I explain :
I
Hello everybody,
I'm french and use MySQL 3.23.40 on the Windows environment.
And I have a problem with the special french characters
(é, è, ê, à, â, etc.)...
I want that the search queries are insensitive to those special
characters.
So that, for example,
the é character is handled as the e
Hello All,
Just thought I'd report back with what seems to be a simple, elegant
solution to my previous inquiry re: writing a program to connect with
the MySQL server that powers my internet site from my desktop PC.
Yesterday I downloaded the latest release of PHP (ver 4.3.0) and, while
reading
In the last episode (Jan 25), Mogenns Gilmour said:
Hi,
I am upgrading mysql from 3.23.23 to .55 on a brand new server and I
don't how to move over the users/password and privileges so all the
logins are the same. Can anyone help?
Just copy the basedir/mysql database files from the old
Hi again,
Just did another test which I find very interesting
Using the Paradox table instead of the MySQL table I managed to load each
and every record search through every field (including all the text in all
the blob field) in just 6 seconds. and still doing a simple group SELECT
GROUP
In the last episode (Jan 25), pazenko said:
I'm currently upgrading mySQL v3.23 to mySQL v4.0, the installation of
v4.0 was a success,I tried to execute mysql_fix_privilege_tables
c:\mysql\binmysql -e mysql_fix_privilege_tables
but i keep on getting the error:
ERROR 1064 at line
At 11:35 +0200 1/25/03, Octavian Rasnita wrote:
Hi all,
I have mysql 4.0.9 gama for Windows installed and I have a problem because I
cannot set a password for a username.
I've tried:
mysql grant all on *.* to 'teddy@localhost' identified by 'password';
The user name and hostname must be
At 20:32 +0200 1/24/03, Octavian Rasnita wrote:
Is it the same in all database servers?
It's in the nature of digital devices to represent continuous values
inaccurately.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: gerald_clark
At 5:07 +0100 1/25/03, Mark wrote:
Hi,
I know, it sounds a bit like a stupid question, but can I run a slave mysqld
server on the same machine?
Sure.
They have to be using different ports, of course.
The idea of just running a slave for the purpose
of bringing it down, each night, to make
This message intended for MyODBC questions list.
Hello VB6, MySQL, and DAO developers,
A very simple example of my problem:
Dim ws As Workspace
Dim conn As Connection
Dim str As String
Set ws = DBEngine.CreateWorkspace(testing, , , dbUseODBC)
str = odbc;driver={MySQL ODBC 3.51
Add an index to ProductionYear. If that doesn't speed things up to
significantly less than a second from the command line, I'd check how MySQL
is set up.
Fred Steinkopf
- Original Message -
From: Thomas Kvamme [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 25, 2003 7:36
Bear in mind that I've never attempted a multilingual website,
but the first thought that I had when I read your post was to
have a table name extension that gets appended based on the
user's language choice/locale/whatever:
$langext = _en;// english
// $langext = _de; // german
//
Hello Xavier,
can't you do the transforming of your keywords before doing the query ?
to transform all special characters in php it would be :
$keywords = strtr($keywords,éè^éëàãâä,_);
add other special characters and a JOKER sign in mysql '_' for each.
Cheers,
Damien
how-to-repeat:
compile a c program use mysqlclient 4.0.9.
Below is the makefile and output from running make
Makefile:
CC = gcc
INCLUDES = -I/usr/include/mysql
LIBS = -L/usr/lib/mysql -lmysqlclient -lm
all: listener
main.o: main.c common.h
$(CC) -c $(INCLUDES) main.c
60 matches
Mail list logo