.sql Database creation

  • bojimuncher

    (@bojimuncher)


    5 years, 6 months ago

    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)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 6 months ago

    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.