Hello,
i m trying to migrate from a home made crm to SuiteCRM my data.
The problem is, my leads table contains a bit more than 6 milions lines. i put very high figures as values on the server in term of time out or memory or max size file. I also set SuiteCrm high figures in the administration panel.
when i try using the wizzard, i have a connection aborded message but no php error in the logs.
i wonder how to import my data using sql because i saw data writen in multiple tables on the sample i used : beans for example.
do you have succeed in this kind of operation ? Could you help me ?
Thanks
Go to php.ini file and set the below according to your need.
post_max_size = 60M
upload_max_filesize = 100M
memory_limit = 300M
file_uploads = On
max_execution_time = 180
Hello,
Thank you for your answer.
Here are my values :
post_max_size = 3000M
upload_max_filesize = 3000M
memory_limit = 4000M
file_uploads = On
max_execution_time = 360000
I still have a « connection aborded » error while submitting my 2,4Go file.
6 million rows is a huge database. Either you throw a lot of hardware at it, and really refine your DB with indexes etc, or you will get into trouble with it.
Assuming you won’t be trying to make 6 million phone calls, my advice is to prune down that database and don’t try feeding it all to SuiteCRM, just the parts that are really interesting for your work currently.