Good question:
I do the following and wonder if I should or shouldn't do it this way?
To backup the database I mysqldump databasename >
/dir_name/dir_name/dir_name/databasename.dump -u username -p
Then to input the info on another computer running mysql or back into a database I
create the database with mysqladmin create databasename
Then I use cat databasename.dump | mysql databasename
Is this correct?
Thanks,
Douglas
Steve Ruby wrote:
> Paul Glace wrote:
> >
> > I have a .sql file that I created by dumping the contains of a mySQL
> > database using mysqldump. Can I now populate a new database from the .sql
> > file?
>
> http://www.mysql.com/documentation/mysql/commented/manual.php?section=mysqldump
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/php/manual.php" before
> posting. To request this thread, e-mail mysql-thread50452@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-brantzdr=appstate.edu@stripped>
>
> If you have a broken mail client that cannot send a message to the above
> address(Microsoft Outlook), you can use http://lists.mysql.com/php/unsubscribe.php
--
Douglas Brantz
Computer Consultant
Fine & Applied Arts
Appalachian State University
Boone, NC 28608
828-262-6312 FAX
828-262-6549 OFFICE
brantzdr@stripped
