when i try to import huge table(using ssh) the server stop responding
this is the command i use
mysql -uusername -ppassword databasename < tablename.sql
but if the file is big the server stops responding so i wait for hlaf an hour restart the server but when i turn it on and see what has been imported i see that 1/3 of the table was imported
so how can i fix this ?
i have 4gb ram and quad core xeon 3210 – centos 5
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |