PDA

View Full Version : Run your vBulletin on your PC


Deaths
07 Apr 2005, 14:43
I know there is a guide like this out already, and it's created by TECK.
However, his guide is outdated, and the download links are no longer valid.

So, I though I'd tell you how I did it :)

Please do NOT distribute this guide outside of vBulletin.org! If you wish to put it on your site, contact me by PM!
Here are a couple of simple steps on how to run your vB on your PC:

Installing Apache, PHP, MySQL, phpMyAdmin, etc...

Download the newest version of PHPTriad (http://sourceforge.net/project/showfiles.php?group_id=9325&package_id=9390).
This is a very easy to use all-in-one pack.
Run the .exe, and let the installer do the job for you.
Now go to C:\apache\mysql\bin\, and run winmysqladmin.
If, and it probably will, it asks you for a password, enter root as password, and password as password.
Goto your start menu > PHPtriad > Apache Console > Stop Apache
Now go to start menu > PHPtriad > Apache Console > Start Apache
Note: Do NOT select "Restart Apache".
Now, Apache will pop up in a new window.
Simply minimize it.
Do NOT close it!
Now, open up c:\apache\htdocs\phpmyadmin\config.inc.php.
Find: $cfgServers[1]['password'] = '';
Between the '' tags, enter "password" WITHOUT the quotes
Save & Close

Now, your "webpage" is available at http://localhost!


Ok, nowthat we've installed and configured everything, we can start with the actuall vBulletin install!

Installing your vBulletin

Look at your task menu, and right click the traffic light icon.
Click "Show me"
Now, go to the databases tab.
Right click on the "Test" database
Click "Create Database".
In the window which just opened, enter the exact name which you gave to your online database. (If you're installing a new vBulletin forum on your local PC, you may call it anything you want. Do remember what you call it though).
Click "Create the Database" once you've entered a name.
Click "OK" on the error box which just poped up.
Now, press cancel, and it should bring you back to the databases tab.
Now, you have 2 options.
Follow these steps if you want to install a NEW vBULLETIN, if not, simply scroll down.

Download a new vBulletin copy from the members area.
Extract it to: c:\apache\htdocs\forum
Open up c:\apache\htdocs\forum\includes\config.php.
Set the the servername to "localhost" (without quotes)
Set NO dbusername and NO dbuserpassword!
Set the database name to the name of the database you created a couple of steps above.
Now install vBulletin, and follow vBulletin's steps.

Follow these steps if you want to install your online vBulletin Board on your PC.

Download your vBulletin files from your FTP
Download you Database from your host.
Rename your database file to vbulletin.sql
Go to http://localhost/phpmyadmin
Go to the database you created a couple of steps ago.
Click the "import" tab.
Find this text: "Or Location of the textfile :" (without quotes)
Bellow it, there should be a "browse" button.
Click it.
Browse to your vbulletin.sql file, and select it
Now, click the "Go" button. ONLY CLICK THIS ONCE
Get yourself a cup of coffee, because this might take a while.
When its done, it will most likely say "No tables found". Just ignore that.


Go to http://localhost/forum/admincp
Log in
If you can NOT log in, follow these steps.

Go to http://localhost/phpmyadmin, and open your database.
Open up the table "datastore" (BROWSE it)

Open up "options" (inside the database)
Find (where XXXX is your cookie domain you set when your board was online.


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


REMOVE the cookiedomain text. sothat it will look like this:

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


Go back to your database.
Now browse the SETTING table.
Find the "cookiedomain" field.
Edit it, and empty the "value" box.

Thats it! You're done!


IF IT SAYS THE DATABASE IS EMPTY, JUST IGNORE THAT! FOLLOW THE REST OF THE STEPS, AND YOU WILL SEE IT WORKS!
You can now start playing around with your offline vBulletin copy, without having to worry about your members :)

Hiro
07 Apr 2005, 22:31
Wow, Awesome dude!

I will be sure to use this ;)

deathemperor
08 Apr 2005, 02:11
Deaths have you checked for an exist guide ?

http://www.vbulletin.org/forum/showthread.php?t=39482

more details, better for newbie

Deaths
08 Apr 2005, 07:37
I know there is a guide like this out already,

Read the post ;).

