Portal Home > Knowledgebase > Articles Database > Cant import 1.5GB db to mysql
Cant import 1.5GB db to mysql
| Posted by -liquid-, 11-18-2014, 03:36 PM |
| Hello i am trying to import a 1.5GB db to a mysql database but everytime i get :
ERROR 2013 (HY000) at line 12118: Lost connection to MySQL server during query
It is Centos 6 64 with cPanel.. i am doing it via ssh this is my cnf file
[mysqld]
default-storage-engine=MyISA
innodb_file_per_table=1
open_files_limit=12000
max_allowed_packet=107374182
net_buffer_length=1000000
wait_timeout=200000
Please advice..???
|
| Posted by dren, 11-18-2014, 04:14 PM |
| Did you check line 12118 and see what is going on?
You might also look at your query_cache_size, and other settings in my.cnf (e.g. max_allowed_packet, key_buffer_size).
Last edited by dren; 11-18-2014 at 04:18 PM.
Reason: Fixed post.
|
| Posted by rogriverac, 11-18-2014, 04:43 PM |
| You should check this values and make sure those are compatible with your file size:
* post_max_size =
* upload_max_filesize =
* max_execution_time =
* max_input_time =
* memory_limit =
* max_allowed_packet =
|
| Posted by zacharooni, 11-18-2014, 05:26 PM |
| Is the database InnoDB?
Try tailing the logfile before you import:
tail -f /var/lib/mysql/$(hostname).err
Leave that open, then, in another SSH session, do your import.
|
| Posted by TransNOC, 11-19-2014, 06:00 AM |
| Try this:
nano /etc/my.cnf
max_allowed_packet = 256M
Save file
service mysql restart
Also make sure any timeouts are at like 1000 seconds until you import the database.
Then try importing your database again.
If it works, remove the above tweaks and restart the MySQL server.
|
| Posted by net, 11-19-2014, 06:13 AM |
| Moved > Hosting Security and Technology .
|
| Posted by Kailash12, 11-20-2014, 01:05 AM |
| Looks like one of the MySQL settings limit is exceeding its allocated limit during restore. As zacharooni suggested, tail your mysql error log file in another SSH session during restore.
|
Add to Favourites 
Print this Article
Also Read
Shared Hosting
Shared Hosting
