Best way to import data into mysql?

hoangvu

New member
Joined
Jun 6, 2012
Messages
1,835
Points
0
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

New member
Joined
Feb 9, 2013
Messages
245
Points
0
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

Active member
Joined
Dec 21, 2015
Messages
412
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

New member
Joined
Dec 3, 2015
Messages
804
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.
 
Newer threads
Recommended threads
Replies
9
Views
3,116
Replies
2
Views
2,284
Replies
1
Views
4,686

Referral contests

Referral link for :

Sponsors

Popular tags

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