O
O
Optimus2017-03-04 09:37:09
MySQL
Optimus, 2017-03-04 09:37:09

Importing a database into OpenServer?

When importing a 4 mb database into phpmyadmin in OpenServer, display the following message:
zVxh9p4Rkrg.jpg
Should I worry, the first line says "Import completed successfully". The MySQL server has gome away error can be for many reasons: it closed the connection due to timeout (hardly here), too large a packet size is also unlikely. Should I disable checking foreign keys on import?
UP: Imported with disabled foreign key checking - everything is fine. But is it right?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Nikolaev, 2017-03-04
@gromdron

OpenServer has a utility - HeidiSQL. It is still better to run large files through imports.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question