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!
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!