Duplicate key name when importing mysql dump file

2009-06-17 Thread Jason Novotny
Hi, I'm trying to import a dumpfile like so: cat aac.sql | mysql -u root AAC It all runs fine until I get something like: ERROR 1061 (42000) at line 5671: Duplicate key name 'FK_mediaZip_to_zipSet' Is there a way I can tell it to ignore or replace the key? Thanks, Jason -- MySQL Gene

Open Source Database Magazine

2009-06-17 Thread bmurphy
hello everyone, Many of you know I have been the editor of MySQL Magazine for the last two years. Beginning with the summer issue I will be making some pretty major changes. The magazine is being renamed Open Source Database Magazine and I am going to be attempting to steer the subject matter to i

Re: myisamchk buffer_size warnings

2009-06-17 Thread Thomas Spahni
On Wed, 17 Jun 2009, Johan De Meersman wrote: Aren't those options defined in megabytes ? On Tue, Jun 16, 2009 at 4:59 PM, Thomas Spahni wrote: Hi I have MySQL 5.0.64 compiled from source. When I run myisamchk on any table I get the following warnings: Warning: