5,576
edits
Changes
From SME Server
Jump to navigationJump to search→RESTORING
===RESTORING===
===RESTORING===
====restoring a .sql file====
In a root terminal
In a root terminal
cd /root/backup/db/ and choose your backup
cd /root/backup/db/ and choose your backup
mysql --user=username --pass=password --host=dbserver database < /path/file.sql
mysql --user=username --pass=password --host=dbserver database < /path/file.sql
====restoring a database sent by mail attachment====
The attachments have been split into multiple files, use this command line to combine them :
cat mail_attachment_2011-08-13_13h15m_* > mail_attachment_2011-08-13_13h15m.tar.bz2
and do this to extract the content
bunzip2 <mail_attachment_2011-08-13_13h15m.tar.bz2 | pax -rv
