Quote:
Originally posted by blazin
Hi Tipsy 
Assuming your using unux or similiar try this:
mysqldump -u DBUSER DBNAME -p > dbdump.sql
then run your db client and type >
create database NEWDBNAME;
exit the client then do this
mysql -u DBUSER NEWDBNAME -p < dbdump.sql
(of course replacing the italics with your db details)
Hope that helps
|
Thanks blazin - only way I know how to do it. Just wodering if there was a quicker/easier way.