/bin/mysqladmin -u root password senha 

GRANT ALL PRIVILEGES ON meuBD.* TO joao@localhost
IDENTIFIED BY 'ola' WITH GRANT OPTION;
FLUSH PRIVILEGES;

SELECT * FROM table WHERE MONTH(data)='05';

SELECT DISTINCT DAYOFMONTH(data),MONTH(data),YEAR(data);

Descrição: seleciona o dia do mês, mês e ano sem repetir da tabela table.

SELECT DATE_FORMAT(campoData,'%d-%m-%Y') FROM table;

Formato: dd/mm/yyyy

http://www.mysql.com/doc/en/Date_and_time_functions.html

SELECT * INTO OUTFILE 'saida.txt' FROM table;

INSERT INTO table1 (nome) SELECT nome FROM table2;

    mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]
 
          o [username] - this is your database username
          o [password] - this is the password for your database
          o [databasename] - the name of your database
          o [backupfile.sql] - the file to which the backup should be written.
 
    mysqldump -u sadmin -p pass21 Customers > custback.sql

:: mysqldump --add-drop-table -u sadmin -p pass21 Customers > custback.sql 

    mysqldump --add-drop-table -u sadmin -p pass21 Customers customer_master 
customer_details> custback.sql 
 
    mysqldump -u [username] -p [password] [databasename] [table1 table2 ....]
 
          o [tables] -

:: mysqldump -u user -p –complete-insert –add-drop-table –databases db1 db2

1. -no-data
2. -no-create-info
3. -no-create-db

LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';

FIELDS TERMINATED BY 'fieldtermstring'
ENCLOSED BY 'enclosechar'
ESCAPED BY 'escchar'
LINES TERMINATED BY 'linetermstring'

FIELDS TERMINATED BY ',' ENCLOSED BY '\"'
LINES TERMINATED BY '\r\n'

  mysql -u [username] -p [password] [database_to_restore] < [backupfile] 
 
  mysql -u sadmin -p pass21 Customers < custback.sql

Cat joins txt…. cool

cat backup1.sql backup.sql | mysql -u sadmin -p pass21 

gunzip < custback.sql.sql.gz | mysql -u sadmin -p pass21 Customers 

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
character-set-server=utf8
default-character-set=utf8
     
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[myisampack]
character-sets-dir=/usr/share/mysql/charsets


# [mysqld-4.1] or [mysqld-5.0] for specific configurations

php.ini

[php-apache2handler]
default-character-set=utf8 

http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/