Kurinchilion.com » Linux Windows Enterprise Solutions
MySQL Table Types that are well known
- MyISAM
- InnoDB
- BSD
When making a choice amongst the different types of tables in MySQL, we need to consider the following points
- Size of database based on the activity
- Nature of database access / activity (whether it involves heavy reads / writes)
- Database backup (schema, data)
- Session handling
- If it involves a sync to another database
- What needs to be done if the application is to be scaled
(more…)
Steps to install MySQL on Ubuntu Server
After setting up the server, issue the below command to install mysql and its associated libraries
$ apt-get install mysql-server mysql-client libmysqlclient12-dev
Edit MySQL configuration file, to set the IP address that will be dedicated for MySQL.
(more…)
How to transfer mysql backup files across network or emails?
Say for example, you generate a mysql dump called “mysql.dump” from your database the size of which is beyond the file transferable limit of your email account. The following steps will help you in making the file transfer possible (more…)
Is MySQL Case-Sensitive?
The SQL syntax is NOT case-sensitive in MySQL.
If the application written in PHP/Perl or other languages were to be used in Microsoft & Linux environment, then it would really be an issue for the database administrators and for the programmers.
That is the reason why you might have noticed books or sites saying that it is always recommended to treat MySQL syntax as being case-sensitive.
It was interesting to learn that the database name remains case sensitive.
As given by MySQL documentation (http://dev.mysql.com/doc/refman/4.1/en/charset-general.html): A character set is a set of symbols and encodings. A collation is a set of rules for comparing characters in a character set.
Why is MySQL Collation an important consideration?
Collation determines the rules in comparing characters including the case sensitiveness, accent sensitiveness, trailing space sensitiveness of the character set. (more…)
Importing a .CSV file in MySQL from command line.
When you want to import records from a .csv file into a table, follow the steps given below:
[root@localhost]$ mysql -u [username] -p [password]
[root@localhost]$ use [my_database]
[root@localhost]$ LOAD DATA LOCAL INFILE ‘userinfo.csv’ INTO TABLE [table name] FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’;
This should be the same command that get executed on windows command prompt as well.
Exporting a .CSV file based on user requirement is very easy in MySQL.
A simple query could generate your desired output as .CSV file. Let’s see what that command is
[root@localhost]$ mysql -u [username] -p [password]
[root@localhost]$ use [my_database]
[root@localhost]$ SELECT * INTO OUTFILE ‘/userinfo.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”" ESCAPED BY ‘\\’ LINES TERMINATED BY ‘\n’ FROM Table_Users;
Voila! You have your desired results in as a .csv file.
In the next article, we will discuss on how we can import data from .csv file back into database.
Mysql Tips for Beginners
* How to log into Mysql from command prompt?
First, Go to the Mysql installation directory and move to the bin directory (C:\Mysql\bin\)
Execute the following command to log into Mysql
C:\Mysql\bin> mysql -u [username] -p [password]
You will be shown mysql command which indicates that you have successfully logged in
mysql> _
(more…)
To shutdown mysql from command prompt, issue the following command in Linux box
[root@computer /]# mysqladmin -u root -p shutdown
In windows,
C:\mysql\bin> mysqladmin -u root -p shutdown _
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Aug | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | |||
Entries (RSS) Designs by Kurinchilion Inc. All rights reserved.