Home  >  Article  >  Topics  >  How can Pagoda modify the storage path of mysql database and change the default data directory with one click...

How can Pagoda modify the storage path of mysql database and change the default data directory with one click...

藏色散人
藏色散人forward
2021-05-06 14:42:125008browse

The following tutorial column of Pagoda Panel will introduce to you how Pagoda can modify the mysql database storage path and change the default data directory with one click... I hope it will be helpful to friends in need. !

Pagoda can modify the mysql database storage path and change the default data directory script with one click!

This shell script is limited to the pagoda bt.cn linux panel. I hope it will be helpful to friends in need. If you have any questions, please leave a message!

How can Pagoda modify the storage path of mysql database and change the default data directory with one click...

Main parameter functions:

1. Modify the database storage path by default

sh mysql_Transfer.sh

2. Restore the original storage path of the database

sh mysql_Transfer.sh old

Script related tips English translation:

Sorry, the /www/server/data directory cannot be found!

Sorry, I can’t find the /www/server/data directory!

Sorry, I can’t find the /www/server/mysql directory!

Sorry, I can't find the /www/server/mysql directory!

Enter the new database path (for example:/home/mysql):

Enter a new database path (for example, /home/mysql):

The new database path cannot be empty!

New database path cannot be empty!

The database directory change was unsuccessful!

Database directory changes not successful!

Database directory changes are successful!

Database directory changed successfully!

Mysql files are being transferred, it may take a minute!

Moving the MySQL file, you may need a minute!

Moving the database file, you may need a minute!

Transferring the database file, you may need a minute!

New mysql installation path:

Now MySQL installation path:

Restore successfully!

Recover successfully!

Recovery failed!

Recovery failure!

New database file path:

New database file path:

============= ==============================================

Download link:

wget http://www.tieww.com/soft/mysql_Transfer.sh && sh mysql_Transfer.sh

Only for 2.X panel use

The above is the detailed content of How can Pagoda modify the storage path of mysql database and change the default data directory with one click.... For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:bt.cn. If there is any infringement, please contact admin@php.cn delete