How to import big files to PhpMyAdmin

[roguitar]

Hello, guys! I have a huge data table, my concern is if I can't upload it to your server through PhpMyAdmin. This table contains the names of all countries, states and cities of the world. I need it because I'm implementing a sign up form and these data are strictly necessary. I know there must be out there other ways to retrieve that information. But... Is it possible to upload or import over 200MB of data to your PhpMyAdmin? If so, how can I do this? The file is zipped. Thank you  

 

[Krydos]

You could use a tool like https://philiplb.de/sqldumpsplitter3/ or you could just upload the .sql file to /home/roguitar/filename.sql and ask one of the admins to import it for you.

[roguitar]

You could use a tool like https://philiplb.de/sqldumpsplitter3/ or you could just upload the .sql file to /home/roguitar/filename.sql and ask one of the admins to import it for you.

Great! Where can I contact the admins? I'm on Ricky server. May I open another question or topic requesting this around here or what? Thank you!  

[roguitar]

You could use a tool like https://philiplb.de/sqldumpsplitter3/ or you could just upload the .sql file to /home/roguitar/filename.sql and ask one of the admins to import it for you.

Well, the file is already there in /home/roguitar/sql/world.sql.gz

Edited July 9, 2019 by roguitar

[roguitar]

Hi, there, howdy? I'm on Ricky server. Could you please help me? I need those data for retrieving countries, states and cities for my registration form. Well, the file is already there in /home/roguitar/sql/world.sql.gz

I want it to be uploaded to my PhpMyAdmin database, more exactly in roguitar_englishup. The file is too big (over 30MB compressed and in total over 200MB) and I'm asking for your help, because I won't be able to do it manually.

 

Thank you! 

Edited July 9, 2019 by roguitar

[roguitar]

 

You could use a tool like https://philiplb.de/sqldumpsplitter3/ or you could just upload the .sql file to /home/roguitar/filename.sql and ask one of the admins to import it for you.

Well, the file is already there in /home/roguitar/sql/world.sql.gz . I want it to be uploaded to roguitar_englishup

 

Well, I sent the request in another post/topic: https://www.helionet.org/index/topic/36207-help-to-import-a-big-sql-file/

Just to let you know...

[roguitar]

You could use a tool like https://philiplb.de/sqldumpsplitter3/ or you could just upload the .sql file to /home/roguitar/filename.sql and ask one of the admins to import it for you.

I've already solved this problem. No need for help. Thanks.