[geeks] MySQL question

[Patrick Giagnocavo +1.717.201.3366]

On Mon, May 24, 2004 at 10:58:59PM -0400, Phil Stracchino wrote:
> On Mon, May 24, 2004 at 09:48:16PM -0500, Bill Bradford wrote:
> > On Thu, May 20, 2004 at 09:37:56AM -0400, Caleb Shay wrote:
> > > My standard line for backing up my mysql servers is:
> > > mysqldump -AacCe --allow-keywords --add-drop-table
> > 
> > What's your standard command for *restoring* from this single huge file?
> 
> 
> mysql < file
> 
> 
> If you want to restore individual databases, of course, it's probably
> easier to create individual dumps.  But I figure about the only reason

if you have a chance, please do look at Postgresql.  Provided your app
can use it, it is a much better choice in many ways.  apologies if
this idea has already been put forth.
--P