TWB
v2014.06.16.08.48.09

MAC - MySQL Server

# start
/usr/local/mysql/bin/mysqld_safe

# besser:
/usr/loca/mysql/support-files/mysql.server  start|restart|stop

# Bsp.
sudo mysql.server start

#

mysqldump -uDBUSER -pDBPASSWORD DBNAME > DBNAME.DATE.sql

# oder spez. Tabellen
mysqldump -uDBUSER -pDBPASSWORD DBNAME DBTABLES > DBNAME.DATE.sql

MySQL DB Import

mysql -uDBUSER -pDBPASSWORD DBNAME < DBNAME.DATE.sql

einfache Befehle

show databases;

use DBNAME;

show tables;

show columns from TABLENAME;