Internal Errigal Collaboration Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Backing Up A Table ======

Author: Michelle McCausland

  * In the command line or in putty navigate to the home/scotty level of a database. (In this instance I am on Errigal QA - qadb2.err).
  * It is important to back up tables on the slave system as opposed to the master to prevent any load/locking issues.
  * cd into the temp directory
  * Type ls to show the files in this directory: 

{{ :support:11.png?nolink |}}

  * Use one of the following commands:
    - mysqldump --single-transaction -u root -p databaseName tableName > appropriatelyNamedFileWithDate.sql
    - mysqldump --single-transaction -u root -p snmp_manager network_element > networkElementBackup0303.sql
    - mysqldump -uroot -p ticketer | gzip -v > ticketer.dump.gz
  * You will be prompted to enter the password here this will confirm the backup
  * If you type ls once again you will see your backup in this directory:

{{ :support:12.png?nolink |}}

  * SUPER IMPORTANT! - To ensure the backup process worked correctly vi/ nano into the file
    - vi nameOfFile
  * If done correctly you will see some mysql in this file:

{{ :support:13.png?nolink |}}

  * Now you are good to go!
  * Keep an eye on these backups that you take, when these backups become outdated please make sure to remove them from the system, if you are unsure check with someone.

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Page Tools