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»

1. how to dump mysql database from command line » dhundee’s world - July 28, 2011

[…] this post moved to how to dump mysql database from command line Tags: mysql, mysql administration No Comments Server Administration « Because the Lord is watching over us apache crashes due to high traffic » […]