When want to take a database backup from shell prompt it gives me error for one table. Still i want to continue the backup for others how should i do that ? I USE mysqldump -f --opt database > backup-file.sql but it won't works Is there any thing diffrent?
You can specify tables you want to backup but not the other way around.
You should use -r name or --result-file=name instead of redirecting output.
Try repairing the table before dumping.
HalfaBee