OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



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.

Migration problem

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

Hi!

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

article_search_object_keywords

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

Moving to another server

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

Sergio,

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.
ramon
 
Posts: 945
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

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.

Regards,
Alec Smecher
Open Journal Systems Team
---
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
http://ocs.sfu.ca/pkp2007/
asmecher
 
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: Google [Bot], Yahoo [Bot] and 3 guests