Jochen,
- Original Message -
From: Jochen Witte [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, December 07, 2004 2:41 AM
Subject: error 1005 (errno150)
Hello,
I try to set up replication and woulkd like to export my master with
mysqldump. The import fails with
Emmett,
- Original Message -
From: Emmett Bishop [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, December 07, 2004 6:01 AM
Subject: Help interpreting SHOW INNODB Status Message
Howdy all,
We're having concurrency problems with a table in our
database and I'm not
Hiu Yen Onn wrote:
hi,
I wish to have clusters of MySQL. i installed it from RPM. version,
4.1.7.
but, i cant get the ndbd command to start my NDB.
do i really need to install from tarball??
i am really new to MySQL clustering. all this while, i am using MySQL
standalone database.
pls guide
I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs
correctly (it is a slave member of my domain). But if I try to connect from
a remote client with mysql administrator, I receive this error:
Could not connect to the specified instance
Mysql error number 1130
Host name is not
Hi,
I wrote a software generating a statistical database. That database
keeps time series.
What I am doing is
- looking at the data file and get the channel names.
- CREATE TABLE IF NOT EXISTS
IF Database exits I want to ALTER the table but only add new coloums
that are new.
Is there a
Am Tue, 07 Dec 2004 10:28:58 +0200 schrieb Heikki Tuuri:
Jochen,
- Original Message -
From: Jochen Witte [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, December 07, 2004 2:41 AM
Subject: error 1005 (errno150)
Hello,
I try to set up replication and
I guess you would would have to write some custom code that has
connections to each database server and operates outside of MySQL to do
this.
For example, WebObjects (www.webobjects.com) allows you to have
multiple EOModels (Enterprise Object models) in a project, each EOModel
can represent a
Hi,
Has anyone any benchmark between 4.0 and 4.1?
MySQL website says that version 4.0 has some performance
improvements but I´ve heard that MySQL-4.0 is 20% faster
than MySQL-4.1.
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hey guys ,
i know this has been discussed but looking through the archives i have more
less hit a stand still , i have one big excel file which has data i would
like to extract., Now i am no expert in perl neither am i in php , i have
looked at some tools like navicat but i dont see where
[snip]
i know this has been discussed but looking through the archives i have
more
less hit a stand still , i have one big excel file which has data i
would
like to extract., Now i am no expert in perl neither am i in php , i
have
looked at some tools like navicat but i dont see where you
Heikki,
- Original Message -
Terry,
- Original Message -
From: Terry Riley [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 8:15 PM
Subject: Locking Issue?
Can someone help, please?
We set up a server to handle a coldfusion
Hi,
I need to import a dump from a mysql-4.1 to mysql-4.0.
I have already read the MySQL Manual page but I didn´t
find the answer, even importing the data with the option
--default-character-set=latin1.
When executed mysql dump.sql, it happend an error
because mysql-4.1 generates the dump
Hi,
Now I found this line the MySQL Manual:
If you run mysqldump without the --quick or --opt option, mysqldump will
load the whole result set into memory before dumping the result. This will
probably be a problem if you are dumping a big database. As of MySQL
4.1, --opt is on by default, but
Jay Blanchard wrote:
[snip]
i know this has been discussed but looking through the archives i have
more
less hit a stand still , i have one big excel file which has data i
would
like to extract., Now i am no expert in perl neither am i in php , i
have
looked at some tools like navicat but i
Hello.
I've compiled MySQL with bdb support and really it makes nothing in bdb
directory while installing. But BDB storage engine works perfectly. So,
something was done on earlier stages.
scohen [EMAIL PROTECTED] wrote:
I am trying to install mysql from source but I am having problems
Hello.
Have you used install wizard? If you have previous installation of MySQL,
have you stopped mysql service of old instance? What's found in windows event
log?
The error log is located in the data directory specified in your `my.ini'
file. The default data directory location is
Hello.
MySQL tarball contains such file.
# md5 mysql-4.1.7.tar.gz
MD5 (mysql-4.1.7.tar.gz) = 04c08d2a5cc39050d9fa4727f8f197e8
# tar -tzf mysql-4.1.7.tar.gz |grep compile-pentium-max
mysql-4.1.7/BUILD/compile-pentium-max
Hiu Yen Onn [EMAIL PROTECTED] wrote:
Hiu Yen Onn wrote:
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Access_denied.html
Massimo Petrini [EMAIL PROTECTED] wrote:
I upgraded my server to 4.0.22 from 4.0.17. The server itselfs runs
correctly (it is a slave member of my domain). But if I try to connect from
a remote client with mysql
Hello.
perror 13
Error code 13: Permission denied
Check if you have necessary permissions on your data directory.
Aaron E. Diehl [EMAIL PROTECTED] wrote:
Hello All,
I'm having trouble upgrading 3.23. to 4.1. Since I don't want to break
production, I'm trying to start a test
Hello.
You may execute select statement similar to this one to determine that you
already have rows with keys you want to insert:
select * from subscriber where phplib_id='val1',$USERCOL='val2',domain='val3';
Where val1,val2,val3 - values from corresponding insert query.
szj
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Access_denied.html
alagu raj [EMAIL PROTECTED] wrote:
hello all,
i had installed mysql-4.1.7 and php-4.3.5 and while
testing the php. it shows error as:
mysql_connect(): Access denied for user
'alaguraj'@'localhost' (using
Hello.
Check that your MySQL installation was compiled with debug support:
mysqld --help
If the --debug flag is listed with the options then you have debugging
enabled.
mysqladmin ver
also lists the mysqld version as mysql ... --debug in this case.
I'm trying to utilize the
Hello.
Can you describe your problem more in detail? As I guess 'PPM' - a tool
from Active State Perl for installing additional modules. What steps
did you pass, while installing ODBC?
I am trying to install ODBC and it does nothing. I am running version 4.1.7
on XP Pro.
PPM hangs when
Hello.
This question often appears in the list. You can't join tables between
databases residing on different MySQL servers.
Rakesh Gupta [EMAIL PROTECTED] wrote:
When I am logged on to a particular mysql server, is it possible to
- Access table residing on a different mysqlserver?
Hola list,
Many thanks to all those who helped with my question about the schema.
Your kindness is sincerely appreciated.
I need to store passwords in my database, and I understand it's bad
form to store them anywhere in a readable format (I remember reading
once that if you call a company
Heikki,
We're using MySQL 4.0.20. Here's the full output:
=
041207 8:33:26 INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 15
seconds
--
SEMAPHORES
--
OS WAIT ARRAY INFO: reservation
Hi all,
I'm using File Manager utility mandatory by my internet provider. He is running
mysql on Linux.
Apparently I should be able to issue commands dirtly to the shell. And I am
able to perform mysqldump and myslshow.
But I can not start the mysql session so my prompt to change to:
mysql
mysql
Hi,
Is there a way to access if a Query is returning its record from QUERY_CACHE or
not?
E.g.
$sql=SELECT * FROM TABLE;
$result=db_query($sql);
print $result;
//If query NoT returned from mysql_query_cache()
//Would Output something like:
Array[status][cached]=0;
Array[status][count]=1;
Skex,
show status like 'Qcache%';
Will give you status of the query cache. There isn't a way to tell if
a query result
came from the cache or not other than the time it took to return or if
it's the only query ran
between checks of the show status. Neither of these methods is very
reliable.
Chris Kavanagh mailto:[EMAIL PROTECTED] wrote on Tuesday, December 07,
2004 3:36 PM:
I need to store passwords in my database, and I understand it's bad
form to store them anywhere in a readable format (I remember reading
once that if you call a company and ask for your password,
and they can
Rhino wrote:
The primary key for the intersection table is the COMBINATION of EmpID
and
ProjID! Neither column by itself would make sense as the primary key
of the
table; the EmpID and ProjID need to be combined to form the primary
key. It
is now possible to store as many projects for an
Do you know if this is available thru the C API .. Could a User Defined
Function be written to return this?
Any more ideas would be great..
Thanks
Skex
-Original Message-
From: Eric Bergen [mailto:[EMAIL PROTECTED]
Sent: 07 December 2004 16:50
To: Alexis Cheshire
Cc: [EMAIL PROTECTED]
We just installed MySQL 4.1.7 (we were previously using 4.0.22)
Our applications have now become extremely slow. When executing
queries directly on the database server, our response times are 228
rows in set (0.00 sec) When we execute them from our development
servers (via mysql query browser,
'show' is a query just like any select. They both return the same type
of result set. As a result they can be issued from the C API or any
other.
http://dev.mysql.com/doc/mysql/en/SHOW_VARIABLES.html
On Tue, 7 Dec 2004 17:12:28 +, Alexis Cheshire [EMAIL PROTECTED] wrote:
Do you know if
Frank,
If you provide more informations like the query and how
many rows it returns, it should be easier help you.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks for the response
If you provide more informations like the query and how
many rows it returns, it should be easier help you.
The query is: select * from cmContent;
The query returns 228 rows.
mysql describe cmContent;
Hmmm...
The MySQL-client is 4.1.7, too?
I realy don´t know if it make some difference, but perhaps
it does.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The MySQL-client is 4.1.7, too?
Yes
The localhost mysql command is version 4.1.7-standard
The remote query browser is version 1.1.1 gamma
The remote JDBC driver is version 3.0.16-ga
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Dear list,
Quick question. What's a reasonable length for a notes-type field? I
couldn't really find any guidelines on the web so I'm thinking of just
setting it to 65,535. Or is that ridiculously long?
Thanks list,
CK.
--
MySQL General Mailing List
For list archives:
Frank,
Wouldn´t it because the client driver (ODBC version)?
Perhaps it´s faster in the local server because it uses a mysql-4.1.7
client.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sorry I think I asked the question in the wrong way...
I know I can access the Variables you mentioned via SHOW queries, but was
wondering if there is any way by either:
1) Hacking the C Source Code
OR
2) Writing a User Defined Function
To determine if a particular query result has been returned
Chris,
Quick question. What's a reasonable length for a notes-type field? I
couldn't really find any guidelines on the web so I'm thinking of just
setting it to 65,535. Or is that ridiculously long?
For performance reasons, the data type should be as short as possible.
Ronan
--
Frank Febbraro wrote:
The MySQL-client is 4.1.7, too?
Yes
The localhost mysql command is version 4.1.7-standard
The remote query browser is version 1.1.1 gamma
The remote JDBC driver is version 3.0.16-ga
Are you seeing the slowdown only from your java app? Or from all clients?
In the changelog
Are you seeing the slowdown only from your java app? Or from all clients?
I see this slowdown from my java app AND from the remote MySQL client
application (called MySQL Query Browser 1.1.1 and 1.1.2). Basically I
see the slowdown from all clients that are remote machines, but I do
not see it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Frank Febbraro wrote:
Are you seeing the slowdown only from your java app? Or from all clients?
I see this slowdown from my java app AND from the remote MySQL client
application (called MySQL Query Browser 1.1.1 and 1.1.2). Basically I
see the
Got me then?! I am still running 4.0.22. Waiting for the connecter/J
to come out of gamma and for 4.1.* to stabilize a bit, so I can't offer
much other than what I have read.
Frank Febbraro wrote:
Are you seeing the slowdown only from your java app? Or from all clients?
I see this slowdown
What character set are you using in the JDBC driver? Does it happen to
be utf-8?
I have tried it with both utf8 and latin1, no difference in delay.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tuesday 07 December 2004 06:41 am, Ronan Lucio wrote:
Hi,
Has anyone any benchmark between 4.0 and 4.1?
MySQL website says that version 4.0 has some performance
improvements but I´ve heard that MySQL-4.0 is 20% faster
than MySQL-4.1.
As far as what? Thats a very general statement. How
I have tried it with both utf8 and latin1, no difference in delay.
Sorry, to be more specific.
I have tried it originally with everything as UTF-8 (database, tables,
connections) I thought that the encoding could be the problem so I
converted/configured everything to latin1 (ISO-8859-1) and
So, ran into a problem with using mysqlhotcopy to build a backup capable
of starting a new replicant. The current option (record_log_pos)
attempts to get master info from show master status, regardless of
whether running on master or slave. It also uses show slave status to
see where the
Jeff,
Has anyone any benchmark between 4.0 and 4.1?
MySQL website says that version 4.0 has some performance
improvements but I´ve heard that MySQL-4.0 is 20% faster
than MySQL-4.1.
As far as what? Thats a very general statement. How do you even know that
affects you?
The following
This might be related to a bug I filed a couple months ago, assuming
your server is running on Windows
http://bugs.mysql.com/bug.php?id=5787
Sorry, I did not mention it, we are running on Linux, Fedora Core 3 to be exact.
--
MySQL General Mailing List
For list archives:
This might be related to a bug I filed a couple months ago, assuming
your server is running on Windows
http://bugs.mysql.com/bug.php?id=5787
Sorry, I did not mention it, we are running on Linux, Fedora Core 3 to be
exact.
My client machine (the remote machine in this mix) is a
On Tuesday 07 December 2004 12:58 pm, Ronan Lucio wrote:
The following thread appeared in the FreeBSD list:
snip
Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can
affect me.
I may have missed it, but myisam, or innodb?
Jeff
pgpSqggIBC6My.pgp
Description: PGP signature
Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can
affect me.
I may have missed it, but myisam, or innodb?
Both, because I have tables that have few inserts and too few
updates/deletes,
like states, cities and so on, but I plan transform every table in InnoDB to
avoid
Should be fine if you have enough resources.
Your options are 255 characters or
64K
2^24-1 bytes
2^32-1 bytes
So 64K looks like a winner. I doubt notes will take more then a few
pages.
-Original Message-
From: Chris Kavanagh [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 07,
Data from my business's transactions are stored in a
few dozen tables in about 5 databases. Right now the
MySQL server with dual RAID 0 80 gig drives. So far
the data which stores about 4 years worth of data only
takes up 1 gig. There are about 4 or five work
stations that store data on this
Hi,
I'd really appreciate any help in speeding up this type of query
SELECT BindId,RecordType from BrowseData WHERE
DATE_FORMAT(DateLastRevised,'%Y-%m-%d') = '2004-12-07';
On a MYISAM table of 122,000 rows, this query takes very long, in the
neighbourhood of 20 minutes.
i'm using mysqld
On Tuesday 07 December 2004 01:22 pm, Ronan Lucio wrote:
Both, because I have tables that have few inserts and too few
updates/deletes,
like states, cities and so on, but I plan transform every table in InnoDB
to avoid corruption issues.
Nothing here has slowed down. A few innodb stuff I
Jeff,
Both, because I have tables that have few inserts and too few
updates/deletes,
like states, cities and so on, but I plan transform every table in InnoDB
to avoid corruption issues.
Nothing here has slowed down. A few innodb stuff I use, has, but thats
it.. I
run linux on a x86.
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 07, 2004 11:30 AM
To: [EMAIL PROTECTED]
Subject: When to cluster vs. replicate
For some time I have been considering replication for added redundancy
so that should something happen to the server
A function on the left hand side will nullify the use of an index.
Marc Dumontier wrote:
Hi,
I'd really appreciate any help in speeding up this type of query
SELECT BindId,RecordType from BrowseData WHERE
DATE_FORMAT(DateLastRevised,'%Y-%m-%d') = '2004-12-07';
On a MYISAM table of 122,000 rows,
Well 1st of all Date_format doesn't allow the use of a key.
Do this.
SELECT ..
WHERE DateLastRevised = '2004-12-07' AND DateLastRevisted
'2004-12-08';
-Original Message-
From: Marc Dumontier [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 07, 2004 11:34 AM
To: [EMAIL PROTECTED]
Ronan Lucio wrote:
Jeff,
Actually, Ive never had such problem.
Im just afraid of it because Ive read some issues about corruption
in MySQL tables and the own MySQL Manual says that exist a command
just to repair MyISAM tables (myisamchk -
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html).
On Dec 6, 2004, at 3:51 PM, Harrison Fisk wrote:
Hi,
On Monday, December 6, 2004, at 04:15 PM, Klaus Berkling wrote:
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7 with the clustering components. The ndbd and
ndb_mgmd processes are
Additionally you should fix your key structure.
Since BindId is already your primary key
Change the sequence of the BindId,RecordType index. Make RecordType the
leftmost prefix in the compound index, you'll get a free index from
this compound.
-Original Message-
From: Dathan
Greg,
Never had table corruption, though I have had index corruption in myisam
tables many times on sound hardware. Usually, this is due to an unclean
shutdown, though I have seen it happen other times when the server is
supposedly running with no problems. A repair table tablename always
Thanks, works like a charm.
Marc
Dathan Pattishall wrote:
Well 1st of all Date_format doesn't allow the use of a key.
Do this.
SELECT ..
WHERE DateLastRevised = '2004-12-07' AND DateLastRevisted
'2004-12-08';
-Original Message-
From: Marc Dumontier [mailto:[EMAIL PROTECTED]
Sent:
On Tuesday 07 December 2004 01:56 pm, Ronan Lucio wrote:
Actually, I´ve never had such problem.
I´m just afraid of it because I´ve read some issues about corruption
in MySQL tables and the own MySQL Manual says that exist a command
just to repair MyISAM tables (myisamchk -
On Tuesday 07 December 2004 02:03 pm, Victor Pendleton wrote:
A function on the left hand side will nullify the use of an index.
Sides dont matter, a function on an index, no matter what side, will kill an
index.
Jeff
pgpsVFJcgS9kp.pgp
Description: PGP signature
I have a bunch of 4.1.7 boxes all running linux, some 32 bit and some 64 bit
and I've never experienced the problem you are having. Are you have the
problem if you connect from a remote linux box?
The final question, does the windows box have reverse DNS setup for it? If
not add it to the
mysql explain select * from queryLog where date_format(queryTime,
'%Y-%m-%d') =
'2004-11-16';
+--+--+---+--+-+--+--+-+
| table| type | possible_keys | key | key_len | ref | rows |
Extra |
On Tuesday 07 December 2004 02:51 pm, you wrote:
mysql explain select * from queryLog where date_format(queryTime,
'%Y-%m-%d') =
'2004-11-16';
mysql explain select * from queryLog where queryTime =
date_format('2004-11-16'
, '%Y-%m-%d');
Rhino wrote:
Well, I think you've just succeeded in demolishing my wonderful example; it
turns out that we don't need to use a stored procedure to find a median
after all ;-)
That wasn't my intention. I thought I was adding support to your example.
Just because it can be done in SQL doesn't
The final question, does the windows box have reverse DNS setup for it? If
not add it to the /etc/hosts file on your fc3 linux box. And reconnect to
mysql.
WOW! That was it. Things are lightning fast now.
Sorry for going completely down the wrong path.
What would have been the best way to
I've been using mysql 4.1 since the first day it was out; it's all been
trial and error. If I remember correctly, I found it on 4.1.0 when I was
doing a processlist, and noticed that some of the boxes connecting to mysql
had reverse and others didn't. So now we actually go to the /etc/hosts file
I've been using mysql 4.1 since the first day it was out; it's all been
trial and error. If I remember correctly, I found it on 4.1.0 when I was
doing a processlist, and noticed that some of the boxes connecting to mysql
had reverse and others didn't. So now we actually go to the /etc/hosts
Emmett,
ok, trx (1) is trying to lock gap G, but trx (2) already has a lock on it.
And trx (2) is trying to insert a new record into that same gap G.
Even a waiting lock request on a gap prevents new inserts into it = a
deadlock.
In 4.1.7, you might avoid this deadlock. In 4.1.7, a waiting gap
Is there in the MySQL query language a function just like the SUM() but
instead of adding multiplying?
AC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It was probably attempting to do a reverse and nothing exists, so it just
has to timeout.
Donny
-Original Message-
From: Frank Febbraro [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 07, 2004 3:23 PM
To: Donny Simonton; [EMAIL PROTECTED]
Subject: Re: MySQL 4.1.7 Network slowdown
No, but Harold Fuchs gave the following solution to Shawn Green in an
earlier thread on this topic http://lists.mysql.com/mysql/166184.
EXP(SUM(LOG(COALESCE(*the field you want to multiply*,1)))
which works because LOG(xy) = LOG(x) + LOG(y), and EXP(LOG(x)) = x. Hence,
sum of the logs = log of
Heikki,
Thanks for the input. Right now we can't move to 4.1,
we're stuck with 4.0.20 for sometime. So, it there
someway that through improving the schema these issues
could be addressed? I added an index on these tables
reflecting the way that data is usually looked up
(always by session_guid
Hi,
On Tuesday, December 7, 2004, at 03:07 PM, Klaus Berkling wrote:
On Dec 6, 2004, at 3:51 PM, Harrison Fisk wrote:
Hi,
On Monday, December 6, 2004, at 04:15 PM, Klaus Berkling wrote:
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7
Hi,
I'm trying to chroot MySQL according to these instructions in linux.com:
http://security.linux.com/article.pl?sid=04/08/19/1422204tid=73tid=35
But the fact is that MySQL never starts (actualy, i think it starts and
dies the next second).
Can't find any errors in logs :(
Any ideas of what can
Right now mysql's SHA1 implementation uses Base16 encoding...
Why not add a Base64+filesafe encoding. This results in significant
space storage. Maybe call the function SHA1BASE64()
Example:
Base64+filesafe(SHA1): C-7Hteo_D9vJXQ3UfzxbwnXaijM
Base64(SHA1):
Is there any feasible way to integrate MySQL into a live chat? I would like to
setup a chat that pulls user profiles from the database as people enter.
http://www.lindsaylohan.name
Donny Simonton wrote:
It was probably attempting to do a reverse and nothing exists, so it just
has to timeout.
Reverse DNS is evil... :)
http://dev.mysql.com/doc/mysql/en/DNS.html
You can disable DNS hostname lookups by starting |mysqld| with the
|--skip-name-resolve| option. However, in this
On page 822 of the pdf copy of the documentation
that I have, it says:
To make it easier to reload dump files for tables
that have foreign key relationships, mysql automatically
includes a statement in the dump output to set FOREIGN_
KEY_CHECKS to 0 as of MySQL 4.1.1.
I'm using MySQL 4.1.7 and the
I have a problem with an update query not replicating through to the slave.
The query is update content_review_site as a,site_rating_factors as b set
a.overall_rating = 77 where a.content_id=243
Version : 4.0.22
OS : Linux X86
How to replicate the error.
CREATE TABLE content_review_site (
I've been running, with great success, version 3.23.58 on my Win2k box
for quite a while now, but am interested in moving up to 4.1. Is there
any incompatiblities between the two versions, or any gotchas to the
upgrade?
--
A. Clausen
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list
On Tue, 07 Dec 2004 16:51:10 -0700
Titus [EMAIL PROTECTED] wrote:
On page 822 of the pdf copy of the documentation
that I have, it says:
To make it easier to reload dump files for tables
that have foreign key relationships, mysql automatically
includes a statement in the dump output to
The easiest way to turn excel into MySQL is to have excel save the
file as a .csv (comma separated values) file and use the mysqlimport
utility or a load data infile query to insert it into a table in
MySQL.
-Eric
On Tue, 7 Dec 2004 16:02:23 -0800, David Ziggy Lubowa
[EMAIL PROTECTED] wrote:
The 'gotchas' are listed in the manul for 3.23 to 4.0 here:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html
and from 4.0 to 4.1 here:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
On Tue, 07 Dec 2004 16:01:51 -0800, A. Clausen [EMAIL PROTECTED] wrote:
I've been running,
Take a look at http://mysql.he.net/doc/mysql/en/Upgrade.html
j- k-
On Tuesday 07 December 2004 15:01, A. Clausen said something like:
I've been running, with great success, version 3.23.58 on my Win2k box
for quite a while now, but am interested in moving up to 4.1. Is there
any
Jay,
Are you using the replicate-do-db option on the slave? This option
relies on 'use' being set correctly when the query is issued. A quote
from the manual explains it better than I can:
Tells the slave to restrict replication to statements where the
default database (that is, the one
Thanks for your inputs Eric.
I tried this but it couldn't give me any insight abt how can optimize this
for space saving of temp tables.
Maybe I am not expert enough to interpret this output, so here it is -
mysql explain select * from T1, T2 where AAA=BBB AND ZZZ like '%R%';
From Excel, save the file as a CSV (comma separated values) use either
mysql load data infile in an insert query or use phpmyadmin to import the
csv into a table in your database.
Regards
Assey
On Tue, 7 Dec 2004, David Ziggy Lubowa wrote:
Hey guys ,
i know this has been discussed but
Josh,
- Original Message -
From: Josh Trutwin [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 08, 2004 5:58 AM
Subject: Re: FOREIGN_KEY CHECKS
On Tue, 07 Dec 2004 16:51:10 -0700
Titus [EMAIL PROTECTED] wrote:
On page 822 of the pdf copy of the
java.sql.SQLException: Communication failure during handshake. Is there a
server running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:275)
at org.gjt.mm.mysql.Connection.init(Connection.java:230)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
99 matches
Mail list logo