Dear list,
ERROR 1031 at line 5167: Table handler for 'total' doesn't have this option
I am trying to use mysqldump to backup my server to another. Can anyone tell
me what the above error means? Is it a column name or perhaps some data
that's conflicting?
Rgds
Terence
- Original Message -
At 10:23 pm -0400 11/06/02, R Talbot wrote:
>> My sense is that it's not as popular for use with MySQL as PHP or
>> Perl, but yes, there are people using it. A few of the MySQL books
>> out there have descriptions of how to use the Python interface for
>> MySQL, and (shameless plug) it's one
I'm using MySQL Max 4.0.1
CREATE TABLE TableTwo
(
Id int NOT NULL auto_increment,
FK_TableOne int NOT NULL REFERENCES TableOne(Id),
PRIMARY KEY (Id)
) TYPE=InnoDB;
--> How can this work without having beforehand created the table "TableOne"
???
On Wed, 12 Jun 2002, Christophe BRAM wrote:
> I'm using MySQL Max 4.0.1
>
>
> CREATE TABLE TableTwo
> (
> Id int NOT NULL auto_increment,
> FK_TableOne int NOT NULL REFERENCES TableOne(Id),
>
> PRIMARY KEY (Id)
> ) TYPE=InnoDB;
>
>
> --> How can this
-Message d'origine-
De : Tonu Samuel [mailto:[EMAIL PROTECTED]]
Envoye : mercredi 12 juin 2002 10:51
A : Christophe BRAM
Cc : [EMAIL PROTECTED]
Objet : Re: Foreign key integrity pb ?
On Wed, 12 Jun 2002, Christophe BRAM wrote:
> I'm using MySQL Max 4.0.1
>
>
> CREATE TABLE Tabl
I have a database called TracerLock. Right now it is in some kind of state
where queries involving the "user" table will hang:
SELECT count(*) FROM user;
but queries involving any other table run fine:
mysql> select count(*) from news_article;
+--+
| count(*) |
+--+
| 1335037
Hallo
Gibt es eine Möglichkeit meine vorhandene Access DB mit einer MYSQL DB
zu syncronisieren.
Das möglichst automatisch oder per Zeitauftrag.
Beim aktualisieren zwischen 2 Access Replikaten kommt ein Konflict
Manager zum tragen.
Gibts ähnliches zwischen MYSQL und Access auch?
Mit freundliche
Now for the folks who don't speak germen, I'll translate his msg:
Hallo,
Is there any possibitity to synchronise my Access datbase with a MySQL
database? If possible automatic or by user action.
While actualising between 2 access copies, there is a Conflict Manager who
helps with the actualisatio
Anil,
Tuesday, June 11, 2002, 8:29:16 PM, you wrote:
AG> The persmissions seems to be ok.
AG> ne other ideas!!
Check permissions not only files but on dirs, too.
Did you compressed table with myisampack?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This emai
Terence,
Wednesday, June 12, 2002, 10:20:03 AM, you wrote:
T> ERROR 1031 at line 5167: Table handler for 'total' doesn't have this option
T> I am trying to use mysqldump to backup my server to another. Can anyone tell
T> me what the above error means? Is it a column name or perhaps some data
T>
Rekha,
Tuesday, June 11, 2002, 8:48:12 PM, you wrote:
RD> Do I need to have some kind of permissions to change a variable ?
No, you should have permissions to run mysqld.
RD> Thanks,
RD> Rekha
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spons
Singleton,
Wednesday, June 12, 2002, 6:10:16 AM, you wrote:
S> I installed the binary from www.mysql.com for the stable release on aix 4.3.3 -- I
am getting the following errors from the libz.a library. I haven't been able to solve
the problem. Anyone
S> out there run into this problem?? The
Rekha,
Tuesday, June 11, 2002, 8:17:01 PM, you wrote:
RD> Where can I get a sample my.cnf?
You can find examples of *.cnf in /usr/doc/MySQL-X.XX.
RD> Thanks,
RD> Rekha
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://
At 11:26 12-6-2002, Wouter van Vliet shared with all of us:
[...]
>Now that I have translated his msg, me too would like to answer. I'll be
>having the some problem too, in some time. Off course I know of the
>possibilty for both to import and export text files (CSV format or anything
>alike) but
Looks like a MERGE table problem to me .. you can't insert data into this
table type because there's actually no data in it ;). You need to insert
data into one of the merged tables.
in version 4.x though, you can set something for the insert thing, so that
it will insert automatically in one of
N. Ott wrote:
> Hallo
> Gibt es eine Möglichkeit meine vorhandene Access DB mit einer MYSQL DB
> zu syncronisieren.
> Das möglichst automatisch oder per Zeitauftrag.
> Beim aktualisieren zwischen 2 Access Replikaten kommt ein Konflict
> Manager zum tragen.
> Gibt's ähnliches zwischen MYSQL und Acc
My dear friend,
Mounting more RAM, your friend don't must expect at "miracles". A server
machine (like your friends) will should run "easily" more then 20
concurrent users.
Your friend have a different kind of problem.
I think it's better to monitoring users activity using "top" utility.If are
th
Dear Gerald,
many thanks, it worked when I changed also in all files
of /var/lib/mysql/mysql/ the owner from "root" to "mysql".
I hope to find in the manual informations about this.
Best regards,
Ernst Hoermann
Gerald Clark schrieb:
> MySQL doesn't own the files.
> chown -R mysql /var/lib/my
merge/union...which i guess is the problem? is it not fully supported by
mysqldump yet?
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 5:33 PM
Subject: Re: MySqlDump
Terence,
Wednesday, June 12, 2002, 10:20:03 AM, you
Hello
MySQL 4.0.1 Solaris 2.7 official binary reproducibly crashes with sig
11 when run in a slave mode and when its master (4.0.1 official Linux
binary) is populated via "mysqlimport" tool from a remote machine.
Here are some interesting log files [edited]:
, $ mysqld --user=mysql
| 020612
Hi
I've got MySQL-4.0.1-2.i386.rpm installed on a PC here.
But I would like to do some changes to the fulltext search. Since I have to
compile from source to be able to change the stopword, can I make it so that
I only have to replace the old mysqld executable?
( downloaded mysql-4.0.1-alpha-pc-l
> Hi,
> I have set up a table with 3 fields. But I have forgetten to add a primary
> key (I'm not sure if its a primary key I want, I just want a
> auto-Increamentig field at the begging of the table.
>
> can anyone tell me how I do this.
>
> Cheers
>
sql
-
Hi all,
I have a serious problem.
I have a production system just launch using MySQL.
auto increment field is used in the system by ASP, Visual Basic and C.
System is using AIX 4.3.3, MySQL 3.23.49
gcc 2.9 source code compiled MySQL
There are some C compiled process using auto increment field c
I have picked up the 3.23.51 binary install and I
am getting the same errors as with 3.23.50.
What's next?
Morris Ford
--- Victoria Reznichenko
<[EMAIL PROTECTED]> wrote:
> Morris,
> Thursday, June 06, 2002, 6:17:57 AM, you wrote:
>
> MF> I am having a problem installing version
> 3.23.50
> MF>
When I try to make a backup executing the sql:
backup tb_name1, tb_name2 to 'c:\temp'
and I have a error like
"Failed copying .frm file: errno =3D 2"
What I have to do in this case.
Regards
Alexander
A busca mais veloz e precisa da internet. Ace
>
> Python has the ability to produce ( with modules) graphics for my
> database
> interface, outside of the Browser enviorment. Seems, from what I have
> read PHP
> is restricted to the Browser, is this correct?
>
Just to answer the question about PHP being restricted to the browser, the answe
In MySQL,
I want to use an auto-incrementing value that works
across multiple tables. For example I have 3 tables
forumA, forumB, forumC, each of which has a primary
key field called 'msgnum'. However, if I declare
'msgnum' auto_increment, 'msgnum' will not be
unique across the 3 tables.
Is there a mysql Windows client side binary
install available? Where can I get it?
Morris Ford
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
---
but it this a problem from the mysql??
I need to use this sql. I can't use mysqldump.
What is the solution for this problem??
Alexander
-- Mensagem Original --
>use mysqldump
>
>Agris
>
>agc> When I try to make a backup executing the sql:
>agc> backup tb_name1, tb_name2 to 'c:\temp'
>
>agc>
ÅÇ´f¼Ù(Borus.Kung) a écrit :
>
> Hi all,
>
> I have a serious problem.
> I have a production system just launch using MySQL.
> auto increment field is used in the system by ASP, Visual Basic and C.
> System is using AIX 4.3.3, MySQL 3.23.49
> gcc 2.9 source code compiled MySQL
>
> There are so
There are several graphical Windows clients available for mysql. The one I'm
using at the moment is from http://www.anse.de/mysqlfront/ and it's very
good. There's a newer one out though (sorry, don't have the URL) that is
more like MS SQL Query Analyzer. I have it installed on my desktop machin
Either shut your mysql server down before making the backup or exclude your
mysql directory from the backup and use mysqldump to dump the contents.
(Which is what I do every night.) Then backup the dump.
Even if nobody is using the server, mysql still holds the files open. There
are ways to back
Yes, you can compile from source, just make sure you specify the proper
directories in ./configure.
try
./configure --help | less
to see all the options.
Make sure you know where your mysql is installed now and where it's data is
now. Then specify those on the ./configure line.
With a little
HI,
I would like to know how can i resume errors in a Alter Table sentence.
I am doing a script that uses alter table to drop some columns of some
tables in my converted access to mysql database.
The problem is that if a column doesn´t exists in a certain table, the
script
* [EMAIL PROTECTED]
> When I try to make a backup executing the sql:
> backup tb_name1, tb_name2 to 'c:\temp'
>
> and I have a error like
>
> "Failed copying .frm file: errno =3D 2"
Strange... I get:
mysql> backup tb_name1, tb_name2 to 'c:\temp';
ERROR 1064: You have an error in your SQL syntax
In the last episode (Jun 12), leonardo klarmann porto said:
> HI,
> I would like to know how can i resume errors in a Alter Table sentence.
> I am doing a script that uses alter table to drop some columns of some
> tables in my converted access to mysql database.
> The problem is
Hi,
I have an installation of MySQL in Windows and another
one in UNIX Solaris 2.7. I need to move the databases
across system and I have manually ftped a database
directory from the Windows MySQL to the UNIX MySQL.
Fine, I can see the database, show tables works,
selects works. The whole nine y
On Wed, 12 Jun 2002, Francisco Reinaldo wrote:
> Fine, I can see the database, show tables works,
> selects works. The whole nine yards? Nope! I cannot
> insert any values in that database. I get the
> following error: "Table xxx is read only". I have
> checked the OS permission for that direct
Hi,
im currently developing a Webshop system. One of the new features of it
should be a "Costumers that bought this product also bought" feature -
concerning this im currently unsure how to implement it - (LAMPS) - my
current thought is following:
Costumer A buys Products with NO: 12, 13 , 2
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
first of all, I would like to take this opportunity to introduce myself: my
name is Lenz Grimmer and I have started working for MySQL as a product and
release engineer in April. For the last four years, I have been working for
the distribution de
Hello Oliver,
Thanks for the suggestion but that was not what I am looking for. I
know about the command SET AUTOCOMMIT=0 but that is a session level
solution.
I want transactions to be on always on the database for every session.
i.e. the default to 0 rather than the default of 1 as it
Terence,
Wednesday, June 12, 2002, 1:22:09 PM, you wrote:
T> merge/union...which i guess is the problem? is it not fully supported by
T> mysqldump yet?
MERGE tables only since 4.0 support INSERTs. If you look into dump
file you can see INSERTs for your MERGE table.
http://www.mysql.com/doc/
Jared,
Tuesday, June 11, 2002, 5:34:41 PM, you wrote:
JR> - Original Message -
JR> From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
JR> To: <[EMAIL PROTECTED]>
JR> Sent: Tuesday, June 11, 2002 10:03 AM
JR> Subject: Re: license...
JR> | Silmara,
JR> | Monday, June 10, 2002, 10:19:28 PM,
slz,
Wednesday, June 12, 2002, 5:29:52 AM, you wrote:
s> mysqlproblem still.prompt:"error 1045: access denied for
s> user:'@localhost'(using password:no)".i do 'status' from the mysql
s> prompt,it display current user:odbc@localhost,but i dont creat the
s> odbc user.
If you don't use user name a
Weaver,
Tuesday, June 11, 2002, 4:16:10 PM, you wrote:
W> Well, I'm under the impression that if the application you're selling
W> provides links to MySQL but not the database itself you don't have to pay
W> for a license for each sale; it's up to the buyer of the app to obtain a
W> MySQL license
aburbello,
Wednesday, June 12, 2002, 4:08:23 PM, you wrote:
a> When I try to make a backup executing the sql:
a> backup tb_name1, tb_name2 to 'c:\temp'
a> and I have a error like
a> "Failed copying .frm file: errno =3D 2"
a> What I have to do in this case.
Use slash '/' or double slash '\\'
Morris,
Wednesday, June 12, 2002, 5:04:09 PM, you wrote:
MF> Is there a mysql Windows client side binary
MF> install available? Where can I get it?
If you mean command-line mysql client program, it is in the Windows
installation package. MySQL binary distribution for Win includes all
client-side
Kaan,
Wednesday, June 12, 2002, 2:10:08 PM, you wrote:
>> I have set up a table with 3 fields. But I have forgetten to add a primary
>> key (I'm not sure if its a primary key I want, I just want a
>> auto-Increamentig field at the begging of the table.
>> can anyone tell me how I do this.
Take a
I wasn't asking a question. I was trying to answer one.
I obviously didn't do a very good job...:>)
--Walt
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 10:01 AM
To: [EMAIL PROTECTED]
Subject: Re: RE: MySQl price
Weaver,
Tu
I apologize greatly for this... but being so new to the UNIX
enviornment and Mac OS X, I couldn't figure out how to make mysqlbug
actually send out the report I generated from it. So I
copy-and-pasted the whole bug report (including comments) into an
email editor I am familiar with and emaile
Hi!
The download mirrors at www.mysql.com for the MySQL-Max version 3.23.51 do
not work yet, but let us hope the mirrors get up to date in a few hours.
InnoDB is a table type in MySQL which provides transactions, foreign key
constraints, and for which there exists a non-locking hot backup utilit
I use urSQL from http://www.urbanresearch.com/ursql.
On Wed, 12 Jun 2002 [EMAIL PROTECTED] wrote:
> There are several graphical Windows clients available for mysql. The one I'm
> using at the moment is from http://www.anse.de/mysqlfront/ and it's very
> good. There's a newer one out though (sor
Don't do it this way. Do something like the following:
Assume two tables, "transaction" and "itemlist".
transaction
---
transaction_id
customer_id
purchase_date
whatever other junk is relevant to a given transaction...
itemlist
transaction_id
item
At Wednesday 12/06/02 17:47, you wrote:
>good morninig
>
>
>how can i get like this prompt in my session:
>
> # (exemple #)
>
>Mysql
>Think you
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I'm confused about the meaning of the help text from ibbackup --help.
Here's the text:
"You should make backups of the .frm files... both BEFORE and AFTER ibbackup
finishes its work, and also store the MySQL binlog segment which is
generated between the moment you copy the .frm files to a backup
Isn't there an administrator on this list that can fix this? Who is
"w3e3demo" and why can't he/she be zapped?
-Original Message-
From: Mailer-Daemon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 11:34 AM
To: Orr, Steve
Subject: NDN: MySQL/InnoDB Hot Backups - What's a "binlog
I modified the mysql.users table incorrectly, changing domain "localhost"
for user "root" to "%" for user "root" without giving any other
permissions...
Now I can't get at any of my databases. What are the possible solutions?
is there a way to restore the default privileges table? reinititialize
Putting the efficiency issues aside to the extent we already have, I don't
see why you can't just use a simple join table for this purpose. You do have
the minor complication of symmetry, but with a simple ordering operation
against your original insertion join even this can be overcome.
Let's wri
I have a quick question regarding queries that involve values in ENUM
columns. Here's the scenario:
I have an ENUM column (category) that can have the values ('Gambling',
'Geographic', 'Medical', 'Sports'). Most of the records have only one of
the category descriptions but some are categorized
At 12:42 -0500 6/12/02, Jeff Field wrote:
>I have a quick question regarding queries that involve values in ENUM
>columns. Here's the scenario:
>
>I have an ENUM column (category) that can have the values ('Gambling',
>'Geographic', 'Medical', 'Sports'). Most of the records have only one of
>the
Does anyone know when and where will be the next mysql conference?
Danilo Djokic
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
I was wondering if someone could help me out with the syntax to use
mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've
tried a few variations of the command but with no luck so far. The
mysql server is running on RH 7.2 and the DAT tape drive is on that same
machine.
Any
Hello,
How does one create a MySQL table with a columns named something like
"creattime" and "modtime" where the creattime value for a record is set
to the current time when the record is created and the modtime value for
a record is set to the current time whenever the record is modified?
T
I have an sql database on my Verio hosted web site using MySQL.
In order to do an sql query I need the MyODBC on my computer.
I downloaded the current version of MyODBC (myodbc-2.50.39-win95.zip) and ran
setup.exe.
The installation stopped dead with the following error message:
An error occurr
At 11:10 -0700 6/12/02, pixelandink.com wrote:
>Hello,
>
>How does one create a MySQL table with a columns named something
>like "creattime" and "modtime" where the creattime value for a
>record is set to the current time when the record is created and the
>modtime value for a record is set to
Yes! My apologies; didn't have my coffee this morning. The column is of
type SET.
Jeff
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 12:50 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: ENUM query question
>
>
> At 12
Hello,
How does one create a MySQL table with a columns named something like
"creattime" and "modtime" where the creattime value for a record is set
to the current time when the record is created and the modtime value for
a record is set to the current time whenever the record is modified?
T
Hi,
Are at least 2 possibilities:
1.Is another process which maintain open this file.
2.MFC30.DLL it's corrupt.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMA
Does anyone know when and where will be the next mysql conference?
Danilo Djokic
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I'm finally jumping into playing with mysql, and talking to it with perl,
and I find that even though I did well in classes years ago in school
I really have no idea what I'm doing :-)
I've been working up the script to simply parse my da
Hi,
I'm using the unixODBC driver manager and MyODBC driver and trying to
connect to my clients database on the MySQL server. But it can't connect.
This is the message I get:
"Can't open lib /usr/local/MyODBC/lib/libmyodbc.so" : undefined symbol:
_dig_vec
How do I fix this?
-Hoa
In MySQL,
I want to use an auto-incrementing value that works
across multiple tables. For example I have 3 tables
forumA, forumB, forumC, each of which has a primary
key field called 'msgnum'. However, if I declare
'msgnum' auto_increment, 'msgnum' will not be
unique across the 3 tables.
T
I was wondering if someone could help me out with the syntax to use
mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've
tried a few variations of the command but with no luck so far. The
mysql server is running on RH 7.2 and the DAT tape drive is on that same
machine.
Any
Hi all,
Has anyone tried before to import data from an Access Table to a MySQL
Table? Actually, I just need to insert some of the columns and doing it
by hand seems quite a long thing to do
Thanks in advance,
Cesar Aracena
CE / MCSE+I
Neuquen, Argentina
+54.299.6356688
+54.299.4466621
__
We are using MySQL 3.23.42 on Linux and having some difficulties with
locks.
I was wondering if anyone out there has written any neat monitoring tools
or knows of
one that will alarm and send email when locks are excessive/persistent.
Thanks, in advance
Candy Bostwick
Ca
thanks all! as Danny Meidell had pointed out for me, the space between MAX
and (ID) i.e. MAX (ID) vs. MAX(ID) had caused the problem. After removing
the space the query works fine.
TA
Bill
-Original Message-
From: Alan Munter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 12:01
I have created a search page which shows all records from a table that
include one or more words of the search string. Is there a way I can
have MySQL sort the results according to relevance, and only display
each recordset once?
I am using ASP with IIS 5
txtSearch = Request("txtSearch")
ar
Greetings:
Perhaps a bug, even. After about 5 months my mysql log file grew to over
300MBytes and I figured I'd do something about it as follows:
tail -n 10 /mysql/why.log > /tmp/why.log && sudo mv /tmp/why.log /mysql/ &&
mysqladmin -u root flush-logs
Unfortunately, this set the permissions
Andy
2) Locks are by thread. If thread dies, so does
it's lock.
David
> -Original Message-
> From: Andy Sy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 12:03 PM
> To: [EMAIL PROTECTED]
> Subject: Auto-increment across multiple tables / Atomicity of update
> statements
Now the new binary (mysql-3.23.51-ibm-aix4.3.3.0-rs6000) gives the following error:
fowler2:singleto-/usr/local/mysql> ./bin/safe_mysqld &
[1] 28004
fowler2:singleto-/usr/local/mysql> ./bin/safe_mysqld[129]: 3998 Illegal
instruction(coredump)
Starting mysqld daemon with databases from /usr/lo
I've written a small port monitor in perl, just to check and make sure
something
is responding on the port. I don't want to do anything fancy, but it
appears that
MySQL doesn't like this. It doesnt block connections from localhost (thank
goodness), but my remote port monitor gets locked out.
Has anyone tried before to import data from an Access Table to a MySQL
Table? Actually, I just need to insert some of the columns and doing it
by hand seems quite a long thing to do?
I followed these instructions and it worked to a T
http://www.sbu.ac.uk/authoring/mysql/convert.shtml
Thank Yo
mysql> desc albums;
+-+-+--+-+++
| Field | Type| Null | Key | Default| Extra |
+-+-+--+-+++
| album_ID| int(11) | | PRI | NULL | auto_increment |
|
I was wondering if someone could help me out with the syntax to use
mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've
tried a few variations of the command but with no luck so far. The
mysql server is running on RH 7.2 and the DAT tape drive is on that same
machine.
Any
Hi,
I have been watching the list for a while now as I get to know
MySQL. I must admit that it is one of the more vibrant communities I
have encountered. I have seen many good answers and even better
questions, but I haven't seen my particular issues come up. I have two
questions, one spec
Never mind ... I made a mistake in the SQL statement !!! :-)
Son Nguyen
--- Son Nguyen <[EMAIL PROTECTED]> wrote:
> mysql> desc albums;
> +-+-+--+-+++
> | Field | Type| Null | Key | Default| Extra |
> +
If you are just doing a port scan, that shouldn't be a problem. However, if
you are going to the DB server, you will need to grant at least 'usage'
permissions to user@host via the GRANT statement.
Regards,
Bhavin.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECT
Steve,
the binlog is the MySQL logical log which it writes if you specify
[mysqld]
log-bin
in my.cnf. They are the files called 'hostname'-bin.00x in the datadir of
MySQL. They contain all INSERT, UPDATE, etc. SQL statements in an almost
human-readable form.
The binlog is used to recover from
> I was wondering if someone could help me out with the syntax to use
> mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've
> tried a few variations of the command but with no luck so far. The
> mysql server is running on RH 7.2 and the DAT tape drive is on that same
> machine
Are you using FULLTEXT indexes on the search coloumns? They will sort
results according to relevance (depending upon the algorithm, that might not
be what you want).
It will index most of the relevant words in your column (which should be a
TEXT or a VARCHAR field) and then search on those words.
Also, this might help
http://www.mysql.com/doc/F/u/Fulltext_Search.html
- Original Message -
From: "Nick Boldt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 12:49 PM
Subject: Sort search results by relevance
> I have created a search page which shows all rec
At 13:12 -0700 6/12/02, Van wrote:
>Greetings:
>
>Perhaps a bug, even. After about 5 months my mysql log file grew to over
>300MBytes and I figured I'd do something about it as follows:
>tail -n 10 /mysql/why.log > /tmp/why.log && sudo mv /tmp/why.log
>/mysql/ &&
>mysqladmin -u root flush-lo
This is a new area for me, so it may sound like a stupid question, but
what do you mean by FULLTEXT indexes?
P.S. the field I am searching is of VARCHAR type.
Nick Boldt
Computer Network Administrator
Track of the Wolf
Elk River, MN 55330
Tel: 763-633-2500 Fax: 763-633-2550
www.trackofthewolf.c
Candice Bostwick ([EMAIL PROTECTED])
Database Specialist (http://waterdata.usgs.gov/nwis)
USGS - National Center Reston, VA 20192
(703) 648-4878
__
We are using MySQL 3.23.42 and having some difficulties with locks.
I was wondering if anyone out there has written any neat mo
Ok. I think I can say nevermind. There must have been something wrong
with my script. Either that or the server must have actually been
down/inaccessible. I tried it again, and it seems to work now, even with
the host being blocked from accessing mysql
(it still manages to connect before it g
Paul DuBois wrote:
>
> At 13:12 -0700 6/12/02, Van wrote:
> >Greetings:
> >
> >Perhaps a bug, even. After about 5 months my mysql log file grew to over
> >300MBytes and I figured I'd do something about it as follows:
> >tail -n 10 /mysql/why.log > /tmp/why.log && sudo mv /tmp/why.log
> >/mys
Hi,
I have an installation of MySQL in Windows and another
one in UNIX Solaris 2.7. I need to move the databases
across system and I have manually ftped a database
directory from the Windows MySQL to the UNIX MySQL.
Fine, I can see the database, show tables works,
selects works. The whole nine y
if you have the file /usr/local/MyODBC/lib/libmyodbc.so, then do
ldd /usr/local/MyODBC/lib/libmyodbc.so
and see if all the dependencies are satisfied.
Regards,
Bhavin.
- Original Message -
From: "Hoa Doan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 11:52 AM
Thanks for the tip but I have added to the table db in
mysql database full permission for everybody to that
database. I don't think that is a permission thing
because when I add a new table, I can insert data into
that new table. Besides it does not happen when I copy
the database from UNIX to Win
Hi All,
some body knows mysql statistics:
# Programers in the world
# sites with MySQL database
# Companies to support MySQL
# sites in with MySQL database
Thanks for your help
Mario
-
Before posting, please check:
1 - 100 of 124 matches
Mail list logo
