How to change MySQL database collation from phpMyAdmin in cPanel
Sometime you may require to change MySQL collation in your web hosting account to use foreign character encoding. There are many ways to change MySQL collation. Here are the steps to change MySQL collation from phpMyAdmin in cPanel:
[1] Login to your cPanel and click on “phpMyAdmin” icon.
[2] Click on your database name and the go to “Operations” tab.
[3] At the bottom of the page you will see the collation option. You can now select a collation from the drop down menu and click on the Go button.
Please note that the new collation will be set for new tables only. Old table will use the previous collation under which they were created. If you want to use new collation for already created tables, you will need to change collation for all tables.
Create a tar archive
Sometime, you may need to move some large folder from one server to another or you may require to take backup of user’s home directory. On Linux platform, you can use command tar to create an archive of the folder.
For example, if you want to create an archive for /home/user1 folder then use the following command:
tar -pczf user1.tar.gz /home/user1
For more options, you may refer the manual of this command. Use following command to get the details about all options:
man tar
-
Recommended Host
-
Affiliate Programs- Premium WordPress Themes
- Estate – Real Estate WordPress Theme
- Unite Micro Blogging WordPress Theme
- Coda Premium WordPress Theme
- Inspire Premium WordPress Theme
- Apz Premium WordPress Theme
- Spectrum WordPress theme
- Moving WordPress blog within your web site
- WordPress Advance Simple Blue theme
- Hello Magazine Premium WordPress Theme
- How to import your blog from LiveJournal to Wordpress blog