Windows – How to save a MySQL database on another drive

MySQLwindows

In my app, I use MySQL for the database backend (the app uses multiple MySQL databases, all use MyISAM tables). For performance reasons, I want to move one of the databases to a solid state drive (DRAM based), but only that database, the other databases should stay on the SATA drive I use. As you know, in MySQL you can only specify the data directory in MySQL settings and you don't have control over where every database is saved. Is there any workaround for this? I'm hoping that there might some trick I'm not aware of that can get the job done.

Any suggestions would be really appreciated, thanks

Best Answer

Assuming your SSD has the drive letter G:\ you move your specific database subdirectory to the new drive and create a symlink in the 'datadir' directory.

mklink /D database_subdir G:\path\to\database

Best wishes, Fabian

Related Solutions

Mysql – Options for reducing size of a MySQL database

Got any indexes you don't actually use?

Mysql – How to sync a subset of tables between two databases on the same thesql database server

If your end goal is to separate the servers then I would suggest running a separate instance on a different port and using standard replicaton between the two

quick google turns out this

alternatively you can use triggers to replicate, something along the lines of

CREATE TRIGGER replicatetable AFTER INSERT ON db1.table
  FOR EACH ROW BEGIN
    INSERT INTO db2.table(field1,field2, ...) values (db1.table.field1,db1.table.field2, ...);
  END;

similar for UPDATE and DELETE

Best Answer

Related Solutions

Mysql – Options for reducing size of a MySQL database

Mysql – How to sync a subset of tables between two databases on the same thesql database server

Related Topic