Backup và Restore MySQL Database bằng lệnh
Nếu bạn đang sử dụng MySQL database, chắc chắn bạn sẽ không mong muốn dữ liệu của bạn bị mât. Do vậy việc backup MySQL database thường xuyên là cần thiết. Bạn có thể đơn giản hóa bằng cách sử dụng lệnh tr…Read More
MySQL Basics
Install MySQL Server
Debian/Ubuntu
[mitesh@Matrix ~]$ sudo apt-get update && sudo apt-get install -y mysql-server
Redhat/CentOS
[mitesh@Matrix ~]$ sudo yum install -y mysql-server
Important Files
Configuratio…Read More
Restoring Database Privileges
I’ve seen several cases in the last few months where database users seemingly “disappear” or privileges appear to become invalid when restoring MySQL data or an entire server from raw backups. This may commonly be attributed…Read More
How to Change the Location of MySQL on cPanel
There may be some situations where you have to move the location of MySQL, for example, if you’re out of disk space or perhaps looking to host it on another device to increase performance. Whatever the reason, moving MySQL i…Read More
Disk Space for MySQL Databases in cPanel Show as 0MB
When you upgrade from cPanel 11.24 to 11.25, your users may notice that in cPanel, their MySQL databases show 0MB of disk space used, when they know their databases are much larger. This is due to an option in cPanel that yo…Read More
0 comments:
Post a Comment