Run your vBulletin on your PC [Archive]

View Full Version : Run your vBulletin on your PC

Deaths

04-06-2005, 10:00 PM

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.
cookiedomain";s:0:"XXXX"
REMOVE the cookiedomain text. sothat it will look like this: cookiedomain";s:0:""
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

04-07-2005, 09:31 PM

Wow, Awesome dude!

I will be sure to use this ;)

deathemperor

04-08-2005, 01:11 AM

Deaths have you checked for an exist guide ?

https://vborg.vbsupport.ru/showthread.php?t=39482

more details, better for newbie

Deaths

04-08-2005, 06:37 AM

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

04-08-2005, 10:34 AM

I use AppServ which offer one file installation and you need to edit nothing to have a local server.

Deaths

04-08-2005, 01:28 PM

I never used it, so I can't make a howto on something I never used. (AppServe, that is)

KW802

04-08-2005, 02:00 PM

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

04-08-2005, 02:29 PM

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

04-08-2005, 02:34 PM

Thanks :).

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

mholtum

04-08-2005, 03:34 PM

went great but there is no "test" db.

deathemperor

04-08-2005, 06:10 PM

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

04-08-2005, 07:18 PM

# 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

04-08-2005, 08:53 PM

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.

04-08-2005, 11:01 PM

edit, nvm :)

Adrian Schneider

04-09-2005, 01:35 AM

tnguy3n

04-09-2005, 03:35 AM

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

04-09-2005, 07:45 AM

# 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

04-09-2005, 08:04 AM

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

04-09-2005, 08:06 AM

Hehe, glad it worked :).

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

AlexUK

04-09-2005, 09:39 AM

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

04-09-2005, 11:08 AM

That is indeed long, too long.

What OS are you using?

AlexUK

04-09-2005, 11:44 AM

windows xp pro

Marco van Herwaarden

04-09-2005, 11:55 AM

Depending on your hardware, this could be normal then yes.

Deaths

04-09-2005, 11:57 AM

Just turn it on when you go to sleep, and in the morning its done ;)

AlexUK

04-09-2005, 11:59 AM

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

04-09-2005, 12:21 PM

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

04-09-2005, 12:39 PM

No thats not what it meant.
My database is still empty.
It not working at all.

Deaths

04-09-2005, 06:17 PM

It looks like its emtpy, but actually its not.

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

YLP1

04-09-2005, 06:44 PM

TyleR

04-09-2005, 07:05 PM

@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

04-09-2005, 07:10 PM

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

04-10-2005, 08:40 AM

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

04-10-2005, 11:12 AM

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

04-10-2005, 01:19 PM

I wouldn't know...

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

tnguy3n

04-10-2005, 09:40 PM

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

05-25-2005, 06:13 AM

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

05-25-2005, 10:06 AM

You will need to add the database information to config.php.

Marco van Herwaarden

05-25-2005, 06:24 PM

If you have a MySQL version 4.1 or higher then you will probable need your MySQL server to allow Old Passwords.

Rickie3

05-26-2005, 03:04 AM

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

Marco van Herwaarden

05-26-2005, 05:24 AM

Check the page source and post here.

Rickie3

05-26-2005, 05:47 AM

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

05-26-2005, 06:01 AM

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

05-26-2005, 06:14 AM

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

05-26-2005, 09:13 AM

Nice to see you solved things :D

pelukis

06-18-2005, 01:31 AM

wow........great way to test stuff...thanks deaths

Barakat

06-18-2005, 08:46 AM

how can i access it ?

Error
MySQL said:

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

Marco van Herwaarden

06-18-2005, 09:42 PM

What MySQL version you are using?

Bounce

08-05-2005, 04:54 PM

Marco van Herwaarden

08-05-2005, 06:53 PM

Set your mysql server to allow "old passwords"

Bounce

08-05-2005, 08:32 PM

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

08-05-2005, 11:46 PM

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

09-25-2005, 11:09 AM

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

09-25-2005, 11:23 AM

Which program?

Feckie (Roger)

09-25-2005, 12:40 PM

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

11-18-2005, 11:17 PM

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

12-16-2005, 03:58 AM

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

12-26-2005, 03:35 PM

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

12-30-2005, 01:15 AM

I guess this thread is dead anymore. what a shame.

Marco van Herwaarden

12-30-2005, 04:45 AM

Just set the Webroot for your webserver to a different location. What webserver are you using?

zendiver

12-30-2005, 02:03 PM

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:

Warning: main(./global.php) [function.main]: failed to open stream: No such file or directory in W:\AppServ\www\gallery\header-inc.php on line 61

Fatal error: main() [function.require]: Failed opening required './global.php' (include_path='.;C:\php5\pear') in W:\AppServ\www\gallery\header-inc.php on line 61

Marco van Herwaarden

