Setting up Replication for MySQL data

http://www.ovaistariq.net/565/setting-up-master-slave-replication-with-mysql/

 

http://www.howtoforge.com/how-to-repair-mysql-replication

 

http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/

How to query on mutliple table in a single shot without joining

Just to share something interesting for novice on SQL (MySQL).
Students   — studentId   — Name    — Age

Subjects     — subjectId   — SubjectName   — studentId

//get all students subjects in one SQL query, with all details of the student such as name, age
select st.*,su.SubjectName from Students st, Subjects su Where st.studentId =  su.studentId

How To Tune SQL Queries in MySQL

Just read on this ^_^

http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html

 

http://www.ducea.com/2006/11/06/identifying-mysql-slow-queries/

Insert rows from Query Results

 

INSERT INTO  table_1( col1,  col2 )  ( select col1, col2 from table_2 )

 

How to export MySQL query to CSV file from console

mysql  -u <user_name>  -p <password>  <database_name>    -h <host_name>  -e  ”select name,age from table_name;” | sed ‘s/\t/”,”/g;s/^/”/;s/$/”/;s/\n//g’ >  /home/xerxis/file_name.csv;

How to backup and restore MySQL database using mysql console

How to dump/backup database;

mysqldump -u {username}    -p{password}    {dbname}     >    {filename_db.sql}

 

How to Restore/Import database backup;

mysql    -u{username}  -p{password}   {dbname}    < { filename_db.sql}