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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment