Thread: ssh backup particular mysql table / database
View Single Post

  #2 (permalink)  
Old 10-23-2007, 12:08 PM
nixcraft's Avatar
nixcraft nixcraft is offline
Never say die
User
  
Join Date: Jan 2005
Location: BIOS
My distro: Ubuntu
Posts: 1,036
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default
Use mysqldump to backup entire database
Code:
mysqldump -u root -p dbname > backup.db.sql
__________________
Vivek | My personal blog
Linux Evangelist
Play hard stay cool
Reply With Quote