How to Import DB via Command Line on Enhance?

prasad0889

Hello Team,

I am trying to import a big DB around 1.5GB using Command Line as importing via PHPMyAdmin is always failing and I have to continue the import several times which is time consuming and not the right way. I have tried increasing the upload size and max execution time, but it has not helped much.

As I have known for several years we can import mysql DB's via command line and for that you need to start the mysql interface. But with Enhance as it is docker based, I am unsure how to start the MySQL interface.

There is no documentation as of now so do not know where I should look for!

prasad0889

I can also see that Enhance switched to sql.gz instead of sql.zip. Any reason for the shift?

Adam

Hi Prasad,

The best way to do this is via the customer's PHP container. You can either "su" to their website user from root or add your SSH key to their website under "developer tools" and connect to the server with SSH.

Once in their environment you can use the MySQL CLI:

mysql -u their_username -p their_database_name < your_backup.sql

You don't need to specify a host with -h unless the site has a remote MySQL.

Enhance doesn't install the MySQL CLI onto the host o/s. If you want to be able to import backups as root then you can install it via apt however I don't recommend this.