How to quickly deploy a 5gb mysql dump on windows?

Question

MySQL

There is a 5gig dump with mysql database, I just can't find a way to quickly import: Linux/Mac - 15-25min, Windows - 6-8 hours...
Tried "mysql <file", "mysql> source file"

Answer 1

You can speed up work with the disk system if you have a lot of inserts in the dump.
Divide them into pieces and wrap, say, every thousand inserts with a transaction:

START TRANSACTION;
   INSERT ...
   INSERT ...
   ...
   COMMIT;

Disable key uniqueness checking before recovery

SET FOREIGN_KEY_CHECKS = 0;
   SET UNIQUE_CHECKS = 0;

then turn it back on

SET UNIQUE_CHECKS = 1;
  SET FOREIGN_KEY_CHECKS = 1;

This is what offhand.
And so - mysql itself is quite well optimized for both Linux and Windows. I think you still have Windows and Linux either have different hardware specifications or settings of mysql itself ..

Answer 2

From a text dump, you can't quickly get it. Try replication.

Answer 3

Windows is of course slower than linux works with the disk, but not by an order of magnitude, is the hardware not the same? on linux ssd and on windows hdd?
What size are the resulting database files? will they fit if they are placed on a ram disk, creating tablespaces on it before importing, then transfer it back (I remember stopping the database a long time ago, transferring the directory with tablespaces to the ram disk, and leaving a symbolic link in the same place, then, after a heavy work with the base, also stopping it, transferred it back)