[thelist] MySQL dump

Michele Wandrei michele at inthree.com
Sat Jul 7 23:21:20 CDT 2001


> Hi, is there anybody here from evolt that can tell me if I can use some
> sort of mysqldump to dump out the database from my mysql installation into
> this one.

Sure.

 From the directory where your dumped file will reside:
mysqldump -u user -pPassword dbname > filename.sql

(note that there is no space between -p and your password)

To restore from the dumped file, start in the directory where the file
resides:
mysql -u user -pPassword dbname < filename.sql


Hope this helps!
___________________________________________________
Michele Wandrei
inThree Design
www.inthree.com








More information about the thelist mailing list