I am trying to import a .sql file which has MyISAM engine, about 51 million rows with 18 columns. The file has 1 primary and 1 unique key. I have after lurking around this site and reading mysql manual learned about how to import by using
repair by sort. This however started my problem. Although
show processlist shows
Repair by sort I cant see the tmp tables that it supposedly creates for the process not to mention when I check the /mysql/data directory .myd and .myi files totals the .sql file but the process does not end. I have left the process open for 2 days without any change at which time I killed it.
Could this be because the computer I have to use as mysql server is wamp or cause of the hardware limitations which has 2.gen i5 with 4GB Ram and 1 500GB HDD with 2 partitions or could the dump I have been given is corrupted?
Thnx in advance for any nudge in the right direction to this newbie about mysql and well databases in general. (Below is the parts of the my.ini with the help of percona config tool)
tmpdir = D:/temp key_buffer_size = 2344M myisam_file_sort_size = 80G myisam_max_sort_file_size = 80G myisam_sort_buffer_size=164M join_buffer=1M record_buffer=1M sort_buffer_size=2M read_buffer_size=2M query_cache_size=132M table_cache=1024 thread_cache_size=256 max_allowed_packet=156M