Results 1 to 2 of 2
  1. #1

    Default How to backup single table via MySQLDump?

    I am totally aware that to backup whole database MySQLDump function is handy but what if only one table gets corrupt? I only want to restore that table from backup.

  2. #2
    Join Date
    Apr 2011
    Posts
    213

    Default

    In that kind of situation you can use the following steps to backup and restore a single mysql table using mysqldump function:

    For backup: Mysqldump u p databasename tablename > tablename.sql

    For example:

    Mysqldump psa BackupsScheduled > BackupsScheduled.sql u admin p cat /etc/psa/.psa.shadow
    Restoration: Mysql u p databasename < tablename.sql

    For Example:

    Mysql psa < BackupsScheduled.sql u admin p cat /etc/psa/.psa.shadow
    Thats all, easy isnt it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •