But while I copied all the table files from A (testing machine) to machine
B (real server), no data was writing into A's tables.Are you saying
that I have to shut down the mysqld on machine A or activate WRITE lock to
A before copying over to machine B?
Qunfeng
At 02:52 PM 5/27
No, I didn't shut down mysqld or read lock. Would you please elaborate it a
little more on why? Thanks a lot!
Qunfeng
At 01:05 PM 5/27/2005, Eric Bergen wrote:
Did you shut down mysqld or read lock before copying the table?
Qunfeng wrote:
Hi,
I am running MySQL 4.1.8-Max-log on two
in advance!
Qunfeng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
text, I can
successfully load into all those records. Any idea why?
Here is my server info
$ uname -a
Linux machinename 2.4.21-9.0.3.ELsmp #1 SMP Tue Apr 20 19:49:13 EDT 2004
i686 i686 i386 GNU/Linux
MySQL version is 4.1.8-standard
Thanks!
Qunfeng
--
MySQL General Mailing List
For list archives: h
:-) I see. Thanks! It w(not vv)orks!!!
Qunfeng
At 10:48 PM 12/21/2004, Paul DuBois wrote:
At 20:44 -0600 12/21/04, Qunfeng wrote:
Paul,
Thanks for your reply. I tried
mysql -p -w DB < test.sql
still no warning.
I tried -vw
it simply echo the sql statement, no warning.
I didn't suggest usi
Paul,
Thanks for your reply. I tried
mysql -p -w DB < test.sql
still no warning.
I tried -vw
it simply echo the sql statement, no warning.
Qunfeng
At 05:45 PM 12/21/2004, Paul DuBois wrote:
At 17:43 -0600 12/21/04, Qunfeng wrote:
Hi,
I am using mysql 4.1 on linux.
When I execute an mysql comm
s matched: 2 Changed: 0 Warnings: 2
However, if I put the same command into a file and run mysql command-line,
no warning or any message was given. I have no idea if there is anything
wrong or how many records got changed.
$ mysql -p DB < test.sql
Is there any way I can show the warning an
Hi,
I am running 4.1.0-alpha on a linux machine. When I use mysqlimport to load
a big data file (~7 Gb), I get an error "mysqlimport: Error: The table
'mytable' is full, when using table: mytable.
I guess the table is too big. Is there any solution for this problem?
Thanks a mi
Hi,
MySQL seems to be able to JOIN columns with different types, e.g., one
column type is int; the other type is varchar. My question is: how badly
does that affect the join performance even though both columns are indexed.
Thanks!
Qunfeng
--
MySQL General Mailing List
For list archives: http
full text search is different than pattern match. If
you want to return stef, you have to use pattern
match.
Qunfeng
--- "Steffan A. Cline" <[EMAIL PROTECTED]> wrote:
> Am I missing something on mysql full text search?
>
>
> I was using a simple statement like
>
.
Qunfeng
--- Frank Peavy <[EMAIL PROTECTED]> wrote:
> Qunfeng,
> ..millions of records.. seems like a lot...
> Would you be kind enough to provide me with your
> hardware configuration?
> Thanks.
>
>
> At 07:57 AM 12/31/02 -0800, Qunfeng Dong wrote:
> >If you are
too bad. Maybe
you can still use fulltext search for general cases;
and use pattern match ONLY when you are searching for
3-char-term. You should be able to make such "Switch"
through your interface.
Qunfeng
--- Frank Peavy <[EMAIL PROTECTED]> wrote:
> Qunfeng,
> Than
It can perform pattern match on text field. The only
draw back is the speed (especially if you are using
%pattern% to do the search) when you tables are
getting huge, since there is no index to help.
Qunfeng
--- Frank Peavy <[EMAIL PROTECTED]> wrote:
> I would like to use pattern matc
wing the "Duplicates"? They are NOT
duplicate because the count(*) with the whereclause
returns 0 records before the above "replace ...
select"
mysql> select count(*) from table2 where clause;
+--+
| count(*) |
+--+
|0 |
+--+
I am using mysql3.2
was not all
numerical for different type of Sequences; but I
managed to assign numerical code to those
non-numerical ones now.
Qunfeng
> > CREATE TABLE NewSequence
> > (
> > Seq_ID varchar(50) NOT NULL,
> > GenBank_Acc varchar(1
replace missing value (NULL) as \N in your .txt file
--- Gianluca Carnabuci <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've been trying to import a huge .txt file into a
> MySql table. In the .txt file, missing values are
> recorded as empty cells (it might be that there's
> some hidden character inste
ning MySQL 3.23.49 on RedHat linux 7.3 on a
dedicated server with 4 GB memory. The only setting I
changed is to copy the my-huge.cnf into /etc/my.cnf.
Qunfeng
--- "Michael T. Babcock" <[EMAIL PROTECTED]>
wrote:
> Qunfeng Dong wrote:
>
> >not-so-good performance (join
_Homolog
(
Seq_ID varchar(50) NOT NULL,
Homolog_PID int NOT NULL,
Homolog_Descvarchar(50) NOT NULL,
Homolog_Species varchar(50),
PRIMARY KEY (Seq_ID, Homolog_PID)
);
--- "Michael T. Babcock" <[EMAIL PROTECTE
MySQL? How
much time have you spend on fine-tune the performance?
Qunfeng
--- Peter Vertes <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've been using MySQL intercompany for a while now
> with great results. Even the diehard MSSQL people
> are amazed at how fast it can be
size
limit for file. MySQL seems to store each of its table
as single file. You need to choose a file system
without that limit.
Qunfeng Dong
--- "B.G. Mahesh" <[EMAIL PROTECTED]>
wrote:
>
> hi
>
> We are evaluating few databases for developing an
> application
chown -R mysql:mysql /home/medic/
and make sure there is no outfile.txt already in that
dir.
--- sam <[EMAIL PROTECTED]> wrote:
> I executed the following statement:
>
> SELECT * INTO OUTFILE '/home/medic/outfile.txt' FROM
> fool;
>
> I get the error meassge
>
> " Can't create/write to file
> '
I also got that msg and I did seem to receive all the
emails from the list.
Qunfeng
--- Bill Rausch <[EMAIL PROTECTED]> wrote:
> I just got a message from the ezmlm program telling
> me that the
> mysql digests have been bouncing and it is going to
> remove me from the list.
y create a test table
create table testTable(
Seq_ID char(20),
Title varchar(100)
);
Qunfeng
--- "Stefan Hinz, iConnect (Berlin)"
<[EMAIL PROTECTED]> wrote:
> Qunfeng,
>
> > A simple left join on two big table took 5 mins to
> > finish.
>
> These li
| rows| Extra |
+---++---+-+-+--+-+---+
| s | ALL| NULL | NULL|NULL |
NULL | 2684094 | |
| h | eq_ref | PRIMARY | PRIMARY | 50 |
s.Seq_ID | 1 | |
+---+----+--
umnb are varchar(11) and indexed.
Table B has about 34,000 records and Table A has about
2,500,000 records. The above query took about 3 hours
to finish. Something is just not right.
Qunfeng Dong
--- David Bordas <[EMAIL PROTECTED]> wrote:
> > I wish to tune our MySQL Server Par
Isn't NULL value in MySQL stored as '\N'? If so, you
can check that in your perl script.
Qunfeng
--- David Wu <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> Running into a frustrating problem. When I have a
> empty table in mysql
> database, i tried run a sele
-O sort_buffer=4M -O
read_buffer_size=1M &
My questions: if I run the above command (as root),
should I run it every time when the server starts? If
so, how can I set the above option automatically when
server starts. Thanks!
Qunfeng Dong
__
Hi, Can anybody give me a simple example of using
PHP's mysql_query to perform mulitple mysql queries. I
am using MySQl 3.23, trying to use create temporary
table and insert ... select to overcome the lack of
union operation in that verion of MySQL.
Thanks!Qunfeng
28 matches
Mail list logo