<?xml version="1.0" encoding="windows-1252"?>
<node id="928911" title="Re: Restore Database With DBI?" created="2011-09-30 16:30:06" updated="2011-09-30 16:30:06">
<type id="11">
note</type>
<author id="5348">
Corion</author>
<data>
<field name="doctext">
&lt;p&gt;I would assume that &lt;c&gt;source FILE&lt;/c&gt; is not a valid MySQL command.&lt;/p&gt;
&lt;p&gt;Why not read each line from the SQL file and &lt;c&gt;$dbh-&gt;do(...)&lt;/c&gt; it? You might also be interested in [mod://DBIx::RunSQL]. Personally, I would just run the &lt;c&gt;mysql&lt;/c&gt; binary with the source file, either locally or on the server. Maybe you want to talk to your database administrator on how to achieve this?&lt;/p&gt;</field>
<field name="root_node">
928903</field>
<field name="parent_node">
928903</field>
</data>
</node>
