[geeks] Mysql backup questions...

[Brian Dunbar]

On Apr 12, 2005, at 9:14 AM, Sandwich Maker wrote:

> " From: Brian Dunbar <brian.dunbar at plexus.com>
> "
> "
> " This is how my host provider recomends that you backup / restore your
> " database
> "
> " []
> "
> " restore
> " cat filename.sql | mysql -uusername -ppassword -h yourMySQLHostname 
> dbname
>
> uuoc?
>
> why not
> mysql -uusername -ppassword -h yourMySQLHostname dbname < filename.sql
> ?

That would probably work - it's one of those things that the provider 
suggested, it works, so I've gone with it.  None of the hosted 
databases I have to work with are very large - a stock tracking db, 
word-press and housekeeping stuff for a startup business.

Brian Dunbar
System Administrator II
Desk: (920) 751-3364
Cell: (920) 716-2027
brian.dunbar at plexus.com
http://www.plexus.com