Hi there, my webspace will getting low in near future and so i have to move my wiki to another one. The files are not the problem, but the database is with 160 MB "huge" (about 1900 articles) (yeah, i know, the real wikipedia has a bit more ;)). Because, there was a few database changes in the mediawiki (and i start with the 1.3.x Version) just a simple question: What tables i dont have to move? This is my database for now:
archive 7,5 KB blobs 1,0 KB brokenlinks 66,0 KB categorylinks 522,8 KB cur 6,5 MB hitcounter 0 Bytes image 391,6 KB imagelinks 249,5 KB interwiki 21,9 KB ipblocks 4,1 KB links 875,3 KB linkscc 403,9 KB logging 438,3 KB math 1,0 KB objectcache 5,4 MB oldimage 15,6 KB page 839,4 KB pagelinks 2,5 MB querycache 1,0 KB recentchanges 634,8 KB revision 4,4 MB searchindex 18,4 MB site_stats 2,0 KB text 118,8 MB trackbacks 1,0 KB transcache 1,0 KB user 386,1 KB user_groups 3,2 KB user_newtalk 1,0 KB user_rights 8,8 KB validate 1,0 KB watchlist 168,3 KB
Whats with objectcache and cur? Can i just create the table without any content? Can i rebuild the searchindex on the new server, so that i dont have to move this through my little 128 Kbit upstream Line?
Do i have to regard other thing for the move?
Some technical informations, if needed: My old webspace is just webspace. No console login. My new Server is a Linux vServer, with root access.
Thanks for help!
Stefan aka Campino
Check the schema for 1.5 in maintenance/tables.sql of the new version to see which tables are used. You don't need to move the objectcache table. If you want, you can leave the *links tables behind and run the maintenance scripts to rebuild them on the other end.
Be sure to manually create tables you don't move and take a full backup, as always.
Rob Church
On 09/02/06, Campino campi@daocpedia.de wrote:
Hi there, my webspace will getting low in near future and so i have to move my wiki to another one. The files are not the problem, but the database is with 160 MB "huge" (about 1900 articles) (yeah, i know, the real wikipedia has a bit more ;)). Because, there was a few database changes in the mediawiki (and i start with the 1.3.x Version) just a simple question: What tables i dont have to move? This is my database for now:
archive 7,5 KB blobs 1,0 KB brokenlinks 66,0 KB categorylinks 522,8 KB cur 6,5 MB hitcounter 0 Bytes image 391,6 KB imagelinks 249,5 KB interwiki 21,9 KB ipblocks 4,1 KB links 875,3 KB linkscc 403,9 KB logging 438,3 KB math 1,0 KB objectcache 5,4 MB oldimage 15,6 KB page 839,4 KB pagelinks 2,5 MB querycache 1,0 KB recentchanges 634,8 KB revision 4,4 MB searchindex 18,4 MB site_stats 2,0 KB text 118,8 MB trackbacks 1,0 KB transcache 1,0 KB user 386,1 KB user_groups 3,2 KB user_newtalk 1,0 KB user_rights 8,8 KB validate 1,0 KB watchlist 168,3 KB
Whats with objectcache and cur? Can i just create the table without any content? Can i rebuild the searchindex on the new server, so that i dont have to move this through my little 128 Kbit upstream Line?
Do i have to regard other thing for the move?
Some technical informations, if needed: My old webspace is just webspace. No console login. My new Server is a Linux vServer, with root access.
Thanks for help!
Stefan aka Campino
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org