How to do import/export of a large size database?

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

Total 0 Votes:

Tell us how can we improve this post?