What is...

[shumar]

What is easiest way to move whole forum from WAMP on local mashine to some hosting server ?
My forum was visible online via DYNDNS.

 

[shumar]

I get this message when I try to online import my DB(exported via backup DB in AdminCP):

 SQL query:

CREATE TABLE `access` (
`userid` int( 10 ) unsigned NOT NULL default '0',
`forumid` smallint( 5 ) unsigned NOT NULL default '0',
`accessmask` smallint( 5 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `userid` , `forumid` )
) ENGINE = InnoDB 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 6

How to change this and to what ??

 

[DON]

wth are u trying to convert to vb?

which board?

 

[shumar]

No, no.
I already have vb instaled on my local network, and was visible online thru dyndns.
Now I have real domain with hosting, and I need to transfer from my local network to server of hosting company. What is easiest way to do that ?

Thank you.

 

[.v0id]

you can dump the database through the command line or using phpmyadmin. Try to google it.

 

[shumar]

I found answer.
It was MySql 4.0 DB and I needed 5.0

Thank you.