[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: mysql backup



On Thu, Dec 07, 2000 at 10:14:06AM +1100 or thereabouts, John Griffiths wrote:
> okies well i've figured out the answer to functional (possibly even correct) mysql backup and restore on debian potato.
> 
> i know i'm not the only person on this list who needs to know this so i'm posting up what works for me.
> 
> to create the backup:
> 
> #mysqldump -c -p DBNAME > DBNAME.sql
> 
> to retreive the database 
> 
> #mysqladmin -p create DBNAME
> #mysql -p DBNAME < DBNAME.sql
> 
> Hope this helps.

yup just in time! ;-)

thx.

-- 


--------------------------------------------------------------------
Key fingerprint = 9DE1 5825 77B4 FF45 7485  D3EB DCCF DE48 09B6 4426
--------------------------------------------------------------------

"Who's watching the watchmen?"

Attachment: pgpLGFPqNsaFm.pgp
Description: PGP signature


Reply to: