On Sun, May 05, 2002 at 07:42:13AM +0100, Alexander Shaw wrote:
>
> Using another machine (running windows) elsewhere on the network, is
> it possible to perform a mysqldump of the databases on the server?
> i.e. without having to go physically to the server machine and
> typing the commands at t
Paul DuBois wrote
"I can think of a couple of different ways to interpret your question.
Offhand, I'd say that you want to specify -h server_host on the mysqldump
command line, but if that's not what you mean, perhaps you can be more
specific."
Sorry probably not so well explained, I'll try agai
On Sun, May 05, 2002 at 03:21:59AM +0100, Donna Robinson wrote:
>
> explain select dances.danceid, dancetitles.title from dances,
> dancetitles where dances.danceid=dancetitles.danceid and
> dancetitles.title regexp "^A" and dances.has_desc='T' order by
> title;
[snip]
> This is TERRIBLE! But
On Sun, May 05, 2002 at 04:02:44PM +1200, Defryn NZ wrote:
> I have been trying to install mysql on my freebsd box but it won't work.
> When I use a freebsd package it works but it does not put it where I want
> it. It seems like there is little control over it
> The freebsd package is also an old
I have been trying to install mysql on my freebsd box but it won't work.
When I use a freebsd package it works but it does not put it where I want
it. It seems like there is little control over it
The freebsd package is also an older version (3.23.42)
I have downloaded the binary for freebsd from
filter-fodder:
Hi,
I am trying to speed things up a bit by indexing, but am having a bit of
trouble.
Take two tables:
TABLE dances (
danceid smallint(5) unsigned NOT NULL auto_increment,
ddref smallint(5) unsigned NOT NULL default '0',
has_desc enum('T','F') NOT NULL default 'F'
See section 3.5.4 of the manual. The example there can be adapted to give
you
the date of the max or min disk size in one query. You have it right for
MAX
and MIN; there is also an AVG function.
>From the manual:
``Can it be done with a single query?''
Yes, but only by using a quite inefficie
At 0:27 +0100 5/5/02, Alexander Shaw wrote:
>A quick query to save some shoe leather.
>
>Is it possible to perform a mysqldump from a remote windows client? Is so
>how?
I can think of a couple of different ways to interpret your question.
Offhand, I'd say that you want to specify -h server_host o
A quick query to save some shoe leather.
Is it possible to perform a mysqldump from a remote windows client? Is so
how?
Have searched the net and MySQL site but have found nothing definitive.
Alex
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.co
> I want to know what is the stable version of MySQL in XP.
That's 3.23.49, and you can download it here ('Windows downloads'):
http://www.mysql.com/downloads/mysql-3.23.html
Greetings
Reto Baudenbacher
-
Before posting, ple
> Fra: Nick Arnett [mailto:[EMAIL PROTECTED]]
> Sendt: 3. maj 2002 04:30
> Emne: Strategies for maintaining tables calculated from other tables?
>
>
> I'm finding that it's not quite as simple as I had imagined to maintain a
> table whose values are calculated by analyzing other tables. The sourc
Dear Helpinghand,
I am a new user of MySQL and my new operating system is WinXP. I want to
know what is the stable version of MySQL in XP. So if anyone know this
please help me.
I'm looking forward hearing from you.
Khyrul Islam
---
On my system error 28 is no space left on device.
harry@LordBlink:~> perror 28
Error code 28: No space left on device
You can verify that is the same on your system with the perror command that
should come with your MySQL installation.
If it is the same error then make sure that your datadir
could you tell me please, what can cause the bellow error?
Testing server 'MySQL 3.23.45' at 2002-05-04 20:10:55
Testing the speed of creating and droping tables
Testing with 1 tables and 1 loop count
Testing create of tables
Can't execute command 'create table bench_4497 (i int NOT NUL
Those are the actual table files that MySQL uses for the MyISAM table type.
You should be able to just copy them into the datadir under a database
directory and MySQL will find them and you should be able to use the tables
like normal after copying them. If you don't know where your datadir is yo
Hi all,
A colleague has created a database with MySQL. She has provided me three files
with the extensions .MYD .MYI .frm, to put them in the server. How can I
import
them into MySQL? I have MySQL 3.23.49 in Debian Linux 'potato'. I have used
myisamchk to check the database, but I do no
* John Berman
[...]
> SQL = "Select * From tbl_births Where RegDistrict Like '%"&term&"%'"
> SQL = SQL & " Or county Like '%"&term&"%'"
> SQL = SQL & " Or Date Like '%"&term&"%'"
> SQL = SQL & " Or pofbirth Like '%"term&"%'"
> SQL = SQL & " Or Forenames Like '%"&term&"%'"
> etc
>
> this if fine fo
At 12:29 -0400 5/4/02, Harrison C. Fisk wrote:
>Actually I think the SHOW TABLE STATUS like 'TABLENAME' command can show
>you the next auto_increment value.
There is no guarantee that this value will actually be used for the
next AUTO_INCREMENT value. Suppose another client issues the following
Hello
I want to make a fulltext searching of aprox. 2GB texts.
Can you help how to do it ? what database ?
I tried it with mysql, but when there was about 500MB,
the insert of article takes about 6 seconds.
hardware was: RAID 0 - 2x 10k U160 SCSI disks
In what hardware should I invest that it
Actually I think the SHOW TABLE STATUS like 'TABLENAME' command can show
you the next auto_increment value.
Although I can say I wouldn't really ever use it except for personal use,
not in an actual application.
Harrison
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "S
* Son Nguyen
> CREATE table test1 (ID int NOT NULL AUTO INCREMENT, name text, value
> text, Primary Key (ID));
>
> INSERT into test1 (name, value) values ("test1", "value1");
>
> INSERT into test1 (name, value) values ("test2", "value2");
>
> DELETE from test1 where ID=2;
>
> How can obt
At 9:01 -0700 5/4/02, Son Nguyen wrote:
> CREATE table test1 (ID int NOT NULL AUTO INCREMENT, name text, value
>text, Primary Key (ID));
>
> INSERT into test1 (name, value) values ("test1", "value1");
>
> INSERT into test1 (name, value) values ("test2", "value2");
>
> DELETE from test1 whe
Hi
Im still fairly new to this but have got a database online an dcan search on
a single file without any problems, Im using ASP to create my pages and all
is going well.
However I now want more, so Im trying to search across the whole dataset for
which Im doing something like
SQL = "Select * F
My new webhost has these two mysql servers installed:
MySQL 3.23.46
MySQL 4.0.1 alpha
which I am going to choose between...
(They say they first installed the alpha just for testing because some
customers requested it, but then kept it because they then thought it
was quite stable)
The best thing
CREATE table test1 (ID int NOT NULL AUTO INCREMENT, name text, value
text, Primary Key (ID));
INSERT into test1 (name, value) values ("test1", "value1");
INSERT into test1 (name, value) values ("test2", "value2");
DELETE from test1 where ID=2;
How can obtain the CURRENT value of next
* Colin Anderson
[...]
> SELECT a.name, b.value, bb.value
> FROM characters a, char_data b, char_data bb, char_data_type c,
> char_data_type cc
> WHERE a.id = b.character_id
> and a.id = bb.character_id
> and (b.char_data_type_id = c.id
> and b.value = '18'
> and c.type = 'Strength')
>
Hi everyone!
The mySQL DB I have to rebuild was only one big table. Afer developing a
new DB design for it, I ran into the problem of transfering the data
from the old to the new database.
I need to split up the records and insert them into the specific tables.
My problem is that I can not fig
This is still a little unclear. You want to check the query to see if it can be run
succesfully, or that it RAN succesfully. Perhaps I should as if you wish to check the
query before or after it runs?
Later on,
Terrence (BDKR)
- Original Message -
From: "mustafa karabulut" <[EMAIL PR
* Kory Wheatley
[...]
> I'm seeing some discrepancy in the operation of the SEC_TO_TIME
> function, however. Let's say my Duration is a value of 9.25. When I
> multiply 9.25 by 3600, I get 33300.00. When I use
> SEC_TO_TIME(33300.00), it returns 09:15:00, the correct value. But when
>
> I try
Just to make sure I understand you, you need to check the sql statements themselves
for errors. Is this correct?
Or, do you instead need to check that a query ran with success?
Late on,
BDKR
- Original Message -
From: "mustafa karabulut" <[EMAIL PROTECTED]>
Date: Sat, 04 May 2002 12:4
vigneshvg,
Saturday, May 04, 2002, 8:59:40 AM, you wrote:
v>Description:
v> I try to run the mysqld script to start the MySQL server. It starts, then
immediately I get a message saying it has ended.
v> [root@localhost init.d]# ./mysql.server start
v> [root@localhost init.d]# Starting mysqld da
NIPP,
Friday, May 03, 2002, 9:16:01 PM, you wrote:
Neoen> I have a column in a table that is currently configured as UNIQUE.
Neoen> I have recently discovered that some duplicates may exist in this column, so
Neoen> I want to remove the UNIQUE flag on this column. How? Thanks.
If you d
It would be nice to know what You're actually trying to do...
How do You want the get Your query back.. eh... "parsed"... ???
Or do You simply want to errocheck Your queries... ??
In this case You could run an "EXPLAIN " Query.
And then check for errors if any...
=d0Mi=
DCS.net
[EMAIL P
Hello,
I need sql statements parsed before they are sent to be queried. I
know-though I am not sure- mysql does these steps:
1-Parse sql statement,check for errors
2-execute the statement
Is there a way to intrude in between step1 and step2 so that we could get
sql statement parsed without i
34 matches
Mail list logo
