Jump to content

How to import big files to PhpMyAdmin

Recommended Posts

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   :rolleyes:


Link to comment
Share on other sites

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 by roguitar
Link to comment
Share on other sites


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...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...