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 us
> 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
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 mi
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
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.
..
