How to download a large database 23gb?

Question

MySQL

Welcome all.
There is a DB on 23 GB. Several times I tried to upload via ftp through filezilla, but for some reason it reaches a certain point and does not load anymore. Although the server has the required amount of space.
Please tell me what are the simple ways to load the database? Probably not through isp manager either, because most likely it will just fail during the import process.

Answer 1

Yes, at least shake a zip, if there are no pictures in the database - a giga 3 dump will take

Answer 2

Maybe the file system does not accept a file of this size, try to break it into pieces and unpack it there, or look at the logs, the cause of the error should be.
FAT32 - 4Gib
NTFS - 16Eib
ext2/3 - 16Gib - 2Tib (depends from block size)
ext4 - 16Gib - 16Tib
XFS - 9Eib
ZFS - 16Eib

Answer 3

It is better to compress gzip first and download it yourself via rsync. Even better is to split the tables into separate files. It supports uploading files like

Answer 4

I don’t know how 23GB, but I uploaded more than 10GB via ISPman. Upload to the server and the panel select local import. You can watch the process in phpmyadmin.

Answer 5

I do not really understand why to load the database via ftp.
Files are clear. Base - why? To lie dead weight? Well, split the archiver into files of 100 mb and upload.
If there is no database server - for example sqlite, then why such a size?
If there is a database server, then open it for external connections, launch Navicat or its equivalent and import the database.

Answer 6

Versatile, simple and reliable, like an axe.
1. Deploy the dump on the local server to a local database.
2. Allow remote connection to the database on the server.
3. Save all records to the server line by line using a local script.