List:General Discussion« Previous MessageNext Message »
From:Douglas Brantz Date:September 12 2000 6:09pm
Subject:Re: mysqldump
View as plain text  
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?



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?
> --
> ---------------------------------------------------------------------
> Please check "" before
> posting. To request this thread, e-mail mysql-thread50452@stripped
> To unsubscribe, send a message to:
>     <>
> If you have a broken mail client that cannot send a message to the above
> address(Microsoft Outlook), you can use


Douglas Brantz
Computer Consultant
Fine & Applied Arts
Appalachian State University
Boone, NC 28608

828-262-6312 FAX
828-262-6549 OFFICE

mysqldumpPaul Glace12 Sep
  • Re: mysqldumpSteve Ruby12 Sep
  • Re: mysqldumpDouglas Brantz12 Sep