Import large Databases using phpmyimporter

If you ran into a problem where you need to copy or move a server, you might have noticed that you need to export the Contao DB and that can be a real problem to import back in again. Most South African providers disallow you to have terminal access, so the only way if via php.

Here is a script that you can use to import large files. You might have to add these lines into the example.php file at the top to increase the memory limit and also to display errors (not enabled on 5.3+)

Added Lines:
[code=php:393jlfx2]<span class="syntaxdefault">
</span><span class="syntaxkeyword"><?</span><span class="syntaxdefault">php*
ini_set</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'memory_limit'</span><span class="syntaxkeyword">,*</span><span class="syntaxstring">'128M'</span><span class="syntaxkeyword">);
</span><span class="syntaxdefault">ini_set</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'display_errors'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault">1</span><span class="syntaxkeyword">);
</span><span class="syntaxdefault">error_reporting</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">E_ALL</span><span class="syntaxkeyword">|</span><span class="syntaxdefault">E_STRICT</span><span class="syntaxkeyword">);
...
*</span><span class="syntaxdefault"></span>[/code:393jlfx2]


http://code.google.com/p/phpmyimporter/