Export a mysql database


I’m trying to export a mysql datbase in a sql file, but without success. I used to export it in phpMyAdmin, but I don’t have it now.

Anyone knows the command to export it wothout installing phpMyAdmin ?



Also, read it’s man page for options

MySQL :: MySQL 5.0 Reference Manual :: 4.5.4 mysqldump - A Database Backup Program

You can install phpMyAdmin from:


It will provide you with a one click install.

You did not ask for it, just mentioned you don’t have it.

The exact command would be:

mysqldump -u username -p database_name>database_file.sql

Thanks. I’ll do it using phpmyadmin.