[Forum] Possible to Run Full website backup on my computer

[wtrk68]

Hi.

I have Vb4.2.3 PL2 and yesterday I took Full web site back up.

Now I want to run all my website on my local computer over backup. It has 650mb database and I dont know how it works.
Is it possible , can someone define it me ?

Which software I should to use ( xampp , etc ) and how to configure it.

Thanks for your answers now.

[Trevor Hannant]

Is this for you to test things locally or to actually run your website from home?

[wtrk68]

Is this for you to test things locally or to actually run your website from home?

I done backup 2 days ago. After that one of admins deleted some post.
Just I want to see it localy.
So I want to setup my backup forum in to my local computer

[Wayne Luke]

It is possible, you would need to run a webserver, PHP and MySQL/MariaDB on your local machine. Depending on your OS you may be able to use a package like XAMPP or WAMPServer to do this.

Please note, we cannot provide support for configuring your local machine to run like a webserver.

[wtrk68]

Dear Wayne Luke thanks for your reply. I tried a few times set it up with Xampp but didnt succeed it because I dont know how to import 650 mb sql.
Thats the point of my problem.

[Lynne]

You most likely would need to import your database via command line. So, you would need to open a Terminal on your computer to do this.

[Wayne Luke]

You can use this command to import a database:

mysql -u username -p -h localhost databasename < backup.mysql

If that fails then use this command to access MySQL:
mysql -u username -p -h localhost

Once logged into MySQL then use these commands:

create database databasename;
use databasename;
source /path/to/backup.sql

Of course you have to replace things like databasename and username with your own information.

You can also use MySQL Workbench to import a database backup:
https://dev.mysql.com/doc/workbench/...rt-import.html