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

[prabhu]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20120701/a9a0802a/attachment.html