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!