yeah this is what i was going to do, but they have replied to my ticket saying they have lifted the import limit to 64MB, which will hopefully resolve my immediate problem..
As long as you can upload it through the browser! Not sure I'd want to upload a 24mb file through the browser.
Doing it via the command line is pretty easy really. For SSH just google 'PuTTY' and download it - that's the SSH client you need.
Fire it up & enter your server URL & connect.
You'll then get a logon prompt, you'll need to check with support for your username & password, but its probably the same as your FTP details.
Once logged in, you'll almost certainly be dumped into the same directory as when you log in through FTP, so if you've uploaded the sql file, it'll be sat there waiting.
Then its a case of typing...
mysql -u<username> -p<password> -D<databasename> < sql_file.sql
So, if your username was sforum, password was letmein & database name was sforum_xenforo the command would be something like:
mysql -usforum -pletmein -Dsforum_xenforo < sql_file.sql
This would then execute the SQL in the file and populate the database.
a couple of things to point out - make sure a) the database exists and b) the sql file doesn't start with CREATE DATABASE ....
If it does, just create the database through the admin system & then remove the line from the SQL file.
You technically don't have to, but I prefer to name the DB on the command line, rather than let the script do it. Use the wrong sql script and all sorts of bad things could happen!
Hope all that helps a bit
