Heikki,
After a good 6-8 hours of runnning, the server just restarted itself
(running the most recent build from the 3.23.xx tree, as you
suggested). I got this message:
InnoDB: Assertion failure in thread 42527756 in file ha_innobase.cc
line 316
InnoDB: We intentionally generate a memory trap.
On Tue, May 28, 2002 at 10:28:08AM -0400, Adam Nelson wrote:
> I think any descent server would be fine:
>
> Linux/FreeBSD
> dual PIII
> 512MB ram (or better 1GB)
> 2 scsi drives with raid1
>
> Frankly, you could even get cheaper than that with 1 processor.
Yeah, that hardware would be more tha
On Tue, May 28, 2002 at 01:39:31PM +0200, Dries Robberechts wrote:
> Hi people,
>
> Is there a way to have the mysqld log to syslog, instead of the
> errorlog flatfile?
Nope.
> I tried piping it to a stdin-to-syslog script, but that wouldn't
> work either.
There's a chance that MySQL is loggin
On Wed, May 29, 2002 at 11:34:38AM +0800, Machi Ma wrote:
> Where can I setting MySQL key buffer, table buffer, read or query
> buffer. Is it in /etc/my.cnf. And what is the maximum supported
> size of them?
Suggested reading:
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
http://www.li
Perhaps you are using php as cgi
try using it as a module of apache
**
-Original Message-
i use mysql_pconnect in php, but after call
mysql_pconnect every time,i find that connection
increase one.it says in php manual, mysql_pco
Patrick Nelson wrote:
-
I want to run a daily cron dump of my MySql system using something like
mysqldump -A > File.sql
I have a .my.cnf file that specifies host user and password, but this is not
available to the cron script when it is run. I would prefer using the
config fi
I want to run a daily cron dump of my MySql system using something like
mysqldump -A > File.sql
I have a .my.cnf file that specifies host user and password, but this is not
available to the cron script when it is run. I would prefer using the
config files (sa .my.cnf) than hard coding the user a
Does anymore know a online documentation of MS-SQL for use with ODBC?
or do i need to buy a book?
thanks,
Jule
--
|\/\__/\/|
| Jule Slootbeek |
| [EMAIL PROTECTED]|
| http://blindtheory.cjb.net |
| __ |
|/\/
On Tue, May 28, 2002 at 10:04:26PM -0600, Tyler Spivey wrote:
> ok - this might seem unbelieveable but:
> why are the benchmarks:
> shell> cd sql-benchmarks #or whatever it is
> shel> perl run-all-tests --user=root --password=password
> and then on another screen i have mysql up -
> and a \s say q
php's pconnect opens a connection for every process that accesses the
database. The webserver processes don't share the connections, but later
accesses on the same process re-use the previous connection. It's very
likely that when you hit your php script, you're going to get a different
webserver
ok - this might seem unbelieveable but:
why are the benchmarks:
shell> cd sql-benchmarks #or whatever it is
shel> perl run-all-tests --user=root --password=password
and then on another screen i have mysql up -
and a \s say queries per sond 1.792 or something around there. what is up?
On Tue, May 28, 2002 at 01:16:28PM -0700, Jeremy Zawodny wrote:
> On Tue, May 28, 2002 at 10:59:45PM +0300, Heikki Tuuri wrote:
> > Jeremy,
> >
> > can you build your own 3.23.51? There is actually the same memory
> > overwrite bug in gethostname_r of glibc/Linux in .49a as in .50.
>
> I'll inst
Where can I setting MySQL key buffer, table buffer, read or query
buffer. Is it
in /etc/my.cnf. And what is the maximum supported size of them?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Tue, May 28, 2002 at 03:21:54PM -0500, Thi Cao wrote:
> All,
>
> Is there a mysqldump utility routine that I can call using the mysql++ api?
Nope. You might be able to use BACKUP TABLE or SELECT INTO OUTFILE
instead.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo
Hi.
On Wed, May 29, 2002 at 02:36:11AM +0200, [EMAIL PROTECTED] wrote:
> It seems I cannot use an alias in WHERE clause, but I can use it in ORDER
> BY.
Correct.
> An examples:
>
> this doesnt work
> SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE ABC =
> 'abc' ORDER BY
Is it mysql isam is means a Indexed Sequentail Access Method and is the
default setting of mysql database is using this method.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
i use mysql_pconnect in php, but after call
mysql_pconnect every time,i find that connection
increase one.it says in php manual, mysql_pconnect
will first try to find a (persistent) link that's
already open with the same host, username and
password. If one is found, an identifier for it will
be re
You all should block anything with 'yahoogroups' anywhere in any
of the headers.
"Notification de Yahoo! Groupes" wrote:
>
> Bonjour,
>
> Vous avez récemment demandé à vous inscrire au groupe
> mysql-france. Comme vous êtes déjà membre de ce groupe,
> votre demande ne sera pas prise en comp
Bonjour,
Vous avez récemment demandé à vous inscrire au groupe
mysql-france. Comme vous êtes déjà membre de ce groupe,
votre demande ne sera pas prise en compte.
Pour toute question sur l'envoi de messages à ce groupe,
veuillez envoyer un e-mail à [EMAIL PROTECTED]
Cordialement,
L'équipe
I have just installed mysql 3.23.49 onto my Mandrake installation using the RPMs.
How can I get the mysql server to start as the PC is booting ??
Pete
__
Your favorite stores, helpful shopping tools and great gift ideas. Experienc
It seems I cannot use an alias in WHERE clause, but I can use it in ORDER BY.
An examples:
this doesnt work
SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE ABC =
'abc' ORDER BY ABC
this works
SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE
field1 =
Running MYSQL 3.23 can the date mmdd be reversed when using Access or VB
frontend so that users can enter it as they are used to eg. ddmm. Also I
tried creating a new field for date using DATE(8) BUT the sql statement came
back with an error. I tried changing the format of the date field t
Hello all, this is my first post to this list. I am relatively new to
MySQL, and my question might be a basic one.
I have a table that contains both character and binary data. I am
reading rows from the table using the function mysql_fetch rows() in a C
program. I can obtain character data
Thanks for the reply! Should I change the structure such that all
varchar fields are in the same table?
I believe you did understand my design correctly. Available_properties
contains the primary data. Property names is just a table that contains
subsequent data for available_properties and de
I'm not sure how to phrase this. Please excuse the crudeness of my description.
I'm storing calendar data in a MySQL database and I'm wondering, is there a
way to specify a day, such as the 28th, and "fourth" "Tuesday" as search
criteria when selecting rows from a table with a field of type dat
Thanks for your prompt reply!
Egor Egorov
actually i alrdy followed the manual..the error is
whenever i type in the command prompt -> mysqld-nt
-install FAILURE TO START SERVICE is the error i
encounter.. but if i run type net start mysql its
alrdy started.
This is the only problem that ive enco
OK, I cannot find this sql query on the website or in any of my manuals.
I have a table that contains a set datatype eg
CREATE TABLE testjason (
ID int(11) NOT NULL auto_increment,
SomeSetColumn set('a','b','c') NOT NULL default '',
) TYPE=MyISAM;
I neet to perform an UPDATE on this ta
How do you reference a column name in another table to avoid repeating the
values?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin
Pflugmann
Sent: Tuesday, May 28, 2002 6:24 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: first mysql
In Mysql I can have tables in one HD and Index and other Like Oracle ??
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
You could be correct about the time zone problem in this sql. I'm somewhat
of a MySQL newbie -- do you mean the system environment variable or is there
a MySQL environment variable for TZ?
Thanks,
Kevin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Hi.
Looks okay, except that you probably want to reference via pro_id and
d_id in table available_properties (given that I understood your table
layout correctly). It is usally considered bad design to repeat the
values itself (the varchars) in several tables.
Bye,
Benjamin.
On Tue, M
Hi.
Maybe your TZ (timezone) environment variable is set to a strange
value? If not, could you provide a full example, so that we can try to
reproduce it and see whether this is a local behaviour of your machine
or a common MySQL behaviour.
Bye,
Benjamin.
On Tue, May 28, 2002 at 01:27
All,
Is there a good GUI application out there that allows me to compare two
mysql databases and view the differences?
Thanks,
Thi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
> SELECT images.filename, images.path, images.desc, categories.name FROM
> images, relate, categories WHERE public = 1 AND relate.fromid =
> images.id AND relate.toid = categories.id
>
> But what I need help with is getting all the images that has no
> categorie associated with them in the tab
Tells a great deal about how confused I am...
I've a database with three tables, one with image data, one with
categories and one table which helps me to have several categories per
image...
The following SQL gives me _all_ the images that has at least one
category associated:
SELECT images.
Hi!
Please go through the checklist in section 3.1 in
http://www.innodb.com/ibman.html. I have a faint recollection that Linux in
some of these cases gives a very obscure error number 22 which in Linux
means 'Invalid argument'. It might really be out of disk space/quota.
Best regards,
Heikki Tu
Jeremy,
I do not know. I am not an expert on the hostname_r memory overrun bug :).
Also, I guess the crash you get does not come from it.
Regards,
Heikki
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent:
All,
Is there a mysqldump utility routine that I can call using the mysql++ api?
Thanks,
Thi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
On Tue, May 28, 2002 at 10:59:45PM +0300, Heikki Tuuri wrote:
> Jeremy,
>
> can you build your own 3.23.51? There is actually the same memory overwrite
> bug in gethostname_r of glibc/Linux in .49a as in .50.
Come to think of it, if that's what caused the problem, wouldn't this
"solve" it for no
On Tue, May 28, 2002 at 10:59:45PM +0300, Heikki Tuuri wrote:
> Jeremy,
>
> can you build your own 3.23.51? There is actually the same memory
> overwrite bug in gethostname_r of glibc/Linux in .49a as in .50.
I'll install 3.23.51 tonight. I have been doing daily builds of the
3.23 and 4.0 tree
is there a way or possibly a command line tool for querying a remote file and
having it dump the select into a local outfile.
it does exacly what i want from the server, but only to create a file on the
server. and just adding local doesn't/hasn't work.
and mysqldump outputs sql, which isn't wh
Jeremy,
can you build your own 3.23.51? There is actually the same memory overwrite
bug in gethostname_r of glibc/Linux in .49a as in .50.
If you build mysqld yourself you can run it inside gdb and do bt full when
it crashes. That might help in tracing the bug.
The assertion failure below means
Hello list, this is my first table for a simple php page and I'm hoping
someone could briefly review its structure. The only fields I'll be
sharing are property_name and type. Are they set up properly for select
join queries?
thank you, justin
Database=properties
Tables are available_properti
Here's what the error log says:
mysqld started
.../bin/mysqld: Undefined symbol "strtoll"
mysqld ended
Thanks,
Tracy
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 2:07 PM
To: [EMAIL PROTECTED]
Subject: RE: error when trying to load large du
You should NOT be running myisamchk while the server is running!
[EMAIL PROTECTED] wrote:
>I get this message when I do a myisamchk on a table right after I use
>phpMyAdmin or other mysql client tools.
>
>What do I need to do to get the table to close properly? I have been
>having to run myis
I just converted several tables to InnoDB on our Linux 3.23.49a
(binary from MySQL.com). After running our production system against
it for about 10 minutes, InnoDB crashed with a stack trace:
---snip---
/home/mysql/bin/mysqld: ready for connections
InnoDB: Assertion failure in thread 159781 in
Sigh, sanity check.
I did set a skip counter, and you were correct, it was on a newer version ( on a
different slave )
That slave server crashed, when we did the reinstall, i reverted back to 3.23.32 ( the
same as the rest of or slaves were running )
So that threw me for a loop seeing now that a
Since it's a date field, it's a date comparison and the date that you
specify ('WWW') gets parsed by the optimizer as being the date '-00-00'
since it can't find any valid date information. This is different from if
it was to convert the date to a string and do a string comparison, which is
w
On 28/5/02 at 12:59, [EMAIL PROTECTED] (Amy Zediak) wrote:
> Where is msql.h located?
On which OS?
Regards,
Phil.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi, I also have a date problem:
My SQL query problem:
For example, I have the following table:
Mytable:
No Name Date Project
1 Bob 2002-05-27Bob's project
2 John -00-00 John's project
When I query "select * from
I've created a dump file using mysqldump that is about 4MB. When I try to
load it on another server using "mysql database < dump.sql" I get errors.
If I create a smaller dump file (below 1MB) it loads without a problem. I
noticed that the default max_allowed_packet size is 1MB, but I've not had
Hehe, this is almost identical to the post I submitted yesterday, entitled "SELECT
'foobar' = 0"
There's a patch in that post, doesn't work for dates but should give an idea of what
has to be done.
The reason is that 'WWW' has to be converted to a date. And the conversion gives it a
value of
Hi,
I have an interesting problem when updating columns of type DATETIME. It
seems that exactly one day is subtracted from the DATETIME value that I
submit in an update query. Has anyone encountered this? Any ideas?
Kevin
-
or mysql.h?...is in your_src_directory/include
- Original Message -
From: "Amy Zediak" <[EMAIL PROTECTED]>
To: "MySql List" <[EMAIL PROTECTED]>
Sent: Tuesday, May 28, 2002 7:59 PM
Subject: msql.h
>
>
> Where is msql.h located?
>
>
Hi,
the internal space for innodb is full...
create new extends (add another ibdata file and restart the mysql)
to see how much space is free, execute the command:
show table status like 'yourtableinnodb'
Iago Sineiro wrote:
>Hi all.
>
>I import a mysqldump from MyISAM database in a new innod
Hello everyone.
I have an issue that can't figure out, and was wondering if someone can help
me with it.
I offer mySQL based e-mail account to my users.
The actual e-mails are stored in a text based directory.
Sometimes when the e-mail is put in the trashcan, it actually deletes the
e-mail folder,
My SQL query problem:
I met a strange problem:
For example, I have the following table:
Mytable:
No Name Date Project
1 Bob 2002-05-27Bob's project
2 John -00-00 John's project
When I use "select * from
> My SQL query problem:
> I met a strange problem:
>
> For example, I have the following table:
>
> Mytable:
>
> No Name Date Project
> 1 Bob 2002-05-27Bob's project
> 2 John -00-00 John's project
>
> When I use "sel
Where is msql.h located?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscri
I get this message when I do a myisamchk on a table right after I use
phpMyAdmin or other mysql client tools.
What do I need to do to get the table to close properly? I have been
having to run myisamchk -r on the talbe every time I do something to it.
Thanks in advance,
Chris
-
On 27 May 2002, at 22:32, [EMAIL PROTECTED] wrote:
> mysql> SELECT dd,count(*) FROM test GROUP BY dd;
> +--+--+
> | dd | count(*) |
> +--+--+
> | 20020527 |1 |
> | 20020527 |1 |
> | 20020527 |1 |
> | 20020527 |1 |
> +--
Hi all.
I import a mysqldump from MyISAM database in a new innodb database. It gives
me an error saying that the table is full
ERROR 1114 at line 3035: The table 'LALBARANPR' is full
These are the values for the innodb variables in the my.cnf file:
innodb_data_file_path = ibdata1:2000M;ibdata2
The mysql command line client can accept batch files as:
mysql -uuser -ppassword database < file.sql
file.sql is just a file with the plain text SQL statements in it that you
want to run.
Then since you are on Windows 2000, you could setup Task Scheduler to run it
every night at whatever time yo
I seem to have answered my own question :-)
The answer is that you have to use -Q or --quote-names in mysqldump
Cheers!
Augey Mikus
Augey Mikus wrote:
> I am attempting to migrate a MySQL driven web application that, in my
> opinion, was designed by a stupid monkey. The php web frontend
i use mysql_pconnect in php, but after call
mysql_pconnect every time,i find that connection
increase one.it says in php manual, mysql_pconnect
will first try to find a (persistent) link that's
already open with the same host, username and
password. If one is found, an identifier for it will
be re
I want to write a batch file of sql statements so that I can schedule
this batch file to run at night automatically and send the sql commands
to a mysql database on a Win2K server. Does anybody have any experience
doing this? Any pointers in the right direction would be much
appreciated.
Tab
-
I am attempting to migrate a MySQL driven web application that, in my
opinion, was designed by a stupid monkey. The php web frontend
dynamically creates tables to store chunks of data rather than just
adding rows to existing tables. Don't ask me why! However, when
attempting to migrate the
* [EMAIL PROTECTED]
>
> I have a question on how MySQL JOIN has effect on query (search)
> performance:
>
> Our database consists of about 250.000 datasets (rows).
> Right now, all of the 150 columns are in one big table.
>
> However, we do have certain columns that are empty for most rows (for
>
I am sure I did something to set the skip counter, it might not have been that
command, but I am sure I did it somehow at the direction of someone else on the list
when I had problems before
-Original Message-
From: Harald Fuchs [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 10:
select id, product, min(price), store from tablename group by product
Better?
Regards
Chris
- Original Message -
From: "Ciprian Trofin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 28, 2002 1:24 PM
Subject: Re[2]: Join or smth.
> Doesn't work the way I want
Hi,
I must tell you something for nothing you try to kill the user, because
if he try twice to execute some query, MySQL 1-st time respond something
like "lost connction or Server is gone" and the 2-nd time recovery
the last connection.
Regards,
Gelu
_
Hi all!
Question. I try to understand with " 4.3 Foreign key constraints "
InnoDB Engine in MySQL-Max-3.23.50/MySQL-4.0.1.
I use MySQL Max (InnoDB) 3.23.49 for Win2000
I have created two tables:
CREATE TABLE parent (id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE
This is OT, perhaps post to comp.lang.perl.*?
Ric
p.s. try use DBI or use lib qw(/path/to/module)
- Original Message -
From: "Amy Zediak" <[EMAIL PROTECTED]>
To: "MySql List" <[EMAIL PROTECTED]>
Sent: Tuesday, May 28, 2002 3:01 PM
Subject: @INC
>
>
> I'm a little confused on ho
Hello,
excuse me. I've looked at the wrong place. I found the solution at
www.innodb.com:
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT,
INDEX par_ind (parent_id),
FOR
Markus,
Tuesday, May 28, 2002, 2:15:09 PM, you wrote:
>> You can use IGNORE keyword in INSERT statement, but it's not quite the
>> same as "INSERT IF NOT EXIST". If you specify IGNORE, any rows that
>> duplicate an existing PRIMARY or UNIQUE key in the table
>> will be ignored in INSERT:
ML> Yes
maxim,
Tuesday, May 28, 2002, 4:47:13 PM, you wrote:
m> Question. I try to understand with " 4.3 Foreign key constraints "
m> InnoDB Engine in MySQL-Max-3.23.50/MySQL-4.0.1.
m> I use MySQL Max (InnoDB) 3.23.49 for Win2000
m> I have created two tables:
m> CREATE TABLE parent (id INT NOT NULL,
sitnikov,
Monday, May 27, 2002, 10:32:07 PM, you wrote:
s> Description:
s> Problem with timestamp(8) and GROUP BY
s> How-To-Repeat:
mysql>> CREATE TABLE test (
s> -> id int auto_increment,
s> -> dd timestamp(8),
s> -> data int,
s> -> PRIMARY KEY (id)
s> -> );
s> Quer
You need to install DBI first.
Amy Zediak wrote:
>
>I'm a little confused on how to add things to @Inc path...i'm trying to
>install Msql-Mysql-modules and it says that my DBI/DBD is not in the
>@INC
>
>Thanks
>Amy
>
>
>
-
Be
On 28 May 2002, 14:20, Benjamin Pflugmann wrote:
> That's an FAQ and explained in the tutorial:
> http://www.mysql.com/doc/e/x/example-Maximum-row.html
~~~
Thanks for the link, which I've bookmarked. Thanks also to those
that responded off-list.
Unfortunately, the approach given in the tutorial
This example is in InnoDB though, which should support foreign key
constraints.
Chris Book
>>In other words data integrity between two tables is not ensured by MySQL.
Your application code must solve this.
-
Before posting, p
I think any descent server would be fine:
Linux/FreeBSD
dual PIII
512MB ram (or better 1GB)
2 scsi drives with raid1
Frankly, you could even get cheaper than that with 1 processor.
-Original Message-
From: Javier Armendáriz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 3:33 AM
Good morning, I'm trying to send an email to the list but this happens.
Im not sure if this is because it was an html email but I kept getting this:
**
Your message cannot be posted because it appears to be either spam or
simply off top
It is kinda old (3.23.32), but I did set some kind of skip counter before, just can't
remeber how I did it.
-Original Message-
From: Harald Fuchs [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 9:50 AM
To: [EMAIL PROTECTED]
Subject: Re: SET SQL_SLAVE_SKIP_COUNTER=
In article <[E
I am having a problem with a user having the correct privleges in mysql.
The user cannot connect to get access to the database, but everything looks correct to
me.
User table...
Host User Password Privs
localhostuser1password Only Y is for File_priv
ip_a
I am new to transactions in mySql
I am using Visual Basic to access a mySql database.
I had seen somewhere that to use transactions through ODBC you have to send
the commit and rollback commands like a select statement.
But even when I send the begin work before my other statements, the commit
is
I'm a little confused on how to add things to @Inc path...i'm trying to
install Msql-Mysql-modules and it says that my DBI/DBD is not in the
@INC
Thanks
Amy
-
Before posting, please check:
http://www.mysql.com/manual.php
try timestamp(14) instead.
[EMAIL PROTECTED] wrote:
>Description:
> Problem with timestamp(8) and GROUP BY
>
>How-To-Repeat:
>
>mysql> CREATE TABLE test (
>-> id int auto_increment,
>-> dd timestamp(8),
>-> data int,
>-> PRIMARY KEY (id)
>-> );
>Query OK, 0 rows affecte
That works perfectly. I did not know that you could alias a table name
multiple times to get multiple distinct selects out of it.
Simple yet elegant. Thanks.
> Hi.
>
> Presuming you have the team names in a seperate table, you could write
> something like:
>
> SELECT home.name, away.name, winn
Hi all!
Question. I try to understand with " 4.3 Foreign key constraints "
InnoDB Engine in MySQL-Max-3.23.50/MySQL-4.0.1.
I use MySQL Max (InnoDB) 3.23.49 for Win2000
I have created two tables:
CREATE TABLE parent (id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE
Greetings from Nairobi, Kenya
Try MySql Front
You can download it from www.mysqlfront.de
Kind regards
Njamba
- Original Message -
From: "andy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 27, 2002 4:48 PM
Subject: Visualizing the shema of the db
> Hi there,
>
> I am
Can someone tell me what the correct syntax for this is?
SET SQL_SLAVE_SKIP_COUNTER=n
Skip the next n events from the master. Only valid when the slave thread is not
running, otherwise, gives an error. Useful for recovering from replication glitches.
mysql> show slave status\G
*
I'm trying to find any and all thoughts on whether to store files in the db (PDF's,
word docs etc) or in the filesystem. If I do in the fs then there is tons of overhead
because of new folders, each client having thier own folder(and subfolders) etc. And
then htaccess'ing the dir's independentl
You will get better response if you post only once, and NOT as a reply
to someone else's question.
Peter Engström wrote:
>Hello everybody!
>
>How can I do a fulltext search on several tables
>with just one SQL query?
>
>Best regards
>/Peter
>
>
>
>--
Hi.
Presuming you have the team names in a seperate table, you could write
something like:
SELECT home.name, away.name, winner.name
FROM games, teams AS home, teams AS away, teams AS winner
WHERE home.id = games.homeid AND
away.id = games.awayid AND
winner.id = games.winnderid A
Hi.
That's an FAQ and explained in the tutorial:
http://www.mysql.com/doc/e/x/example-Maximum-row.html
Regards,
Benjamin.
On Tue, May 28, 2002 at 12:05:19PM +0100, [EMAIL PROTECTED] wrote:
> I'm a comparative MySQL newbie who is struggling with sub-selects. In
> other DBMS's, I can us
Hello.
Have a look at the isamchk tool. Be sure to make a backup of the table
in question beforehand and to shut down the server while the tool is
running.
Regards,
Benjamin.
On Tue, May 28, 2002 at 11:37:15AM +0200, [EMAIL PROTECTED] wrote:
> Hello list,
>
> In one of my mysql da
I am attempting to get mysql-max running with Innodb. I am using the
latest version .49 on a Redhat 6.2 server. The following is my my.cnf,
which I have placed in the /var/lib/mysql directory:
# Example mysql config file for medium systems.
#
# This is for a system with little memory (32M - 64M
Evgeny,
Tuesday, May 28, 2002, 12:23:58 PM, you wrote:
>>> When try to use BACKUP TABLE, i get an error
>>> 'Failed copying .frm file: errno = 2' in the result table.
>>> What's the problem?
RC>> BACKUP TABLE write files with the user MySQLd is running...
RC>> So if your deamon run as mysql, you
Karan,
Tuesday, May 28, 2002, 2:05:37 PM, you wrote:
KS> Dear Sir,
KS> I did all the steps to compile the code i.e.
KS> ./configure --prefix=/usr/local/mysql
KS> --with-named-curses-libs=/lib/libncurses.so.5.2
KS> make
KS> make install
KS> scripts/mysql_install_db
KS> and then I tried mys
Neville,
Tuesday, May 28, 2002, 11:23:06 AM, you wrote:
NL> this is the error message I get
NL> "Can't connect to local MySQL server through socket
NL> '/var/lib/mysql/mysql.sock' (2)"
NL> Why is this ?
Check permissions on the MySQL datadir. Look also into the .err file
in the MySQL data dir
1 - 100 of 144 matches
Mail list logo
