can database and media folder be moved to a different drive?

March 29, 20231 Views

I have to move my site from Drive C: to Drive E:.

Is there a better way to do this than uninstalling the following:

and re-installing on Drive E:?

For example, how can I move just the database files and media folder to Drive E:?

Post Views: 1

1 comment

Anonymous says:

March 29, 2023 at 3:35 pm
DISCLAIMER : Only a MySQL DBA, not WordPress expert

You could migrate the database as follows:

Very first thing is to locate the my.ini for MySQL. Search all data volumes until you locate my.ini

Next, login to MySQL and run
```
SHOW VARIABLES LIKE 'datadir';
```
This will tell you what folder MySQL data is stored. For this example, let’s say it returned C:Program FilesMySQLMySQL 5.0data

You can shutdown mysql from the DOS Command Line as follows
```
net stop mysql
```
Next, Make your own folder on Drive E:
```
mkdir E:MySQLDB
```
You can then copy the MySQL Data Folder to Drive E:
```
cd "C:Program FilesMySQLMySQL 5.0data"
xcopy /s * E:MySQLDB
```
Here is the good part: Run notepad on my.ini and replace datadir in it with
```
[mysqld]
datadir=E:/MySQLDB
```
Finally, startup mysql
```
net start mysql
```
Check the Task Manager. If you see mysqld.exe in the processlist, CONGRATULATIONS !!!

In terms of the other LAMP components, you will have to examine php.ini and other related config files and do the same thing.
Log in to Reply