dump file sql
mysqldump -umytable -p -hserver DatabseName TableName > test.sql;
dump file gz
mysqldump -umytable -p -hserver DatabseName TableName | gzip > test.gz;
unzip mysql dump
gunzip < filename.gz | mysql -uphuc.duong -p -hlocalhost DatabseName;
mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]
No comments:
Post a Comment