It's not better for newbies at this stage, because 1 of his links is outdated (how is a newbie going to get the right file?), the MySQL is still a 3.x version (some hacks will cause major problems), and this Apache installation is WAY easier, as its just an installed, no zipping to directories, etc...

:nervous:

Wow, Awesome dude!

I will be sure to use this ;)
Glad you like it :)

deathemperor
08 Apr 2005, 11:34
I use AppServ which offer one file installation and you need to edit nothing to have a local server.

Deaths
08 Apr 2005, 14:28
I never used it, so I can't make a howto on something I never used. (AppServe, that is)

KW802
08 Apr 2005, 15:00
I use AppServ which offer one file installation and you need to edit nothing to have a local server.Your typical "newbie"' wouldn't know anything about AppServ or even SourceForge.

tnguy3n
08 Apr 2005, 15:29
Nice tutorial. it may be very helpful to newbies.

I run IIS + php/mysql/activeperl on my window. It's been working all good so far. One nice thing about IIS is that it allows me to test ASP scripts on my localhost too. :)

Deaths
08 Apr 2005, 15:34
Thanks :).

This wasnt created for a TOTAL newbie, because a total newb wouldn't see any use in this anyway...

mholtum
08 Apr 2005, 16:34
went great but there is no "test" db.

deathemperor
08 Apr 2005, 19:10
Your typical "newbie"' wouldn't know anything about AppServ or even SourceForge.

What I meant was: instead of telling them to edit this and that you can tell them just run a file(click next next and next..) and then http://localhost , isn't it better for newbie ? The only thing you need to guide for that 'newbie' is the link to download that file.

AlexUK
08 Apr 2005, 20:18
# Click the "import" tab.
# Select "browse" near "upload file"

I installed everything ok.
Now I am in phpmyadmin but I dont see the fields above.
There is a run sql queries area only.
Any ideas?

KW802
08 Apr 2005, 21:53
What I meant was: instead of telling them to edit this and that you can tell them just run a file(click next next and next..) and then http://localhost (http://localhost/) , isn't it better for newbie ? The only thing you need to guide for that 'newbie' is the link to download that file.... but then you end up having to tell the 'newbie' where to find AppServ, how to install that, what the need to know about it, and then they can 'click next next next'. Somewhere in the chain the person needs to be flat out told what directions to take: Adding another layer to it like AppServ just strays from the KISS method.

N8
09 Apr 2005, 00:01
edit, nvm :)

SirAdrian
09 Apr 2005, 02:35
Awesome Deaths, even though there is already another one, it's nice to check 2 sources. Things like this also take a lot of work, so thanks!

Quick question: will this work from the internet, via http://ipaddress/ ?

tnguy3n
09 Apr 2005, 04:35
Awesome Deaths, even though there is already another one, it's nice to check 2 sources. Things like this also take a lot of work, so thanks!

Quick question: will this work from the internet, via http://ipaddress/ ?
If your ISP allows you to run server on their network, ppl can access to website on your home machine.

Deaths
09 Apr 2005, 08:45
# Click the "import" tab.
# Select "browse" near "upload file"

I installed everything ok.
Now I am in phpmyadmin but I dont see the fields above.
There is a run sql queries area only.
Any ideas?
Yes, below that big textbox there is a little text saying:
"Or Location of the textfile :"
Press "browse", the press "go".

Awesome Deaths, even though there is already another one, it's nice to check 2 sources. Things like this also take a lot of work, so thanks!

Quick question: will this work from the internet, via http://ipaddress/ ?
Depends on your ISP.
Your firewall will probably block it though, if you have a good router.

You can access it from your local network VIA the IP, just go to WinMySQLadmin, and there it says your local IP.

EDIT:
Updated the guide, gone into a little more detail for the importing of your old DB.

Also fixed a little typo, it wasnt an "Upload" button, but a "Go" button ;)

TyleR
09 Apr 2005, 09:04
Wow, i never knew i could do this ^_^

