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?

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.

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 ;).

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.

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 ^^).

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 ;).

How do I do that? Can you explain as I am new to this

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

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

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

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.

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.

Via SSH.

https://vborg.vbsupport.ru/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

does anyone know?...

bump

Has anyone tried this on a mac?

get the zip file from php.net and extract the files in the curent php directory that is set by phptriad

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 though, it works great for me.

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)

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

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

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

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

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

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

This is a great way to learn to MOD your own board.

I installed it in about 10 min but had to use easyPHP 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.

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 ?