Advice on exporting mysql database on Joomla (no phpmyadmin

Hi, I need an advice on how to export my ?Joomla mysql database. Unfortunately there is no phpmyadmin installed on my server and I tried to setup one but I have hard time setting it up. I have ftp and console access. All the information I have about the mysql database is from the [login to view URL] file of joomla. Is this enough to export the database? I tried with the console and a php file to export the database but I was getting access denide. Any ideas would be appreciated.