minte9
LearnRemember / MYSQL



Sql dump

Easily restore or import MySQL data with mysql command.
 
# <span class='keyword_code'>mysqldump</span> --<span class='keyword_code'>routines</span> -u root -p pass db_name > backup.sql
-- routines = Dump stored routines (procedures and functions) from the dumped databases

Import

 
# mysql -u root -p pass db_name_new <span class='keyword_code'>< backup.sql</span> 
http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/ http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html





Questions and answers




Import sql dump

  • a) mysqldump ... db_name > backup.sql
  • b) mysql ... db_name < backup.sql


References