Restoring An 800meg .sql Backup?

[Prizm]

HI everyone. I've just purchased almost everything I can from IPB to convert and upgrade to IPB.

I'm upgrading from PHPBB, and am VERY glad we're doing it. We operate a pretty high traffic forum. The database back-up from PHPBB was ~800megs. Now I know restoring that through phpmyadmin is just something that will happen. The only reason I was going to restore it is because I wasn't 100% sure of the IPB converter. So what I was going to do, was backup a copy of the phpbb sql, restore it locally on my own webserver, and run the converter and see what happened.

Does anyone have any advice on such a situation? It's imperative that I lose no data. I'm having a similar issue with my gallery, we'll get to that another time I suppose, and probably best talked over with the photopost people on how to back up and restore into the IPB Gallery.

Thanks in advance to anyone who can offer some assistance :D

[bfarber]

I replied to this somewhere else. Company forums maybe?

[Prizm]

Yes you did. You answered with the command for sql in the command line. What is the best route to execute that both locally, and remotely once I need to restore this on a remote server?

[bfarber]

Well to export you change < to >

mysql -u (username) -p -D (database) > export.sql

Then to import

mysql -u (username) -p -D (database) < export.sql