opencats.org

mysqldump -u my_user -pmypassword my_database joborders > joborders_dump.sql

Which type of dump are you talking about?

Here are the commands for your reference.

If you intend to backup the existing MySQL Database
mysqldump -u [user name] -p[password] [database name] > [dump file.sql]

If you have already backed up database and intend to restore into already existing database
mysql -u [user name] -p[password] [database name] < [dump file.sql]

ensure,
When you do the backup, use mysqldump and > symbol
When you do the restore, use mysql and < symbol

Thank you