Database size allowed for loading through the PhpMyAdmin interface
is limited by the PHP parameters post_max_size and upload_max_filesize.
(usually 100-200 MB), so if the database dump volume exceeds these parameters, you can download the dump using SSH access.
In the DirectAdmin control panel is available Web SSH Client, for authorization use the same access data as for DirectAdmin.
Before you import the sql dump, you need to create a database in the DirectAdmin hosting control panel – https://tuthost.ua/faq/kak-sozdat-bazu-dannyh-mysql/.
Use the following command to import:
| mysql –user=user –password=password name_database_data < file_dump.sql |
Use the following command to export the database:
| mysqldump –user=user –password=password name_database_data file_dump.sql |