Works like a charm..will definately be using this for testing mods i make for my forum ~_^

Deaths
09 Apr 2005, 09:06
Hehe, glad it worked :).

There should be some kind of install button for hints & tips :/

AlexUK
09 Apr 2005, 10:39
I am loading my vbulletin.sql file which is 9mb size but I am waiting for so long and nothing happens, I mean almost an hour now.
is this normal?

Deaths
09 Apr 2005, 12:08
That is indeed long, too long.

What OS are you using?

AlexUK
09 Apr 2005, 12:44
windows xp pro

Marco van Herwaarden
09 Apr 2005, 12:55
Depending on your hardware, this could be normal then yes.

Deaths
09 Apr 2005, 12:57
Just turn it on when you go to sleep, and in the morning its done ;)

AlexUK
09 Apr 2005, 12:59
I actually got a message saying that the document had no information/was empty.
I tried to load this several times yesterday and today and no luck.
Shame.

Deaths
09 Apr 2005, 13:21
If you read through the guide, you will notice it says that it is NORMAL that it says that ;).

When its done, it will most likely say "No tables found". Just ignore it.

AlexUK
09 Apr 2005, 13:39
No thats not what it meant.
My database is still empty.
It not working at all.

Deaths
09 Apr 2005, 19:17
It looks like its emtpy, but actually its not.

Just follow the steps, and you'll see it works.

YLP1
09 Apr 2005, 19:44
Newbie here... I am stuck...everything worked up until the time to click on test database...nothing there..I then right clicked to create a database and it dialog box says that the server must be connected.

Help?!?!?! ;)

TyleR
09 Apr 2005, 20:05
@AlexUK: split the db file into like 3 .sql files, and run them in precise order so that you wont recieve any mysql errors.

