https://htyp.org/mw/api.php?action=feedcontributions&feedformat=atom&user=137.21.132.41 2026-06-23T16:03:38Z User contributions MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=MySQL/migration&diff=1926 2005-04-15T23:49:08Z

<p>137.21.132.41: </p> <hr /> <div>K,<br /> here's how I do it:<br /> ==Backing up==<br /> #Make sure you've got [http://www.phpmyadmin.net PHPMyAdmin] running<br /> and that's all happy. I won't cover this part here as it varies with<br /> your set up.<br /> #Login and choose '''Export''' from the main page<br /> #Leave most of the default options. Specifically,<br /> #*Format: SQL<br /> #*Select the database(s) you want in the listbox<br /> #*etc.<br /> #Checkmark 'Add DROP TABLE'. This will make sure that when you restore<br /> from a backup, it will delete existing tables before restoring from the<br /> backed up ones.<br /> #Checkmark 'Save to file' at the bottom, or it will just dump it to<br /> your browser window, and that's no fun.<br /> #*You probably also want to use compression. These won't be huge files,<br /> but a 1.5mb database compresses to about 150kb. So, y'know, whatever.<br /> Wiggy recommends BZIP.<br /> #Click '''Go'''.<br /> ==Restoring from backup==<br /> ''I'm writing this from memory, so I might be wrong, but I '''think'''<br /> it's right.''<br /> #Click '''Databases''' from the PHPMyAdmin main page<br /> #Click the name of your databse (it should already exist; have you<br /> [re]installed [http://www.mediawiki.org MediaWiki] yet? Do that first.)<br /> #Click the '''SQL''' tab<br /> #Where it says '''Location of textfile:''', browse to your latest<br /> backup, then click '''Go'''.<br /> Good luck :E</div>

137.21.132.41