Actian Community Blogs

One can face a problem when migrating from MySQL to VectorWise, when a fast and appropriate method is required. Using multiple inserts is not the way VectorWise likes to see it, but using additional dumps can have a high storage cost.

I shall give here a hint, how to migrate large tables from MySQL to VectorWise using low disk space and memory usage. We'll use linux named pipes. First we have to create a pipe:

$ mknod my_pipe p

Now we make a query to...