jump to navigation

how to dump mysql database from command line August 28, 2008

From shell:

mysqldump -h localhost databasename > filename.sql

if you need to enter a password:

mysqldump -h localhost -p databasename > filename.sql

databasename is the name of the database you want to dump filename.sql will be the target fila of the dumped database

Comments»

no comments yet - be the first?


Bad Behavior has blocked 146 access attempts in the last 7 days.