[Deploying Sakai] Fwd: Reg : How to copy the machine A Sakai to machine B sakai

Steve Swinsburg steve.swinsburg at gmail.com
Sun Jul 1 14:16:25 PDT 2012


What version Sakai are you running on the second system? It needs to match the first. Then you need to upgrade the database.

Sent from my iPhone

On 02/07/2012, at 0:46, prabhu <prabhu142003 at gmail.com> wrote:

> 
> Hi
> 
> Thanks for your reply..
> 
> I have dump of my database which is 2.3GB. 
> 
> And i tried to import the dump into the machine B's database with the following command
> 
>  mysql -u sakai -p -h localhost sakai25x < mysqldump.olc.sql
> 
> after entering the password,
> 
> its shows the following message, repeatedly in an interval of 1 minute.
> 
> What could be the cause? 
> 
> How to restore such a large database into mysql?
> 
> The below error message was noticed in the catalina.out log file.
> 
> 
> 2012-07-01 09:44:42,330 ERROR QuartzScheduler_QuartzScheduler-OLC_MisfireHandler
>  org.quartz.impl.jdbcjobstore.JobStoreTX - MisfireHandler: Error handling misfir
> es: Couldn't retrieve trigger: Column 'PRIORITY' not found.
> org.quartz.JobPersistenceException: Couldn't retrieve trigger: Column 'PRIORITY'
>  not found. [See nested exception: java.sql.SQLException: Column 'PRIORITY' not
> found.]
>         at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStore
> Support.java:1572)
>         at org.quartz.impl.jdbcjobstore.JobStoreSupport.recoverMisfiredJobs(JobS
> toreSupport.java:949)
>         at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobSto
> reSupport.java:3126)
>         at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(Jo
> bStoreSupport.java:3874)
>         at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobSt
> oreSupport.java:3894)
> Caused by: java.sql.SQLException: Column 'PRIORITY' not found.
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
>         at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1093)
>         at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2734)
>         at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSe
> t.java:237)
>         at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDel
> egate.java:2129)
>         at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStore
> Support.java:1554)
>         ... 4 more
> 
> 
> 
> 
> 
> On Sun, Jul 1, 2012 at 2:15 AM, Steve Swinsburg <steve.swinsburg at gmail.com> wrote:
> Hi
> 
> Just dump your database and import it into the new one. However you should use MySQL 5.1.
> 
> S
> 
> Sent from my iPhone
> 
> On 01/07/2012, at 4:47, prabhu <prabhu142003 at gmail.com> wrote:
> 
> > hi,
> >
> > I have two servers running. Let me name it as Machine A and Machine B.
> >
> > I have sakai 2.8.0 up and running for the past few months on Server A which is having mysql version of 5.0.26
> >
> > Now, i want to move that to Machine B which is having mysql version of 5.5.16.
> >
> >
> > How to do that?
> >
> > If any suggestions please help me..
> >
> >
> > --
> > Regards:
> >
> > J.PRABHU,
> > RedHat Certified Engineer,
> > Cisco Ceritified Network Associate,
> > Coimbatore.
> > _______________________________________________
> > production mailing list
> > production at collab.sakaiproject.org
> > http://collab.sakaiproject.org/mailman/listinfo/production
> >
> > TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
> 
> 
> 
> -- 
> Regards:
> 
> J.PRABHU,
> RedHat Certified Engineer,
> Cisco Ceritified Network Associate,
> Coimbatore.
> 
> 
> 
> -- 
> Regards:
> 
> J.PRABHU,
> RedHat Certified Engineer,
> Cisco Ceritified Network Associate,
> Coimbatore.
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
> 
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20120702/ca81658d/attachment.html 


More information about the production mailing list