Sorry, I wasn't paying attention. I didn't realize you were talking about the mysql db. Downgrade to 3.23.52. Import the .sql from your previous dump. Then upgrade per the latest manual ensuring your upgrade the grant tables (per page 138 in the new pdf manual). I hope this is a little more helpful. Pat...
How many rows are we talking about here? Would hand editing your sql file be reasonable ----- Original Message ----- From: "Ronan Lucio" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 06, 2004 5:37 PM Subject: Re: mysqldump > Patrick, > > > >From your description, I assume you already have data in an existing > version > > 4 database that has existing table structures that are different from your > > 3.23 dump. > > I didnīt have datas, but I had already run the mysql upgrade script. > Because the original version of the MySQL in Linux distribution is > 3.23.58 and choose to upgrade it first. > > > Alternatively, if you don't need the data from the existing database drop > it > > and recreate it. Then run your dump against it, followed by the necessary > > alter table statements. > > May I drop even the columns_priv and db databases and after restore > I gain all fuctionalities and performance from MySQL-4.0.x? > > Thanks, > Ronan > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]