Amit's Blog
  • Home
  • Videos
  • All Posts
  • Tags
  • About Me
Subscribe
Tagged

mysql restore

A collection of 1 post

mysql

Mysqldump Tips and Tricks

MySQL Database Backup Ignore one or more tables while doing mysqldump : mysqldump -u username -p database --ignore-table=db.table1 --ignore-table=db.table2 > mysqldump.sql``` ****Compress the output of mysqldump :**** mysqldump -u username -p database  | /bin/gzip -9 > filename.sql.gz **Backuping a single table from a database** mysqldump -u -p

  • amit
amit Jan 30, 2012 • 1 min read
Amit's Blog © 2023
Powered by Ghost