Re: mysql dump problems, no data dumped

what command are you using to do the dump? I mean the entire command, including all the options. On Thu, Oct 30, 2008 at 12:25 PM, Andy Smith <[EMAIL PROTECTED]> wrote: > Hi, > > Im having an issue using mysqldump to dump a DB from comercial app which > includes mysql 4.0.18-pro. It doesnt howev

Re: "lost connection to mysql server during query" errors

In my experiences, there're three reasons below. 1. Your network is not stable. 2. Your mysqld's parameter called max_allowed_packet is adjusted too small, trying to increase it. 3. Your mysqld's parameter called connect_timeout is adjusted too small, trying to increase it. On Thu, Oct 30, 2008 at

Re: moving from 3.23.58 to 5.0.45

I think Claudio Nanni 's suggestion is the best! On Thu, Oct 30, 2008 at 8:29 PM, Claudio Nanni <[EMAIL PROTECTED]>wrote: > Hi Mark, > > from my experience I can tell you that you can easily migrate. > > A quick and dirty way is to use the two(or more) different MySQL > installations > on same se

Re: mysql dump problems, no data dumped

Hi,andy. Can you show me the details about the options of mysqldump to be used ? On Fri, Oct 31, 2008 at 1:25 AM, Andy Smith <[EMAIL PROTECTED]> wrote: > Hi, > > Im having an issue using mysqldump to dump a DB from comercial app which > includes mysql 4.0.18-pro. It doesnt however include mysq

Re: auto_increment problem

alter table tablename modify id int not null auto_increment primary key; On Sat, Oct 25, 2008 at 2:48 AM, Paul <[EMAIL PROTECTED]> wrote: > Anybody know if there's a way to change a primary key field that is not > auto-incremented, turning on auto-increment but preserving the values that > are cu

mysql dump problems, no data dumped

Hi, Im having an issue using mysqldump to dump a DB from comercial app which includes mysql 4.0.18-pro. It doesnt however include mysql dump for online backups so Im using the one installed by default in my linux dist which as you can see below is version 10.11. My problem is that the dump is exi

Re: moving from 3.23.58 to 5.0.45

On thing that tripped me up when I did the same move was the change in LEFT JOIN syntax. It now joins to the LAST table in a list. This change actually happened half way through the 4.0x series. Doesn't effect data, but does effect queries. There MAY also be a difference on how string compariso

Re: moving from 3.23.58 to 5.0.45

Hi Mark, from my experience I can tell you that you can easily migrate. A quick and dirty way is to use the two(or more) different MySQL installations on same server (or even different ones) and different ports of course. You dump the whole DB from the 3.23.58 and import it on the 5.0.45. If you

Re: moving from 3.23.58 to 5.0.45

On Thu, Oct 30, 2008 at 5:16 AM, Obantec Support <[EMAIL PROTECTED]>wrote: > Hi > > are there any doc's on how to migrate DB in 3.23.58 format to 5.0.45 > moving from a Fedora Core3 to Centos5.2 server. > > Mark > > http://www.justfuckinggoogleit.com/?q=mysql+upgrade First result. -- Rob Wultsc

moving from 3.23.58 to 5.0.45

Hi are there any doc's on how to migrate DB in 3.23.58 format to 5.0.45 moving from a Fedora Core3 to Centos5.2 server. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]