@YLP1: Did you go to: Start->PHPTriad->Apache Console->Stop Apache then clicking Start->PHPTriad->Apache Console->Start Apache (and keep the MS-DOS 'looking' prompt the whole time!..don't X out, you CAN minimize it.) before right clicking on the icon in the bottom right of your desktop ?

lasto
09 Apr 2005, 20:10
I am loading my vbulletin.sql file which is 9mb size but I am waiting for so long and nothing happens, I mean almost an hour now.
is this normal?
9 meg on your computer should be done in about 10 mins.

Also when looking to the left for tables they may not show so log out and back in - solves the problem all the time.

Use a program called Mysqfront to create databases local - is well easy program to use.

Deaths
10 Apr 2005, 09:40
It is normal for it to say it is empty, it's some kind of bug in phpMyAdmin.
Just continue the steps, and you'll see it'll work.

The Realist
10 Apr 2005, 12:12
Out of curiosity, what if you want to run your forum from home and do the above and setup a forwarding URL by using dyndns.org.

How would you set this up so it connects to an outside port?

Laters

Deaths
10 Apr 2005, 14:19
I wouldn't know...

Maybe someone else knows, but I'm not good with stuff like that.

tnguy3n
10 Apr 2005, 22:40
9 meg on your computer should be done in about 10 mins.

Also when looking to the left for tables they may not show so log out and back in - solves the problem all the time.

Use a program called Mysqfront to create databases local - is well easy program to use.
9 MB is a little too big for phpMyAdmin to handle, maybe you should copy & paste.

Rickie3
25 May 2005, 07:13
can somebody please advise,ive installed everything and all is working the only thing i am having trouble with is installing vbulletin.ive just downloaded vb 3.0.7 unzipped it to my documents,then i cut and pasted the upload folder to C:\apache\htdocs then i renamed the upload folder to forum,i then went into the forums folder and opened the includes folder,then renamed config.php.new to config.php and i also done the edits in your instructions and saved,to do the install i typed http:/localhost/forum/install/install.php,and this is what it comes up with:::::
Please make sure you have entered the values in to config.php.new and renamed the file to config.php.

i have been at this for a while now and have checked and re checked everything what am i doing wrong,i also noticed when i highlight my mouse over the config.php file it saying type NEW file and config.php under it,any help or advise appreciated,i really want to get this working great for testing some of the hacks/and codes

Deaths
25 May 2005, 11:06
You will need to add the database information to config.php.

Marco van Herwaarden
25 May 2005, 19:24
If you have a MySQL version 4.1 or higher then you will probable need your MySQL server to allow Old Passwords.

Rickie3
26 May 2005, 04:04
ok now when i type in
http:/localhost/forum/install/install.php it just goes to a blank page,any ideas???

Marco van Herwaarden
26 May 2005, 06:24
Check the page source and post here.

Rickie3
26 May 2005, 06:47
hi thanx for your time,i right clicked mouse view source and this it what it said
<p></p>

i ran the vb_test.php that loaded up fine mysql test page
then i ran the phpinfo,and that brought up the php page with settings,so i take the local server is working ok

Marco van Herwaarden
26 May 2005, 07:01
Try upload your files again. Make sure you keep the original directory structure and that all non-image files are uploaded in ASCII format.

Rickie3
26 May 2005, 07:14
ahh i think thats where i might be making the mistake,i am unzipping the vb files to my documents,then i am cutting and pasting the upload folder to apache/htdocs,is this the wrong way to do it?if so what is the right way to go about it??thankyou for your help so far

update i did a format and fresh install on my laptop,all is working great,very happy yee haa @MarcoH64 thankyou so much for your support,and a special thanks to deaths

Marco van Herwaarden
26 May 2005, 10:13
Nice to see you solved things :D

pelukis
18 Jun 2005, 02:31
wow........great way to test stuff...thanks deaths

Barakat
18 Jun 2005, 09:46
how can i access it ?

Error
MySQL said:


Access denied for user: 'root@localhost' (Using password: YES)

Marco van Herwaarden
18 Jun 2005, 22:42
What MySQL version you are using?

hIBEES
05 Aug 2005, 17:54
I've followed all the instructions (I think)

When i goto "create database" it says "The server must be connected" :nervous: :nervous:

I reinstalled, got it now :squareeyed:

arghHHHHHHH now get:


Welcome to phpMyAdmin 2.2.3

Error

MySQL said:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Marco van Herwaarden
05 Aug 2005, 19:53
Set your mysql server to allow "old passwords"

hIBEES
05 Aug 2005, 21:32
Set your mysql server to allow "old passwords"

where do I do that ? sorry a bit new to mysql and php,i'm getting there thou,i'll take a look about

thanks

Revan
06 Aug 2005, 00:46
I've followed all the instructions (I think)

When i goto "create database" it says "The server must be connected" :nervous: :nervous:

I reinstalled, got it now :squareeyed:

arghHHHHHHH now get:


Welcome to phpMyAdmin 2.2.3

Error

MySQL said:

Client does not support authentication protocol requested by server; consider upgrading MySQL client1. You are running an outdated version of phpMyAdmin. I suggest you upgrade to the latest version (2.3.1-pl1 last I checked).
2. To fix that error, go to mysql.com and download MySQL Administrator.
From that program, you can login to the root account WITHOUT a password, then edit the root account and set a password. Editing accounts in MySQL Administrator is pretty easy, you'll find it. Then close the program, reopening it and this time use the password you just set to login to the root account again. If this succeeds, you can now run vBulletin.

clearchannel
25 Sep 2005, 12:09
Can someone tell me what version of Apache, PHP and MySql this program uses? I could not find it on the site.

Marco van Herwaarden
25 Sep 2005, 12:23
Which program?

Feckie (Roger)
25 Sep 2005, 13:40
I Use Appserv

AppServ 2.5.4a Packages
Apache 2.0.54
MySQL 4.1.12a
PHP 5.0.4
phpMyAdmin-2.6.2pl1
MyODBC-3.51.11-2




AddOns for AppServ


appserv-AddOns-drupal-4.6.1.exe Web Blog script.
appserv-AddOns-gallery-1.5.exe Gallery on Web just cool !!!
appserv-AddOns-Mambo-4.5.2.2.exe Mambo Mambo Mambo.
appserv-AddOns-Moodle-1.5.exe Moodle E-Learning System.
appserv-AddOns-phpBB-2.0.15.exe Hot Hit with phpBB.
appserv-AddOns-PHP-Nuke-7.7.exe For Nuker !!
appserv-AddOns-Torrent-Tracker-200505051951.exe Torrent Tracker.
appserv-AddOns-WordPress-1.5.1.2.exe Web Blog.
appserv-AddOns-ZendOptimizer-2.5.10.exe Zend Optimizer 2.5.10 AddOns for AppServ Only !!

(Here (http://www.appservnetwork.com/))

peterska2
19 Nov 2005, 00:17
I've just done this and if I got to localhost/phpmyadmin I get the following error


Error

MySQL said:

Can't connect to MySQL server on 'localhost' (10061)


I didn't get asked to set the username and password either.

I'm running Win2k, if that helps.

apfparadise
16 Dec 2005, 04:58
I have a pretty basic question on this. I installed the package from the original post. It says to download the VB package, change the config.php file, and then install VB. But the only way to install VB is to run the install.php file, right? But it does not recognize php as a runnable format. Isn't that what it was supposed to do? I am trying to do a brand new install of 3.5, add all the hacks (new versions, including the skin) of my current online site, and then migrate over using the database.

Is that even possible?

zendiver
26 Dec 2005, 16:35
Just a quick question. Do you have to have your websites located in the htdocs folder OR is there a way to install the package on a different drive? Reason I ask, is I don't really want my site on my C: drive just in case it crashes and I have to reinstall the OS.

Thanks Death. I have tried doing this several times and have never got it to work individulally on my home pc.

zendiver
30 Dec 2005, 02:15
I guess this thread is dead anymore. what a shame.

Marco van Herwaarden
30 Dec 2005, 05:45
Just set the Webroot for your webserver to a different location. What webserver are you using?

zendiver
30 Dec 2005, 15:03
Marco,

I am using the following:
AppServ 2.5.4
- Apache 2.0.54
- MySQL 5.0.15
- PHP 5.0.4
- phpMyAdmin-2.6.2-pl1

I have finally got everything working with the exception of PhotoPost. The Features and Randoms seem to be working fine on the main interface of the forums, but when I click on the Gallery menu choice, I get the following errors:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

Marco van Herwaarden
30 Dec 2005, 15:22
Sorry no experience with PhotoPost, i suggest you ask on their support site.

Daniel
02 Jan 2006, 22:23
/me needs for OS X :(

*hint hint*

Lpspider
20 Jan 2006, 22:51
Okay, I have some problems installing it...

I think I got almost everything down. However, when I go to install the VB - connecting to install/install.php, I don't get the expected vb page with the steps to continue, but rather see the entire code of the page.

What's up? How can I work around this?

Help is greatly appreciated.

peterska2
20 Jan 2006, 22:52
it sounds like your files are not in the right format. Try again with a fresh set of files extracted from your zip file.

Lpspider
20 Jan 2006, 23:30
it sounds like your files are not in the right format. Try again with a fresh set of files extracted from your zip file.

Nope. Just tried that and it had no further effect. Still just seeing the code when viewing it in IE. :/

peterska2
20 Jan 2006, 23:36
Have you got php installed on your PC? It's the only other possibility I can think of.

bada_bing
21 Jan 2006, 03:50
Nice thread I will try to so this, as it would be nice to have a running copy on my home PC

Lpspider
21 Jan 2006, 16:39
Have you got php installed on your PC? It's the only other possibility I can think of.

Umm... I was under the impression that running phptriad would install php. Is that not the case?

Installing Apache, PHP, MySQL, phpMyAdmin, etc...

Marco van Herwaarden
21 Jan 2006, 19:28
Sorry can't help too much with this, never run these combined products myself. Always install them seperate (and that is dead easy), so i can also update them independant or even run mulitple versions.

stinger2
21 Jan 2006, 21:24
i installed the triad....but when i get to the point of creating a new database.......it rather says ......database created instead of the error the author mentionedso.......when i want to import the database ...there is no such option in THIS phpmyadmin.....in my online phpmyadmin i can see that option

another question
where should i place the forum file? should it be in C?

thanks in advance

TheMusicMan
21 Jan 2006, 21:58
I installed this many months ago with success and it has performed superbly for me - thanks for the instructions. I do have one qn though...

My localhost resides on my C: drive which is only a small laptop drive and is quite full. I have an additional drive in my Dell laptop and am wondering if there is a way to change localhost to read an alternate drive?

Is this poss? cheers.

Lpspider
12 Feb 2006, 17:15
Okay, turns out I was using the wrong url to access it. So I go to http://localhost/forum/install/install.php and it asks for my member code/number/whatever. I enter it but the page just refreshes. What's up with that? Any ideas? I'm eager for a fix.

Marco van Herwaarden
12 Feb 2006, 17:57
I guess you entered the wrong Customernumber

Lpspider
12 Feb 2006, 19:32
I guess you entered the wrong Customernumber

Wow. I feel really stupid.

On step three I get this error:


Attempting to attach to database

Error description: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) c:\apache\htdocs\forum\includes\class_core.php on line 279

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.

simon.
13 Feb 2006, 11:01
This is really useful! Thanks!

Lpspider
14 Feb 2006, 01:04
This issue I have I believe has something to do with username/password. I don't think I created one (for the database) though.

bada_bing
15 Mar 2006, 15:51
How can I use a current backup of my running production database and my production site locally? I would like to simulate my production site on my local PC so that I can test my mods and hacks first.

TheMusicMan
15 Mar 2006, 16:45
How can I use a current backup of my running production database and my production site locally? I would like to simulate my production site on my local PC so that I can test my mods and hacks first.Install this http://www.vbulletin.org/forum/showthread.php?t=79539

Works a treat.

bada_bing
15 Mar 2006, 17:38
Install this http://www.vbulletin.org/forum/showthread.php?t=79539

Works a treat.
Why are you posting a link to this same thread??

TheMusicMan
15 Mar 2006, 18:46
Haha... I didnt realise sorry... but it is what you asked for no?

bada_bing
15 Mar 2006, 18:55
Haha... I didnt realise sorry... but it is what you asked for no?
Yes and no.. I understand that doing these steps will allow me to run a local vopy of vb on my local PC but How do I import a copy of my production database and entire site to run locally for testing was my question rather then running a new fresh copy of VB?

monstergamer
01 Apr 2006, 01:39
been using this for a year or so with the older verson, i just change PCs. so i had to get this back.
this way is alot easier the the firest tut.

Deaths
04 Apr 2006, 23:49
Heh, I had no idea this thread was still alive after all this time.

I'll keep an eye on this thread from now on.. my appologies to everyone I didn't assist.

TheMusicMan
05 Apr 2006, 08:18
For what it's worth - I installed this recently on several machines and it works flawlessly on them both. Not sure there's anyting needs 'fixing'... great work thanks.

Deaths
05 Apr 2006, 18:20
Thanks for your positive feedback ;).

bada_bing
07 Apr 2006, 16:01
I am having problems importing my production database after I downloaded it and renamed it as specified in the directions. From phpmyadmin I try to do the import the area when the directions says go get a cup of coffee :D well I have tried serveral time and the page ends up timing our saying page cant be displayed... I all coffeied out doing this can someone help please.. My database is 260 mb and I am on a windows 2K machine.

Deaths
07 Apr 2006, 16:54
Well, a 260 mb database is indeed a bit too big for phpMyAdmin ;).

I'm pretty sure your answer has already been answered in this thread though. Have a read through the pages and you'll probably find it.

bada_bing
07 Apr 2006, 17:11
Well, a 260 mb database is indeed a bit too big for phpMyAdmin ;).

