Hello all,
I am trying to add a field to a very large table. The problem is that mysql
locks up when trying to do so. I even tried deleting the foreign keys on
the table and it wont even let me do that, again locking up.
It works for around 5 minutes or so then just either locks or the data
Hey all,
So I decided to start fresh on a test machine just to see if I could get
french characters working.
These are my steps:
Freshly Installed Mysql 5.0.45
Configure the MySql Server now
Detailed Configuration
Developer Machine
Multifunctional Database
Online Transaction Processing
Enable
the field blank:
SET NAMES utf8;
SET CHARACTER SET utf8;
update `newsletter` set `newsletter`.`story` = "é û ê à èé û ê à èé û ê à è"
where `newsletter`.`news_id` = 35;
Can anyone shed some light on what I am doing wrong?
--James
- Original Message -
From: "James Sh
Hello,
After I dump the database in and change everything to utf8(or if I try to
dump and make them all utf8 on the dump) I get an "incorrect string value"
error when trying to put french characters in.
Any ideas?.
--James
- Original Message -
From: "James Sh
ct: Re: Character encoding problem
James Sherwood wrote:
Hello,
We are trying to upgrade from 4.0 to 5 and we are not having any luck on
the character sets.
We need to use French characters for some things.
We have tried setting utf8 for everything we can find but the characters
still show all scre
Hello,
We are trying to upgrade from 4.0 to 5 and we are not having any luck on the
character sets.
We need to use French characters for some things.
We have tried setting utf8 for everything we can find but the characters
still show all screwed up..
I have read the manual regarding all th
Hello,
I am trying to install php nuke and I get this error:
File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2)
Character set '#33' is not a compiled character set and is not specified in
the 'c:\mysql\share\charsets\Index' file
I have researched it and nothing ive tried works.
Any
Hello.
I have a question about on delete cascade.
If i have 2 tables such as this:
Table1Table2
PrikeyPrikey
Table2foreinkey name
name description
description
Now if I delete a row from table1 that has a foreign
Thanks for the info,
Not sure how this came about as it has been working fine and it is on a
windows system and using the root user.
Any ideas would be much appreciated,
Thanks,
James
- Original Message -
From: "Dan Buettner" <[EMAIL PROTECTED]>
To: "Ja
Hello,
Today we tried to create a new field on a table in one of our databases. When
we tried to save the field we get the error:
Error on rename of "./DBNAME/TABLENAME.MYI" to "./DBNAME/#SQL2-210-174.MYI"
(Errorcode: 13)
Has anyone ever seen this before?
Thanks,
James
if you have there STRICT_ALL_TABLES
> or STRICT_TRANS_TABLES values. Due to this all warnings are converted to
> errors and import fails. In 4.0 you might have the same problems, but
> server just doesn't produce warnings, and you don't know what's going
> on.
>
>
&g
Win2003 Dell PowerEdge 2850 and when I
> run the
> > service it uses a constant 25%cpu and seems locked up. I cannot even
> stop the service I
> > have to end the process in the task manager. Any ideas?
>
> James Sherwood wrote:
>
>
> --
> For technical support
Hello,
Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have
tried to revert back to 4.0.
I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850 and when I run the
service it uses a constant 25%cpu and seems locked up. I cannot even stop the
service I have to end th
Hello,
I dumped a database from our 4.0 server to a .sql file.
When I try to input it back into the new 5.0 database, it gives me this error
(1406 data too long for column)
This works fine on 4.0 but will not work on 5.0.
I also tried modifying the mediumtext to longtext in the dumpfile but it
SOLVED, sorry for the message.
It was a different error, will post on it shortly
James
- Original Message -
From: "James Sherwood" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, October 25, 2005 1:39 PM
Subject: Error 150 when inputing a dump
Hello,
I dumped a database fro
Hello,
I dumped a database from our 4.0 server to a .sql file.
When I try to input it back into the new 5.0 database, it gives me this error
which I beleive is a foreign key constraint error.
Normally I just put FOREIGN_KEY_CHECKS=0; and that solves it but it doesnt
accept that line in 5.0
An
Still no answer
>
>
> On Tue, 16 Aug 2005, James Sherwood wrote:
>
> > I think I have found the problem:
> >
> > Doing Select @@character_set_database , results, client and connection
it
> > all returns
> > latin1
> >
> > I tried set character_set_x
ction.html
>
>
> > If no one has anymore ideas I think our best route is to dump it,
install
> > 4.0 on this server and import it back in.
>
> Perform an import so that all fields in your table have an utf8 character
> set. And tune properly the connection variables.
&g
[EMAIL PROTECTED]> wrote:
> > The older version is 4.xx.xx im not sure how to
> tell.
> >
> > New version is 4.1.12
> >
> > Thank you,
> > James
> >
> >
> > - Original Message -
> > From: "Bruce Dembecki" <[EMAIL PRO
y' longtext character set latin1 NOT NULL
> >
> > We tried linking our tomcat to the old database on the other server
> > through
> > this tomcat and everything works fine but when we link the tomcat back
> > to
> > the new database, it will not play nice w
The older version is 4.xx.xx im not sure how to tell.
New version is 4.1.12
Thank you,
James
- Original Message -
From: "Bruce Dembecki" <[EMAIL PROTECTED]>
To: "James Sherwood" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, August 15, 2005 2:50 PM
Subject:
I am still having trouble with french characters if anyone has ANY ideas,
please help.
We have installed the newest version of MySql and cannot get it to play nice
with French characters. Our older version worked fine. The problem may (or
may not) be that when we put the dump into the new datab
Hello,
We have installed the newest version of MySql and cannot get it to play nice
with French characters. Our older version worked fine. The problem may (or
may not) be that when we put the dump into the new database(yes its default
charset is Utf8) the default character set for the table is U
you can look for in torque?
>
> -----Original Message-
> From: James Sherwood [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 07, 2005 12:51 PM
> To: mysql@lists.mysql.com
> Subject: Re: max_connections
>
> This error is thrown in a mask we use called Torque, it does
Subject: RE: max_connections
> Where are you getting this error from?
>
> Sounds like something on top of mysql that is doing the connection pooling
> perhaps.
>
> -Original Message-
> From: James Sherwood [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 07, 2005 12:28 PM
&
Hello,
I have a problem with a database mask I use named torque. I get an
error "Cannot get connection from pool"
I beleive it is from the max_connections reaching their limit. I put the
line max_connections=200 in the my.cnf file but when I check the show
variables of the database through E
Yes, there are other databases on that mysql installation.
The only thing is, I recently upgraded it to the latest release of mysql.
James
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "James Sherwood" <[EMAIL PROTECTED]>
Cc: <
er box? It sounds like you took a
> > snapshot of the data but have not installed the executables yet.
> >
> > James Sherwood wrote:
> >
> >> I am trying to transfer a database from one linux box to another,
> >> both using
> >> redhat.
> >&g
I am trying to transfer a database from one linux box to another, both using
redhat.
On one I performed a mysqldump and it worked fine.
On the other I created the database using a manager and tried the 'mysql
username password database < filename.sql' command
The problem is, I cannot seem to get
Hello,
I have installed mysql but did not install it as a service.
All I do is runmysqld-max-nt.exe
Now I need it to run as a service. It is on a win2003 machine.
Can I make it run as a service once I already have it installed.
I cannot lose data and do not want to do a mysqldump, uninstall
30 matches
Mail list logo
