https://docs.civetsolutions.com/index.php?action=history&feed=atom&title=Manual%2FBacking_up_Convention_Master 2026-05-27T04:49:25Z Revision history for this page on the wiki MediaWiki 1.43.8 https://docs.civetsolutions.com/index.php?title=Manual/Backing_up_Convention_Master&diff=35&oldid=prev 2018-12-02T19:43:10Z

<p>Created page with &quot;== How to back up existing files and the database == While the upgrade scripts are well-maintained and robust, things could still go awry. Before proceeding to update Conven...&quot;</p> <p><b>New page</b></p><div>== How to back up existing files and the database == <br /> <br /> While the upgrade scripts are well-maintained and robust, things could still go awry. Before proceeding to update Convention Master and the database schema, &#039;&#039;&#039;make a full backup&#039;&#039;&#039; of Convention Master, including both the database and the files:<br /> <br /> ===Convention Master&#039;s database===<br /> * MySQL, do a SQL dump with the &lt;code&gt;mysqldump&lt;/code&gt; command:<br /> mysqldump --user=&#039;&#039;&#039;&#039;&#039;db_user&#039;&#039;&#039;&#039;&#039; --password=&#039;&#039;&#039;&#039;&#039;db_userpassword&#039;&#039;&#039;&#039;&#039; &#039;&#039;&#039;&#039;&#039;convention_master_db&#039;&#039;&#039;&#039;&#039; &gt; &#039;&#039;&#039;&#039;&#039;file.sql&#039;&#039;&#039;&#039;&#039;<br /> :( replacing the &quot;db_user&quot; with your valid database username, &quot;db_userpassword&quot; with the database user&#039;s password, &quot;convention_master_db&quot; with your Convention Master database name, and &quot;file.sql&quot; with the desired output filename. The output file name can have a full file path included if you want it to go to another folder.)<br /> * Make sure you move that backup file to a safe location where it won&#039;t be deleted or accessable by web.<br /> * You do not need to use any extra flags with &lt;code&gt;mysqldump&lt;/code&gt;. The stored procedures and triggers are always automatically rebuilt when you login to the Convention Master console if they are missing or the database user has changed.<br /> <br /> ===Convention Master&#039;s files===<br /> * tar, compress all files into a backup file with the &lt;code&gt;tar&lt;/code&gt; command:<br /> tar -cvpzf backup.tar.gz --exclude=/backup.tar.gz /path/to/your/installation/ <br /> * Make sure you move that backup file to a safe location where it won&#039;t be deleted or accessable by web.<br /> * Generally any user edited files will be new files that are not tracked by svn, and thus would not be overwritten by an upgrade. The most common changes are:<br /> :* configuration of database settings: &lt;code&gt;.../shared_php/db_connect.inc.php&lt;/code&gt;<br /> :* configuration of kiosks via steps files: &lt;code&gt;.../kiosk/{kiosk_name}/steps.inc.php&lt;/code&gt;<br /> :* addition of custom theme folders in &lt;code&gt;.../themes/&lt;/code&gt;</div>

Alofoxx