Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

Question

Installing MySQL repository question

Posted December 3, 2019 496 views
MySQL

Hi,
To import a database it’s apparently necessary to install a mysql repository or something else. After downloading it from Oracle, the computer asks what application to open it with. I thought it was the application. What application is it supposed to use to open it?

From these links:
https://www.digitalocean.com/docs/databases/mysql/how-to/import-databases/
https://dev.mysql.com/downloads/file/?id=491630

Thank you

Add a comment
jpants
By:
jpants

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer
bobbyiliev December 4, 2019

Hello,

I can see that you are referring to the Managed MySQL databases, in this case I would recommend following the steps in this tutorial on how to install the MySQL client:

https://www.digitalocean.com/community/tutorials/how-to-connect-to-managed-database-ubuntu-18-04

Once you have the MySQL client, you can then import your database backup.

Regards,
Bobby

How To Connect to a Managed Database on Ubuntu 18.04
by Mark Drake
If you're new to working with managed databases, the best way to perform certain tasks, like connecting to the database, may not be self-evident. In this guide, we will go over how to install client programs for a variety of database management systems, including PostgreSQL, MySQL, and Redis, on an Ubuntu 18.04 server. We'll also explain how to use these programs to connect to a managed database instance.
Reply Report

Related

Looking for something else?

Ask a new question Search for more help