PROGRAMMING

 
REMEMBERS




Last update:   29-10-2021

Sql dump

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

Import

 
# mysql -u root -p pass db_name_new < backup.sql 
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    
Table definition

        A B C D E F
🔔
1/1