Backup and Restore problem

[msaghaei]

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

[asmecher]

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