Masbuchin

I moved to nearlyfreespeech.net hsoting today. The decision is because I need a load balanced web hosting with a pay as you go features. Currently, cloud hosting is the solution, but not for my pocket.

I began to export my database and import that using shell. File transfer going smooth, but when I began import using my usual techniques, it is failed because my dump has many duplicate primary key id.

So I need to force mysql to import, here is how I did that:

mysql --force --quick -hYourHost -uYourUsername -pYourPassword YourDatabaseName< YourDumpFile.sql

This should work with another host too.

Force MySQL Import to NearlyFreeSpeech.Net Host is posted on February 4th, 2010 by buchin. This post is filed under: Web Hosting .

Tagged with:

nearlyfreespeech net mysqlimport