I'm pretty sure your answer has already been answered in this thread though. Have a read through the pages and you'll probably find it.
Could not find a simular problem in the thread?

Deaths
08 Apr 2006, 13:57
Well, what you can do is import parts of the database step by step. So basicly copy 1/10th of the database file (make sure you end the copy/paste at the end of a table inject or things will get messy ^^).

gavinzac
08 Apr 2006, 18:29
trying to import the database, its "only" 36mb but its been importing for the last 3 hours. restart?

Deaths
10 Apr 2006, 19:41
Try restarting it. If that doesn't work, split it into pieces aswell ;).

bada_bing
12 Apr 2006, 03:06
Well, what you can do is import parts of the database step by step. So basicly copy 1/10th of the database file (make sure you end the copy/paste at the end of a table inject or things will get messy ^^).
How do I do that? Can you explain as I am new to this

gavinzac
12 Apr 2006, 20:58
i tried to split it but my text editor crashed trying to "cut" 15 mb of data.

Jordan17
17 Apr 2006, 14:42
9 meg on your computer should be done in about 10 mins.

Also when looking to the left for tables they may not show so log out and back in - solves the problem all the time.

Use a program called Mysqfront to create databases local - is well easy program to use.

Mine is 50+ MB so it just times out all the time.

john1744
22 May 2006, 16:26
How about images getting corrupted on the localhost? All my images are trying to show up as my actual sites address which of course doesn't work since I am not connected to the net when working on this.

