ssh to source database

hi, 
I have successfully migrated data using pro tool from magento 1.9 to 2.2. At this time I have both database on same server.
Now, while real time migration. My Magento 2.2.6 is on different server then Magento 1.9.2.
 
My question is :
1) Can I connect magento 1.9.2 db via ssh and do migration process ? Can you please provide me settings that I have to do?
2) What will be fast either (a) if I take dump from 1.9.2 and using that sql dump file create new 1.9.2 database on same server where magento 2.2.6 is installed and start migration
or
(b) I connect to source db via ssh and do migration

3) DB size is 12 GB, how much time it will take while doing via SSH?

5 answers

Profile photo of Mall Staff 184060.00 $tone November 21, 2018
Public

Hi there,
We’d like to clarify further below: 

1) Can I connect magento 1.9.2 db via ssh and do migration process ? Can you please provide me settings that I have to do?

In order to connect to your M1 database, you need to enable remote connection from M2 server in your M1’s MySQL server. You might want to ask your system admin to help with enabling MySQL remote connection. 

2) What will be fast either (a) if I take dump from 1.9.2 and using that sql dump file create new 1.9.2 database on same server where magento 2.2.6 is installed and start migration
or
(b) I connect to source db via ssh and do migration

It’s a better option in terms of performance if you connect directly to your databases in the same MySQL server rather than via remote connection. 

3) DB size is 12 GB, how much time it will take while doing via SSH?

This varies depending on many factors. Our migration tool does migrate all core data objects as noted in our product page here, and the performance will depend on the volume of these data objects as well. 

Regards,
Mall.

#1
Profile photo of ubdev Staff 98030.00 $tone November 21, 2018
Public

Hi Sunny, 
Yes, please move forward with the migration, and strictly follow all steps in the Readme.html that comes packed with your download package. 
In case you have any additional question during the process, please get back to us here. 
Regards,
Ubertheme team

#3
Profile photo of sunny patel 110.00 $tone November 21, 2018
Public

I have stuck with hosting provider. Here is the situation
My hosting provider allow only one database on instance. For other database I have to use other instance. 
And mysql remote connection is only possible via ssh tunnel. Like from command line I have to connect to other instance via ssh and then have remote sql connection on command line.
But on migration tool on -- “Database Setting” screen(Step 1) I didn’t find anyway to connect via ssh. In this case is there any option where I can provide SSH key, username, pwd to other remote instance and continue data migration.

#4
Profile photo of Mall Staff 184060.00 $tone November 21, 2018
Public

Hi there,

But on migration tool on — “Database Setting” screen(Step 1) I didn’t find anyway to connect via ssh. 

I’m sorry, that is not supported by our migration tool yet. For your case, you should upgrade your MySQL instance to add more database. And then, you could import your M1’s database in same M2’s MySQL instance server.
Regards,
Mall.

#5

Please login or Register to Submit Answer

Written By

Comments