Importing LARGE sql files into a database

this has come up quite often since many websites have a huge database, like my forums. for example, this would be good for files that cant be imported via phpmyadmin, or other php powered mysql fonrtends.