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

*TouchingVirus* · 03-21-2006, 04:00 PM

Drop the database & re-dump the one you're trying to import and you should be fine. The .SQL file shouldn't contain duplicate entries of rows marked as unique since it's a dump of an active SQL database which wouldnt allow them to occur..

As for myself, I do the manual way. The more you do manually the more you get to grips with the software and understand its setup better if something goes wrong or you wanna tweak something. It's why i prefer to setup httd.conf, php.ini and my.ini using Editplus.

I'm quite fast at it by now and I can setup all 3 in the time it takes to setup using EasyPHP and I get all my custom options

*TouchingVirus* · 03-21-2006, 04:11 PM

Quote:

Originally Posted by stinger2

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

Quickest way to get out of your situation would be to modify the .SQL file and remove the duplicate entries by removing the line or putting a # at the front of it ( i think it's a #

).

You could also modify the build of the table so that Key 2 isn't set to "unique"

stinger2 · 03-22-2006, 01:06 PM

thank you sir

what do you use to edit the database? since i never edited the sql manually....
looking at it in ultraedit does not show the lines for me?

cDizzle · 03-23-2006, 04:38 AM

in the rare occasion that I use windows, I prefer wamp for apache/php/mysql/perl http://www.wampserver.com/
it is php 5 / apache 2 (i like apache 1 tho since it is what is on most any production server) and mysql 5

but otherwise, i run linux, and have compiled apache 1.3.34 and php 5.1.2, and php 4.4.2 as a cgi module all from source, and mysql 4.1.16 from yum

I like my linux and think anyone here using windows should get that and ditch their windows!!!

stinger2 · 03-25-2006, 07:00 PM

just to update.....i created a new database with latin character and the problem is solved...........thanks every one for his help
rgds

hetecro · 03-28-2006, 02:44 AM

I use WAMP... It installed in seconds, and it all worked great, no restart needed...

Shawn · 03-28-2006, 07:46 AM

Im getting a free redirecting url such as cjb.net what will the url be to redirect it to???

CrazyShooter · 03-29-2006, 09:58 AM

Hey, instead of http://localhost/ cant i use my ip instead ?

Arnoud · 03-29-2006, 10:30 AM

Quote:

Originally Posted by CrazyShooter

Hey, instead of http://localhost/ cant i use my ip instead ?

Should work aswell, yes.

_Fatal · 05-01-2006, 10:17 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.

that would be what deaths said right? "password" because I tried it more then once and I keep getting the message, know why?

C:\apache\mysql\bin>mysql -u username_for_mysql -p database_name < backup.sql
Enter password: ********
ERROR 1045: Access denied for user: 'username_for_mysql@localhost' (Using passwo
rd: YES)

LOL, i'm such I noob, didn't realize I had to actually change the "usernam_for_mysql" lol!!! sorry.

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)