Installing or updating to Ghost 0.4.2 with a MySQL Database
Posted by on 29 October 2013 11:23 AM
Note: the tactic detailed below ONLY works for shared plans. If you have a VPS/Cloud or Dedicated server, no fear... just get in touch with us. We'll prep your server for the Ghost change.
Preparing Your Account For Ghost
Note: you can now use Ghost in a subfolder, but you cannot use the folder "ghost" or you'll break it!
Configure Ghost for Your Website and Database
Install Ghost's Dependencies
If you're interested in multiple configurations or using SQLite, read on....
Multiple Configurations, SQLite and more
Ghost also supports SQLite for a database backend, along with multiple configurations. For instance, you could set up a developer config with an SQLite database for testing. In the config.js file from earlier we only had you adjust the production configuration.
To set up an alternate configuration:
filename: path.join(__dirname, '/content/data/mytesting.db')
Note: all settings are stored in the database, so don't be surprised that it looks like a newly installed blog. Simply revert the change in the .htaccess file and restart Ghost again to bring it back.
Backing up Ghost
Ghost does provide rudimentary backup features, but please be aware that backups consist of text only. Binary items such as images are not included. For example purposes, we'll assume ghost is located at
Ghost is behaving very strangely, images and links are broken, stylesheets are missing, etc and soforth!
Did you install Ghost to a sub-directory, with something like Wordpress installed above it? If so, the .htaccess file above the ghost install is most likely causing the problem. Open the .htaccess file you created for Ghost, and add this line at the top, then save the file:
I changed or updated Ghost's theme and the changes aren't displaying!
Since Ghost runs as a persistent process for an amount of time, Ghost simply needs to be restarted for the changes to take effect. To do this, simply:
Remember that the above path is only an example, you'd need to touch thefile under your actual ghost install.