OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Backup and Restore problem

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

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Backup and Restore problem

Postby msaghaei » Thu Feb 23, 2006 1:03 am

Dear OJS support team

I backed up the OJS database on my server using a php script which outputs the whole database (data and structure) in the form of sql statements, which when executed by mysql engine restore the whole database. When I tryed to restore the database there appeared some errors as "Multiple primary keys". I checked the output sql statements and it seems to me that some tables has multiple primary keys (the full list is below).

article_files:
file_id int auto_increment primary key
revision int primary key

article_html_galley_images
galley_id int primary key
file_id int primary key

article_search_object_keywords
object_id int primary key
pos int primary key

custom_section_orders
issue_id int primary key
section_id int primary key

email_templates_data
email_key char(30) primary key
locale char(5) primary key
journal_id int primary key

email_templates_default_data
email_key char(30) primary key
locale char(5) primary key

group_memberships
user_id int primary key
group_id int primary key

journal_settings
journal_id int primary key
setting_name char(255) primary key

notification_status
journal_id int primary key
user_id int primary key

plugin_settings
plugin_name char(80) primary key
journal_id int primary key
setting_name char(80) primary key

review_rounds
article_id int primary key
round int primary key

roles
journal_id int primary key
user_id int primary key
role_id int primary key

section_editors
journal_id int primary key
section_id int primary key
user_id int primary key

versions
major int primary key
minor int primary key
revision int primary key
build int primary key

I wonder wether this is a bug in the back up script or there are really multiple primary keys in the mentioned tables.
Thank you

M Saghaei
msaghaei
 
Posts: 119
Joined: Sun Jan 08, 2006 1:01 pm

Postby asmecher » Thu Feb 23, 2006 10:59 am

Hello msaghaei,

That's probably a bug in the backup script. There are many tables with multiple keys, which is allowed, but not multiple primary keys, which is not valid SQL.

Have you considered using mysqldump to accomplish this task?

Regards,
Alec Smecher
Open Journal Systems Team
asmecher
 
Posts: 7710
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Yahoo [Bot] and 7 guests