Best way to import data into mysql?

Marc0

Well-known member
Registered
Joined
Jun 6, 2012
Messages
890
Points
28
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

Well-known member
Registered
Joined
Feb 9, 2013
Messages
112
Points
18
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

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

Well-known member
Registered
Joined
Dec 21, 2015
Messages
292
Points
43
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.
 

Ron Killian

Well-known member
Registered
Joined
Dec 3, 2015
Messages
363
Points
0
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.
 

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top