CREATE DATABASE IF NOT EXISTS `old_redmine_database` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci īundle install -without development test rmagick Vi redmine_backup_11032020.sql - Database: `old_redmine_database` ![]() Edit the backup sql file to remove the lines that create the old database.Restore your Redmine database into OpalStack MariaDB.Use FileZilla or SCP to upload the sql backup to your new server.You should rename this file to something like redmine_backup_.sql Your browser should download a localhost.sql file.Navigate to EXPORT, leave Quick selected, select SQL from the drop dropdown and press GO.Note: if you don't have the user and password name you can get them from the redmine database.yml file located on your server under: ~/webapps/redmine/redmine/config/database.yml Login to phpMyAdmin (, where XXX is the server number) using your database user name and password.Backup existing Redmine MySQL Webfaction Database.Restore an Existing Redmine Database (Optional) # Use "utf8" instead of "utfmb4" for MySQL prior to 5.7.7 Setup Redmine Database YML File cd $REDMINE_APP_PATHĬp config/ config/database.ymlĬhange the database.yml file to match your setup production: This just makes it easier to use the commands belowĮxport RAILS_APP_PATH=/home/$USER/apps/$RAILS_APPĮxport REDMINE_APP_PATH=$RAILS_APP_PATH/redmine-$REDMINE_VERĮxport PATH=$RAILS_APP_PATH/env/bin:$REDMINE_APP_PATH/bin:/usr/pgsql-11/bin/:$PATH Setup your environment # Change these to match your setup. I am using MariaDB even though there are known issues, since I need to port from MySQL on WF.Either use the password on Notices page or change the MariaDB User Password (e.g., DB_USER=redmine, DB_PASSWORD=) Note: a password will automatically be created for you and available on the Notices page. Note: the database name and user will be the same Create a MariaDB Database (e.g., DB_NAME=redmine).Create a Domain to point to Redmine (e.g., SITE=).Create a Ruby On Rails application (e.g., RAILS_APP=redmine).This should help anyone that needs to get Redmine running on OpalStack. # since you don't have to restart the webserver when you make code changes.After lots of searching for how to install redmine on a VPS, I was able to cobble together the following instructions. This slows down response time but is perfect for development Usually this option set to false in development with the following comment: # In the development environment your application's code is reloaded on Open config/environments/production.rb and change line config.cache_classes = true Since (for now) you are interested only in source code updates per request, you can change only one parameter in rails configuration to do so. It is better to create separate database for development environment, but not necessary, since you're already developing in production.įind your web-server configuration file and change in there environment to development. In this mode source code files are read by server upon every request.Ĭhange database.yml, so it will have the same configuration options as in production mode. ![]() ![]() You could switch to rails development environment.
0 Comments
Leave a Reply. |