www.si-community.com

Code: Select all

(following this https://www.phpbb.com/support/docs/en/3.2/ug/upgradeguide/upgrade3/)

==== software ====
	1. download WinSCP, set up the ftp connection using normal FTP file protocol, others didn't work for me
		(for transfering files, always use Transfer Settings -> Automatic)
	2. download http://phpminiadmin.sourceforge.net/ latest version to disk (it's 1 file only, e.g. copy to D:\forumbackup\phpminiadmin.php)
	
==== backup ====
	1. transfer the whole folder ftp://ftp.test.com/forum_root_dir/ to disk (e.g. to D:\forumbackup\old_forum_root\)	
	2. open D:\forumbackup\old_forum_root\config.php in a text editor and copy the db name/username/password settings from there into phpminiadmin.php, example:
		
		config.php:
			...
			$dbms = 'mysqli';
			$dbhost = 'localhost';
			$dbport = '';
			$dbname = 'db134883484-01';
			$dbuser = 'db134883484-adm';
			$dbpasswd = 'oeqq223QF';
			$table_prefix = 'phbadm_';
			$acm_type = 'file';
			$load_extensions = '';
			$email_function_name = 'mail';
			...
			
		======>
			
		phpminiadmin.php:
			...
			#DEFAULT db connection settings
			# --- WARNING! --- if you set defaults - it's recommended to set $ACCESS_PWD to protect your db!
			$DBDEF=array(
			'user'=>"db134883484-adm",#required
			'pwd'=>"oeqq223QF", #required
			'db'=>"db134883484-01",  #optional, default DB
			'host'=>"",#optional
			'port'=>"",#optional
			'chset'=>"utf8",#optional, default charset
			);
			$IS_COUNT
			...
			
	3. copy phpminiadmin.php to secret location on ftp (e.g. ftp://ftp.test.com/phpminiadmin12312.php) .. or set a password inside phpminiadmin.php
	4. visit www.test.com/phpminiadmin12312.php in browser check if forum DB can be accessed from there
	5. if not, check for possible errors when copying the info from config.php to phpminiadmin.php
	6. go to phpminiadmin's export tab, download the sql file to disk (e.g. (e.g. D:\forumbackup\old_db\XXXYYY.sql), gz sometimes doesn't work
	7. note: from the downloaded directory and the sql file, the forum could now be restored completely if something goes wrong!
	
==== cleanup original db ====== 
	1. log in the forum as admin, go to acp
	2. in board settings, set active style to prosilver
	3. in "styles" tab disable all styles except prosilver
	4. in "system" tab delete all language packs except "en"
	5. download https://www.phpbb.com/customise/db/official_tool/stk/
	6. copy the stk folder from the zip to ftp://ftp.test.com/forum_root_dir/stk
	7. back in acp, replace in the browser url .../adm/index.php?--- with .../stk/index.php?.... (this is because cookies might not work.....)
	8. in "support tools" tab, run database cleaner, click "continue" and "yes" to all questions
	9. stk suggests to do another backup, could be done but it's not necessary.
	
==== update db ==== 
	1. download/unzip phpBB latest version (3.2) to a new folder on the disk (e.g. D:\forumbackup\new_forum_root)
	2. delete directories "images", "files", "store" and the config.php file from that folder
	3. copy "images", "files", "store" and the config.php from your files backup to that folder (e.g. D:\forumbackup\old_forum_root\ into D:\forumbackup\new_forum_root)
	4. upload the whole folder to ftp://ftp.test.com/new_forum_root_dir/ 
	5. set permissions of the directories "cache", "files" and "images/avatars" to 777 (writable)
	6. visit www.test.com/new_forum_root_dir/install
	7. Click update, then update again
	8. Select "Update database only" and click Submit
	9. delete install directory
	10. delete phpminiadmin.php to be sure
	
=== final steps ===
	1. using ftp, rename the old forum_root_dir to "some_other_url"
	2. rename new_forum_root_dir to forum_root_dir
	3. delete the contents of "new_forum_root_dir/cache" dir EXCEPT index.html and .htaccess (if it's there)
	4. test if everything works, then delete some_other_url
	

Code: Select all

Current ACP (online) > Maintenance > Backup (Full / gzip / Download / Select all tables)

New ACP > Maintenance > Restore

Code: Select all

Current ACP (online) > Maintenance > Backup (Full / bzip2 {OR} text / Download / Select all tables)

New ACP > Maintenance > Restore