| Posts: n/a |
moving vb to new server
A- Before Moving :
1- first of all Turn Off Forum
2-Uninstall all Hack/Plug-in (not disable) sometimes to disable plugin cause eval () error while upgrading
3- Move all styles to files system (except default style) as default clientscript/vbulletin_css (if it is absent create new one)
AdminCP > vBulletin Options > Style & Language Settings
4- move attachments to file system
AdminCP > Attachments > Attachment Storage Type
5- move members avatar to file system
AdminCP > Avatars > User Picture Storage Type
6- uninstall all other language (except deafult Language )
AdminCP > Languages & Phrases > Language Manager
7- Repair / Optimization
AdminCP > Maintenance > Repair / Optimize Tables (select all tables)
AdminCP > Maintenance > Repair / Optimize Tables > Fix Unique Indexes
8- run all commands in tools.php
9- Finally run following queries to repair dB
if you have no SSH account do above commands using phpmyadmin
consequently we had a very healthy and small dB to move
B- Dumping dB :
1- use following command to dump dB
if you want to zip db while dumping use following
- if you have no SSH accounts use AdminCP or phpmyadmin
B-1 moving db to new server from old server :
see here : vBulletin Manual
C- Restoring dB to new server :
1- if you have root access run following query to create new dB
otherwise run following query after create db
2- run following query to restore dB
3- Repair / Optimize Tables using phpmyadmin
4- you can start "upgrade"
Thats all
Good luck.........................
1- first of all Turn Off Forum
2-Uninstall all Hack/Plug-in (not disable) sometimes to disable plugin cause eval () error while upgrading
3- Move all styles to files system (except default style) as default clientscript/vbulletin_css (if it is absent create new one)
AdminCP > vBulletin Options > Style & Language Settings
Code:
Store CSS Stylesheets as Files? = Yes
AdminCP > Attachments > Attachment Storage Type
Code:
Attachment File Path = images/attach
AdminCP > Avatars > User Picture Storage Type
6- uninstall all other language (except deafult Language )
AdminCP > Languages & Phrases > Language Manager
7- Repair / Optimization
AdminCP > Maintenance > Repair / Optimize Tables (select all tables)
Code:
Optimize Tables = Yes Repair Tables = Yes
8- run all commands in tools.php
9- Finally run following queries to repair dB
Code:
myisamchk -r -u root -p db mysqlcheck -r -u root -p db
consequently we had a very healthy and small dB to move
B- Dumping dB :
1- use following command to dump dB
Code:
mysqldump -u root -p123 --default-character-set=latin1 forum > backup.sql
Code:
mysqldump -u root -p123 --default-character-set=latin1 forum | bzip2 -c > backup.sql
B-1 moving db to new server from old server :
see here : vBulletin Manual
C- Restoring dB to new server :
1- if you have root access run following query to create new dB
Code:
CREATE DATABASE `forum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Code:
ALTER DATABASE `forum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Code:
mysql -u root -p 123 -f forum < backup.sql
4- you can start "upgrade"
Thats all
Good luck.........................
Linear Mode
