How multiple MySQL databases are assigned to multiple different file directories
How multiple MySQL databases are assigned to multiple different file directories
I installed the Phpnow environment
The default database is placed in the D:\phpnow\MySQL-5.0.90\data\
I want to use Baidu Cloud database synchronization, Baidu Cloud directory in D:\yun\
I want d:\phpnow\mysql-5.0.90\data\hello.* (Hello database) to be transferred to d:\yun\db\hello.*.
Other databases (there are many databases I don't want to sync) or in the original directory
How do I set up to use PHP to access the transferred Hello database normally?
Share to:
------Solution--------------------
No, you can't.
Designated DataDir can only achieve the purpose of the overall relocation
------Solution--------------------
Reference:
How multiple MySQL databases are assigned to multiple different file directories
I installed the Phpnow environment
The default database is placed in the D:\phpnow\MySQL-5.0.90\data\
I want to use Baidu Cloud database synchronization, Baidu Cloud directory in D:\yun\
I want d:\phpnow\mysql-5.0.90\data\hello.* (Hello database) to be transferred to d:\yun\db\hello.*.
Other databases (there are many databases I don't want to sync) or in the original directory
How do I set up to use PHP to access the transferred Hello database normally?
Build multiple MySQL instances, just to open multiple ports.