CODEWITHSUNDEEP
mysqldatabaseserverwampwebmatrix
Zev
Zev

Reputation: 165

How do I put a database onto a local server?

I have a bunch of backed up wordpress mysql database files, I am trying to access them in Microsoft Webmatrix. I originally used WAMP. I honestly have no idea what I'm doing. I am under the impression I have to have the database running on a server in order to connect to it? Help please...

Upvotes: 0

Views: 262

Answers (1)

Redbeard011010
Redbeard011010

Reputation: 964

You'll want to have a MySQL server instance installed (this may already be the case), then you can simply restore those backups. This link will help you with syntax for restoring databases from .sql files http://webcheatsheet.com/sql/mysql_backup_restore.php

Depending on the version of MySQL you have installed, and the version of MySQL the databases were created with, you may have to upgrade the databases. More information can be found here: https://dev.mysql.com/doc/mysql-enterprise-backup/3.8/en/restore-upgrade.html

Upvotes: 1

Related Questions