Open the command propmpt
First create the database by name alfrescotest
go to the location where your alfresco.sql is been stored which is been got from sqldump command and reun the below command
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p alfrescotest < alfresco.sql
The command for exporting the databse is as below.
Open any location and run this command.
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -u root -p alfresco > alfresco.sql
D:\b\trunk\alfresco-server-bm335\alf_data>mysql -u root -p alfresco335<Dum
ReplyDeletep20101220alfresco333.sql
Enter password: ****
Here alfresco335 is the name of the database