MySQL DBA - Tips and Techniques Magazine

11 Nov 2014

Extracting single table from a mysqldumpfile

 

http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-mysqldump-file.html

 

1) Download the attached file and call is extract_sql.pl

2) ftp to server where mysqldump file resides

3) ./extract_sql.pl -t tacas.user -r latestmaster > mytable.sql

 

 

there you go, a file containing create table and data for single table from mysqldumpfile.

 

No comments:

Post a comment