moving SMF to other server

[oostcoast]

SMF Version: SMF 1.1.1
I found an other free webserver without adds or banner ( a am now on hxxp:funpic.de [nonactive]), were i want to move my forum (including TP) to (110mb.com)
What is the best way to do that, i want to use the database of the new server.
i thought, i download my entire forum and upload it to my new and ( dont know how move my database to the new one)
can anyone give my some suport?? 

[IchBin™]

You need to make sure you backup your database so you can import it to your new server. After you are done backing up your database from the forum maintenance section you'll need to restore the database.
Restoring a Database

One thing you'll have to do is run repair_settings.php to fix the paths in your forum settings.
What is repair_settings.php?

The order of the process should be similar to this:
1. Backup files and database.
2. Copy files to new host.
3. Restore database to the new host.
4. Run repair_settings.php

[oostcoast]

if I import the SQL data it gives a error

Code Select Expand

Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; CREATE TABLE `smf_ads` ( ADS_ID mediumint(8) unsigned NOT NULL auto_incr' at line 13 my sql file is locates hxxp:jptforum.110mb.com/dump.sql [nonactive] the server uses phpminiadmin or something like that (it is REALLY "simple" and.. it SUCKs (no help, no menu) if I install phpmyadmin, the admins will bann me ( WHY??? phpmyadmin is the BEST)

can I aslo connect to my "good old" funpic database ( on hxxp:oostcoast.oo.funpic.de [nonactive]) what adress can I use then?  

[IchBin™]

Sorry, I don't have much info on the phpminiadmin. You're best bet would be to look on the web for some help on it. Not sure about the SQL error you're getting either, but since its coming from the the ad management mod I'd ask the mod author if thye have any info on it.

As for pointing to your old mysql, your host would have to give you that permission and info, especially if its on another server.

[oostcoast]

I fixed the error 
the phpminiadmin cant handle multyple queries so I used bigdump ( an batabase dump script) to insert all my data.

[redone]

Import your database using Bigdump

Follow the instructions provided and you should be all set. Sometimes importing using phpmyadmin can present the odd problem or two.

[reyes]

İt dosnt work...