Moving my current board database to a new host

[eteune]

YaBB SE Version: 1.5.4
PHP Version: 4.1.1
MySQL Version: 4.0.x
Server Platform: Windows
Link to Forum:

Problem Description:
How can I move my current forum database to my new host?
I have access directly to everything on my current board, but for the new host I do not have direct access to the actual dabase files, only phpmyadmin interface.
thanks,

Ed

[Peter Duggan]

but for the new host I do not have direct access to the actual dabase files, only phpmyadmin interface.

Install the forum, which will create a new DB from the .sql file, select this with phpMyAdmin and import your dump through the SQL menu!

[eteune]

Right, thanks, but I've never done this before, so I'm not sure about a few things.
The dump just comes out in the browser so I just save it as an sql file?
Also, in the dump there are a few lines like:

Notice: Undefined variable: QUERY_STRING in D:\www\tbboard\QueryString.php on line 27

Do I just remove those and then just take the dump and name it *.sql and upload it via the sql tab in phpmyadmin?
thanks

[Peter Duggan]

What are you using to make the dump?

[eteune]

I'm using the Dump feature in YaBBSE

I am very close now, I keep manually editing pieces of it. I should probably have it successfully moved over today some time.

I saved the dump file as *.sql and am editing it in Textpad.

[eteune]

Look like I finally have it all moved over without a hitch at the new host  

Took some manual editing of dump sql file, but not too bad.

Thanks again for a great product, looking forward to the release of SMF!