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.