Help restoring db?

[Christopher McCrory]

On Mon, 2005-04-18 at 13:01 -0700, Patrick Campbell wrote:
> This may not be the right forum for this so if it is I apologize - I
> have backed a bugzilla database using:
> 
> mysqldump -u root -p bugs > bugzilla.20050418 and am trying to import
> it on 
> a new mysql server using
> 

You might try:

mysqldump --opt -u root -p bugs > bugzilla.20050418.sql

yes?


> mysql -u root -p bugs < bugzilla.20050418
> 
> I'm getting 
> ERROR at line 84:
> 
> Line 84 is all garbled text...
> 
> Working with 3.23.58 ... Any thoughts? 
> 
> 
> --  
> Patrick Campbell 
> OurVacationStore.com 
> Website Administrator 
> Tel. 602.896.4729
> 
-- 
Christopher McCrory
 "The^W One of the guys that keeps the servers running"

chrismcc at pricegrabber.com
 http://www.pricegrabber.com

Let's face it, there's no Hollow Earth, no robots, and
no 'mute rays.' And even if there were, waxed paper is
no defense.  I tried it.  Only tinfoil works.