Best way to import data into mysql?

[hoangvu]

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]

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.

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

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

https://www.webmastersun.com/thread...nd-restore-large-MySQL-databases-by-Mysqldump

 

[Developer]

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]

DO you have SSH access for your hosting services ?

 

[Ron Killian]

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.