Migration 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
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

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: 31
Joined: Wed Aug 03, 2005 12:04 am
Location: Spain

Migration problem

Postby SergioRuiz » Mon Jan 29, 2007 5:37 am


We're migrating OJS from one server to another. Everything is running smoothly, but we have a problem with the database, actually with one table from the database


It is quite a big table (10 mb) and I cannot export it from one server to another (we use mysql). It looks like it stores articles keywords or something similar, and whilst it is only partially copied, it looks like everything is working fine.

Question is... is there any way to export a table in mysql in different pieces? is there a way to re-generate this table contents?

Any help will be appreciated. Greetings from Spain,

Sergio Ruiz

Posts: 945
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

Moving to another server

Postby ramon » Tue Jan 30, 2007 9:37 am


If I'm not mistaken, the article_search_object_keywords table is used to speed up the search engine, and it is built while using the system. I don't think it will affect the use.

However, you can dump parts of the database, instead of a full dump.
Having PHPMyAdmin (or PGPadmin for PostgeSQL databases) to view your databases via web makes it easier to export parts of the database as either zip or plain sql files.
Then, you can import them into the other server.

Via shell it may be more difficult but you should be able to accomplish that.

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

Postby asmecher » Tue Jan 30, 2007 10:11 am

Hi Sergio,

I've moved extremely large databases from server to server using mysqldump and netcat as follows:
  • On the sending server, run:

    Code: Select all

    mysqldump -u (username) -p (database name) | gzip -c -9 - | nc -l -p 5000
    Enter the password and press <Enter>.
  • On the receiving server, run:

    Code: Select all

    nc (IP of sending server) 5000 | gunzip -c - | mysql -u (username) -p (database name)
    Enter the password and press <Enter>. The transfer should start.
However, the article_search_... tables don't need to be transferred; you can re-generate them with the tools/rebuildSearchIndex.php script.

Alec Smecher
Open Journal Systems Team
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada

Return to “OJS Technical Support”

Who is online

Users browsing this forum: No registered users and 3 guests