How to IMPORT Large Database??

[tonywells82]

I need to Import my Database but it says the max file size to upload is 512MiB.

My Database is a tar.gz file that's over 4.78 GB. How would I be able to do that? Is there some other way to Import such a large Gzip file?

Thanks in advance!
TW

[shawnb61]

If you've never done it before, the best way to do so is to ask your host!

If you have to do it yourself, you need to FTP the file up there first.  Most of the webpage loads use http which will take too long & be too flaky.  Sometimes they work, but if there's any issue at all you have to start over.  You will find FTP much faster & more reliable.

Once the file is on the host, loading the file to the DB via the mysql command line is the best way to go.  Your host needs to provide command line access via SSH for you to do that.  I've never had luck with a tool like phpmyadmin to do large files.  Work straight with mysql - again, much faster & more reliable.
https://phoenixnap.com/kb/how-to-backup-restore-a-mysql-database

[Sir Osis of Liver]

Host support should do it, if they don't, move to a decent host.

You can import it with a third party utility like MySQLDumper or BigDump.

[tonywells82]

OK. Will check with my host about that.
Thanks,
TW

[Dzonny]

There's also a small software called "sql splitter" which you can use to split large database into multiple smaller parts, so you can then import it one by one.