[How To] Run vBulletin On your P.C.

ShavedApe · 03-19-2006, 08:12 AM

Been there done that. One question though why?

I have set up manually in the past a few times but so much quicker just to use one of pre compiled installers why waste time.

Senna · 03-19-2006, 03:02 PM

Quote:

Originally Posted by ShavedApe

Been there done that. One question though why?

I have set up manually in the past a few times but so much quicker just to use one of pre compiled installers why waste time.

certainly for a little testboard on your local machine, which is only used when yuo use it ;)

03-19-2006, 06:16 PM

i was using easyphp, but say wamp5, and thats way better for me

MegamanHero · 03-20-2006, 03:15 AM

well as ur title says busy busy admin

shogust · 03-20-2006, 10:51 AM

Im working Years with Apache2Triad

Its working great

Greetz, Shogst

stinger2 · 03-20-2006, 06:27 PM

Quote:

Originally Posted by ShavedApe

I know its prolly a while ago since this was discussed but I may as well say what I do here.
first of all download yourself an sql back up of your board.
eg. vbulletin.sql and save it to your mysql/bin/ dir.

open comand prompt and type cd c:\path\to\your\mysql\bin_dir\
eg. c:\mysql\bin\

now type mysql -u username_for_mysql -p database_name < vbulletin.sql
hit enter
you will now be asked for password of mysql server enter that and wait till its done.

hi ShavedApe
how did you import the database.??
i am trying to set a local server to test the upgrade of my vb 3.5.1 to 3.5.4 before doing it.
i managed to set a local server at my pc and i was trying to import the database using the following command

Quote:

c:\mysql\bin\mysql -u username -p dbname < c:\backup.sql

BUT when i try to restore my database i get the following error

Quote:

Quote:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\stinger>C:\AppServ\mysql\bin\mysql -u root -p stinger < c:\bk11152005.sql
Enter password:******

THIS is the error

Quote:

ERROR 1062 (23000) at line 4250: Duplicate entry 'tiδsto' for key 2

or this error

Quote:

ERROR 1062 (23000) at line 4262: Duplicate entry 'andrΘ' for key 2

anyone can help me explaining the error

ps.i used appserv, phptriad, wampserver, plus different versions of Mysql....

always the same error

my actual database has been transfeered to 2 normal servers already without problems and i used different copies of the database with different sizes

can anyone help me here explaining this error i am getting..and how to correct it??

kind regards

*xfile* · 03-20-2006, 08:48 PM

AppServer is updated more often than others

codeX · 03-21-2006, 02:00 AM

I'm using easyphp/phptriad for running vB in local host. It's working..

I'm checking all the hacks in localhost before applying to my forum.

ShavedApe · 03-21-2006, 02:51 AM

Quote:

Originally Posted by stinger2

hi ShavedApe
how did you import the database.??
i am trying to set a local server to test the upgrade of my vb 3.5.1 to 3.5.4 before doing it.
i managed to set a local server at my pc and i was trying to import the database using the following command

BUT when i try to restore my database i get the following error

Quote:

THIS is the error

or this error

anyone can help me explaining the error

ps.i used appserv, phptriad, wampserver, plus different versions of Mysql....

always the same error

my actual database has been transfeered to 2 normal servers already without problems and i used different copies of the database with different sizes

can anyone help me here explaining this error i am getting..and how to correct it??

kind regards

Hate to say it but the error is pretty self expalnatory.
There is already an entry for what it tells you and im guessing the table is set to unique for that field.
Which must mean youve already imported some of the dbase before.
Download a fresh backup and then empty your dbase you can even drop it completely and then create a completely empty one to import into.
Then follow the instructions I gave.
Should you recieve that error again im afraid your only option would be to remove the duplicate entries.

stinger2 · 03-21-2006, 03:49 PM

Quote:

Originally Posted by ShavedApe

Hate to say it but the error is pretty self expalnatory.
There is already an entry for what it tells you and im guessing the table is set to unique for that field.
Which must mean youve already imported some of the dbase before.
Download a fresh backup and then empty your dbase you can even drop it completely and then create a completely empty one to import into.
Then follow the instructions I gave.
Should you recieve that error again im afraid your only option would be to remove the duplicate entries.

thanks shavedApp again.

the database was imported to an empty database
just to make sure i emptied it again and imported again...same error......

can you tell me how can i remove the dublicate entry please?
should i remove the whole line??

and does that mean that my actual database is having also that duplicate?? then how was it transfeered twice without any problem?
ps. the hosting company did the install for me

thank you sir again for your help
NOTE
i just searched for these 2 words (Tiësto andrò )and they are just words in a 2 different posts ........should i just delete the post ??

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[How To] set usernames in color/bold/italic	GirlsOnTop	vBulletin Modification Tutorials	17	05-13-2008 02:24 AM
[How To] Run a Query	Ken Iovino	vBulletin Modification Tutorials	6	08-29-2007 02:23 PM
[How To] Add Options per forum	Ken Iovino	vBulletin Modification Tutorials	10	03-03-2007 03:25 PM
[How To] Run a vb page outside of the forum directory	Junior	vBulletin Modification Tutorials	7	01-10-2007 07:05 PM
vBulletin Development Update: vBulletin 3.5	Arnoud	Announcements	0	05-11-2005 05:14 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)