How to backup forum and run on PC

[cyberman]

hi everybody,
I wonder if i could backup my forum and run it on PC. Is it possible ???

[kerk]

download pack-all-in-one AppServ and install appl. (incl: apache server, php, mysql, phpmyadmin) if not installed
install forum
upload backup via phpmyadmin (or any other script =))

[cyberman]

Originally Posted by kerk

download pack-all-in-one AppServ and install appl. (incl: apache server, php, mysql, phpmyadmin) if not installed
install forum
upload backup via phpmyadmin (or any other script =))

>> you mean sql backup or all folers ???

[kerk]

sql backup, sure =)) (>quote< upload backup via phpmyadmin )

[ShavedApe]

phpmyadmin will only work if the back up is small.

I use Appserv myself as it goes but for larger backups do this:

Save back up to bin folder of mysql found in the appserv folder

Open command prompt and type cd C:\Path\to\appserv\mysql\bin
now type
mysql -u your_username_for_mysql -p the_database_name_you_want_to_import_to < file_name.sql
hit enter
it will ask for password
this is the mysql password you have set
recent versions of appserv have'nt been great at recording username and password on install so if you find the one you chose doesnt work use root and blank password

[kerk]

ShavedApe, I have other script to backup my databases (Site Keeper Dumper LE 1.0.6) but settings in russian language... is free for download and use =))
work with larges backups (100 Mb +)

[cyberman]

Originally Posted by kerk

ShavedApe, I have other script to backup my databases (Site Keeper Dumper LE 1.0.6) but settings in russian language... is free for download and use =))
work with larges backups (100 Mb +)

>> How does it work ??

[cyberman]

Originally Posted by ShavedApe

phpmyadmin will only work if the back up is small.

I use Appserv myself as it goes but for larger backups do this:

Save back up to bin folder of mysql found in the appserv folder

Open command prompt and type cd C:\Path\to\appserv\mysql\bin
now type
mysql -u your_username_for_mysql -p the_database_name_you_want_to_import_to < file_name.sql
hit enter
it will ask for password
this is the mysql password you have set
recent versions of appserv have'nt been great at recording username and password on install so if you find the one you chose doesnt work use root and blank password

>> I think Appserv is similar to PHPtriad !!!

[angelicGrace]

Wamp is a better all in one than PHPTriad or Appserv. Its easier to use, easier to install for newbies to the world of dummie servers, and takes up less hard drive space.

I do know from experience. I tried. PHPTriad when I first wanted a dummie server. i never could figure it out.

Appserv was ok, but it was so hugh that it sent my computer into lockdown too often and it was a bit hard to navigate for a newbie.

Wamp gave me neither problem. i was able to figure it out with great ease.

granted that's just my two cents worth. you might find you prefer one of the packs of programs i didn't care for.

[cyberman]

Guys,
I can't make it. I backed up my forum under file name: myforum.sql . I try to restore it to run my forum locally. I don't know how to do , since Mysql doesn't have restore option. I'm using PHPTriad to run forum on PC. Please, help ....