LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 05-15-2014, 04:05 PM   #1
abhijeetdutta
Member
 
Registered: Aug 2009
Posts: 135

Rep: Reputation: 16
Migrating from HSQLDB to MySQL


i am " Migrating from HSQLDB to MySQL " and will update the forum how the process going on.

if i face issue anywhere, will let you know as-well and ask for the help

cheers

Last edited by abhijeetdutta; 05-15-2014 at 04:07 PM.
 
Old 05-15-2014, 04:32 PM   #2
szboardstretcher
Senior Member
 
Registered: Aug 2006
Location: Detroit, MI
Distribution: GNU/Linux systemd
Posts: 3,369
Blog Entries: 1

Rep: Reputation: 1088Reputation: 1088Reputation: 1088Reputation: 1088Reputation: 1088Reputation: 1088Reputation: 1088Reputation: 1088
Sounds like someone let a development system get turned out to production before they were ready too!!

I've had great success in this situation using the Mysql Workbench which does migrations. Give it a try.

https://www.mysql.com/products/workbench/
 
Old 05-16-2014, 03:37 AM   #3
heytimc
LQ Newbie
 
Registered: Nov 2003
Distribution: Centos 6.5/Fedora 19/Ubuntu 14.10
Posts: 10

Rep: Reputation: 4
What was your decision made on?

I continually examine mySQL and personally I wouldn't migrate to it unless there was a very special set of circumstances. We chose PostgreSQL instead (in fact we replaced Oracle with it and have never regretted it) for far better ACID compliance.

May I ask your decision points, abhijeetdutta, for moving from HSQLDB and why did you chose mySQL?
 
Old 05-16-2014, 01:31 PM   #4
raje
LQ Newbie
 
Registered: Jan 2012
Posts: 1

Rep: Reputation: Disabled
I did it successfully along with getting smtp mail server cofigured
 
Old 05-19-2014, 09:39 AM   #5
abhijeetdutta
Member
 
Registered: Aug 2009
Posts: 135

Original Poster
Rep: Reputation: 16
Hello,

I am really sorry for my late reply, as i was suffering from cough and cold.

Regarding my post, i did it successfully.

@ szboardstretcher- Thanks for your recommendation, i also followed same and it works for me.

Below url help me alot

https://community.igniterealtime.org...20mysql_en.pdf

https://confluence.atlassian.com/dis...SQLDB+to+MySQL

You need install some jar files and other stuffs to make it run successfully

Thanks
 
Old 05-19-2014, 09:45 AM   #6
abhijeetdutta
Member
 
Registered: Aug 2009
Posts: 135

Original Poster
Rep: Reputation: 16
Hello heytimc

regarding your question " for moving from HSQLDB and why did you chose mySQL? ", reason, i am using openfire HSQLDB as backend. we are planning to hookup this box to AD server and HSQLDB not responding as our expectations initially.

This the reason, i migrated my servers to mySql.

Thanks
 
Old 05-19-2014, 10:14 AM   #7
heytimc
LQ Newbie
 
Registered: Nov 2003
Distribution: Centos 6.5/Fedora 19/Ubuntu 14.10
Posts: 10

Rep: Reputation: 4
But why?

I meant more specifically what criteria did you use to select mySQL? There are many databases to choose from - what business match did the features of mySQL make that made you choose it over others like PostgreSQL?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Migrating to MariaDB from MySQL LXer Syndicated Linux News 0 10-15-2013 06:10 AM
Migrating MySQL Data stranger_6_7 Linux - General 1 08-17-2007 10:51 AM
Migrating db relationships from Access to MySQL crashsystems Linux - Server 2 02-10-2007 01:21 PM
Switching from MySQL to HSQLDB shortblock Linux - General 0 04-01-2006 09:03 AM
HSQLDB - Has anybody used it? sekelsenmat Programming 3 06-12-2005 04:29 AM


All times are GMT -5. The time now is 08:10 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration