3 ways to import large SQL files into MySQL database

3 ways to import large SQL files into MySQL database
February 4, 2022 No Comments Tutorial rhalp10

Are you having trouble importing large SQL file into your mysql /mariadb or even on hosting site like GoFaddy, Hostinger ?

Here some ways to import it and hope it will work out for you.

1. Using CMD (Command Prompt)
mysql -u root -p databasename < "C:\downloads\sql\large_table.sql"

//use this instead if you have blob / json
mysqldump -u root -p databasename --hex-blob < "C:\downloads\sql\large_table.sql" 
2. Configure WAMP / XAMP to increase upload and post limit.
STEP 1
3. SQL dump splitter

SqlDumpSplittr is a Windows tool with a simple step-by-step wizard to split SQL text dumps from MySQL and PostgreSQL into several files with defined file size. PHP upload limits are not an issue anymore. Just split your dumps into pieces and upload it.SqlDumpSplittr is creating one SQL file with the CREATE and ALTER statements, and several files with INSERT or COPY statements of the data.

Download SQL dump splitter:

STEP 1
STEP 2
STEP 3

https://stackoverflow.com/questions/38759870/xampp-mysql-table-doesnt-exist-in-engine-1932/48656159#48656159

https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te

Tags
About The Author
0 0 votes
Article Rating
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x