Home

MySQL

MySQL

The most widely used open source SQL product

 

Migrate from SMF Forum to Drupal

Sun, 02/14/2010 - 7:48pm — hunter

Recently I needed to do a migration from the Simple Machines Forum (SMF) to the Drupal Native Forum. I think most people by this point have heard of Drupal, and if you're reading this, chances are you're in a similar situation. If you want to migrate from SMF to Drupal, there is no direct route beyond writing your own Migration software from scratch in PHP. In this project I'm migrating from a Bridged Joomla and SMF site that has roughly 16,000 posts and about 1100 users.

Acquia: Best Practices for Scaling Drupal

Thu, 01/21/2010 - 7:49pm — hunter

This is a fantastic primer for scaling LAMP architecture.

 

Wysiyg API and Input_formats quick start

Sun, 01/17/2010 - 1:15pm — hunter 

-- phpMyAdmin SQL Dump

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `chrihu3_port112209`
--

-- --------------------------------------------------------

--
-- Table structure for table `filters`
--

DROP TABLE IF EXISTS `filters`;
CREATE TABLE IF NOT EXISTS `filters` (
  `fid` int(11) NOT NULL auto_increment,
  `format` int(11) NOT NULL default '0',
  `module` varchar(64) NOT NULL default '',
  `delta` tinyint(4) NOT NULL default '0',
  `weight` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`

{syntaxhighlighter brush: css;fontsize: 100; first-line: 1; }-- phpMyAdmin SQL Dump SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `chrihu3_port112209` -- -- -------------------------------------------------------- -- -- Table structure for table `filters` -- DROP TABLE IF EXISTS `filters`; CREATE TABLE IF NOT EXISTS `filters` ( `fid` int(11) NOT NULL auto_increment, `format` int(11) NOT NULL default '0', `module` varchar(64) NOT NULL default '', `delta` tinyint(4) NOT NULL default '0', `weight` tinyint(4) NOT NULL default '0', PRIMARY KEY (`fid

Some imagacache presets

Sun, 01/17/2010 - 12:58pm — hunter

I use the following SQL to get some quick presets up and rolling.  I know this can be cleaner, but it works for many smaller sites I do.  Just dump this into an SQL statement in Phpmyadmin or from the command line.

Backing up w/ Drush

Tue, 12/29/2009 - 12:07am — hunter
I love drush

Drush, my favorite new tool, is proving to be quite useful.  Drush saves you time by picking up your connection string from the sites settings.php folder that you're backing up, you no longer need to configure each backup script individually. 

sample usage for this script would be:

bash backup.sh /full/path/to/drupal/site <optional> archive_prefix <optional> #of days to keep archives for

Syndicate content