Jump to content


Photo

How to import big files to PhpMyAdmin

PhpMyAdmin Database big tables sql php.ini phpmyadmin database

  • Please log in to reply
6 replies to this topic

#1 roguitar

roguitar

    Rank II Member

  • Members
  • PipPip
  • 77 posts

Posted 08 July 2019 - 10:26 PM

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:

 



#2 Krydos

Krydos

    Rank X Member

  • Root Admin
  • 18,924 posts
  • Gender:Male

Posted 08 July 2019 - 11:33 PM

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.

#3 roguitar

roguitar

    Rank II Member

  • Members
  • PipPip
  • 77 posts

Posted 09 July 2019 - 12:57 AM

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! ;) 



#4 roguitar

roguitar

    Rank II Member

  • Members
  • PipPip
  • 77 posts

Posted 09 July 2019 - 01:15 AM

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 by roguitar, 09 July 2019 - 11:26 PM.


#5 roguitar

roguitar

    Rank II Member

  • Members
  • PipPip
  • 77 posts

Posted 09 July 2019 - 03:06 AM

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, 09 July 2019 - 03:11 AM.


#6 roguitar

roguitar

    Rank II Member

  • Members
  • PipPip
  • 77 posts

Posted 09 July 2019 - 03:30 AM

 

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...a-big-sql-file/

Just to let you know...



#7 roguitar

roguitar

    Rank II Member

  • Members
  • PipPip
  • 77 posts

Posted 11 July 2019 - 01:11 AM

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.







Also tagged with one or more of these keywords: PhpMyAdmin, Database, big tables, sql, php.ini, phpmyadmin, database

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users