Saturday, October 16, 2010

Import and Export mysql tables

To export the mysql table

#mysqldump -u user -ppassword "databasename" "tablename" > tablename.txt

To import tables

#mysql -u user -ppassword "databasename" < tablename.txt

No comments:

Post a Comment