Search options (Page 1 of 2)

How to get most recent posts through FTP method?

Or, should I always try to work from backups?

hot damn again!  The forum is "correlating" and being seen by the database. It's loaded up and functioning. Thought this was sooo esoteric, reallly had no idea this was so simple! : )  VERY COOL.

One small issue needing rectifying though:

When I moved (FTP'ed) forum files from one server to the other the old server blocked me from moving the cache folder stating it could not be "opened because the server says you do not have the required permissions." Same thing happened when I tried to download the files to my own computer.

So, I tried a workaround by creating a new, but empty, cache folder on the new server. Which, worked but.....the forum is not up to date with the latest posts.

How to get all of the posts onto the new server?

ok -- so, i should upload most recentt backup of the punbb forum from old server onto new server via FTP?

THEN, this backup I've FTP'ed will "correlate" with the recent mysql database dump i've successfully imported and the forum should be accessible as it was on old server?

(hoping yes)

I've edited config.php to connect to new server and uploaded it...but when I type in the address as

www.webaddress.com/hk/forum/config.php

nothing happens. This should load the config file and direct the database shouldn't it?
What am I doing wrong here?

THANKS.

HOT DAMN!!!    that's all i can really say.

I've been working on this for a LONG time. And, I just read for the first time   -----

"Import has been successfully finished."

unfortunately, i just don't know enough about how to do this kind of editing/changing of code yet. wish i could do it...but just don't know how. anyone know any good tutorials for mysql work like this? as always THANKS to everyone here who has tried to help me in this learning process.

most humbly, will

Looking more elbekko...I see that the code you provided has changed the collation from latin1_swedish_ci to utf8_unicode_ci on the 'bans' table.

But, that the remaining tables are still using latin1_swedish_ci.

Would you suggest changing this collation for/on all tables?
If so, how to? THANKS.

pasted it in the SQL tab in phpMyAdmin but got this:

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

MySQL said: Documentation
#1050 - Table 'bans' already exists

-----

Should I erase the 'bans' table first then paste this in?

Or change "CREATE TABLE" to "EDIT TABLE" ?

will

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

Reading some instructions online, it is stated that I should first create a database and then import the  exported database into it via unzipping. When I'm in phpmyadmin it asks for number of fields in order to create new database.

are these steps accurate? if so, how many fields? THANKS.

WILL

ok-- I've downloaded the mysqldump php file. I've uploaded this via FTP to old server and then run it. pulled up page w/MySQL connection parameters. Is this correct so far?