phpMyAdmin with Varnish

Need to use phpmyadmin on a server running Varnish cache?

It can be tricky, especially since phpmyadmin relies on session cookies for security which dont seem to match up with varnish.

It took us a while but we figured it out… but then forgot what we did!

So for now I will show how to export a db using SSH (workaround):

  • Open SSH and connect to your server
  • cd to where you want to dump your mysql database
  • enter the following command: mysqldump -uUSERNAME -p DATABASE > backup.sql

Replace USERNAME, and DATABASE with the relevant values, note username is the Database username!

  • Hit enter and you will be prompted for the username’s password.
  • Boom the database will appear in  your directory!

 

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scroll to Top