Wednesday 15 August 2012

SQL command line

dump file sql
 mysqldump -umytable -p -hserver DatabseName TableName >  test.sql;
dump file gz
mysqldump -umytable -p -hserver DatabseName TableName | gzip >  test.gz;

unzip mysql dump
gunzip < filename.gz | mysql -uphuc.duong -p -hlocalhost DatabseName;

mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]