Tuesday, May 4, 2010

Dump using sed & mysqldump

Dump table mysql using sed

sed -n '/^-- Table structure for table \`nametable\`/,/^-- Table structure for table/p" namedb > namatable.sql

using mysqldump

mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql

restore DB / table

mysql -u username -ppassword databasename < /tmp/databasename.sql Dump table mysql using sed

sed -n '/^-- Table structure for table \`nametable\`/,/^-- Table structure for table/p" namedb > namatable.sql

using mysqldump

mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql

restore DB / table

mysql -u username -ppassword databasename < /tmp/databasename.sql

No comments:

Post a Comment