How large is "too large"? Both mechanisms you chose depend on PHP configuration.<br><br>Do you have shell access? A combination of <br><br>mysqldump -uuser -ppassword database>database.sql<br><br>-and-<br><br>
mysql -uuser -ppassword database < database.sql<br><br>will backup and restore a database.<br><br>Most hosting environments have a MySQL backup and restore mechanism.<br><br>Jim<br><br><div class="gmail_quote">On Wed, Feb 24, 2010 at 11:22 AM, Kieran Lal <span dir="ltr"><<a href="mailto:kieran@acquia.com">kieran@acquia.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Scott,<br>
<br>
2010/2/24 Kieran Lal <<a href="mailto:kieran@acquia.com">kieran@acquia.com</a>>:<br>
<div class="im">> Hi Scott, if your search tables are that big, then Drupal is unlikely to perform well with it's native search. MySQL will be burned managing those large tables and slow your entire Drupal site down. I suggest you segment your load by using an external search engine like Apache Solr, <a href="http://drupal.org/project/apachesolr" target="_blank">http://drupal.org/project/apachesolr</a>. This is what we use on Drupal.org.<br>
><br>
> If you don't have the ability to quickly set-up Solr in a Java environment, you can create a free 30 day subscription at Acquia.com to try hosted Apache Solr search. Installation instructions are here: <a href="http://acquia.com/documentation/acquia-search/activation" target="_blank">http://acquia.com/documentation/acquia-search/activation</a> . This would allow you to reduce your DB size, and get higher quality search.<br>
<br>
</div>I should specify, that with the smaller db size, your DB backup<br>
strategy should continue to work. If you DB is still too big, then I<br>
suggest you move to a MySQL master slave DB configuration and do<br>
direct back-ups from the MySQL slave DB instance.<br>
<br>
Cheers,<br>
<font color="#888888">Kieran<br>
</font><div><div></div><div class="h5">><br>
> Cheers,<br>
> Kieran<br>
><br>
> On Wed, Feb 24, 2010 at 1:45 AM, Scott <<a href="mailto:scott@bscottholmes.com">scott@bscottholmes.com</a>> wrote:<br>
>> I have a site that has become too large to effectively use the backup<br>
>> and Migrate module. I've just finished updating the site from my<br>
>> development platform and in order to migrate the latest version of the<br>
>> database I had to exclude the search_index table from the backup. To<br>
>> get around this I did backup the search_index table using phpmyadmin and<br>
>> importing it separately. Neither drupal nor phpmyadmin would restore<br>
>> the entire database as a single file. Does anyone have any<br>
>> recommendations to improve this situation?<br>
>><br>
>> Thanks in advance, Scott<br>
>><br>
>> --<br>
>> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
>><br>
><br>
><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Rev. Jim Tarvid, PCA<br><a href="http://ls.net">http://ls.net</a><br><a href="http://drupal.ls.net">http://drupal.ls.net</a><br><a href="http://crossleft.org">http://crossleft.org</a><br>
<br><br>