Example:

systemwars.com/forums/images/image.gif - is what it is showing up as instead of

localhost/forums/images/image.gif

parad0xx
27 May 2006, 21:16
Mine is 50+ MB so it just times out all the time.

Yeah, I cannot seem to get my SQL file loaded and mine is only 9MB. I let it run 9 hours. Someone please explain an alternate method then posting it through phpmyadmin please.

mdavis1984
23 Jul 2006, 02:32
Hey i did all this allready lol but i use abyss webserver x2. nice server and they got free version to called x1. way super user friendly. of course i had to install mysql phpmyadmin and all that good stuff. and vb 3.5.4. great help here though.

Chris-777
24 Jul 2006, 15:32
Yeah, I cannot seem to get my SQL file loaded and mine is only 9MB. I let it run 9 hours. Someone please explain an alternate method then posting it through phpmyadmin please.


Via SSH.

http://www.vbulletin.org/forum/showthread.php?t=106935

a 9MB database should take about ten seconds.

Irisfire
25 Jul 2006, 04:52
that package linked for phptriad has php 4.1.1...what's the easiest way to upgrade the php?

Jay...
05 Aug 2006, 21:21
thats what i want to know

Irisfire
06 Aug 2006, 07:10
does anyone know?...

Jay...
06 Aug 2006, 14:37
bump

