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
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.
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,
- Posts: 31
- Joined: Wed Aug 03, 2005 12:04 am
- Location: Spain
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: 945
- Joined: Wed Oct 15, 2003 6:15 am
- Location: Brasília/DF - Brasil
I've moved extremely large databases from server to server using mysqldump and netcat as follows:
- On the sending server, run:
Enter the password and press <Enter>.
- Code: Select all
mysqldump -u (username) -p (database name) | gzip -c -9 - | nc -l -p 5000
- On the receiving server, run:
Enter the password and press <Enter>. The transfer should start.
- Code: Select all
nc (IP of sending server) 5000 | gunzip -c - | mysql -u (username) -p (database name)
However, the article_search_... tables don't need to be transferred; you can re-generate them with the tools/rebuildSearchIndex.php script.
Open Journal Systems Team
Don't miss the First International PKP Scholarly Publishing Conference
July 11 - 13, 2007, Vancouver, BC, Canada
- Posts: 10015
- Joined: Wed Aug 10, 2005 12:56 pm
Return to OJS Technical Support
Who is online
Users browsing this forum: Bing [Bot], Google [Bot] and 2 guests