Help Restoring a MySQLdumped database...????

2002-02-25 Thread Miretsky, Anya 

How do I restore a Mysqldump of a database? I've found documentation on how
to backup a db and have done but I can't figure out how to create a new db
from my dump file? Please help.

thanks

Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY  11225

(718)623-7265
[EMAIL PROTECTED] 

-
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

Re: Help Restoring a MySQLdumped database...????

2002-02-25 Thread Georg Richter 

On Monday, 25. February 2002 17:47, Miretsky, Anya wrote:
 How do I restore a Mysqldump of a database? I've found documentation on how
 to backup a db and have done but I can't figure out how to create a new db
 from my dump file? Please help.

1) Create an empty db yourdb
2) mysql -uuser -ppassword yourdb  yourdump.sql

Thats all

Regards

Georg

-
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