Thanks Jeremy :)
>From: Jeremy Zawodny <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Desmond Lee <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: exporting data >Date: Fri, 2 Aug 2002 15:59:01 -0700 > >On Fri, Aug 02, 2002 at 03:55:52PM -0700, Desmond Lee wrote: > > Hi guys > > > > I know that you can import data into a table by using 'load data infile' >or > > 'mysql' import. > > > > however, is there something that allows you to export the create >statemtns > > for the table schema and the data of a database for backup. SO that if >we > > reinstall the whole thing from scratch all we need are the exported >files > > that will recreate the whole database from the time we exported? > >mysqldump will do it. > >Jeremy >-- >Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! ><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > >MySQL 3.23.51: up 64 days, processed 1,352,277,811 queries (240/sec. avg) _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php