XOOPS FAQ - Installation & Beginner's first steps - How do I backup and migrate my Xoops website?

Backup procedures:
(For hosted xoops sites)

When backing up a xoops site, you will need to get a backup of both the file structure (the xoops site and modules) as well as the MySQL database

FileStructure Backup
To backup the file structure, you need to download the complete xoops html folder with an FTP application.

Note:Some modules safe certain cache files in a hidden or locked mode, so the FTP application either does not see the file or can not download it. Make sure you test your backup and restore procedure at least once so you do not get surprises when you restore a real backup.

MYSQL Backup
You will need to have access to your MySQL database via the phpMyAdmin. Under the main "Welcome to phpMyAdmin" window, you will find the "export" function.
View dump (schema) of databases:
- Select the database you want to backup
- Select SQL
- Select your compression (zipped/gzipped/bzipped)
- Press "Go"
and your database will be downloaded via your web browser to your local computer

For more detailed backup/restore instructions of an MySQL database, I found a tutorial at: Wordpress Tutorial site

Restore to a different site:
You can upload your file structure to the new site with an FTP application. Note the path of the new server will be different than the previous site. You will have to know the physical path as well as the virtual path (URL)

 // XOOPS Physical Path 
    // Physical path to your main XOOPS directory WITHOUT trailing slash 
    define('XOOPS_ROOT_PATH', 'var/www/html/yourURL.com/yourxoopsfolder'); 
 
    // XOOPS Virtual Path (URL) 
    // Virtual path to your main XOOPS directory WITHOUT trailing slash 
    define('XOOPS_URL', 'http://www.yourURL.com/yourxoopsfolder');

Now you will have to edit your "mainfile.php" and change the path according to the new site URL and physical path.

Restore your SQL database
In the new site you will need to have access to your mySQL via the "PHPMyAdmin" application again.

Upload the database by opening the "Run SQL query" window. Select the "database backup" zip file and run the query. The database will be created on the new site.
Now you have to create the same MySQL database user as in the old site and give the correct access rights to the user.

That should be all.

The xoops site should run on the new site now.
(Please feel free to amend if not complete)

If you get an error like this:

Quote:

Error [Xoops]: Unable to connect to database in file class/database/databasefactory.php line 34

then you need to check your user name and password in your mainfile.php

3 Comment(s)

The comments are owned by the author. We aren't responsible for their content.

Author of this FAQ ??

carnuke Published 12/08/2004 22:02 Home away from home Joined 11/05/2003 Comments 1955

Will the author of this FAQ please contact me, so that I can register the FAQ in YOUR name, note mine. (oops )

Update URLs in the DB - easy!

davidthomas1 Published 06/19/2005 10:17 Quite a regular Joined 11/05/2004 Comments 384

If you need to update absolute / incorrect URLs, try this handy MySQL function:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

I ran it from PHPMyAdmin as SQL against a couple of tables and it worked like a charm

Moving from XOOPS to WordPress

miealex Published 01/21/2007 14:52 Updated 01/29/2007 16:45 Just popping in Joined 12/12/2004 Comments 96

For moving from XOOPS to Wordpress you can use this as a reference (I am using this solution as I'm typing and it works like a charm): http://www.cre8d-design.com/blog/2006/09/13/moving-from-xoops-to-wordpress/

Later edit: migration is over and you can see the result of this switch from XOOPS to WP at All ROmanian Crews - Graffiti Site

This doesn't mean XOOPS is not good !!! After all we relied on XOOPS CMS for 2 years. WP is just better now for our purpose.