5,576
edits
Changes
From SME Server
Jump to navigationJump to searchno 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.. :)
