Skip to content

2012

  • 1 min read

Import a SQL dump from one schema into another with MySQL Workbench

When restoring a MySQL dump from MySQL Workbench, currently it is not possible to specify a different schema than the schema used during the export. The workaround for that is to edit the dump file (which is just a text file) in a text editor and change the name of the schema manually.

For example to change the schema name from ‘old_schema’ to ‘new_schema’, open the dump file in a text editor and change these two lines:

CREATE DATABASE  IF NOT EXISTS 'old_schema' /*!40100 DEFAULT CHARACTER SET utf8 */;
USE 'old_schema';

to this:

CREATE DATABASE  IF NOT EXISTS 'new_schema' /*!40100 DEFAULT CHARACTER SET utf8 */;
USE 'new_schema';

After that, import the dump file using MySQL Workbench as usual. Please note that if you exported the old schema with qualified identifiers you would also have to search and replace the schema name everywhere in the dump file, otherwise each object would have the old schema name as prefix.

  • 1 min read

The specified password for user account ‘root’ is not valid, or failed to connect to the database server.

While installing WordPress 3.4 via Web Platform Installer 4.0 on IIS 7, at some point the Web Platform Installer asks for MySQL ‘root’ user password. There you might get this error: “The specified password for user account ‘root’ is not valid, or failed to connect to the database server”. That happens even if you enter the correct password.

Here is how to fix it:

  • In the Windows registry, delete the mysql_pwd reg key under HKCU\Software\Microsoft\WebPlatformInstaller
  • Download and install the latest MySql .NET Connector (32 bit). At the time of writing, the latest version of MySql .NET Connector was 6.6.4.
  • 1 min read

Super Agile: Replace email with a shared blog

At Primo Software, we have switched from email to using shared internal blogs. That has improved communication in several ways:

  • Instead of emailing multiple people, you now write a post on the blog and all people who are subscribed to it are notified
  • Discussions are visible to everybody including future employees
  • As a side effect, posts have become more substantial. You post when you really have something valuable to share
  • People who prefer email can still choose to receive email notifications, daily digest, weekly digest and so on…
  • Posts are searchable
  • 1 min read

Convert an existing Google Apps account to a Google Apps Reseller account

This one was giving me a headache.

I was trying to enroll Swift Software Group in the Google Apps Reseller program, but the standard application form did not want to accept our domain name “swiftsoftwaregroup.com”. It kept coming back saying “This domain has already been registered with Google Apps.”

I just found a way around this:

Basically, you first have to sign in to your existing Google Apps account and then navigate (in the same browser window) to http://new.googlepartnerconnect.com/Home/enrollment.You should to complete the reseller enrollment from there.