creating database using dump file
Posted: Thu Aug 29, 2002 4:42 am
Hi all;
I am trying to create a database using a dump file, but am not too sure how to do it.
1)I know/think that this is the command I have to use :
mysql> mysql -u <username> -p <password> -D <database> < news.sql
but it doesn't seem to work and just spits out errors.
2)where do i put my news.sql file
thanks
I am trying to create a database using a dump file, but am not too sure how to do it.
1)I know/think that this is the command I have to use :
mysql> mysql -u <username> -p <password> -D <database> < news.sql
but it doesn't seem to work and just spits out errors.
2)where do i put my news.sql file
thanks