backup restoration problem.

MySQL & MariaDB Other MySQL® Questions
1

Hi everyone,

I am using rhel-5 (64bit) and mysql version is 5.0.82.
I am taking dump through mysqldump command but many times in restoring time its showing error messages like “ERROR at line 17525: Unknown command ‘\Z’.” etc.

2

What are the exact commands you use to create the backup and to restore it?

3

for taking dump:
mysqldump -p -u root --single-trasaction DBName > filepath.sql

for resotration:

mysql -p -u root DBName1 < filepath.sql

4

Can you look at the line in “filepath.sql” identified by the error message, and see what’s there?