What is the SSH command line for database backup?

[CyberGuy]

Hello,

I know that the SSH command line for database restore is:

mysql -u user -p dB < data.sql


....and my question is:

What is the SSH command line for database backup?

What I want to do is backup my phpBB2 forum database. The phpBB2 forum has a feature in the admin pannel to do a complete database backup but whenever I use it, it seems to just hang and does not complete the procedure. It works before when the database is not so big, but now that the database is getting over 120 MB, it seems to not work so well. That is why I want another method of backing up my phpBB2 database using SSH command.

[dave2k4]

Have you tried using the 'Backup' option within cPanel, from this option you can download a recent backup of your phpbb sql database and restore a database, or you can use the export feature within phpMyAdmin

[Adnan]

mysqldump -h localhost DATABASE > DATABASE.sql