Big size SQL import problem?
I have backup of Mybb forum SQL. I want to import that. SQL file size is 222MB. I used Bigdump.php. But when proccess is %100, it give me error:
ALTER TABLE `mybb_posts` ADD PRIMARY KEY (`pid`), ADD KEY `tid` (`tid`,`uid`), ADD KEY `uid` (`uid`), ADD KEY `visible` (`visible`), ADD KEY `dateline` (`dateline`), ADD KEY `longipaddress` (`longipaddress`), ADD FULLTEXT KEY `message` (`message`); -> Lost connection to MySQL server during query
I tried many times but import is not completed. How i fix that?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.