WikiSysop: Update link to Community_Portal page

2023-10-26T13:58:08Z

Update link to Community_Portal page

← Older revision		Revision as of 15:58, 26 October 2023
Line 38:		Line 38:
	You should now have a working installation of the most recent refbase version.		You should now have a working installation of the most recent refbase version.

	[[refbase:~~Community_Portal~~\|Let us know]], if you run into any problems!		[[refbase:Community_portal\|Let us know]], if you run into any problems!

	[[Category:Installation]]		[[Category:Installation]]
	__NOEDITSECTION__		__NOEDITSECTION__

WikiSysop: Hide section edit links

2023-10-26T13:55:29Z

Hide section edit links

← Older revision		Revision as of 15:55, 26 October 2023
Line 41:		Line 41:

	[[Category:Installation]]		[[Category:Installation]]
			__NOEDITSECTION__

WikiSysop: Original page content from 31-Oct-2008

2023-10-26T13:55:02Z

Original page content from 31-Oct-2008

New page

This document describes how to upgrade an existing refbase installation to the most recent version. See the 'UPDATE' file that comes with the refbase package for latest information regarding the update process.

== Backup your database & settings ==

We strongly recommend to [[backup the database|backup]] your existing refbase database before proceeding! You may also want to make a backup copy of your refbase scripts folder. It's especially important that you make a backup copy of the files ''db.inc.php'' and ''ini.inc.php'' (which are located within the ''initialize'' subdirectory of your refbase base directory).

== Download and install scripts ==

[http://sourceforge.net/project/showfiles.php?group_id=64647 Download] the latest stable release version (or, alternatively, get the latest development version of refbase from the refbase [[SVN_version|SVN repository]]). Then, unpack the download archive (if necessary) and copy all refbase scripts to your server's web directory.

If you haven't done already, you may want to download [[Bibutils]] and copy the binaries to an executable path. Bibutils provides additional import and export funtionality to refbase (e.g. support for Endnote & BibTeX). It is optional, but highly recommended. See [[Bibutils#Installing_Bibutils_for_use_with_refbase|here]] for help on how to enable Bibutils for an existing refbase installation.

== Re-apply your database settings ==

Open the new files ''db.inc.php'' and ''ini.inc.php'' and insert again your modifications from the old ''db.inc.php'' and ''ini.inc.php'' files which you backed up in step 1. A good [http://en.wikipedia.org/wiki/Text_editor text editor] (or [http://en.wikipedia.org/wiki/File_comparison file comparison] tool) that is able to compare two versions of the same file can help to solve this task.

== Update MySQL database ==

There are two methods (web-based & manual) to update the refbase MySQL database. The web-based update method uses the ''update.php'' script and is highly recommended since it's update mechanism is generally smarter and more flexible than the manual update method which uses ''update.sql''. In any case, your data should remain untouched by the update operation.

Note that the update process requires a MySQL user that has administrative permissions for the refbase MySQL database, which must include these permissions:

SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, INDEX

=== Web-based update ===

Point your web browser to ''update.php'', supply the user name and password of a MySQL user that has administrative permissions for the refbase MySQL database (see above), and click the "Update" button to complete the update process. A detailed log will be generated for all performed update actions.

=== Manual update ===

If, for some reason, you cannot use the (recommended) web-based update method, you can use the MySQL structure file (''update.sql'') that comes with the refbase package to manually add/alter the MySQL tables that were added/changed in the newest refbase version. To perform the database update, open a command line shell, make your deployment directory the current working directory (<code>cd ...</code>) and execute the following command:

mysql -h localhost -uADMINUSER -p --database=DATABASE_NAME < update.sql

where <code>DATABASE_NAME</code> is the database name that you've specified in variable <code>$databaseName</code> (in file ''initialize/db.inc.php'') for refbase. <code>ADMINUSER</code> must be replaced with the name of the MySQL user that has administrative permissions for the refbase MySQL database (see above). You'll be asked for the password of this user to confirm execution of this command.

You should now have a working installation of the most recent refbase version.

[[refbase:Community_Portal|Let us know]], if you run into any problems!

[[Category:Installation]]

Updating refbase - Revision history

WikiSysop: Update link to Community_Portal page

WikiSysop: Hide section edit links

WikiSysop: Original page content from 31-Oct-2008