1. wrong thread. check the backup tutorial.

2. i dont recommend anyone to use phptriad. it removes you the ability to configure the way you want all the server options.
the old school way is always the best way... and it works perfectly. why? because with phptriad, if there is a new php, mysql or apache release, you must uninstall everything and lose all your settings and data.
in my humble oppinion, phptriad is for lazy people who dont like to take the time to configure their server the right way. if you use phptriad, you will never learn anything about any config file and settings related to apache, php and mysql.

[high]remember, if is not working is because you missed a step.[/high] just an example, 99% of the people forget to restart Apache after they set all their options. this tutorial worked perfectly on every single pc i install it, so it must work also in yours.

You also don't learn anything from just following someone else's tutorial and following instructions.

true. it took me a while to get it the right way the installation. you remember the DirectoryIndex tip you gave me long time ago?

Ok...

1. *dies* That is the same point Firefly brought up. You see, you cannot use an SSH client like Putty to backup your forums installed on a localhost, like my pc. It wont connect for purposes that are probably logical--one being it is my pc and making a connection through putty to the very computer you type on seems silly. Still, I need a way to make a reliable backup so that when I finish with my forums on my computer I can transfer the backup to my webserver.

2. If I had a real server I would more than likely go your way Nakkid with doing by hand, ofcourse It's just my crappy Compaq Laptop and the only real purpose of it right now is for testing hacks on my vbulletin. Same reason I would never use a wysiwyg over regular text editors for any programming/authoring.

If you want to backup or restore databases on your home pc you can enter the same commands you would in an SSH client from the DOS command line. Navigate to your mysql directory and you can run them from there.

Thanks for the help, that worked perfectly ;)

Glad it worked for you. :)

Quick Tutorial - How to backup/restore on a localhost

I thought I would make this because I fought alittle trying to get this working using the MSDOS shell, and found some things to be alittle different than from what backing up is usually like.
Once again, thanks to FWC for the tip, and also Logican from another post providing me some info

(note: done using Windows XP, should work on older OS also)

----------------------------------------------------------------------------------------

1. Copy and paste the following into your address bar, then hit enter: %SystemRoot%\system32\cmd.exe

2. Now depending on how you installed MySQL on your system, either with or without PHPTriad, you need to browse to that directory bin folder.

For example, if you did use PHPTriad, type cd c:\apache\mysql\bin.


3. For BACKING UP:

Type mysqldump -u username --opt database_name > backupfile.sql, filling in username and database_name with the correct values.

This method worked perfectly for me using the PHPTriad installation, should do the same with the other. If it asks you for a password, enter the password.


4. For RESTORING:

Type -u root -ppassword database_name < backupfile.sql in the command prompt.

You might get an error saying a table already exists, if so you need to clear your current database. Go into phpmyadmin and drop it that way. Be sure not to drop the whole database eliminating it, but just dropping the tables. Before doing this check your database backup you just created to make sure it actually created its and is not corrupt.

Thats it!

good tutorial.. :)
i will add it in the first post, if you dont mind. :D