Mysql Mysqldump - Administration

➟

Last update: 29-10-2021

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)

 
# 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

REMEMBERS