Posted by Momseekingbalance on March 24, 2020 at 9:15pm
After our last Drupal Group meeting (which was online and ROCKED, yo!!...,) I wanted to inquire, "phpMyAdmin or NOT to phpMyAdmin?" That is the question (snicker).
As I have been experimenting with development/test/amoeba-Drupal-environments using Cloudways, I have always added phpMyAdmin to the show. I know during our last meeting I asked if that was necessary and the answer was, No. What I'm now curious about is, what does phpMyAdmin bring to the party that I will miss if I don't continue to add it?
Thanks for any feedback given!
Comments
I use HeidiSQL with Cloudways
I use HeidiSQL with Cloudways and other MySQL hosts. This is awesome because you can pipe the 3306 traffic over SSH. No additional ports open! Awesome desktop database frontend.
https://www.heidisql.com/
Thanks for the input Greg!
Thanks for the input Greg! FYI: I tried to look up some info on you and gregbosen.org is not coming up. My site has similar issues. LOL... I just thought I would let you know.
For 95% of what I do, and I
For 95% of what I do, and I believe what you will do as well, The Cloudways Database GUI will give all the functionality (and more) than you will need. What Cloudways does well is to take care of the 5% behind the scenes for us, and strip away all of the over complexity for what "we" need to do on a daily basis. I hope this helps. I believe this methodology is being used by many providers out there. I just found a nice home with cloudways.
BTW - You can use MYPHP Admin with cloudways if you must.
Thanks for posting!
Thanks for taking the plunge Diane and posting a question as a Discussion!
Others in the group -- feel free to post your questions in the group! You'll need to have logged in, joined the group at https://groups.drupal.org/spokane-wa , and then you should see a "Create discussion" link in the sidebar.
Drupal programmer - http://poplarware.com
Drupal author - http://shop.oreilly.com/product/0636920034612.do
Drupal contributor - https://www.drupal.org/u/jhodgdon
Just about done with phpmyadmin
I am finding that the terminal is a powerful and efficient tool for managing databases. I lost my reliance on phpmyadmin during an effort to update my local stack (mysql, php, and phpmyadmin). What really made me turn the corner were the limitations of upload sizes and runtimes for importing and exporting databases - phpmyadmin would do it, but it took some cajoling. Because of the way I updated phpmyadmin, I had to reconfigure it. I figured learning how to use the terminal was time better spent as compared to learning how to tweak the software. I will admit that I've struggled with some of the commands trying to get the syntax correct. Hint: avoid hyphens in your db names.
Using terminal to manage databases is getting me toward the goal of building a script (like Jennifer suggested) that automates the replication of my live sites onto a local environment terminal. It seems like a script that does this would be a "thing" everyone does ... perhaps everyone does. Anyone?
I'd be happy to share the workflow and command sequence if interested.