import old database to fresh install, or: goin' nuts. (Page 1 of 2)

I figured the problem was something like that, but was unsure exactly what.

I'll try again - during the install when punbb tells me that there are already forums in the database I want to  use, it won't let me proceed unless I specify another php prefix - so i should specify, install additional forums to the database, then change the prefix in the config to use the old db?

Sorry if I'm being dense.

Thanks a lot for the help.

you dont need to run the install file at all if you have the old database. just upload it via phpmyadmin and edit the config file to your database info.

Hello. I am working with a similar scenario and was hoping I could tag along on this?

Is there a step by step/FAQ posting somewhere which could assist and instruct me in how to go about going from one server to another, transferring the database via phpadmin?

IF not, is it correct that: I must first export the database from old server to my computer, then import those files from my computer to new server? And, that once the old database has been imported to the new server, the config.php file can then be changed according to the new server's info and populated database will be found on the new server?

I've been trying with phpadmin but keep getting the following errors: import.php: Missing parameter: import_type
import.php: Missing parameter:

I just don't know enough about all the programming side of things, and think I've just been going about it all wrong, probably. THANKS!

Will

willray: Do you have SSH access either with your old host or with your new host?

old server does use ssh. but new server does not for shared hosting, they only allow virtual dedicated and dedicated.

the error exactly, is as follows:

import.php: Missing parameter: import_type (FAQ 2.8)
import.php: Missing parameter: what (FAQ 2.8)

mysqldump generates an SQL dump of the database (it's a binary that comes with MySQL, not a PHP file). Download the database dump from the old server and upload it to the new server

Use phpMyAdmin, yeah

A database doesn't have fields: a table does. Make sure you're creating a database, not a table within an existing database.

I suck so bad. Keep getting this error:

Error

SQL query:

CREATE TABLE `bans` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`username` varchar( 200 ) default NULL ,
`ip` varchar( 255 ) default NULL ,
`email` varchar( 50 ) default NULL ,
`message` varchar( 255 ) default NULL ,
`expire` int( 10 ) unsigned default NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL said: Documentation
#1064 - 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 'DEFAULT CHARSET=latin1' at line 9

Thanks!

Hate to admit this but I'm so inexperienced (but wanting/willing to learn) in all this that I don't even know how to use this code ---- For instance, how do I go about putting this where it needs to go? How to change this SQL syntax? Much appreciation for all the help.