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 hosting
Register
1
atisolution
Moving hosting

hi

I would like to move my hosting. Normally, cpanel to use struture _ as ati_xoopsdata.

In new hosting, my user is: erpvncom, so that my database is named erpvncom_xoopsdata.

So, database name is changed - how to configure in Xoops?

Thanks in advance
2
young
Re: Moving hosting

  • 2008/10/30 4:05

  • young

  • Just popping in

  • Posts: 99

  • Since: 2006/1/16


you can configure it from "mailfile.php" and look for the line:

// Table Prefix
    // This prefix will be added to all new tables created to avoid name conflict in the database. If you are unsure, just use the default "xoops".
    define( 'XOOPS_DB_PREFIX', 'xoops' );

    // Database Hostname
    // Hostname of the database server. If you are unsure, "localhost" works in most cases.
    define( 'XOOPS_DB_HOST', 'localhost' );

    // Database Username
    // Your database user account on the host
    define( 'XOOPS_DB_USER', '_' );

    // Database Password
    // Password for your database user account
    define( 'XOOPS_DB_PASS', '' );

    // Database Name
    // The name of database on the host. The installer will attempt to create the database if not exist
    define( 'XOOPS_DB_NAME', '_' );
3
Anonymous
Re: Moving hosting

  • 2008/10/30 9:55

  • Anonymous

  • Posts: 0

  • Since:


Yep.... just alter the settings/details in mainfile.php

Remember to note those folders which should be CHMOD 777 and you'll be fine
4
ghia
Re: Moving hosting

  • 2008/10/30 10:42

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


and eventually to empty the cache and the records in the sessionstable.
5
sailjapan
Re: Moving hosting

how do you do that, ghia?
Never let a man who does not believe something can be done, talk to a man that is doing it.
6
Anonymous
Re: Moving hosting

  • 2008/10/30 12:54

  • Anonymous

  • Posts: 0

  • Since:


Easiest way is to install the xoopscare module from http://xoops.instant-zero.com/ - this will do it for you automatically for time to time. It will also do lots of other things to keep your site and database all tickety-boo

Highly recommended
7
atisolution
Re: Moving hosting

hi,

thanks for your information. I just moved my host already.

I have a lot of query error in my site. Here is some of:

- SELECT * FROM xoops_modules WHERE dirname = 'news'
- SELECT * FROM xoops_modules WHERE dirname = 'mydownloads'
- SELECT * FROM xoops_modules WHERE dirname = 'newbb'
- SELECT * FROM xoops_modules WHERE dirname = 'smartfaq'

I sure that I have /modules/news, modules/mydowloads, modules/newbb, modules/smartfaq - but I also got error

Could you help me to correct it?
8
ghia
Re: Moving hosting

  • 2008/11/3 11:20

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Quote:
- SELECT * FROM xoops_modules WHERE dirname = 'news'
- SELECT * FROM xoops_modules WHERE dirname = 'mydownloads'
- SELECT * FROM xoops_modules WHERE dirname = 'newbb'
- SELECT * FROM xoops_modules WHERE dirname = 'smartfaq'
These are not errors, but a list of SQL requests made to the database.
Errors are listed before.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

436 user(s) are online (313 user(s) are browsing Support Forums)

Members: 0

Guests: 436

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