Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: msilkjr on December 27, 2004, 05:56:43 PM

Title: restoring a mysql database
Post by: msilkjr on December 27, 2004, 05:56:43 PM

ok so I got a sql file I backedup. Nowhow do I import it?

I did - mysqldump -c YOURDBNAME > /path/yourdbname.sql
to back it up. so how do I get it back in ?

Title: restoring a mysql database
Post by: ergozd on December 27, 2004, 06:17:43 PM

You can find lots to read at
http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html

You can also try using phpmyadmin
http://mirror.contribs.org/smeserver/contribs/nightspirit/e-smith-phpmyadmin/

Best rgds, Ergin

Title: restoring a mysql database
Post by: Damian on December 31, 2004, 12:00:49 PM

Try:

cat  /path/yourdbname.sql  | mysql YOURDBDBNAME

Damian