Sometimes it’s easier to just drop to the command line then browse for fancy tools like phpMyAdmin. This is useful, especially for quick jobs.
Of course you need to replace:
- user – mysql username
- password – the password
- your_database – the database you want to backup
Adding -h host.domain.com would allow to backup a remote mysql database from YOUR shell, something like this: