User Tools
Writing /app/www/public/data/meta/support/backing_up_a_table.meta failed
support:backing_up_a_table
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| support:backing_up_a_table [2016/09/14 16:48] – mmcc | support:backing_up_a_table [2021/06/25 10:09] (current) – created - external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== 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/ | ||
| + | * cd into the temp directory | ||
| + | * Type ls to show the files in this directory: | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | * 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: | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | * 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: | ||
| + | |||
| + | {{ : | ||
| + | |||
| + | * 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. | ||
Page Tools
