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.