KevinL
06 Aug 2006, 18:09
Has anyone tried this on a mac?

Ranma2k
07 Aug 2006, 12:09
that package linked for phptriad has php 4.1.1...what's the easiest way to upgrade the php?
get the zip file from php.net and extract the files in the curent php directory that is set by phptriad

Mine is 50+ MB so it just times out all the time.
Click start -> run -> type "CMD" -> hit enter
in dos
go to mysql\bin directory ( assuming mysql is installed on drive C: )
cd c:\mysql\bin

run the following command

mysql -D mydatabase -u username -p < c:\path\to\file\mysqlfile.sql



mydatabase is your database name that you want to load the sql file into
username if the username for the database ( mostly is root).
mysqlfile.sql is your SQL file that you want to load

if you have set a password then it will ask you for the password after you hit the Enter key
if you didn't set a pssword use this command insted


mysql -D mydatabase < c:\path\to\file\mysqlfile.sql


using this i loaded a 290 MB database in 1 min

MakZF
09 Aug 2006, 11:21
Nice tut, I'd reccomend using EasyPHP (http://prdownloads.sourceforge.net/quickeasyphp/easyphp1-8_setup.exe?download) though, it works great for me.

amnesia623
09 Aug 2006, 17:22
I've always used XAMMP to install everything.

Then I added an entry in my windows 'hosts' file that made my domain name point back to localhost so all my links/graphics/etc would resolve back to my pc.

So no matter if I was connected to the internat or not, when I typed www.mydoamin.com into my browser it would loop back into the webserver that was on my PC.

*this is a great way to mess with someone too because you can point any domain to any other domain...like hotmail.com to ratemymullet.com*

