Since I always forget:
mysqldump –extended-insert=false –host <host> –skip-lock-tables -u <user> –password <database> <table> > file.sql
Tag Archives: mysql
Simple MySQL export/import
mysql -e 'SELECT * FROM table' > out.txt
load data local infile 'out.txt' into table 'some_table'