GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

backup restoration problem.

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • backup restoration problem.

    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?

    Comment


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

      for resotration:

      mysql -p -u root DBName1 < filepath.sql

      Comment


      • #4
        Can you look at the line in "filepath.sql" identified by the error message, and see what's there?

        Comment


        • #5
          restoration stop at table "TBL_EVENT_SUBMISSION_QUEUE"

          And this table desc is


          +------------------------+-------------+------+-----+------- --+----------------+
          | Field | Type | Null | Key | Default | Extra |
          +------------------------+-------------+------+-----+------- --+----------------+
          | FLD_QUEUE_ID | int(11) | NO | PRI | NULL | auto_increment |
          | FLD_ADD_DATE_TIME | datetime | NO | | NULL | |
          | FLD_LAST_TRY_DATE_TIME | datetime | YES | | NULL | |
          | FLD_TRY_COUNT | int(11) | YES | | NULL | |
          | FLD_SUBMIT_DATA | blob | YES | | NULL | |
          | FLD_QUEUE_STATUS | smallint(6) | YES | | NULL | |
          | FLD_REMARKS | text | YES | | NULL | |
          +------------------------+-------------+------+-----+------- --+----------------+


          I again restored data this time it showing error.

          ERROR at line 18924: Unknown command '\''.I think blob Type creating problem.

          Comment


          • #6
            If that's the case, then the --hex-blob option to mysqldump might help.

            Comment

            Working...
            X