5

How to use SSH import database into mysql?

view full story
linux-howto

http://serverfault.com – I have a bigger database(2.1GB). I want input it into mysql in server part. If I output it from mysql in local part with tar.gz format, it has 420MB, if left a sql format, it has 2.1GB. How to use SSH import database into mysql? some method here support sql format only: # mysql -u username -p database_name < file.sql transfer a 420MB tar.gz to server part, than do a unziped?(maybe a long time during unzipped) cut sql to many pieces? Or better idea? Another question, should I modify the my.cnf to support a large size file input? Regards. (HowTos)