XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / Moving a XOOPS site
Register
1
MSGDogs
Moving a XOOPS site

  • 2004/2/2 13:13

  • MSGDogs

  • Just popping in

  • Posts: 45

  • Since: 2003/8/8 1


Im about to change my webspace provider and would like to move all my webiste without having to start form scratch...is this possible to do and if so is there a tutorial/walkthrough for the process?
2
Mithrandir
Re: Moving a XOOPS site

Did you try searching the forums for an answer?

Yes, it is very possible. Just copy the files from your current webhost to the new one, change the mainfile.php to fit the new database, path and URL settings, set permissions for cache, upload and templates_c directories and mainfile.php.
Then all you need is a database interface to both the old and the new database to export all XOOPS tables (structure + data) from the old one and import them into the new database.

After that, you should be set to go.
3
Wilkinsa
Re: Moving a XOOPS site

  • 2004/2/2 14:01

  • Wilkinsa

  • Just popping in

  • Posts: 47

  • Since: 2003/4/13


Talk to your new host sometimes they have a way to move sites without going through all that. For example if your current web host has cpanel. And your next web host has cpanel there is a good possibility that they should be able to transfer it over for you with minimal if any problems. I should know I'm a web host who has XOOPS sites that I run

-Adam
4
MSGDogs
Re: Moving a XOOPS site

  • 2004/2/3 8:59

  • MSGDogs

  • Just popping in

  • Posts: 45

  • Since: 2003/8/8 1


Thanx for the info guys
5
MSGDogs
Re: Moving a XOOPS site

  • 2004/2/3 14:16

  • MSGDogs

  • Just popping in

  • Posts: 45

  • Since: 2003/8/8 1


Came across a problem when transfering the database....when the uplaod gets to the
DROP TABLE IF EXISTS xoops_msg_bb_posts_text;


i get this error
Error

SQL-query :  

CREATE TABLE xoops_msg_bb_posts_text(

post_id int( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
post_text text,
PRIMARY KEY ( post_id ) ,
KEY search( post_text ) 
) 

MySQL said: 


BLOB


any ideas as its driving me mental
6
m0nty
Re: Moving a XOOPS site

  • 2004/2/3 18:37

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


u may need to split your database dump file into smaller parts..

and upload each part in stages..
7
MSGDogs
Re: Moving a XOOPS site

  • 2004/2/3 20:57

  • MSGDogs

  • Just popping in

  • Posts: 45

  • Since: 2003/8/8 1


Thanx m0nty ...tried that but still the same message

Error

SQL-query :  

CREATE TABLE xoops_msg_bb_posts_text(

post_id int( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
post_text text,
PRIMARY KEY ( post_id ) ,
KEY search( post_text ) 
) 

MySQL said: 


BLOB column 'post_text' used in key specification without a key length
Back

Any more ideas guys
8
Dave_L
Re: Moving a XOOPS site

  • 2004/2/3 21:58

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


That's not the same message. The new one provides more details.

The problem is that key "search" either needs to be of type FULLTEXT, or else a length needs to be provided. I'm not sure why the info in the file you're restoring is incorrect, though.

What are the MySQL versions on your old server and new server?

What version of XOOPS are you using?

Is that table standard in Xoops? The prefix "xoops_msg_" seems unusual.
9
MSGDogs
Re: Moving a XOOPS site

  • 2004/2/4 16:13

  • MSGDogs

  • Just popping in

  • Posts: 45

  • Since: 2003/8/8 1


MySQL versions are the same on both servers

the table has msg in it as i have two XOOPS sites running on one database

on a standard install the table would be
xoops_bb_posts_text
10
davidl2
Re: Moving a XOOPS site

  • 2004/2/5 1:15

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


Thanks to this article - I think i've managed to move my own site to a new location.

Many thanks to all!
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

363 user(s) are online (289 user(s) are browsing Support Forums)

Members: 0

Guests: 363

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits