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?