12-30-2005, 02:22 PM

Sorry no experience with PhotoPost, i suggest you ask on their support site.

Daniel

01-02-2006, 09:23 PM

* Daniel needs for OS X :(

*hint hint*

Lpspider

01-20-2006, 09:51 PM

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

01-20-2006, 09:52 PM

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

01-20-2006, 10:30 PM

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

01-20-2006, 10:36 PM

Have you got php installed on your PC? It's the only other possibility I can think of.

bada_bing

01-21-2006, 02:50 AM

Nice thread I will try to so this, as it would be nice to have a running copy on my home PC

Lpspider

01-21-2006, 03:39 PM

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

01-21-2006, 06:28 PM

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

01-21-2006, 08:24 PM

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

01-21-2006, 08:58 PM

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

02-12-2006, 04:15 PM

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

02-12-2006, 04:57 PM

I guess you entered the wrong Customernumber

Lpspider

02-12-2006, 06:32 PM

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.

02-13-2006, 10:01 AM

This is really useful! Thanks!

Lpspider

02-14-2006, 12:04 AM

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

03-15-2006, 02:51 PM

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

03-15-2006, 03:45 PM

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 https://vborg.vbsupport.ru/showthread.php?t=79539

Works a treat.

bada_bing

03-15-2006, 04:38 PM

Install this https://vborg.vbsupport.ru/showthread.php?t=79539

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

TheMusicMan

03-15-2006, 05:46 PM

Haha... I didnt realise sorry... but it is what you asked for no?

bada_bing

03-15-2006, 05:55 PM

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

04-01-2006, 12:39 AM

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-04-2006, 10:49 PM

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

04-05-2006, 07:18 AM

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

04-05-2006, 05:20 PM

Thanks for your positive feedback ;).

bada_bing

04-07-2006, 03:01 PM

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

04-07-2006, 03:54 PM

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

04-07-2006, 04:11 PM

Deaths

04-08-2006, 12:57 PM

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

04-08-2006, 05:29 PM

trying to import the database, its "only" 36mb but its been importing for the last 3 hours. restart?

Deaths

04-10-2006, 06:41 PM

Try restarting it. If that doesn't work, split it into pieces aswell ;).

bada_bing

04-12-2006, 02:06 AM

gavinzac

04-12-2006, 07:58 PM

i tried to split it but my text editor crashed trying to "cut" 15 mb of data.

Jordan17

04-17-2006, 01:42 PM

john1744

05-22-2006, 03:26 PM

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

05-27-2006, 08:16 PM

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

07-23-2006, 01:32 AM

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.

Guest210212002

07-24-2006, 02:32 PM

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.

https://vborg.vbsupport.ru/showthread.php?t=106935

a 9MB database should take about ten seconds.

Staxed

07-25-2006, 03:52 AM

that package linked for phptriad has php 4.1.1...what's the easiest way to upgrade the php?

Jay...

08-05-2006, 08:21 PM

thats what i want to know

Staxed

08-06-2006, 06:10 AM

does anyone know?...

Jay...

08-06-2006, 01:37 PM

bump

KevinL

08-06-2006, 05:09 PM

Has anyone tried this on a mac?

Ranma2k

08-07-2006, 11:09 AM

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

08-09-2006, 10:21 AM

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

amnesia623

08-09-2006, 04:22 PM

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

11-02-2006, 02:12 PM

Getting this error when trying to access phpmyadmin

Error

MySQL said:

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

Blaine0002

11-24-2006, 07:18 PM

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

11-26-2006, 11:01 AM

PHPTriad sux.use XAMMP. Works great

Blaine0002

11-26-2006, 12:52 PM

hell i just downloaded the latest versions of each and managed to stick em together :)

Lord Kirken Mor

03-13-2007, 02:12 AM

What is there for Mac OS X Tiger? I dont have a windows.

Luky

04-14-2007, 05:57 AM

PHPTriad? I used to use Xampp, ill try this but :)

SoftDux

05-11-2007, 11:35 AM

what about the licencing of VB? Won't the local copy give some errors saying the domain isn't registered?

karlm

05-18-2007, 07:05 AM

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

06-07-2007, 01:55 AM

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

06-16-2007, 04:05 PM

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

07-25-2007, 02:55 PM

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

08-01-2007, 04:44 PM

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

08-03-2007, 09:04 PM

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

08-04-2007, 10:41 AM

this is great thanks .

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

Demon Child

08-25-2007, 05:44 PM

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

01-19-2008, 11:51 AM

nice guide

i am using something similar to this

well done :up:

choccyclaire

05-29-2008, 09:49 PM

Thank you for the awesome detailed article.

It has helped me immensely.

Golzarion

05-30-2008, 06:20 AM

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

05-30-2008, 10:54 AM

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

10-06-2008, 07:45 AM