Ziki
02 Nov 2006, 15:12
Getting this error when trying to access phpmyadmin

Error

MySQL said:

Can't connect to MySQL server on 'localhost' (10061)

Blaine0002
24 Nov 2006, 20:18
Newbie here... I am stuck...everything worked up until the time to click on test database...nothing there..I then right clicked to create a database and it dialog box says that the server must be connected.

Help?!?!?! ;)

Same problem here, yes ive tried restarting apache.
is the icon in the bottom right supposed to be red?
I can right click it, go to winNT and click start service, but it fails for some reason :-/

Ziki
26 Nov 2006, 12:01
PHPTriad sux.use XAMMP. Works great

Blaine0002
26 Nov 2006, 13:52
hell i just downloaded the latest versions of each and managed to stick em together :)

Lord Kirken Mor
13 Mar 2007, 03:12
What is there for Mac OS X Tiger? I dont have a windows.

Luky
14 Apr 2007, 06:57
PHPTriad? I used to use Xampp, ill try this but :)

SoftDux
11 May 2007, 12:35
what about the licencing of VB? Won't the local copy give some errors saying the domain isn't registered?

karlm
18 May 2007, 08:05
I've had to update to the latest php & mysql versions to work with vb3.6.7, but it's worth it. This is an AWSOME article... I wish I'd read it long ago, would've saved a lot of messing about with test forums' using subdirectories & another of my limited mysql's with my hosting company.

Thanks for this article - excellent learning material for we n00bz

Daisil
07 Jun 2007, 02:55
vBulletin 3.6.7 requires MySQL version 4.0.16 or greater. Your MySQL is version 3.23.47-nt, please ask your host to upgrade..

I fixed my PHP Version but how can I fix my MySQL version to work w. this!?

Thanks,
Daisil

Does anybody know?

TECK
16 Jun 2007, 17:05
That is a good example how BAB is to use those type of setups.
Do it your self, install it the old school way. Then you can upgrade instantly to whatever version you like and not depend on someone to update their software.

I NEVER installed those type of system into my PC

blazingpc
25 Jul 2007, 15:55
This is a great way to learn to MOD your own board.

I installed it in about 10 min but had to use easyPHP (http://sourceforge.net/projects/quickeasyphp/) because the Triad in the first post is to old.

I recommend doing this.

TECK
01 Aug 2007, 17:44
I recommend using the right way: install manually and configure yourself PHP and MySQL... if you want to learn something.
If you don't want, yes, use those premade programs.

Opserty
03 Aug 2007, 22:04
XAMPP works fine, I used to do it the old way but now its just easier to download something like xampp. If a new version comes out just uninstall and reinstall and save the mysql db files. Simple really :p

dtv100
04 Aug 2007, 11:41
this is great thanks .

what about if you have more than one forum is possible to run all from my PC ?

Demon Child
25 Aug 2007, 18:44
i got a link to add to this ... go to www.apachefriends.org and download the latest version of xampp it installs everything you need automaticaly

simtex
19 Jan 2008, 12:51
nice guide

i am using something similar to this

well done :up:

choccyclaire
29 May 2008, 22:49
Thank you for the awesome detailed article.

It has helped me immensely.

Golzarion
30 May 2008, 07:20
It seems a little strange ! Why do not we use easyphp or xamp ???
I believe it's more easy and faster !!
Sorry, but I can't find anything new about this article ...

Opserty
30 May 2008, 11:54
The post was written back in 2005, I'm not sure if those pieces of software were available then. I use xampp its quick and easy to install and even has an easy to use control panel.

SoftDux
06 Oct 2008, 08:45
Marco,

I am using the following:
AppServ 2.5.4
- Apache 2.0.54
- MySQL 5.0.15
- PHP 5.0.4
- phpMyAdmin-2.6.2-pl1

I have finally got everything working with the exception of PhotoPost. The Features and Randoms seem to be working fine on the main interface of the forums, but when I click on the Gallery menu choice, I get the following errors:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



I know this is a very old post, but I can't find any other references to it. How did you get PhotoPost to run off your PC?