Title: .sql Database creation
Last modified: November 18, 2020

---

# .sql Database creation

 *  [bojimuncher](https://wordpress.org/support/users/bojimuncher/)
 * (@bojimuncher)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/sql-database-creation/)
 * Hi,
 * We recently cut ties with our WordPress site developer and were given a zip file
   of our site that was in process including a .sql file for the database that has
   the header “– MySQL dump 10.13 Distrib 5.6.49, for Linux (x86_64)
    –” in the .
   sql file. I am starting up a local Windows Server running Server 2019 with IIS
   and WordPress and would like to import that site as it was into our local environment.
   I’m thinking I would need to get the server set up, install IIS etc., and then
   copy over the zipped files replacing the fresh WP installation files, but how
   would I restore the database?
 * Thanks!

Viewing 1 replies (of 1 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [5 years, 6 months ago](https://wordpress.org/support/topic/sql-database-creation/#post-13678581)
 * You could use PHPMYADMIN to create a database and import the .sql file or do 
   this from the command line, though I’m not clear on how that’s done on Windows.
 * On a Linux server, it would be
 *     ```
       mysql -u root -p
          create database dbname;
          grant all on dbname.* to 'dbuser'@'localhost' identifed by 'dbpassword';
          exit;
       mysql -u root -p dbname < database.sql
       ```
   

Viewing 1 replies (of 1 total)

The topic ‘.sql Database creation’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [restore](https://wordpress.org/support/topic-tag/restore/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/)
 * 1 reply
 * 2 participants
 * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * Last activity: [5 years, 6 months ago](https://wordpress.org/support/topic/sql-database-creation/#post-13678581)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics