mysqlcheck gives you this ability to repair, optimize and analyze databases stored in your server. one of the good uses of this app is to mass repair, optimize or analyze all the existing databases on the server. In order to achieve any of those mysqlcheck can be used as below:
|
1 2 3 |
mysqlcheck --all-databases -r #repairs all databases mysqlcheck --all-databases -a #analyze all databases mysqlcheck --all-databases -o #optimize all databases |
Incoming search terms:repair […]
Today morning I was with one of my friends, and we were trying to figure something then we reached a point that he did a “ls” command to see the file details and sizes, well he used “ls -l” a very good and useful command but then I find him strugelling with calculating the file […]
Here we go. I need to install some sort of desktop environment on my server in order to be able to use it for something later on! So I’m about to install Graphical Interface. As this latest version of Gnome is kind of sucky for a server I’m not going to go with Gnome, so […]
Sometimes you have to use SSH to get some jobs done in Linux! So what if you need to run multiple applications under SSH? Well the first solution is to open multiple SSH connections. Screen can make your life easier by letting you to have multiple windows on a single SSH session! But it’s not […]
Sometimes using SSH to re-index Magento data is the best way to avoid the connection timed out problems in stores which have a big database. To avoid this you can run the re-index PHP code under SSH instead of web browser! to do it simply enter your Magento root folder in your SSH client and […]
