Restoring a OCS 1.0 for Windows Conference site

Are you responsible for making OCS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, michael, John

Forum rules
The Public Knowledge Project Support Forum is moving to

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
Posts: 10
Joined: Tue Jan 23, 2007 11:38 pm
Location: Queensland, Australia

Restoring a OCS 1.0 for Windows Conference site

Postby ll » Tue Jun 26, 2007 5:39 pm

Dear All,

I have OCS 1.0 running in production on a Windows Server 2003 box (IP# is xxx.yyy.zzz.237) with software installed in the partiton G: (G: is the Windows drive letter). It is setup as a multiple conference system but with only one conference instance hosted at the moment.

I built another OCS server on another Windows 2003 box (IP# xxx.yyy.zzz.236) with software installed on C: (not G:) - this is going to be a backup for the production server which is now hosting a live conference. This back-up server is also setup as a multiple conference system with the same admin credentials as the production server.

I did a backup from the production server (through the Multiple Conference Manager) and it created just one file named ocs-backup-yyyy-mm-dd.sql. Before restoring this file, I opened it in Windows Notepad and changed the reference to G:// to C:// (one occurrence) and the server ip address from zzz.237 to zzz.236 (again one occurrence). When I restored this file to the backup server (ie xxx.yyy.zzz.236), it gives the following error:

"Backup/Restore Conference Database
Error importing backup file 121
C:\ocs\conference\admin\backup.php CREATE TABLE papers( cf int(11) NOT NULL, id int(11) NOT NULL auto_increment, first_name varchar 6 ((*** stuff deleted ***).

I can access the conference which is hosted on the system. However, Papers/asbtracts and Reviewers are missing from the conference site.

Thank you for your help in advance.


Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Postby asmecher » Tue Jun 26, 2007 10:51 pm

Hi Lucky,

This is probably a MySQL version incompatibility rather than an OCS bug. Try running the SQL dump directly into the mysql command line tool, e.g.

Code: Select all

mysql -u username_here -p < /path/to/dump_file.sql
It'll tell you where the bug is and provide more information.

Alec Smecher
Public Knowledge Project Team
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada

Return to “OCS Technical Support”

Who is online

Users browsing this forum: No registered users and 1 guest