View Full Version : Run your vBulletin on your PC
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 :)
Wow, Awesome dude!
I will be sure to use this ;)
deathemperor
08 Apr 2005, 03:11
Deaths have you checked for an exist guide ?
http://www.vbulletin.org/forum/showthread.php?t=39482
more details, better for newbie
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, 12:34
I use AppServ which offer one file installation and you need to edit nothing to have a local server.
I never used it, so I can't make a howto on something I never used. (AppServe, that is)
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, 16: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. :)
Thanks :).
This wasnt created for a TOTAL newbie, because a total newb wouldn't see any use in this anyway...
mholtum
08 Apr 2005, 17:34
went great but there is no "test" db.
deathemperor
08 Apr 2005, 20: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.
# 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?
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.
Adrian Schneider
09 Apr 2005, 03: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, 05: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.
# 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 ;)
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 ~_^
Hehe, glad it worked :).
There should be some kind of install button for hints & tips :/
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?
That is indeed long, too long.
What OS are you using?
Marco van Herwaarden
09 Apr 2005, 13:55
Depending on your hardware, this could be normal then yes.
Just turn it on when you go to sleep, and in the morning its done ;)
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.
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.
No thats not what it meant.
My database is still empty.
It not working at all.
It looks like its emtpy, but actually its not.
Just follow the steps, and you'll see it works.
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?!?!?! ;)
@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 ?
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.
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, 13: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
I wouldn't know...
Maybe someone else knows, but I'm not good with stuff like that.
tnguy3n
10 Apr 2005, 23: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, 08: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
You will need to add the database information to config.php.
Marco van Herwaarden
25 May 2005, 20: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, 05: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, 07:24
Check the page source and post here.
Rickie3
26 May 2005, 07: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, 08: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, 08: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, 11:13
Nice to see you solved things :D
pelukis
18 Jun 2005, 03:31
wow........great way to test stuff...thanks deaths
Barakat
18 Jun 2005, 10:46
how can i access it ?
Error
MySQL said:
Access denied for user: 'root@localhost' (Using password: YES)
Marco van Herwaarden
18 Jun 2005, 23:42
What MySQL version you are using?
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, 20:53
Set your mysql server to allow "old passwords"
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
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, 13: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, 13:23
Which program?
Feckie (Roger)
25 Sep 2005, 14: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, 01: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, 05: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, 17: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, 03:15
I guess this thread is dead anymore. what a shame.
Marco van Herwaarden
30 Dec 2005, 06:45
Just set the Webroot for your webserver to a different location. What webserver are you using?
zendiver
30 Dec 2005, 16: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, 16:22
Sorry no experience with PhotoPost, i suggest you ask on their support site.
/me needs for OS X :(
*hint hint*
Lpspider
20 Jan 2006, 23: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, 23: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
21 Jan 2006, 00: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
21 Jan 2006, 00:36
Have you got php installed on your PC? It's the only other possibility I can think of.
bada_bing
21 Jan 2006, 04: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, 17: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, 20: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, 22: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, 22: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, 18: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, 18:57
I guess you entered the wrong Customernumber
Lpspider
12 Feb 2006, 20: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.
This is really useful! Thanks!
Lpspider
14 Feb 2006, 02: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, 16: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, 17: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, 18: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, 19:46
Haha... I didnt realise sorry... but it is what you asked for no?
bada_bing
15 Mar 2006, 19: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, 02: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.
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, 09: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.
Thanks for your positive feedback ;).
bada_bing
07 Apr 2006, 17: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.
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, 18: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?
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, 19:29
trying to import the database, its "only" 36mb but its been importing for the last 3 hours. restart?
Try restarting it. If that doesn't work, split it into pieces aswell ;).
bada_bing
12 Apr 2006, 04: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, 21:58
i tried to split it but my text editor crashed trying to "cut" 15 mb of data.
Jordan17
17 Apr 2006, 15: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, 17: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, 22: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, 03: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, 16: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.
that package linked for phptriad has php 4.1.1...what's the easiest way to upgrade the php?
thats what i want to know
Has anyone tried this on a mac?
Ranma2k
07 Aug 2006, 13: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
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, 18: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*
Getting this error when trying to access phpmyadmin
Error
MySQL said:
Can't connect to MySQL server on 'localhost' (10061)
Blaine0002
24 Nov 2006, 21: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 :-/
PHPTriad sux.use XAMMP. Works great
Blaine0002
26 Nov 2006, 14:52
hell i just downloaded the latest versions of each and managed to stick em together :)
Lord Kirken Mor
13 Mar 2007, 04:12
What is there for Mac OS X Tiger? I dont have a windows.
PHPTriad? I used to use Xampp, ill try this but :)
SoftDux
11 May 2007, 13:35
what about the licencing of VB? Won't the local copy give some errors saying the domain isn't registered?
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
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?
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, 16: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.
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, 23: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
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, 19: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
nice guide
i am using something similar to this
well done :up:
choccyclaire
29 May 2008, 23:49
Thank you for the awesome detailed article.
It has helped me immensely.
Golzarion
30 May 2008, 08: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, 12: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, 09: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?
vBulletin® v3.6.12, Copyright ©2000-2012, Jelsoft Enterprises Ltd.