Dumping or backing up a table:
mysqldump -u username -ppassword --default-character-set = latin1 --single-transaction database --tables table > /location/table_bk.sql
Restoring a backed up sql.
mysql -u username -ppassword database < /location/table_bk.sql
Thursday, October 23, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment