Create the Database
Now, that the server is up and running, you are ready to start the database creation with the following command:
mysqladmin -u root CREATE 'cascade'
That will create the Cascade database. You can replace root (the default administrator account for MySQL) with any username with appropriate privileges and 'cascade' (the database name) with whatever you find appropriate. Now after creating the database you need to set up the database default character set and collation. Cascade uses UTF-8 character set for support of many different languages. To specify the character set and collation you log on to MySQL:
mysql -u root -p
and then execute:
ALTER DATABASE 'cascade' DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
where 'cascade' is the database name. If everything is correct, you should see the following:
Query OK, 1 row affected (0.00 sec)
now type:
exit
Finally, we are ready to import our data into the database. Provided that the import file is in the current directory, you can proceed with this:
mysql --default-character-set=utf8 -u root -p 'cascade' < cascade.sql
Make sure no errors appear on the screen. If so, you are ready to start the Cascade application.