On Mar 31, 2005, at 1:13 AM, Rafal Kedziorski wrote:
I'm working with JBoss and MySQL 4.0.22 (and 4.0.18 on Testsystem).
But under the load, I get sometimes Exceptions like this:
java.sql.SQLException: Deadlock found when trying to get lock; Try
restarting transaction message from server: Lock
Hi,
I'm working with JBoss and MySQL 4.0.22 (and 4.0.18 on Testsystem). But
under the load, I get sometimes Exceptions like this:
java.sql.SQLException: Deadlock found when trying to get lock; Try
restarting transaction message from server: Lock wait timeout exceeded;
Try restarting
I'm having some difficulty with a program I wrote
which uses the MySQL C api. I'm trying to migrate
my server from version 4.0 to version 4.1.
I have no difficulty connecting to the server using
the mysql.exe command line utility, but when I try to
connect from my program using the same
Password hashing was changed in 4.1 to improve authentication security, but
this complicates backward compatibility. See the manual for details:
http://dev.mysql.com/doc/mysql/en/old-client.html
http://dev.mysql.com/doc/mysql/en/password-hashing.html
Your best bet is to link your app against
just connecting through the API which is giving me problems.
I can connect to the 4.1.1 server with the mysql CLI, but
only the 4.0 server with the API. I did have to make one
minor change to the code to get it to recompile. Is there
some other API issue which I need to be aware of?
The code I
On Fri, 25 Mar 2005, Andrew Prock wrote:
On Fri, 25 Mar 2005, Michael Stassen wrote:
Password hashing was changed in 4.1 to improve authentication security, but
this complicates backward compatibility. See the manual for details:
http://dev.mysql.com/doc/mysql/en/old-client.html
Hi,
Anyone know why I can't run multiple commands from the query browser using
semicolons to separate the commands?
ex:
The following command works fine:
select now();
However the following commands do not
select now();
select version();
Your help is appreciated,
-JM
--
MySQL General
Justin Moore [EMAIL PROTECTED] wrote on 03/23/2005 10:38:48 AM:
Hi,
Anyone know why I can't run multiple commands from the query browser
using semicolons to separate the commands?
ex:
The following command works fine:
select now();
However the following commands do not
select
: Wednesday, March 23, 2005 10:39 AM
To: mysql@lists.mysql.com
Subject: semicolon commands causing problems
Hi,
Anyone know why I can't run multiple commands from the query browser using
semicolons to separate the commands?
ex:
The following command works fine:
select now();
However
execute the two statements.
Any ideas what could be causing this?
-Original Message-
From: Justin Moore
Sent: Wednesday, March 23, 2005 10:39 AM
To: mysql@lists.mysql.com
Subject: semicolon commands causing problems
Hi,
Anyone know why I can't run multiple commands from
: Wednesday, March 23, 2005 9:34 PM
Subject: RE: semicolon commands causing problems
I forgot to mention that it is happening from my ant scripts too. So the
problem is occurring outside of the query browser as well. However, from
the command line I can execute the two statements.
Any ideas what could
Hello.
Please, search in MySQL archives (at lists.mysql.com/mysql) about
successful solutions to your problem. You may use --focre --nodeps
flags for the rpm command.
[snip]
I want to upgrade mysql client 3.23. to mysql 4.1.10
But when I type rpm -Uvh mysql-client-4.1...rpm
It's
Consider this:
v_age, v_name, v_eno are 3 variables.
Exec sql Select age into :v_age from temp where name = :v_name and eno
= :v_eno;
Suppose:
v_name =rama
v_eno = NULL
Table: temp
Suppose the values in my table are,
Name = rama
Eno = NULL
Age = 23
The
I want to upgrade mysql client 3.23. to mysql 4.1.10
But when I type rpm -Uvh mysql-client-4.1...rpm
It's says that some file from install mysqlrpm conflict with file from
package mysql3.23
I try to uninstall package mysql3.23 with the rpm on the cd, but it's doesn't
work
I
Hi!
Am Di, den 15.03.2005 schrieb Heikki Tuuri um 8:21:
Douglas,
- Original Message -
From: Douglas B. Jones [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, March 14, 2005 11:19 PM
Subject: compilation problems with 4.1.10a on Tru64 5.1
Subject: Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
Jeff,
I am in SLC Utah.
Do you have your /var/log/mysqld.log file? I've put mine on the list
so that anyone can see it.
thanks,
C.F.
Jeff Steinkamp wrote:
I've had the same problem and for the last
learning mysql and I have a problem when i
make a full backup with mysqldump.
I have a lot of table rows written in spanish. In
the backup file (.sql) I have problems with certain
spanish characters like:
? -- ?i
? -- ?¿
? -- ?-
? -- ??
and so many others like that.
However, when I
Hello.
under /var/lib/mysql saying mysqld started and mysqld ended.
It is unusual behavior of MySQL to leave the error files without
clues. Please, send us the contents of this file.
The tables are not created not even if I run mysql_install_db.
According to the manual they should
Hello Mr Paharenko,
I have started it with mysqld_safe and I also tried
/etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are
empty so I've tried mysql_install_db which runs but the databases
remains empty as well.
It is weird. I've done so many
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysqld_safe and I also tried
/etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are
empty so I've tried mysql_install_db which runs but the databases
remains empty as well.
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysqld_safe and I also tried
/etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are
empty so I've tried mysql_install_db which runs but the databases
remains empty as well.
Here is the script to compile 4.1.10a, it worked compiled fine
with the directory changed on 4.0.23a and before:
#!/usr/bin/ksh
PATH=/usr/local/bin:$PATH
export PATH
echo $PATH
D=mysql-4.1.10a
CC=cc
export CC
CXX=cxx -O
export CXX
cd $D
./configure \
--prefix=/usr/local/mysql-test\
Hi Bob,
Yes the ownership is correct. In fact I did a chmod -R mysql:mysql
/var/lib/mysql and I still have the same problem.
I wonder if it is because I am running a dual processor machine.
Robert A. Rawlinson wrote:
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with
Subject: Re: Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
Jeff,
I am in SLC Utah.
Do you have your /var/log/mysqld.log file? I've put mine on the list
so that anyone can see it.
thanks,
C.F.
Jeff Steinkamp wrote:
I've had the same problem and for the last month I've not been able
Douglas,
- Original Message -
From: Douglas B. Jones [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, March 14, 2005 11:19 PM
Subject: compilation problems with 4.1.10a on Tru64 5.1
Here is the script to compile 4.1.10a, it worked compiled fine
with the directory
Hello,
I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp
It is a dual Xenon PIII server.
I am trying to install MySQL 4.0.24 as I usually do:
- There are no other mysql servers present, no 3.x as I did not install it.
- I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm
- I run rpm -ivh
Hi! I'm learning mysql and I have a problem when i
make a full backup with mysqldump.
I have a lot of table rows written in spanish. In
the backup file (.sql) I have problems with certain
spanish characters like:
á -- Ãi
é -- é
í -- Ã-
ú -- ú
and so many others like that.
However, when I make
On Thu, 3 Mar 2005, Olivier Kaloudoff wrote:
Hello,
we're working on a two node setup to achieve high
availability using 4.1.8;
we first setup both servers with --bin-log, and only
the slave server (db1) with --log-slave-updates. (binary logfile
name is master on both server)
Hello all,
I have I small problem I wonder if there is a easy solution for..
I have a SQL-query where I count out how many users per n_id I have. it is a
little tricky because I had to do a left joint and compare two tables to get
out thoose that are represented only in one of the tables.
Joppe A [EMAIL PROTECTED] wrote on 03/01/2005 02:21:31 PM:
Hello all,
I have I small problem I wonder if there is a easy solution for..
I have a SQL-query where I count out how many users per n_id I
have. it is a little tricky because I had to do a left joint and
compare two tables to
Hello.
g++ -o sqltest sqltest.o -L/usr/lib/mysql -R/usr/lib/mysql -lmysqlclient -lm
-lz
You should specify the location of libmysqlpp.a and add -lmysqlpp to the list
of libraries. Remove -R flag. Look into the mysql++-1.7.28/examples directory.
Arthur [EMAIL PROTECTED] wrote:
Hi
Hi there, guys.
I'm new to MySQL++.
When I try to compile the first simple example of mysql++ tutorial, the
following error occurs:
g++ -g -O -Wall -I/usr/include/mysql++ -I/usr/include/mysql -c sqltest.cc
In file included from sqltest.cc:3:
usage
(which is fine) but the more searches that are being done (the website is
getting more users daily) the longer the cpu is at 100% and the higher the
load gets.
To me it sounds like you are having problems with your database design and
that you could benefit from some indexes perhaps. Do
too high.
To me it sounds like you are having problems with your database design and
that you could benefit from some indexes perhaps. Do you have any indexes?
If you list your table structure and queries that are bogging things down,
the mysql list will be more than happy to help you. :)
Its
On Fri, 25 Feb 2005, Chris Aitken (The Web Hub) wrote:
Its highly possible as this is the first database ive had to use with a
large number of records. I shall look into indexing part of databasing now.
Any suggested places to start that explains it helpfully ?
One way to do it, would be to
Hi all,
I have just created a databased website that is working with a fairly large
number of records (well, 10 million records is the biggest database ive
ever worked on so far) but also have a large number of searches of these
records happening regularly.
The problem ive come across, is my
http://www.innodb.com/order.php
Order MySQL Network from http://www.mysql.com/network/
- Original Message -
From: John Swartzentruber [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 20, 2005 11:54 PM
Subject: Problems with LOAD DATA INFILE
I am new to SQL
Hello.
I think, you don't have a server part of MySQL distribution.
You should install something like mysql-server-xxx.rpm
when i run whereis mysql
Use 'l' query option for the rpm command to see all files from the package:
rpm -ql mysql-3.23.58-1
ayion [EMAIL PROTECTED]
for your help by pointing out this very useful command.
- Original Message - From: John Swartzentruber
[EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 20, 2005 11:54 PM
Subject: Problems with LOAD DATA INFILE
I am new to SQL and to MySQL, but am working
I am new to SQL and to MySQL, but am working with it on a project for a
graduate Database system course. I'm running MySQL 4.1.10 under Windows
2000. I am trying to load a table from a text file. The table in
question has a foreign key. The table that it references contains data.
The problem
dear sir
good wishes.
i am using enterprise redhat linux 3. mine rpm version of mysql is
-3.23.58-1 and it was installed by the time of linux installation.
when i use if the rpm is installed or not by using the comman rpm -qa
| grep mysql
it shows
mysql-3.23.58-1
libdbi-dbd-mysql-0.6.5-6
hello all,
I am a newbe working with MySQL.
I have a problem that I can't figure out how to do.
I have 2 tables that I want to take out data from, the tables looks
like below.
tableA
==
ID VARCHAR(12)
NAMEVARCHAR(255)
CREATED TIMESTAMP
tableB
==
USER_ID
Joppe A [EMAIL PROTECTED] wrote on 02/17/2005 09:45:31 AM:
hello all,
I am a newbe working with MySQL.
I have a problem that I can't figure out how to do.
I have 2 tables that I want to take out data from, the tables looks
like below.
tableA
==
ID VARCHAR(12)
NAME
Joppe A wrote:
hello all,
I am a newbe working with MySQL.
I have a problem that I can't figure out how to do.
I have 2 tables that I want to take out data from, the tables looks
like below.
tableA
==
ID VARCHAR(12)
NAMEVARCHAR(255)
CREATED TIMESTAMP
tableB
Roger Baklund wrote:
Try something like this:
SELECT ID,NAME,COUNT(*)
FROM tableA
LEFT JOIN tableB ON
tableA.ID = tableB.ID
GROUP BY ID,NAME
Nope, sorry, that won't work, ID exists in both tables thus it must be
prefixed with table name or alias: SELECT tableA.ID,... GROUP BY
HI All,
I'm back,...I've removed MySQL completely and reinstalled it using
the binaries for Mac OS X 10.3+ from the mysql website. I still have
a Client API version of 3.23 in the phpinfo() while I see 4.1.9 from
the command line.
I can get things to work using the Old_Password suggested
: Jeff Mao [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: RE: php conection problems
Date: Fri, 11 Feb 2005 11:29:17 -0500
HI All,
I'm back,...I've removed MySQL completely and reinstalled it using the
binaries for Mac OS X 10.3+ from the mysql website. I still have a Client
API version of 3.23
Jeff Mao wrote:
I'm back,...I've removed MySQL completely and reinstalled it using the
binaries for Mac OS X 10.3+ from the mysql website. I still have a
Client API version of 3.23 in the phpinfo() while I see 4.1.9 from the
command line.
This has *nothing* to do with the MySQL you've
Thanks,...that's the info I needed to help me know where to look for
a solution,..I'll direct my work on the php side of things!
Jeff
At 9:07 AM -0800 2/11/05, Hassan Schroeder wrote:
Jeff Mao wrote:
I'm back,...I've removed MySQL completely and reinstalled it using
the binaries for Mac OS X
:29 AM
To: mysql@lists.mysql.com
Subject: RE: php conection problems
HI All,
I'm back,...I've removed MySQL completely and reinstalled it using the
binaries for Mac OS X 10.3+ from the mysql website. I still have a Client
API version of 3.23 in the phpinfo() while I see 4.1.9 from the command
line
') method in
MySQL to populate a column, but as far as connecting I had no problems.
Michael
-Original Message-
From: Jeff Mao [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 10, 2005 3:02 PM
To: mysql@lists.mysql.com
Subject: php conection problems
Hi All,
I'm not sure this a MySQL
server to the 4.1
and ran that script and my php seems to work fine using the 3.23 client. I
had to fix other instances where I had used the password('pass') method in
MySQL to populate a column, but as far as connecting I had no problems.
Michael
-Original Message-
From: Jeff Mao [mailto
Hi All,
I'm not sure this a MySQL problem or a PHP problem,...
I just picked up a new laptop, and like I had always done in the
past, installed MySQL and PHP so I could test and play with code
locally.
The laptop is a Mac Powerbook running 10.3.8. The MySQL installation
is the Standard 4.1.19
[snip]
In the past, I've always simply installed these two pieces as I
mentioned above and everything was so easy,but it's been awhile
since I last did this,did I miss something?
[/snip]
Permissions?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
problems
Hi All,
I'm not sure this a MySQL problem or a PHP problem,...
I just picked up a new laptop, and like I had always done in the past,
installed MySQL and PHP so I could test and play with code locally.
The laptop is a Mac Powerbook running 10.3.8. The MySQL installation is the
Standard
I've tried using a variety of very wide open permissions just to get
something to connect including:
using the root user/password in the php scripts
declaring a user in mysql,...
grant all on mydatabase.* to myuser identified by 'mypassword';
grant all on mydatabase.* to myuser@'%' identified by
],
mysql@lists.mysql.com
Subject: RE: php conection problems
Date: Thu, 10 Feb 2005 15:36:19 -0500
I've tried using a variety of very wide open permissions just to get
something to connect including:
using the root user/password in the php scripts
declaring a user in mysql,...
grant all on mydatabase
: Jeff Mao [EMAIL PROTECTED]
To: Jay Blanchard [EMAIL PROTECTED],
mysql@lists.mysql.com
Subject: RE: php conection problems
Date: Thu, 10 Feb 2005 15:36:19 -0500
I've tried using a variety of very wide open permissions just to
get something to connect including:
using the root user/password
Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Jeff Mao [mailto:[EMAIL PROTECTED]
Sent: Friday, 11 February 2005 7:36 AM
To: mel list_php; mysql@lists.mysql.com
Subject: RE: php conection problems
, 11 February 2005 7:36 AM
To: mel list_php; mysql@lists.mysql.com
Subject: RE: php conection problems
That did the trick,...thanks
so,...why is my Apache installation using an old client? After
reading your suggestion, it makes more sense when I look at the
output of phpinfo() which says that mysql
- Adelaide)
Cc: mysql@lists.mysql.com
Subject: RE: php conection problems
I'm running Mac OS X,...so if the the disable and rebuild isn't too
hard, can you outline that process?
Jeff
Probably because they don't have the time to get the latest and
greatest
client library every time. I'm not sure
AM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: RE: php conection problems
I'm running Mac OS X,...so if the the disable and rebuild isn't too
hard, can you outline that process?
Jeff
Probably because they don't have the time to get the latest and
greatest
client library
On Tuesday 08 February 2005 21:11, Stephane Pinel wrote:
Hello,
When I try to insert decimal numbers like 12857.59, 13858.58 or
14785.60, they are inserted as 12857.58, 13858.57 and 14785.59 ?!
DataType is DECIMAL 10,2
Any idea of a way to avoid this annoying issue ?
Thanks.
Regards.
Steve Grosz [EMAIL PROTECTED] wrote on 02/08/2005 06:04:48 PM:
I already have a version of MySql 4.1.17 running on a different server,
but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that 4.0.23 isn't as easy to set up as the later versions.
reconstituted from a munged response
(original post)
Steve Grosz [EMAIL PROTECTED] wrote on 02/08/2005 06:04:48 PM:
I already have a version of MySql 4.1.17 running on a different server,
but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that
Steve Grosz [EMAIL PROTECTED] wrote on 02/09/2005 03:43:22 PM:
I downloaded the MySql Administrator and simply run that. and
dragged the icon to the startup menu so it loads MySql on startup.
Not entirely sure how to load MySql as a 'service' on Win2003 Server.
The only message I get, and
, but in the subjects column, only family is in
the field.
Everything else in the row gets into the table with no problems. And
there is no error message - as far as the MySQL server is concerned,
everything went fine.
I've looked at different doc sites about MySQL to see if you have to
format set data differently
, but in the subjects column, only family is in
the field.
Everything else in the row gets into the table with no problems. And
there is no error message - as far as the MySQL server is concerned,
everything went fine.
I've looked at different doc sites about MySQL to see if you have to
format set data
Hello,
When I try to insert decimal numbers like 12857.59, 13858.58 or
14785.60, they are inserted as 12857.58, 13858.57 and 14785.59 ?!
DataType is DECIMAL 10,2
Any idea of a way to avoid this annoying issue ?
Thanks.
Regards.
Stéphane.
--
MySQL General Mailing List
For list archives:
I already have a version of MySql 4.1.17 running on a different server, but
am trying to setup v.4.0.23 to see if it will allow me to use PHPBB's
software.
I'm finding that 4.0.23 isn't as easy to set up as the later versions.
I modified the my.ini file and put it in the \windows directory for
Hi,
I've got an odd setup that I need to diagnose. The customer won't
allow us to upgrade very far with the OS or MySQL.
Its currently on a BSD/OS 4.0.1 system, and 4.2 is the highest we
could possibly be allowed to go.
We have upgraded to mysql-3.23.58 (Customer won't
Hello.
On some systems tcpwrapper works with MySQL not that well as expected. For
example see:
http://bugs.mysql.com/bug.php?id=5652
And some bugs aren't fixed in old 3.23.xx versions. In my opinion, your problem
is related to DNS. You may disable DNS lookups by starting mysqld with the
-4185 Fax
http://www.meitech.com/
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 26, 2005 12:08 AM
To: Frederic Wenzel
Cc: Gustafson, Tim; mysql@lists.mysql.com
Subject: Re: Problems with select distinct
Frederic Wenzel wrote:
On Tue, 25
Hello
I am trying to run the following query on my server:
select Documents.ID,
Name
from Documents,
DocumentFiles,
DownloadLog
where Documents.ID = DocumentFiles.Document and
DocumentFiles.ID = DownloadLog.DocumentFile
order by DownloadLog.AddedOn desc
limit 5
I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
reasons I avoid DISTINCT when possible. Try:
SELECT Documents.ID, Name
FROM Documents, DocumentFiles, DownloadLog
WHERE Documents.ID = DocumentFiles.Document
AND DocumentFiles.ID = DownloadLog.DocumentFile
GROUP
On Tue, 25 Jan 2005 08:44:45 -0500, Michael Stassen
[EMAIL PROTECTED] wrote:
I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
reasons I avoid DISTINCT when possible.
Isn't this supposed to be correct? Ordering has to take place as the
very last operation, after any
Frederic Wenzel wrote:
On Tue, 25 Jan 2005 08:44:45 -0500, Michael Stassen
[EMAIL PROTECTED] wrote:
I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
reasons I avoid DISTINCT when possible.
Isn't this supposed to be correct? Ordering has to take place as the
very last
Andy,
- Alkuperäinen viesti -
Lähettäjä: Andy Davidson [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Lähetetty: Tuesday, January 04, 2005 5:02 PM
Aihe: Re: BIG InnoDB problems!
...¨
On Mon, 3 Jan 2005, Heikki Tuuri wrote:
the problem you had was serious corruption
had our developer basically start from scratch (using her stored
text files)... so far, there have been no problems...
We're keeping our fingers crossed!
:-)
J.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
InnoDB problems!
Greetings Heikki and Happy New Year!
Here's what I got. I hope it's useful.
beech:/home/jfreeman # resolve_stack_dump -s /tmp/mysqld.sym -n
mysqld.stack
0x815f0cf handle_segfault + 575
0xe420 _end + -138916432
0x82e71d5 buf_read_page + 165
0x82e71d5 buf_read_page + 165
Hi Heikki,
Please see below...
On Mon, 3 Jan 2005 15:14:12 +0200, Heikki Tuuri [EMAIL PROTECTED] wrote:
Joshua,
the stack trace below shows that you are trying to drop a database? Why?
At that point, I'd heard from our developer of so many problems I
figured what I would do is test things
.
Regards,
Heikki
- Alkuperäinen viesti -
Lähettäjä: jsf [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: mysql@lists.mysql.com
Lähetetty: Monday, January 03, 2005 4:31 PM
Aihe: Re: BIG InnoDB problems!
Hi Heikki,
Please see below...
On Mon, 3 Jan 2005 15:14:12 +0200, Heikki
well, since we were having so many problems with the InnoDB tables, we
created a non-InnoDB version of the database in question...
Basically we want to do whatever it will take to get InnoDB tables
working in our environment. Any assistance you can offer towards this
goal will be greatly
]
Kopio: mysql@lists.mysql.com
Lähetetty: Monday, January 03, 2005 4:56 PM
Aihe: Re: BIG InnoDB problems!
well, since we were having so many problems with the InnoDB tables, we
created a non-InnoDB version of the database in question...
Basically we want to do whatever it will take to get InnoDB tables
up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: jsf [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 31, 2004 12:26 AM
Subject: BIG InnoDB problems!
I've been
InnoDB tables.
We are having serious problems with these tables.
There are indications in the error logfile regarding what to do to try
and discover the root of these problems and fix them. I will begin
pursuing those options shortly after posting this but as:
1) We're under a deadline
. The smallest has 5 tables,
the largest 14 tables. All the tables in all the databases are myISAM
tables.
There is ONE database on the server that we are trying to create/work
with that is all InnoDB tables.
We are having serious problems with these tables.
There are indications
tables.
There is ONE database on the server that we are trying to create/work
with that is all InnoDB tables.
We are having serious problems with these tables.
There are indications in the error logfile regarding what to do to try
and discover the root of these problems and fix them
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: jsf [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 31, 2004 12:26 AM
Subject: BIG InnoDB problems!
I've been struggling with this problem for the last few days. I've
Hello.
When you are using mysql command line client under windows,
all data you see is in cp866 character set (property of all console programs).
And at the server side data is in cp1251 character set. So you should
use sql statements for correct work:
SET character_set_client = 'cp866';
Hi all,
I originally posted this to the replication list, but as I haven't yet
received a response, I thought I'd try my luck here...
I'm having some troubles with replication, in particular restarting a
slave. I'm using MySQL 4.0.22 for the slave, and 4.0.21 as the master.
I've followed the
[EMAIL PROTECTED] wrote:
However, when I restart the slave (through init scripts, or when
rebooting the server etc.), instead of continuing on from where it left
off, it appears to start again from the beginning. This is confirmed by
watching the value of Relay_Log_Pos from SHOW SLAVE STATUS\G.
PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Problems with replication restarting
[EMAIL PROTECTED] wrote:
However, when I restart the slave (through init scripts, or when
rebooting the server etc.), instead of continuing on from where it left
off, it appears to start again from the beginning
MySQL version or release on what O/S?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, December 20, 2004 9:26 AM
To: [EMAIL PROTECTED]
Subject: RE: Problems with replication restarting
So this would imply that you cannot simply stop/start a slave server
[EMAIL PROTECTED] wrote:
So this would imply that you cannot simply stop/start a slave server -
instead, I would need to write a wrapper script that stops the slave
using STOP SLAVE, and at next startup, read the master.info file to
find out where it left off, and then issue a CHANGE MASTER TO...
Victor Pendleton wrote:
A. Clausen wrote:
I made a copy of my entire Mysql 3.23 data directory and moved it on
to a box with a fresh install of MySQL 4. While the NT service starts
up fine (I'm using 4.0.22-nt-max), I can't login. I know that there
are supposed to be mods made to the mysql
Subject: Problems Moving from 3.23 to 4 (Win2k)
I made a copy of my entire Mysql 3.23 data directory and moved it on to
a box with a fresh install of MySQL 4. While the NT service starts up
fine (I'm using 4.0.22-nt-max), I can't login. I know that there are
supposed to be mods made
I made a copy of my entire Mysql 3.23 data directory and moved it on to
a box with a fresh install of MySQL 4. While the NT service starts up
fine (I'm using 4.0.22-nt-max), I can't login. I know that there are
supposed to be mods made to the mysql database tables, but I thought
there was at
What errors are being displayed when you attempt to log in? Is anything
being written to the error log itself?
A. Clausen wrote:
I made a copy of my entire Mysql 3.23 data directory and moved it on
to a box with a fresh install of MySQL 4. While the NT service starts
up fine (I'm using
Hello,
I recently upgraded the MySQL server from 4.0.15 to 4.1.7, without
significant problems. But I continued to use PHP-4.3.9 linked against
the old MySQL 4.0.15 on the webservers for some time. Everything went
ok, up until the point when I tried linking PHP-4.3.9 against
MySQL
601 - 700 of 2763 matches
Mail list logo