[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