How to change the MySQL data default directory If you're new here, you may want to subscribe to my RSS feed and if you have questions related to your ubuntu system post question to our forums. Thanks for visiting! Sponsored Link MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries. If you want to install Mysql database server in Ubuntu check this tutorial. What is Mysql Data Directory? Mysql data directory is important part where all the mysql databases storage location.By default MySQL data default directory located in /var/lib/mysql.If you are running out of space in /var partition you need to move this to some other location. Note:- This is only for advanced users and before moving default directory make a backup of your mysal databases. Procedure to follow Open the terminal First you need to Stop MySQL using the following command sudo /etc/init.d/mysql stop sudo cp -R -p /var/lib/mysql /path/to/new/datadir
Converting your MySQL database to UTF8 This document describes how to convert your MySQL database from the latin1 charset to UTF8. Moodle requires that your Database is now UTF8 and will not upgrade if your database is not. For more information about UTF8 have a look at the doc on unicode. Why? You may see the following error when upgrading your Moodle. It is required that you store all your data in Unicode format (UTF-8). Default Mysql character set Moodle requires UTF8 in order to provide better multilingual support and has done since Moodle 1.8. You need to do two things. 1) Change your mysql to have utf8 as its character set and 2) Change your database to utf8. The descriptions elsewhere in this section cover making the utf8 database versions using mysqldump. To make mysql default to utf8 you can edit /etc/my.cnf as follows. (This was good for ubuntu server lucid 10.04 2.6.32-24-server Jan 2011) In the client section of my.cnf [client] ... .... ... default-character-set=utf8 .... and further down in my.cnf [mysqld] ... ... Explained
6 Handy Sites To Learn New Ubuntu Tweaks & Tricks Ubuntu has grown in popularity immensely over the last few years ““ and for good reason. The operating system is accessible (both in a software and hardware sense), compatible with a lot of software and won’t cost you a penny. If you’re looking to expand your Ubuntu knowledge, have a burning question about some missing feature or are a newcomer to the world of Linux then these 5 sites are a great source of information. OMG! My personal favourite source for Ubuntu-related news and developments, interspersed with timely how-to posts and tutorials. As well as instructional pieces, there’s plenty of news about upcoming software, updates and unreleased versions to gawp at, as well as editorial pieces, interviews and software reviews. OMG! Ubuntu Geek A repository (mind the pun) of tutorials and instructionals, purely aimed at the Ubuntu Linux distribution makes this a cracking resource for users old and new. UbuntuForums.org ““ Tutorials & Tips UbuntuGuide.net UNIX Men MakeUseOf Answers Conclusion