Dear all,
Benetl, a free ETL tool for MySQL, is out in version 4.1.
This version brings GUI improvement: control of field names and table
(EtlTool) name.
With this version, it is now possible to use > and < with "if" operator
on a part formula.
This version brings some cod
Hey,
happy new year and I do have a question what might be the best way to
migrate some different databases to a new central server.
The question came up as I wanted to put our web CMS database on our
newer master/slave mysql installation.
We run red hat el 4 and 5 right now, so the source db is
Hi!
I don't do DBA work, so my info may be incomplete:
monem mysql wrote:
> Hello
>
>
> I have to upgrade many mysql databases from mysql 4 and 4.1 to 5.4 with a
> large size 2.7 TB
>
> [[...]]
>
>
> The official method takes too much time. But I've
Using mysqldump and loading directly into 5.4 *might* work, but you should
never do any of this on your production system without testing.
Get another box, start with 4.1 and do the upgrade on a test server -- even
test your queries as there a few incompatible changes between 4 and 5. One you
Hello
I have to upgrade many mysql databases from mysql 4 and 4.1 to 5.4 with a
large size 2.7 TB
All tables use the MyISAM engine.
I have to make that update on live system with minimal down time possible.
The official method takes too much time. But I’ve read that we can use ‘*dump
and
Victoria Reznichenko writes:
> "Holly Chamberlain" wrote:
>
>>
>> Does anyone have a good site that contains the current SQL standard? Or
>> does anyone know is ISNULL() and IFNULL(), and similar null testing
>> functions, standard SQL or extensions to SQL?
>
> No, there are no such functions in
On Fri, Aug 28, 2009 at 9:18 AM, Shawn Green wrote:
> Hank wrote:
>
>> Hello All,
>> I'm in the process of upgrading my database from 4.1 to 5.0 on CentOS.
>> I've been testing the "mysqlcheck --check-upgrade --auto-repair"
>> command,
>
Hank wrote:
Hello All,
I'm in the process of upgrading my database from 4.1 to 5.0 on CentOS.
I've been testing the "mysqlcheck --check-upgrade --auto-repair" command,
and on one of my MYISAM tables, it's taking forever to upgrade the table.
It has about 114 milli
Hello All,
I'm in the process of upgrading my database from 4.1 to 5.0 on CentOS.
I've been testing the "mysqlcheck --check-upgrade --auto-repair" command,
and on one of my MYISAM tables, it's taking forever to upgrade the table.
It has about 114 million rows, and I&
Benching
Somebody knows why 4.1 is faster than 5.0 mysql versions
Ing. Jaime Fuentes R.
997500459
2421905-2423252
Enviado desde mi BlackBerry de Claro.
-Original Message-
From: Brent Baisley
Date: Tue, 2 Jun 2009 12:32:39
To: Ray
Cc:
Subject: Re: Question about query - can this be
A DB politics between mysql & oracle again
Thats quite ironic given recent events :)
--
Linux web infrastructure consulting, cr...@codenation.net
Free live poker tournament listings, http://www.g5poker.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
kengheng wrote:
Hi All, I've performed a upgrade from 4.1.22 to 5.0.81, the
mysql_upgrade performed well on all tables repairing, however, after
upgrade the same db from 5.0.81 to 5.1.33, a few tables got the error
as below:
Error: Unknown table engine 'InnoDB'
error: Corrupt
Any ide
Hi All, I've performed a upgrade from 4.1.22 to 5.0.81, the
mysql_upgrade performed well on all tables repairing, however, after
upgrade the same db from 5.0.81 to 5.1.33, a few tables got the error as
below:
Error: Unknown table engine 'InnoDB'
error: Corrupt
Any ideas?
THnaks.
--
:56 AM 5/5/2009, dimitar nen4ev wrote:
Hi
I am using Mysql 4.1 on
CPU 2 Xeon 3.0 Ghz + 2 Virtual (Hyperthreads) (I
think it is not using the 2nd processor)
Memory 4GB
I think that the read from the HDD is 50mb per 1 sec, but I am not sure.
I have very big problem with performance,
because the
M 5/5/2009, dimitar nen4ev wrote:
Hi
I am using Mysql 4.1 on
CPU 2 Xeon 3.0 Ghz + 2 Virtual (Hyperthreads) (I
think it is not using the 2nd processor)
Memory 4GB
I think that the read from the HDD is 50mb per 1 sec, but I am not sure.
I have very big problem with performance,
because there are
Hi
I am using Mysql 4.1 on
CPU 2 Xeon 3.0 Ghz + 2 Virtual (Hyperthreads) (I think it is not using the 2nd
processor)
Memory 4GB
I think that the read from the HDD is 50mb per 1 sec, but I am not sure.
I have very big problem with performance, because there are very bad search
queries, but
at 11:48 PM, Alagar samy wrote:
> Hi,
>
> i am using mysql_server-4.1.23 and in the documentation of 4.1
> (http://dev.mysql.com/doc/refman/4.1/en/dynamic-system-variables.html) , it
> is mentioned innodb_thread_concurrency variable can be set at runtime.
>
> but i am gettin
Hi,i am using mysql_server-4.1.23 and in the documentation of 4.1 (http://dev.mysql.com/doc/refman/4.1/en/dynamic-system-variables.html) , it is mentioned innodb_thread_concurrency variable can be set at runtime.but i am getting error when trying to set dynamically .. mysql> SET GLO
#x27;d go the slave route.
>>
>> You should certainly test your application to make sure 5.1's
>> differences (data types, syntax, etc) don't cause problems. Otherwise
>> you're risking getting badly stuck and having to downgrade to 4.1
>> again in a crisis.
Baron Schwartz wrote:
If you can't take downtime, I'd go the slave route.
You should certainly test your application to make sure 5.1's
differences (data types, syntax, etc) don't cause problems. Otherwise
you're risking getting badly stuck and having to downgrade to 4
If you can't take downtime, I'd go the slave route.
You should certainly test your application to make sure 5.1's
differences (data types, syntax, etc) don't cause problems. Otherwise
you're risking getting badly stuck and having to downgrade to 4.1
again in a crisis
Hi All,
I need to migrate a large (30G) database from 4.1 to 5.1 on a live
system that cannot afford a large amount of downtime. The official
method (copy files, run mysql_upgrade...etc) is looking like it will
take forever, particularly since I need to move it 5.0 before 5.1. How
do
The biggest difference is that 4.1 does not support store routine but the
5.1 support.
On Sat, Jul 5, 2008 at 1:08 AM, Pablo <[EMAIL PROTECTED]> wrote:
> Hi all,
> I'm looking for some information about difference and new features
> between mysql 5 and mysql 4.1
> C
Hi all,
I'm looking for some information about difference and new features
between mysql 5 and mysql 4.1
Can somebody give me any documentation or link?
All documentation is good for me ;)
Thanks
Pablo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
d the slave becomes the master.
Very simple in theory, a bit more complicated in practice.
Brent Baisley
Systems Architect
On Apr 23, 2008, at 2:28 PM, Paul Choi wrote:
Does anyone have experience with upgrading large databases (~500GB
each)
from MySQL 4.1 to 5.0? The tables are in InnoDB forma
Does anyone have experience with upgrading large databases (~500GB each)
from MySQL 4.1 to 5.0? The tables are in InnoDB format. We are using the
Community version.
I've read that it's recommended that you use mysqldump and then restore,
but this is not possible for us, as we canno
database in 4.1
hi list,
how can I rename a database with full innodb tables ?
The version is 4.1
Thnaks all
"Questo messaggio ed ogni suo allegato sono confidenziali e possono essere riservati
o, comunque, protetti dall'essere diffusi. Se il ricevente non é il destinatario diretto
de
You can try to dump-to-sql the whole DB,
Create a new DB and import the sql-dump in the new DB.
Aloha!
Claudio
-Messaggio originale-
Da: Thomas Raso [mailto:[EMAIL PROTECTED]
Inviato: martedì 12 febbraio 2008 17.20
A: mysql@lists.mysql.com
Oggetto: rename database in 4.1
hi list
hi list,
how can I rename a database with full innodb tables ?
The version is 4.1
Thnaks all
Hi all,
I'm looking for information about References attribute in Mysql, help me!
thanks in advance.
Bo
mario henriquez wrote:
> hi, i got a problemas in mysql with suse 10 enterprise server, the error:
>
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near ''
> at line 1.
>
> when i treat to create a new d
hi, i got a problemas in mysql with suse 10 enterprise server, the error:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ''
at line 1.
when i treat to create a new data base, appears this message.
pleas
I recently ran across
http://www.mysql.com/news-and-events/newsletter/2004-01/a000303.html and
thus http://xquark.objectweb.org/. It appears that is will only work with
4.0 and I'm using 4.1.x. I've never installed MySQL, but I could attempt to
install a newer version is something
huh. it's a varchar(50) on table1 and a varchar(50) on table2. i
wonder why explain is reporting 150 as key_len?
utf8?
yes. that does make sense.
is there anything else i can investgate?
Do you need utf8? :-)
yes. it's an internationalized application :)
Check your cache hits. I can'
Russell Uman wrote:
Baron Schwartz wrote:
I don't think it will be any better to count distinct values. I think
the query is just slow because the index lookups are slow. Is the
'word' column really 150 bytes?
huh. it's a varchar(50) on table1 and a varchar(50) on table2. i wonder
why exp
Baron Schwartz wrote:
I don't think it will be any better to count distinct values. I think
the query is just slow because the index lookups are slow. Is the
'word' column really 150 bytes?
huh. it's a varchar(50) on table1 and a varchar(50) on table2. i wonder why
explain is reporting 150
I don't think it will be any better to count distinct values. I think
the query is just slow because the index lookups are slow. Is the
'word' column really 150 bytes? That's probably the culprit. How slow
is this, by the way? 370k rows in one table, verifying the
non-existence of index re
There's no "using distinct", but there is "not exists", and in fact no rows are
returned. Slow query log reports "#Query_time: 94 Lock_time: 0 Rows_sent: 0
Rows_examined: 370220"
EXPLAIN:
id select_type table type possible_keys key
key_len ref rows
Hi,
Russell Uman wrote:
howdy.
i trying to find items in one table that don't exist in another.
i'm using a left join with a where clause to do it:
SELECT t1.field, t2.field FROM table1 t1 LEFT JOIN table2 t2 ON t1.word
= t2.word WHERE t2.word IS NULL;
both tables are quite large and the q
howdy.
i trying to find items in one table that don't exist in another.
i'm using a left join with a where clause to do it:
SELECT t1.field, t2.field FROM table1 t1 LEFT JOIN table2 t2 ON t1.word =
t2.word WHERE t2.word IS NULL;
both tables are quite large and the query is quite slow.
the f
In the last episode (Oct 23), Ivan Longhi said:
> I'm running mysql-server on a linux debian box
>
> with apt package system I upgraded mysql server from 4.1 to 5.0 (apt
> automatically execute mysql_upgrade)
>
> now on my 5.0.32 server almost everything works fine,
hi,
I'm running mysql-server on a linux debian box
with apt package system I upgraded mysql server from 4.1 to 5.0 (apt
automatically execute mysql_upgrade)
now on my 5.0.32 server almost everything works fine, except for a
database containing 4 tables: two of them have been upgraded as
Hi,
We've recently upgrade from MySQL 4.0.18 to 4.1.20 and our applications
(Websphere) its not displaying the character as its supposed to do.
But when i do a "select..." from comand , the results from the old server and
the new are the same, also for mysql-query-browser.
Thanks
mysqlcheck -h$host -u$user -p$pass --analyze $dbname
I wish that was the case!
I tried analyze table ... and optimize table ..., which I presume
would be the same. It did not help. I also ran mysqlcheck just to see
if it will make a difference. Nope!
--
MySQL General Mailing List
For list arch
Gmail User wrote:
> I had perfectly working complex queries both with LEFT JOIN and without
> and they were returning results in under a second. After upgrade to
> 5.0.x, the same queries would return results in 20-30 second range.
I had a similar problem once (not related to 4.x->5.x though), it
When you upgraded from 4.1 to 5.0, did you do an in-place upgrade, or mysqldump
your data and then re-import?
As replied to Sebastian's post, in-place.
Try using either mysqldump or mysql-administrator to dump out your data to an
.sql file. Then re-import all of your data into 5.x. You
possible you had set up some query cache in 4, but not currently in 5?
may not be optimized, but yes, query cache is enabled, all 25 MB of it. :-)
how did you 'upgraded' your data?
regrettably, in-place.
interestingly, I was recovering after server crash that chopped of a
table. after upgra
Here's a question that begs to be asked --
When you upgraded from 4.1 to 5.0, did you do an in-place upgrade, or mysqldump
your data and then re-import?
MySQL 5.x's query cache and table optimizers work very differently than in 4.1,
so the results you are getting are probably from 2
Gmail User schrieb:
> I had perfectly working complex queries both with LEFT JOIN and without
> and they were returning results in under a second. After upgrade to
> 5.0.x, the same queries would return results in 20-30 second range.
possible you had set up some query cache in 4, but not currently
I had perfectly working complex queries both with LEFT JOIN and without
and they were returning results in under a second. After upgrade to
5.0.x, the same queries would return results in 20-30 second range.
Through trial and error, I discovered that in case of SELECT ... FROM
table1, table2 ... O
Hi there,
I have recently upgraded from mysql 4.0 to 4.1.x
Now I am facing an error while issuing this delete command:
# delete report images in db
$stmt= "
DELETE
FROM
$DB.$T21
USING
$DB.$T21 AS rp,
$DB.$T13 AS r
hello,
There is something I obviously missed, can't figure out what, since it
seems so simple.
as user root (of mysql),
mysql> use mysql;
I can see :
mysql> select * from columns_priv where User='demandeur' order by Column_name;
and I get :
+--+---+--+---+-
MAIL PROTECTED]>
To: "ViSolve DB Team" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, February 09, 2007 6:54 AM
Subject: Re: revoke SELECT on a column [ MySQL 4.1 ] + column "Comment"
Hello,
thanks again to ViSolve DB Team.
so, it turns out that for MySQL4.1, il will h
Hello,
thanks again to ViSolve DB Team.
so, it turns out that for MySQL4.1, il will have to built a sql file,
built with script (shell or perl).
[ note that so far I use MySQL 4.1 on production
server, and I only test features on MySQL 5 on an other machine linux
Debian].
at last, my LAST
et i=i+1;
end while;
end;
mysql> call g(hide_this_col);
Thanks
ViSolve DB Team.
- Original Message -
From: "Gilles MISSONNIER" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 07, 2007 9:26 PM
Subject: Re: revoke SELECT on a column [ MySQL 4.1 ] + column privileg
MISSONNIER" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 06, 2007 11:05 PM
Subject: revoke SELECT on a column [ MySQL 4.1 ]
Hello,
In a table [say t100], having 100 columns,
I want to allow the select on all columns but 1.
I tried to do this by granting all columns in the table t100
- Original Message -
From: "Gilles MISSONNIER" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 06, 2007 11:05 PM
Subject: revoke SELECT on a column [ MySQL 4.1 ]
Hello,
In a table [say t100], having 100 columns,
I want to allow the select on all columns but 1.
I tried to do t
Hello,
In a table [say t100], having 100 columns,
I want to allow the select on all columns but 1.
I tried to do this by granting all columns in the table t100, of the base,
then revoke SELECT on the column "hide_this",
but this doesn't work.
mysql> GRANT SELECT ON the_base.t100 to 'a_user'@'lo
Regarding the format of TIMESTAMP columns, one of the user comments on
http://dev.mysql.com/doc/refman/4.1/en/timestamp-4-1.html
offers the solution below:
Posted by Kjell Arne Rekaa on April 14 2005 11:11pm
If you want the same view of a timestamp field in 4.1.x as it was in
in earlier mysql
Hi! I would like to upgrade the database of my organisation from
mysql4.0.22 from 4.1. We use Debian.
I've read info in the manual, but i don't have things clear.
We process data of DB with scripts, and I'm annoyed because the change
of format of timestamp, is there any command i
I just installed MySQL 5.0 yesterday and ran my application that has a lot
of selects with left joins. I noticed the application is running 4x-7x
slower than with MySQL 4.1. Now it could be because I'm using a new my.ini
file (dedicated server) and I haven't yet copied my old my.in
words.
Carlos
On 9/26/06, Curious George <[EMAIL PROTECTED]> wrote:
I dumped a database from a 4.0 mysql and am attempting to move it to a
server running 4.1 - using the command line:
$ mysql -u root -pmypassword empty4.1db < 4.0dump.sql
The result:
ERROR 1064 (42000) at line 2: Yo
I dumped a database from a 4.0 mysql and am attempting to move it to a
server running 4.1 - using the command line:
$ mysql -u root -pmypassword empty4.1db < 4.0dump.sql
The result:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check
the manual that corresponds to y
On Wed, 2006-08-23 at 22:23 +0200, spacemarc wrote:
> Hi,
> I have a query like this:
>
> SELECT table1.*,(
> SELECT COUNT( field2 )
> FROM table2
> WHERE id=10
> ) AS total
> FROM table1
> GROUP BY id
> LIMIT 1
>
> but the subqueries do not work with mysql
ut the subqueries do not work with mysql < 4.1. How can I convert it
(or make to work) in MySQL 3.x, 4.0 possibly in one only query?
thanks
--
http://www.spacemarc.it
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi,
I have a query like this:
SELECT table1.*,(
SELECT COUNT( field2 )
FROM table2
WHERE id=10
) AS total
FROM table1
GROUP BY id
LIMIT 1
but the subqueries do not work with mysql < 4.1. How can I convert it
(or make to work) in MySQL 3.x, 4.0 possibly in one only query?
thanks
--
h
nd stable. For safety's sake once
you get it back to 4.1 I'd suggest running CHECK TABLE tablename
EXTENDED on each to ensure integrity.
I've always had success going forward with releases, but haven't ever
tried going back that I recall.
Dan
That's what I ended up doing,
e
you get it back to 4.1 I'd suggest running CHECK TABLE tablename
EXTENDED on each to ensure integrity.
I've always had success going forward with releases, but haven't ever
tried going back that I recall.
Dan
On 8/7/06, mos <[EMAIL PROTECTED]> wrote:
I'm plann
s
in 5.0 and then use the same tables in 4.0?
Are there any speed improvements in 5.0 compared to 4.1?
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Amir Bukhari wrote:
-Original Message-
From: Addison, Mark [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 18, 2006 1:22 PM
To: Amir Bukhari; mysql@lists.mysql.com
Subject: RE: Backup problem from 5.0 to mysql 4.1
From: Amir Bukhari Sent: 18 July 2006 09:23
I have local mysql 5.0
> -Original Message-
> From: Addison, Mark [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 18, 2006 1:22 PM
> To: Amir Bukhari; mysql@lists.mysql.com
> Subject: RE: Backup problem from 5.0 to mysql 4.1
>
> From: Amir Bukhari Sent: 18 July 2006 09:23
> >
From: Amir Bukhari Sent: 18 July 2006 09:23
>
> I have local mysql 5.0 and I have developed an arabic site.
> The database
> encoding is utf8-bin. Localy everything work fine, all arabic text are
> displayed OK.
> Now I want to move it to a server in internet. The server ha
I have local mysql 5.0 and I have developed an arabic site. The database
encoding is utf8-bin. Localy everything work fine, all arabic text are
displayed OK.
Now I want to move it to a server in internet. The server has mysql 4.1 and
as I restored the database there, some special arabic character
Cheers Dan. Exactly what I needed :)
Iain
Dan Trainor wrote:
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a
mysql 4.1 database. The
Iain Conochie wrote:
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a mysql
4.1 database. The error message I get is
ERROR 1251: Client does not support
Afternoon,
Apologies if this has been discussed before, I could not find a
reference of it. So here we go :)
Currently, I have a need to get a mysql 4.0 client to talk to a
mysql 4.1 database. The error message I get is
ERROR 1251: Client does not support authentication protocol
prathima rao wrote:
hi,,
the query is select sum(gtotal) from invoice this if i connect to 4.1 says
14000 but in 5.1 it says 0.00
why so
is it because i copy data from 4.1 to 5.1
I don't know. Did you try exporting from 4.1 with mysqldump and running
the dump script on the 5.1 s
this will be helpful in tracking down the problem.
Dan
prathima rao wrote:
hi,,
the query is select sum(gtotal) from invoice this if i connect to 4.1 says
14000 but in 5.1 it says 0.00
why so
is it because i copy data from 4.1 to 5.1
rao
- Original Message -
From: "Pet
hi,,
the query is select sum(gtotal) from invoice this if i connect to 4.1 says
14000 but in 5.1 it says 0.00
why so
is it because i copy data from 4.1 to 5.1
rao
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "prathima rao" <[EMAIL
prathima rao wrote:
hello every one,
i have two mysql servers one is the local server 4.1 and one is the
centralised server 5.0 . i copy data from 4.1 to 5.0 through a option called
copy database to another server/host - (drop table if exists)
during this process i am not getting the same
hello every one,
i have two mysql servers one is the local server 4.1 and one is the
centralised server 5.0 . i copy data from 4.1 to 5.0 through a option called
copy database to another server/host - (drop table if exists)
during this process i am not getting the same resule as i get in 4.1 ie
Hi, due to some problems I was having I re-intalled 4.1 the other day
(had orig zip from when first downloaded (mysql-4.1.9-win32.zip), so was
able to install exact same version I had previously) only problem is, I
can't read tables... I had backed up my data, copied my db's back
>From the manual:
http://dev.mysql.com/doc/refman/4.1/en/legal-names.html
An identifier may be quoted or unquoted. If an identifier
is a reserved word or contains special characters, you must
quote it whenever you refer to it.
(Exception: A word that follows a period in a qualified name
m
Dear All,
While migrating from MySQL 4.0 to MySQL 4.1, I found that the database
could not be loaded in 4.1 because MySQL 4.1 uses a reserved keyword "div"
that was not "reserved" in 4.0.
Is there anyway to get around the issue?
Thanks in advance.
Manoj
--
MySQL
MySQL Mailing List,
Currently I'm running MySQL 4.1.15 on my home computer where I do web
development, and MySQL 4.1.13-beta on my hosting service. Actually, I do
work on web sites that are hosted on many hosting services, but on only
one of them do I have enough access to decide for myself if
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I have been unable to use the bk client to update my bk trees. I just
hangs
/usr/local/bin/bk-update bk://mysql.bkbits.net/mysql-4.1 mysql-4.1
I usually run this every 4 hours to keep my local trees up to date. The
process usually completes in a
Is there any way to turn off collation in mysql 4.1? PHPadmin is showing a
new colation dropdown menu which I need to get rid of.
Thanks,
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am using the .net connector for mono in my application to connect to MySql
servers. Application is open-source and can be found here:
http://fileuniverse.com/?p=showitem&ID=2746
The program searches some text files for info to store in a database.
- In both my Linux boxes, with MySql
Hi,
My software use to run with mySQL 4.1, but now i have to use some of the new
features of mySQL 5.0 i did dump all databases, uninistalled mysql4.1,
installed the mysql5.0 and start loading the .sql file. This operation use
to take about 4 hours but know it is taking 1day!!! Did anything
5:09 PM
Subject: migrating 4.0 to 4.1 character set problems
Hi,
I am having character set problems while trying to migrate my data from a
server running 4.0.25-standard to a server running 4.1.16. I believe that
the orginal database was using the latin1 character set (not sure, is
there an
HOWTO: Covernt mysql 4.0.x DBs to 4.1.x #
# This will also update the character sets from #
# Latin1 to utf8 #
# #
###
1. Backup the old database. It must be backed
be supported in 4.0.x) and the default character set for the 4.1
server is latin1 as well. However when I try to import my data from a
mysqldump from the older server all accents are turned into question
marks.
I've searched the forums and mailing lists extensively for clues as
to how
Which binary did you use, and where did you download it from?
what is the result of "uname -a" ? are they both 64 bit machines?
32-bit machines? where is libstdc++ on both machines? It's possible
one machine has a library linked to another location, or they have
them in different locations. Sp
I have two FC4 computers I believe to be set up identically, I installed
mysql5 in both, the first one made the change without a hitch but the
second refuses to install with the error message:
"./bin/mysqld: error while loading shared libraries: libstdc++.so.5:
cannot open
shared object fil
On 3/3/06, Claire Lee <[EMAIL PROTECTED]> wrote:
> Hello,
> I'm going to upgrade from 4.1 to 5.0. My question is
> how do I handle the data from old version. Do I need
> to recreate tables in the mysql database when I
> install the new version or can I use the old mys
Hello,
I'm going to upgrade from 4.1 to 5.0. My question is
how do I handle the data from old version. Do I need
to recreate tables in the mysql database when I
install the new version or can I use the old mysql
database from the old version? Data in other database
I believe I can dump and i
Hello fellow listers,
I recently upgraded via RPMs from 4.1 to 5.0.18 on a RH9.0 (glibc2.3, kernel
2.4.20) machine.
Now I have problems starting the mysqld automatically. When it is invoked, the
error
"Couldn't find MySQLmanager or server" is emitted. Here is a short history
unicode in
the new setup.
> -Original Message-
> From: [EMAIL PROTECTED]
> Sent: Mon, 20 Feb 2006 13:01:20 -0500
> To: [EMAIL PROTECTED]
> Subject: Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8
>
> I also had problems converting latin1 to utf-8. For whatever reas
're not running
--compatible=[something not mysql]).
Hope this helps!
-Sheeri
On 2/18/06, David Spidley <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > Sent: Sat, 18 Feb 2006 00:12:19 +0100
> > To: [EMAIL PROTECTED]
> >
> -Original Message-
> From: [EMAIL PROTECTED]
> Sent: Sat, 18 Feb 2006 00:12:19 +0100
> To: [EMAIL PROTECTED]
> Subject: Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8
>
> On 17.02.2006 15:34 (+0100), David Spidley wrote:
>> What is the official way to tak
1 - 100 of 957 matches
Mail list logo
