Mysql: Exporting one table

To export only one table with it’s data from the database run:

>mysqldump -u dbuser -p dbname tablename > filename.sql

and to import the table back again:

>mysql -u dbuser -p dbname < filename.sql

About this entry

You’re currently reading “Mysql: Exporting one table,” an entry on Faris Madi

Published:
2007-06-14 / 11:25 am
Category:
Programming, Technology, linux
Tags:
, , ,