# backup restoration problem.

**URL:** <https://forums.percona.com/t/backup-restoration-problem/1312>\
**Category:** Other MySQL® Questions\
**Created:** [December 21, 2009, 4:24am UTC](https://forums.percona.com/t/backup-restoration-problem/1312 "2009-12-21T04:24:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![apoorv261](https://avatars.discourse-cdn.com/v4/letter/a/85e7bf/32.png) [@apoorv261](https://forums.percona.com/u/apoorv261)\
**Post date:** [December 21, 2009, 4:24am UTC](https://forums.percona.com/t/backup-restoration-problem/1312/1 "2009-12-21T04:24:08Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [December 21, 2009, 1:15pm UTC](https://forums.percona.com/t/backup-restoration-problem/1312/2 "2009-12-21T13:15:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![apoorv261](https://avatars.discourse-cdn.com/v4/letter/a/85e7bf/32.png) [@apoorv261](https://forums.percona.com/u/apoorv261)\
**Post date:** [December 22, 2009, 12:58am UTC](https://forums.percona.com/t/backup-restoration-problem/1312/3 "2009-12-22T00:58:51Z")

</div>

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

for resotration:

mysql -p -u root DBName1 \< filepath.sql

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [December 22, 2009, 10:03am UTC](https://forums.percona.com/t/backup-restoration-problem/1312/4 "2009-12-22T10:03:05Z")

</div>

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