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
Need help to troubleshoot mysqlnd_ms setup on PHP72 with php-fpm Question Question
Hi, I am not familiar with droplets and linux whats the easiest way to access my files Question Question

Question

Upgrading Dokku caused me to lose mysql db service

Posted February 4, 2016 2.5k views
MySQLDokku

I upgraded dokku from the 3 series to 4. After upgrading my mysql db service is missing. Did I lose all the data from that database, or is there some way I can access it on my system?

Add a comment
kbhardwaj
By:
kbhardwaj

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
Need help to troubleshoot mysqlnd_ms setup on PHP72 with php-fpm Question Question
Hi, I am not familiar with droplets and linux whats the easiest way to access my files Question Question
Add a comment
3 comments
  • gndo February 4, 2016
    Reply Report

    Try looking in the datadir of your installation to see if your database files are still there

    ls `my_print_defaults --mysql | grep datadir | sed -e 's/--datadir=//'`
## or try the standard location on ubuntu
ls /var/lib/mysql

    If you see subdirectories for your apps, then your database may not be a total loss.

  • kbhardwaj February 4, 2016
    Reply Report

    I do have subdirectories there:

        ibdata1  
    ib_logfile0  
    ib_logfile1  
    mysql  
    mysql_upgrade_info  
    performance_schema

    There are a lot of subdirectories under mysql as well. I’m going to check all these out now. Any tips on which files to look in? Thanks for your help

  • gndo February 4, 2016
    Reply Report

    @kbhardwaj - First, make sure that your current mysql installation is accessible:

    service mysql status   ### should display  that it is running
mysqlshow -u root -p  ### enter dbroot pw,  displays current databases if mysql is running

    If the first command above failed, then you may need to check your packages

    dpkg -l | grep mysql
## make sure you have a mysql-server package and note the version
dpkg --status mysql-server-YOURVERSIONHERE

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
ryanpq June 9, 2016

This question was answered by @gndo:

@kbhardwaj - First, make sure that your current mysql installation is accessible:

service mysql status   ### should display  that it is running
mysqlshow -u root -p  ### enter dbroot pw,  displays current databases if mysql is running

If the first command above failed, then you may need to check your packages

dpkg -l | grep mysql
## make sure you have a mysql-server package and note the version
dpkg --status mysql-server-YOURVERSIONHERE

View the original comment

Reply Report

Related

Looking for something else?

Ask a new question Search for more help