drupal

My ISP remove my MySQL DB by mistake. As a good admin (jejeje lucky me) I had a backup of it. It was sql file of 70MB, 12MB if compressed.
If you have worked with a default installed PhpMyAdmin will know that you can only upload DB of 8MB. So, what can I do with my big data? The solution is Bigdump.

It's a php script that executes little parts of you dumped DB and it restarts itself when finishes, continuing where it stopped.

The conf is really simple, you have to configure the php script bigdump.php:

Then just call it www.mydomain.com/bigdump.php.

As simple as it sounds.

I'm not very familiar with drupal. Honestly, I use it because long time
ago my brother recommend it, but I have no much idea about it.
So, when I was thinking on maintaining two blogs (the old and the new
one) I first though on adding a new taxonomy vocabulary and the assign
it to all old entries. In other words, tag all the old content with
"old_content" tag.

But, after some quick reply in commandob mailing list, I start looking
at drupal multi-site management, and I have to say that it's really
simple.

I wanted to manage two sites: blog.emergetux.net and
oldblog.emergetux.net. So, after creating both DNS entries and
modifying ISPconfig co-domain configuration, I only had to create a
couple of directories under sites (one for each site I wanted to
manage) and add a custom setting.php file:

sites/default/settings.php
sites/emergetux.net/settings.php
sites/oldblog.emergetux.net/settings.php

[note] emergetux.net includes *.emergetux.net except oldblog with is
explicity defined.

If you want to manage many different sites you have 2 options:

1) use different databases for each site. This is not my case.

2) use one database but use different table name for each site. You can
do it by adding a table prefix to each site.

So, in my case, I left old blog without prefix and added 'new_' prefix
to new one.

sites/emergetux.net/settings.php
$db_url = 'mysql://username:password@localhost/databasename';
$db_prefix = 'new_';<br>
sites/oldblog.emergetux.net/settings.php
$db_url = 'mysql://username:password@localhost/databasename';
$db_prefix = '';

[note] default site uses same conf as emergetux.net site.

And that's all!