Tips & Tricks
There are really many approaches on how to import a 500MB database. Some use mysql command line, some use GUI clients. What I found out to be the quickest way is to log in to mysql console, create a database and execute source command:select all
$ mysql -u root mysql > create database my_db; Query OK, 1 row affected (0.00 sec) mysql > use my_db; Database changed mysql > set names utf8; Query OK, 0 rows affected (0.00 sec) mysql > source path_to_big_sql_dump.sql ....