Friday, January 11, 2013

Dump single table with mysqldump command

You can easily take backup of single large table with musqldump command

mysqldump -u user -p database name tablename > '/target_path/filename.sql'

Once you enter it will ask for mysql user password, after entering password it will create dump file at specified location.

No comments:

Post a Comment