Vesta Control Panel - Forum

Hello dear Vesta community.

I'm new here in this community and with vestaq and working already some months with vesta.

I have a large DB and want import. A lot of categories and entries.
Now i want import 200MB Database as zip.

(mysql/socket 900 - Filesize UL 1024M)

Before - i get error 2006 - mysql server gone away.
Now i have figured out, i have to setup in etc/mysql.conf the keep alive timeout to 900.
Ok. But now i get the issue 500.
Sometimes it works,- if i setup new vesta to debug this error, sometimes not.
What i do sometimes right, what not. (???)

What i have especially to do/setup, that i can import large DB files/socket_timeout/keep_alive_timeout?
Who can help me please.

Thanks for that.

Greetings

-------------

Edit: (With this settings it worked a install before, but now i get a 500)

key_buffer_size = 256M
max_allowed_packet = 1024M
table_open_cache = 256
sort_buffer_size = 1024M
read_buffer_size = 1024M
read_rnd_buffer_size = 1024M
myisam_sort_buffer_size = 1024M
thread_cache_size = 1024
query_cache_size= 1024M
thread_concurrency = 8

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=200
max_user_connections=50
wait_timeout=900
interactive_timeout=300
long_query_time=5

How many ram do your server/vps have?