Changes

From SME Server
Jump to navigationJump to search
369 bytes added ,  09:11, 10 April 2013
no edit summary
Line 88: Line 88:  
nano /usr/local/bin/automysqlbackup  
 
nano /usr/local/bin/automysqlbackup  
 
   echo `du -hs --si "${CONFIG_backup_dir}"`
 
   echo `du -hs --si "${CONFIG_backup_dir}"`
 +
 +
 +
# mysql --user=username --pass=password --host=dbserver database < /path/file.sql
 +
# or
 +
# mysql --user=username --pass=password --host=dbserver -e "source /path/file.sql" database
 +
#
 +
# NOTE: Make sure you use "<" and not ">" in the above command because
 +
# you are piping the file.sql to mysql and not the other way around.
 +
#
 +
# Lets hope you never have to use this.. :)

Navigation menu