Dear friends,
I import data to my table,from CSV file.CSV file has emails in each row.
While importing, A window pops up stating number of rows imported, however when I
see the table, nothing has been imported.
Version of mysql, gui and structure of table has been pasted.
Any guidance with
Hi All,
I am getting very weired problem after shifting our server. here is the
details:-
I have a table with two columns
1-TimeStamp timestamp(14)
2- SID bigint(20)
when inserting _INSERT INTO _/_TABLENAME values (1258975462,125987)_
results in /_INSERT INTO _/_TABLENAME values
Do you mean SQLYog? If so, this is a MySQL GUI - Info. at:
http://www.webyog.com/sqlyog/index.php
John R. Porter
I.T. Services
University of Strathclyde
Faculty of Education
76 Southbrae Drive
Glasgow
G13 1PP
e-mail: [EMAIL PROTECTED]
Tel. 0141 950 3289
-Original Message-
From: Robert J
Hi, I'm stuck on this really badly. Can anyone help me out please?
Thanks,
JS.
I tried running the create index again using --verbose but this is all I
got:
ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STLd39Et'
(Errcode: 27)
--
CREATE INDEX timeindex ON internet_usage
Hi,
We have an environnment with a master and a slave. We run a script every
hour (on the master only) that does something like this to backup some
parameters :
insert into backup(NULL,NULL) VALUES(NULL,NOW())
SET @backup_id = @@LAST_INSERT_ID
INSERT INTO backup_param ( SELECT @backup_id, col1,
Hello,
SQL Maestro Group is happy to announce the release of SQL Data Wizard
1.3 - a powerful Windows GUI utility for MySQL data export, import,
database conversion and PHP script generation. The trial version of the
software is available at
Invalid entry format for the timestamp field. Did this work before?
-Original Message-
From: Tariq Murtaza
To: [EMAIL PROTECTED]
Sent: 7/26/04 4:43 AM
Subject: Weird problem for TIMESTAMP feild
Hi All,
I am getting very weired problem after shifting our server. here is the
details:-
I
I am looking for a string substitution command in MYSQL and was
wondering if anyone can help me. Searching the archives was not
fruitful. Here is an example :
CREATE TABLE tbl (id INT(2), names VARCHAR(20));
INSERT INTO tbl VALUES (1, 'aaa');
INSERT INTO tbl VALUES (2, 'bbb; aaa; ccc');
How often do you optimize/analyze your tables? Have you checked the index
cardinality? What does an explain plan show?
-Original Message-
From: Julien Lavigne du Cadet
To: [EMAIL PROTECTED]
Sent: 7/25/04 4:26 PM
Subject: Slow server - any idea?
Hi eveybody,
I've got problems since a few
Try using the REPLACE command.
-Original Message-
From: Adaikalavan Ramasamy
To: [EMAIL PROTECTED]
Sent: 7/26/04 8:04 AM
Subject: String substitution in MYSQL
I am looking for a string substitution command in MYSQL and was
wondering if anyone can help me. Searching the archives was not
( if this is a FAQ or better asked elsewhere, can someone point me in the
right direction? )
In general, what are the rules for using MySql as the database in a
commercial software package?
I am writing faxing software in windows. Currently it is just used by the
client who paid me to write a
Have you tried using the last insert id function instead?
SET @backup_id = last_insert_id()
-Original Message-
From: Philippe Poelvoorde
To: [EMAIL PROTECTED]
Sent: 7/26/04 7:03 AM
Subject: Replication script pb
Hi,
We have an environnment with a master and a slave. We run a script
According to the docs (http://dev.mysql.com/doc/mysql/en/DATETIME.html)
The number 1258975462 equates to the date 1258-97-54 62:00:00 which is
not a valid date. That's why you get the zero date value.
That number could also equate to a unix_timestamp() value for the date
2009-11-23 06:24:22
Thank you ! Works like a charm. Here is the successful syntax
UPDATE tbl SET names = REPLACE(names, 'aaa', 'zzz');
I found this link to be quite useful
http://www.jayallen.org/journey/2004/04/how_to_perform_a_mysql_search_and_replace
Regards, Adai.
On Mon, 2004-07-26 at 14:07, Victor
Hi List,
I figured out the fix for it. I need to do a sync and wait for the sync to get over
and take a backup.
Thanks,
Sp.Raja
Original Message
From: Sp.Raja [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Fri, Jul-23-2004 8:03 PM
Subject: Re: Innodb assertion
Hello,
I have a question related to nested sets:
On my website a user should be able to create subusers and give them the
rights to add/change/delete subsites of the users website. If I remove one
or more rights to a user all of its subusers should have the same
restrictions as the user. If I
If you go through the online manual of mysql, it points out that mysql
can be used under gpl (then you have to be giving away the source code
for your software with mysql) or else you have to purchase mysql
commercially. In your case you sure need to buy it.
On Mon, 2004-07-26 at 08:11, Steve
Hi,
I'd like to know how you guys write SQL command for this problem. there are
some categories which I give them A, B, ... and I have a string field
(catstr) with 10 characters in mytable to keep selected categories in a
record. when user selects C, G, K, I keep CGK in catstr field.
categories
Perhaps I misunderstood the license but it would seem to me that for the
original use, a commercial license is *not* needed, since anyone can
privately use MySQL for their own private commercial use without a license
(I think). From what I understand the only need for a commercial license
comes
Hi Terence,
Hi all,
My system reports:
Open_tables 512
Opened_tables 24,429
The docs say that if the latter is high I should increase the table
cache size. (currently at 512)
Looks like you should do that.
How does one decide what size to increase it to? And is there a
problem
with
Hi,
I'd like to know how you guys write SQL command for this problem. there
are
some categories which I give them A, B, ... and I have a string field
(catstr) with 10 characters in mytable to keep selected categories in a
record. when user selects C, G, K, I keep CGK in catstr field.
Hi
Though I would like to look up a way to implement what you want in
MySQL, one thing was indicative and I wanted to point out.
If, say there was a way, you could remove the c and d rights from
subsequent users by removing it from User2, I think you are talking
about some kind of history
I am creating a small database that keeps track of users and assigns
them a unique user ID.
The problem is that sometimes the users might request to be added more
than once (i.e. click on the submit button multiple times). Therefore I
only want to add users if their details (here defined by both
You should never create multi-purpose fields that you will need to use
to reference other data, which is what you did here. The database can't
use an index because the codes are not in set positions.
You need to create a table for linking the categories with mytable,
since you are trying to
May I suggest a design change as a solution? I would suggest that you
should create a user/category table to replace your catstr field:
CREATE TABLE user_category (
user_Id int not null,
category_Code char(1) not null
UNIQUE (user_Id, category_Code)
)
There will be one record in the
Adaikalavan Ramasamy [EMAIL PROTECTED] wrote on 26/07/2004
16:05:23:
I am creating a small database that keeps track of users and assigns
them a unique user ID.
The problem is that sometimes the users might request to be added more
than once (i.e. click on the submit button multiple
Hi,
I'm using MySQL 4.0.20 on a fairly loaded server, running OpenBSD 3.5 (P4
3Gz, 2GB RAM, SCSI U160 36GB disks), and the database itself is around
8GB. There are a couple of large tables (2.000.000 rows), but most of
them are small.
The data is retrieved intensively, so we can build reports
Your model is flawed.
My son and I have the same first and last names.
Therefore, we could not be users on your system.
Adaikalavan Ramasamy wrote:
I am creating a small database that keeps track of users and assigns
them a unique user ID.
The problem is that sometimes the users might request to
Thanks Alec ! This works wonderfully.
But I have another related question. How do I write an IF ELSE command
with MYSQL. In this context, I want it to return myID if the record
already exists, otherwise insert into database.
This naive syntax does not work :
IF EXISTS (SELECT myID FROM tb WHERE
Richard Clarke [EMAIL PROTECTED] wrote:
It is the proper binary from mysql.com.
mysql-standard-4.1.3-beta-pc-linux-i686.tar.gz
I have also filed a bug report for this problem. #4673
There is some extra information in the bug report describing what my
application does.
Okay, thank you.
As I understand from the following link
http://dev.mysql.com/doc/mysql/en/Using_the_MySQL_software_under_a_commercial_license.html
You need to buy a commercial license if the software you are developing
is not to be registered under GPL.
Aman
On Mon, 2004-07-26 at 09:55, Issac Goldstand wrote:
Andrew Hill [EMAIL PROTECTED] wrote:
Perhaps it would be better to insert the timestamp, rather than letting
MySQL set it.
Sure. This gives consistency in your situation.
Or, is there perhaps a way to let MySQL select which table
to perform the insert into, based on the time?
No.
-Original Message-
From: Michael Abbott [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 11:28 AM
To: [EMAIL PROTECTED]
Subject: RE: using mysql in commercial software
This may not be strictly legal, but you could have the end user download
MySQL.. to run with your
Stefan Klopp [EMAIL PROTECTED] wrote:
We recently upgraded our mysql server from 3.23 to 4.0.18 and have found
that all of our Unicode characters are now being displayed as question marks
(?). Anyway this only happens when viewing over the web as when we view via
the shell mysql we can see
Hello Aman,
[..]
I think he was talking about user roles.
one creates a role and then assigns that role to the users.
When one changes the role rights then automatically users' rights
change according to the roles they have.
The main problem I have to do the rollback. A 2nd table is no
Michael Sleman [EMAIL PROTECTED] wrote:
key_buffer = 384M
Try to enlarge this up to, say, 1G and check it out how that helps.
sort_buffer_size = 2M
You may want to enlarge this as well.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Levi Campbell [EMAIL PROTECTED] wrote:
Okay, I got the RPM package installed but when I use rpm -I =
mysql-server-4.0.20-0.i386.rpm, I am told that I need several files, =
most of which I can't find in the Debian package library. I need the =
following files: /usr/bin/perl, sh-utils and sh,
Will Martell [EMAIL PROTECTED] wrote:
Not a MySQL issue. MySQL is a standalone native Win32 application that does not
need Cygwin. The same applies to MySQL command-line client.
Thank you for reading this email.
I have the following Configuration
Windows 2000 Server
MySQL Win32 Binaries
Jim McAtee [EMAIL PROTECTED] wrote:
Can I easily restore individual databases and/or individual tables from a
backup made with mysqldump?
Yes if you will individually dump the tables.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored
Scott Haneda [EMAIL PROTECTED] wrote:
I was just reading a forum post on mysql, someone said it was possible in
mysql 4 to insert data into more than one table at once. Is this possible,
if so, where in the docs can I see a example of this?
Not possible. What is possible is inserting several
Redmond Militante [EMAIL PROTECTED] wrote:
i have a large text blog that i want to extract strings out of.=20
the large text blob
See http://dev.mysql.com/doc/mysql/en/String_functions.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Hello Aman,
Monday, July 26, 2004, 6:03:07 PM, you wrote:
Hello,
I have a question related to nested sets:
On my website a user should be able to create subusers and give them the
rights to add/change/delete subsites of the users website. If I remove one
or more rights to a user all of
In light of the licensing restrictions on using MySql in a commercial
package, why would MySql be prefered over Firebird or SQL Server 2005
express edition. Both appear to be no charge to redistribute compared to the
$250 for MySql.
http://firebird.sourceforge.net/
Michael Gale [EMAIL PROTECTED] wrote:
Please install MySQL official binary downloaded from http://www.mysql.com/ and
check if the problem is gone. It very much looks like some build issues.
Also please check that MySQL has enough memory to run - i.e. the key_buffer
variable is reasonably high
On Mon, 2004-07-26 at 10:24, DebugasRu wrote:
Hello Aman,
Monday, July 26, 2004, 6:03:07 PM, you wrote:
Hello,
I have a question related to nested sets:
On my website a user should be able to create subusers and give them the
rights to add/change/delete subsites of the users
Ginger Cheng [EMAIL PROTECTED] wrote:
If a table has a column defined as 'float not null' and the corresponding
txt file used to load it have sth like 'nan' for the column, although
giving warnings, the record will be loaded and the column looks like 'nan'
by using mysqlimport. But
james patrick [EMAIL PROTECTED] wrote:
I previously had a server runnning RH 7.3, cPanel 9.41 and MySQL
4.0.20. I'm moving to a different server running Fedora 1, DirectAdmin
and MySQL 4.0.17.
I have a large database (200mb) and I'm trying to move it over.
200mb is not a large database.
from http://dev.mysql.com/doc/mysql/en/INSERT.html:
14.1.4 INSERT Syntax
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES ({expr | DEFAULT},...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
...
If you specify the ON DUPLICATE KEY UPDATE
Thank Martijn, Brent, and Shawn so much! I did not know about GROUP_CONCAT() funtion.
I checked MySQL document page but just under string function in User Comments
section there was an example of using it. Shawn, where can I find the syntax of this
command? it looks like we can pass some
This seems more like the solution I want. I am using perl-DBI and when
there is an error (i.e. duplicate insert), the rest of the scrip it not
executed. But this is gives me the following error. What am I doing
wrong ?
mysql desc tb;
I am using a development build of 4.1.3 (the last 4.1.3 release I think;
mysql-4.1.3-beta-nightly-20040628) so I suppose I have this coming, but
here goes:
As I am running on RH Enterprise Server 3 with a Pentium Xeon (32-bit)
According to the documentation, for a 32 bit processor, I should be
Does anyone know what goes on (system wise) during the CREATE INDEX ? I can
see it's copying the table file, what then though?
Hi, I'm stuck on this really badly. Can anyone help me out please?
Thanks,
JS.
I tried running the create index again using --verbose but this is all I
got:
ERROR 3 at
Adaikalavan Ramasamy wrote:
This naive syntax does not work :
IF EXISTS (SELECT myID FROM tb WHERE firstname='Jack' AND
lastname='Doe') ELSE (INSERT INTO tb(firstname, lastname) VALUES
('Jack', 'Doe');
Assuming you have the unique index on (firstname, lastname), just do
INSERT IGNORE INTO tb
Yes, this does what I want and does not produce an error (which caused
the remaining MYSQL syntax not to be executed). The firstname, lastname
was for example only. In my problem, these are two different identifiers
so I am not worried about multiple dual identifiers.
Thanks to Keith Ivey, Alec
At 20:58 -0600 7/21/04, Jim McAtee wrote:
(Apologies in advance for the crossposting, but I asked the same questions
on the MySQL Windows list and didn't get any replies)
I need a simple backup mechanism for MySQL (3.2x) that will backup all
databases on a server. Something that can be run from a
Adaikalavan Ramasamy [EMAIL PROTECTED] wrote on 26/07/2004
16:31:44:
But I have another related question. How do I write an IF ELSE command
with MYSQL. In this context, I want it to return myID if the record
already exists, otherwise insert into database.
This naive syntax does not work :
Mysql is easier to install than Firebird and runs in more Operative
Systems than SQL Server.
Steve Richter wrote:
In light of the licensing restrictions on using MySql in a commercial
package, why would MySql be prefered over Firebird or SQL Server 2005
express edition. Both appear to be no
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
Is where you will find the GROUP_CONCAT function in the manual.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Mojtaba Faridzad [EMAIL PROTECTED] wrote on 07/26/2004
11:34:30 AM:
Thank Martijn, Brent, and
At 14:32 -0700 7/22/04, Scott Haneda wrote:
I was just reading a forum post on mysql, someone said it was possible in
mysql 4 to insert data into more than one table at once. Is this possible,
if so, where in the docs can I see a example of this?
Scott,
Perhaps you could ask someone to provide an
On Mon, 26 Jul 2004 17:47:37 +0100, Adaikalavan Ramasamy
[EMAIL PROTECTED] wrote:
This seems more like the solution I want. I am using perl-DBI and when
there is an error (i.e. duplicate insert), the rest of the scrip it not
executed. But this is gives me the following error. What am I doing
You must be getting an error code when inserting now.
If that is related to index file size (that's what I had)
.
You can do ALTER TABLE tablename MAX_ROWS=big_num
On Mon, 2004-07-26 at 11:48, Michael Dykman wrote:
I am using a development build of 4.1.3 (the last 4.1.3 release I think;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve Richter wrote:
| In light of the licensing restrictions on using MySql in a commercial
| package, why would MySql be prefered over Firebird or SQL Server 2005
| express edition. Both appear to be no charge to redistribute compared
to the
| $250
Note: I installed MySQL on my labtop (a Windows XP machine) which is
located at the same site as the Oracle server, just to compare the insert
times with the remote MySQL database. Inserts which were taking over 4
minutes were now completing in 90 seconds or less. Approximately 1 second
per
At 12:48 -0400 7/26/04, Michael Dykman wrote:
I am using a development build of 4.1.3 (the last 4.1.3 release I think;
mysql-4.1.3-beta-nightly-20040628) so I suppose I have this coming, but
here goes:
As I am running on RH Enterprise Server 3 with a Pentium Xeon (32-bit)
According to the
This is a follow-up to my original post from yesterday. I've narrowed down
the problem to the test-connect script.
C:\mysql\benchperl test-connect --user=root --password=tops3cr3t
Testing server 'MySQL 4.0.20a nt' at 2004-07-26 13:01:26
Testing the speed of connecting to the server and sending
Steve Richter wrote:
-Original Message-
From: Michael Abbott [mailto:[EMAIL PROTECTED]
Sent: Monday, July 26, 2004 11:28 AM
To: [EMAIL PROTECTED]
Subject: RE: using mysql in commercial software
This may not be strictly legal, but you could have the end user download
MySQL.. to
FirebirdSQL is an excellent project, but as far as I know there is not a
single organization that stands behind it providing support, training,
etc. as MySQL AB does with the MySQL product line.
Might want to take a look at http://www.ibphoenix.com/
Training is pretty pricey, but it's there.
I've optimized the main tables (the forums one and a few others) a few days
ago.
About index cardinality, I don't know what to tell you. For a few tables it
is high, like for the vbulletin postindex (higher than 11 000 000) but it's
absolutely normal for such a forum.
And about explain, we've
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
|FirebirdSQL is an excellent project, but as far as I know there is not a
|single organization that stands behind it providing support, training,
|etc. as MySQL AB does with the MySQL product line.
|
|
| Might want to take a
Hi all,
If I write a comercial software that allow my customer at instalation time
to select between mysql, interbase or other data base is it legal?
Regards,
Laercio.
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: segunda-feira, 26 de julho de 2004 15:26
To:
Hello,
I am trying to write a db creation script that will create a database as a well as
repair an existing database. What I can't seem to find is a set of key words that
will allow me to detect if a column or index already exists in a table and thus skip
the creation of the column or index.
Hey,
I am trying to create an index on a varchar column, but I am getting a
suspicious error I am unable to overcome.
Indeed there are duplicated rows but since there is no constraint nor a
key in the table, I do not see why this error is generated.
I would appreciate some help.
Here are the
At 14:08 -0500 7/26/04, Ghate, Shishir wrote:
Hello,
I am trying to write a db creation script that will create a
database as a well as repair an existing database. What I can't
seem to find is a set of key words that will allow me to detect if a
column or index already exists in a table and
[Aman's view of my problem]
Hi,
I think you know what my problem is.
My solution so far is (from another mail):
-- snip --
The main problem I have to do the rollback. A 2nd table is no option
because it might be possible that another users rights get be change before
the rights of the first
I guess that would depend on what kind of license your database connection
libraries come with.
** DISCLAIMER ** I AM NOT A LAWYER and THIS IS *NOT* LEGAL ADVICE.
**DISCLAIMER **
Whenever I ask myself can I sell what I just created and keep my source
code hidden, I rely on several factors:
I totally recommend Paul Dubois's book.
Excellent book I own the first edition.
I bet the second edition is just
as good and more up to date.
Paul DuBois wrote:
At 1:55 +0200 7/26/04, Schalk Neethling wrote:
Can anyone suggest o great book to learn MySQL inside out? I am
thinking of getting:
Hi Steve,
In light of the licensing restrictions on using MySql in a commercial
package, why would MySql be prefered over Firebird or SQL Server 2005
express edition. Both appear to be no charge to redistribute compared to
the
$250 for MySql.
http://firebird.sourceforge.net/
Sorry to re-send, but I lost some mail and thought perhaps this was
answered and I missed it, but looking at the archives I don't see any
replies.
Thanks!
Charles
I have a quick question about how programs linked against the mysql C
libraries handle the following:
-assume three mysql hosts,
I executed the following preparation work:
1. Upgraded Mac OS X 10.3.1 to 10.3.4
2. Installed two additional security updates
3. Examined the status of the Xcode packages
pre-installed on the box Documentation states it is
Xcode 1.0 for Mac OS 10.3 Panther
4. I ran all installers except, CHUD,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martijn Tonies wrote:
[snip]
| SQLExpress is not MSDE, it looks like it though. SQLExpress
| has a 4Gb limit/database and I don't recall a user limit, but a
| concurrent-load limit of 5. That is, many can connect, but only
| 5 concurrent batches
thank you for the suggestion, I will give that a try. I thought it
suspicious that the table stopped receiving data at 2 bytes under the
natural 4G limit (8 byte int) which was standard under 3.22. As I said,
I am using a development release and I have found 1 or 2 other
regression errors along
I looked at the SHOW COLUMNS statement and they have what I want, but I need to
condition off them. For example, I don't want to execute an ALTER TABLE command to
add a column if that column is already there. I've tried IF DOES NOT EXIST SHOW
COLUMN ... followed by the ALTER TABLE command,
I apologize for my skepticism of 15 minutes ago. I finally _read_
http://dev.mysql.com/doc/mysql/en/Table_size.html carefully, and indeed
your suggestion is dead on.
thank you again.
On Mon, 2004-07-26 at 14:19, Paul DuBois wrote:
At 12:48 -0400 7/26/04, Michael Dykman wrote:
I am using a
I run some mysql command files (just SQL statements in a file I read
from standard input) and need to place some annotiations/comments in the
output.
If I place standard SQL comments (-- comment text) or MySQL comments
(# comment text) they do not show up in the mysql client output. Well,
in a
looks like the answer is no. As soon as fee based software touches the
mysql install on the PC, the user is obligated to pay the $250. At least I
guess it is the user who has to pay. Because once you pay for the mysql
install, you can use as many fee based applications as you want.
-Steve
Hello,
I have been pulling my hair out trying to get a SELECT statement to work
using a range of Unix timestamps as the criteria.
MySQL Version 4.0
SELECT FROM_UNIXTIME(time) FROM srvlog WHERE FROM_UNIXTIME(time =
'1080948600') AND FROM_UNIXTIME(time = '1080997876');
I also tried
Craig Hibbert wrote:
SELECT FROM_UNIXTIME(time) FROM srvlog WHERE FROM_UNIXTIME(time =
'1080948600') AND FROM_UNIXTIME(time = '1080997876');
Why do you have FROM_UNIXTIME() in the WHERE clause? You said
the time column was already in Unix time, and regardless, you're
passing the function the
On Mon, Jul 26, 2004 at 04:09:51PM -0400, Charles Sprickman wrote:
I have a quick question about how programs linked against the mysql C
libraries handle the following:
-assume three mysql hosts, say 10.0.0.2, 10.0.0.3, and 10.0.0.4
-assume a dns name db.example.com that returns the
OK, I ran sh mysqld_safe on my computer and it said Starting mysqld-max deamon.,
went to the next line on screen and didn't give me a command line, which leads me to
think one of two things happened: 1. the server started successfully. 2. the server
startup faild and locked up. I'm hoping it is
[how to store userpermissions in a tree in mysql]
Hi,
after a long time of try and error I have this as a result:
mysql select * from node;
+-+-+-+-+-+--+--+--+
| node_id | root_id | payload | lft | rgt | a| c| d|
hello list!
i'll be moving from a RedHat server to a Debian server very soon. despite the
different linux distributions, is it ok to transfer my entire mysql database by just
copying everything in /var/lib/mysql of the RedHat system to the Debian system? has
anyone tried this before?
the
I am trying to analyze a query that is taking forever.
I am new to this so or rather desperate.
I would assume that my query would be faster, if
the event id (*.cid) Primary key were used to search
for rows in the iphdr table with the same event id,
but I don't think that is happening. Could some
Mark,
How is it possible to have a hit rate of 1000/1000? Doesn't the buffer
get initialized by cache misses?
-- Matt [EMAIL PROTECTED]
Re: INNODB SHOW STATUS
From: Marc Slemko (marcsznep.com)
Date: Wed Apr 21 2004 - 10:29:44 CDT
On Tue, 20 Apr 2004, Emmett Bishop wrote:
Howdy all,
On Mon, 26 Jul 2004 18:03:25 -0700, Matt Solnit [EMAIL PROTECTED] wrote:
How is it possible to have a hit rate of 1000/1000? Doesn't the buffer
get inOn Mon, 26 Jul 2004 18:03:25 -0700, Matt Solnit [EMAIL PROTECTED] wrote:
How is it possible to have a hit rate of 1000/1000? Doesn't the
Dear, [EMAIL PROTECTED],
Does flush table with read lock timeout?
E.g:
After we excute flush table with read lock ,
All of the table in all of the database can't be updated or delete.
But if we doesn't execute 'unlock tables',does it release the lock due to time out?
Any idea appreciated.
I have a table like this
+---+-+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+-+--+-+-++
| id | int(3) | | PRI | NULL |
auto_increment |
| idTable | int(3)
At 16:22 -0500 7/26/04, Ghate, Shishir wrote:
I looked at the SHOW COLUMNS statement and they have what I want,
but I need to condition off them. For example, I don't want to
execute an ALTER TABLE command to add a column if that column is
already there. I've tried IF DOES NOT EXIST SHOW
Hi Folks,
Being relatively new to InnoDB I have read the books etc. but can't find
anything about regular maintenance that may or may not need to be
performed on the tablespaces. With other databases I have worked on, a
regular dump and load of a database is generally required, on a
semi-regular
At 16:50 -0600 7/26/04, Levi Campbell wrote:
OK, I ran sh mysqld_safe on my computer and it said Starting
mysqld-max deamon., went to the next line on screen and didn't give
me a command line, which leads me to think one of two things
happened: 1. the server started successfully. 2. the server
At 17:39 -0700 7/26/04, Shannon R. wrote:
hello list!
i'll be moving from a RedHat server to a Debian server very soon.
despite the different linux distributions, is it ok to transfer my
entire mysql database by just copying everything in /var/lib/mysql
of the RedHat system to the Debian
1 - 100 of 117 matches
Mail list logo
