mysqldump --opt --skip-lock-tables --skip-add-locks --single-transaction partitioned_database partition_table --where="partition_key >= 'partition_value'" >/path/to/file.sql