MySQL on Windows
Running the Content Engine's database scripts on Windows is not quite as simple as the example shown in step 5 of Install Database. You will need to run each script individually as follows:
cd mysql-home\bin mysql -u username -p database < engine\database\mysql\tables.sql mysql -u username -p database < engine\database\mysql\indexes.sql mysql -u username -p database < engine\database\mysql\constants.sql mysql -u username -p database < engine\database\mysql\constraints.sql
where:
-
mysql-home is the path of the folder in which you installed MySQL.
-
username is the SQL user name.
-
database is the name of the Content Engine database.
-
engine is the path of the folder in which you installed the Content Engine.