Best way to import data into mysql?

Marc0 · Feb 2, 2016

I have a database 260 MB but I have issues when importing my database into Mysql via phpMyadmin, its very slow and sometimes time out. I heard of using bigdump or mysql dumper but not sure how it will works. Do you guys use these tools or having alternatives? what are your best ways to import data into mysql?

CyberAlchemist · Feb 2, 2016

Edward said:
I have a database 260 MB but I have issues when importing my database into Mysql via phpMyadmin, its very slow and sometimes time out. I heard of using bigdump or mysql dumper but not sure how it will works. Do you guys use these tools or having alternatives? what are your best ways to import data into mysql?

I used mysqldumper but to be honest, it required to configure and knowledge to restore dbs with it. In other words, it looks a big script and more complex than bigdump.

vps9 said:
you can google about it. you can find many youtube videos regarding this.

Agree but if you are using a VPS, you can try these methods

http://www.webmastersun.com/threads/8301-Download-and-Restore-MySql-database-via-SSH

http://www.webmastersun.com/threads...nd-restore-large-MySQL-databases-by-Mysqldump

Developer · Feb 2, 2016

As someone who deals with MySQL on a daily basis, i can attest that the BEST way would be to do it manually via phpMyAdmin. Break the file into chunks and take it slowly. Yes, it may take a while, but you can monitor it as it goes along. I do this exact sort of stuff daily with DBs 4 and 5 times the size of yours. Let me know if you need any help.

hmb-robert · Feb 4, 2016

DO you have SSH access for your hosting services ?

Ron Killian · Feb 19, 2016

Most cpanels have a limit to the size of a SQL file you can import. I have gotten by this by compressing the file, as phpMyAdmin will take compressed or gzip versions. Though, don't know if compression would make your SQL small enough? Never had much luck with zip, but gzip has worked for me.

Best way to import data into mysql?

Marc0

Well-known member

CyberAlchemist

Well-known member

Developer

Well-known member

hmb-robert

Member

Ron Killian

Well-known member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud