11
sharifa
Re: Testing Offline
  • 2006/4/18 1:26

  • sharifa

  • Just popping in

  • Posts: 36

  • Since: 2006/4/15


So within the mainfile.php do I change the directoy to

localhost/htdocs

Think I need a step by step guide for this bit and an example, would make it alot easier to understand thanks ;)

12
snow77
Re: Testing Offline
  • 2006/4/18 1:56

  • snow77

  • Just can't stay away

  • Posts: 864

  • Since: 2003/7/23


the mainfile.php found in your XOOPS files in your localhost server has to have the following lines according to the settings of your local webserver:


LINES 31-39, configure physical path and virtual path,
Ex. physical path: C:/xampplite/htdocs/xoops
Ex. virtual path:http://localhost/xoops
Quote:

// XOOPS Physical Path
// Physical path to your main XOOPS directory WITHOUT trailing slash
// Example: define('XOOPS_ROOT_PATH', 'C:/xampplite/htdocs/xoops');
define('XOOPS_ROOT_PATH', 'C:/xampplite/htdocs/xoops');

// XOOPS Virtual Path (URL)
// Virtual path to your main XOOPS directory WITHOUT trailing slash
// Example: define('XOOPS_URL', 'http://localhost/xoops');
define('XOOPS_URL', 'http://localhost/xoops');


LINES 62-84, configure database details here:
Quote:

// Database
// Choose the database to be used
define('XOOPS_DB_TYPE', 'mysql');

// 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', 'root');

// 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', 'mydatabasenamehere');



upload the back up of your database to your localhost in phpmyadmin.
www.polymorphee.com
www.xoopsdesign.com

13
sharifa
Re: Testing Offline
  • 2006/4/18 2:06

  • sharifa

  • Just popping in

  • Posts: 36

  • Since: 2006/4/15


Quote:

snow77 wrote:

upload the back up of your database to your localhost in phpmyadmin.


Think I understood that apart from that bit.

Now I get this error:




This page cannot be displayed due to an internal error.

If you are the administrator of this site, please visit the XOOPS Troubleshooting Page for assistance.

Error [Xoops]: Unable to connect to database in file C:\Program Files\xampp\htdocs\testing\class\database\databasefactory.php line 34

14
Bassman
Re: Testing Offline
  • 2006/4/18 5:53

  • Bassman

  • Friend of XOOPS

  • Posts: 1272

  • Since: 2003/5/23


Make sure the details of the new database you created match those in your mainfile.php. Also make sure you added the user to the database in phpMyAdmin.

BTW I have just found Webserver On A Stickwhich should be ideal for a portable XOOPS installation :) I haven't tried it with XOOPS yet though.

15
sharifa
Re: Testing Offline
  • 2006/4/18 7:24

  • sharifa

  • Just popping in

  • Posts: 36

  • Since: 2006/4/15


Where is phpMyAdmin, I can't find it anywhere.

16
Bassman
Re: Testing Offline
  • 2006/4/18 9:37

  • Bassman

  • Friend of XOOPS

  • Posts: 1272

  • Since: 2003/5/23


If you can't find PHPMyAdmin, how did you upload the database backup?

17
sharifa
Re: Testing Offline
  • 2006/4/18 16:11

  • sharifa

  • Just popping in

  • Posts: 36

  • Since: 2006/4/15


Quote:

Bassman wrote:
If you can't find PHPMyAdmin, how did you upload the database backup?


What? I never uploaded any database back up.

This is how it went.

I installed XOOPS on www.lifensoulonline.co.uk/testing

Once that had installed and I'd fiddled with it for a bit, I downloaded the whole Testing directory to my PC.

Thats it, thats all I've done. Thats why I don't have a clue where PHPMyAdmin is or what it even is :)

18
sharifa
Re: Testing Offline
  • 2006/4/18 20:01

  • sharifa

  • Just popping in

  • Posts: 36

  • Since: 2006/4/15


I found phpMyAdmin :) Finally.

No one mentioned it would be on my server as possibly part of my hosting package.

My hosting use CPanel so I installed Xoop that way, maybe thats why I've never noticed phpMyAdmin before as I've never used it.

19
sharifa
Re: Testing Offline
  • 2006/4/18 20:35

  • sharifa

  • Just popping in

  • Posts: 36

  • Since: 2006/4/15


OK, so I can see the databases, but how to I make a backup of them onto my PC?

EDIT

Never mind found the backup option.

20
sharifa
Re: Testing Offline
  • 2006/4/18 23:05

  • sharifa

  • Just popping in

  • Posts: 36

  • Since: 2006/4/15


Back again :) gonna keep bugging you till I get it working.

So I found phpMyAdmin but now what? I've just installed XOOPS on my other host 'cause it has no other databases.

So I went to back up the database and CPanel X on my .com domain seems to not include phpMyAdmin.

The database file I named in the setup as stevenw_xoop1

When I go to backup in CPanel X the only database I can see is this

Download a MySQL Database Backup

xoop1

So when I attempt to, it downloads it as a xoop1.gz

Now what? This is so confussing my head is gonna burst.

Help me Obi Won, your my only hope! ;)

:(

I'm totally confussed.

EDIT-Bare in mind I'm a noob at this and haven't a clue where to save all the files or what files to edit.

Login

Who's Online

161 user(s) are online (111 user(s) are browsing Support Forums)


Members: 0


Guests: 161


more...

Donat-O-Meter

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

Latest GitHub Commits