Importing 60mb database

[Battle_Ring]

hello im trying to move my forum to a new host but it wont load using import in phpmyadmin because it says the file is too big is there any other way

[bairy]

If you have shell access, use that. I don't know the linux commands for command line sql so someone else will have to help with that.

Otherwise, you could split the textfile up into small chunks of 1mb or so. So long as create table 'paragraphs' are kept together you can split on any line. It's tedious and it will be slow, but it will work.

[Kirk Y]

Yeah I'm on an IIS server -- so splitting up our SQL restores is insanely annoying.

Anyway, I've still got the code we used when we were on a Linux host.

mysql -u root -psecret -D stocks2 < stocksdb.sql

It's fairly self-explanatory, stocks2 is the database you're restoring to and stocksdb.sql is the file/path/to/your/sql/file.

[Hellcat]

You could also upload the .sql file viy ftp and let a custom php script do the import (assuming max. execution time isn't set too low for ths)