LinuxQuestions.org
Visit Jeremy's Blog.
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, 03:05 PM   #1
abhijeetdutta
Member
 
Registered: Aug 2009
Posts: 141

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 03:07 PM.
 
Old 05-15-2014, 03:32 PM   #2
szboardstretcher
Senior Member
 
Registered: Aug 2006
Location: Detroit, MI
Distribution: GNU/Linux systemd
Posts: 4,278

Rep: Reputation: 1693Reputation: 1693Reputation: 1693Reputation: 1693Reputation: 1693Reputation: 1693Reputation: 1693Reputation: 1693Reputation: 1693Reputation: 1693Reputation: 1693
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, 02:37 AM   #3
heytimc
LQ Newbie
 
Registered: Nov 2003
Distribution: Centos 7/Ubuntu 20.04.2
Posts: 14

Rep: Reputation: 6
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, 12: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, 08:39 AM   #5
abhijeetdutta
Member
 
Registered: Aug 2009
Posts: 141

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, 08:45 AM   #6
abhijeetdutta
Member
 
Registered: Aug 2009
Posts: 141

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, 09:14 AM   #7
heytimc
LQ Newbie
 
Registered: Nov 2003
Distribution: Centos 7/Ubuntu 20.04.2
Posts: 14

Rep: Reputation: 6
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 05:10 AM
Migrating MySQL Data stranger_6_7 Linux - General 1 08-17-2007 09:51 AM
Migrating db relationships from Access to MySQL crashsystems Linux - Server 2 02-10-2007 12:21 PM
Switching from MySQL to HSQLDB shortblock Linux - General 0 04-01-2006 08:03 AM
HSQLDB - Has anybody used it? sekelsenmat Programming 3 06-12-2005 03:29 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 11:18 PM.

Main Menu
Advertisement
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
Open Source Consulting | Domain Registration