1
atisolution
Moving hosting

hi

I would like to move my hosting. Normally, cpanel to use struture <user name>_<database name> 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''<username>_<database_user_name>' );

    
// Database Password
    // Password for your database user account
    
define'XOOPS_DB_PASS''<your_password>' );

    
// Database Name
    // The name of database on the host. The installer will attempt to create the database if not exist
    
define'XOOPS_DB_NAME''<username>_<database 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 fromhttp://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

Who's Online

175 user(s) are online (74 user(s) are browsing Support Forums)


Members: 0


Guests: 175


more...

Donat-O-Meter

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

Latest GitHub Commits