Hi.
Working on Linux, I've got installed MySQL 3.23.58, but I'm
experiencing some problems. For instance, I suffer too many
connections error but I cann't set 'max_connections' parameter to a
value bigger than 250.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed
On Wed, 2007-11-07 at 10:22 +0100, thomas Armstrong wrote:
Hi.
Hello,
Working on Linux, I've got installed MySQL 3.23.58, but I'm
experiencing some problems. For instance, I suffer too many
connections error but I cann't set 'max_connections' parameter to a
value bigger than 250.
... and
Hi Tiago. Thank you very much for your answer.
I decided to migrate to MySQL 5.0, and I've got some questions:
- I installed MySQL from sources on '/usr/local/mysql'. Is it as easy
as installing it again on '/usr/local/mysql5'?
Yep. Just change the '--prefix' com './configure' time.
ok
Hi All
Make sure you use the mysqldump from version 5 and not version 3. Also
recheck all your application queries once you have restored the data the
list of changes SQL syntax might haunt you.
Mark
thomas Armstrong wrote:
Hi Tiago. Thank you very much for your answer.
I decided to
Make sure you use the mysqldump from version 5 and not version 3. Also
recheck all your application queries once you have restored the data the
list of changes SQL syntax might haunt you.
But can I use '/usr/local/mysql5/bin/mysqldump' to dump data of MySQL 3?
--
MySQL General Mailing List
Never tried it with version 3 only 4.1 but it has a --compatible switch
with a version 3.23 switch see command line --help so I assume the mysql
guys are allowing you to dump 3.23. Try dumping it without the switch as
you will be restoring to 5.0. The idea is to make sure the restore is
done