Title: Import wordpress database – SQL file…? Last modified: August 21, 2016 --- # Import wordpress database – SQL file…? * Resolved [mberrios74](https://wordpress.org/support/users/mberrios74/) * (@mberrios74) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/) * installed wordpress and the database to my laptop. Now site is ready to upload to host (Network Solutions) & I got started with the database. I created new clean database on their MyPHPadmin, now to import my wordpress site database. but, I can’t seem to locate appropriate .sql file with the wordpress database name. * do I need to create this sql file? how do I do this? extract the file within MySQL application? I do not have ANY familiarity with this app MySQL. Please help! * If I do not need to import a .sql file, what type of file needs to be imported? Thank you… Viewing 12 replies - 1 through 12 (of 12 total) * [Krishna](https://wordpress.org/support/users/1nexus/) * (@1nexus) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4269880) * While installing WordPress at your host’s server, the MySQL database also will be created. You can import the database from your local WordPress to your live site. A review of this file will be helpful: [http://codex.wordpress.org/Restoring_Your_Database_From_Backup](http://codex.wordpress.org/Restoring_Your_Database_From_Backup) * Thread Starter [mberrios74](https://wordpress.org/support/users/mberrios74/) * (@mberrios74) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4269903) * Is it required to install WordPress at my host’s server? * I thought I just had to import from my local WordPress site. But, I can’t find a SQL file on my local files. * [renjithmb22](https://wordpress.org/support/users/renjithmb22/) * (@renjithmb22) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4269909) * check the database name in your wp-config file then if you are using wamp or xamp , go its phpadmin select databases that match in your configuration then select EXPORT link to export the data you save generated(sql file) file and then upload it to the desired server. * you may copy local wordpress installation to desired server and do the changes in wp-config file if required. * Thread Starter [mberrios74](https://wordpress.org/support/users/mberrios74/) * (@mberrios74) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4269979) * Thanks. * I did not previously use WAMP. My windows computer launched MS WebMatrix and I ended up using that while I built the site. I do not see any phpadmin in WebMatrix. * So I decided to download WAMP. When I click on it to run it, it seems like nothing happens. I uninstalled and tried again. Nothing happens. There is no app button pinned to indicate it is even running. * Did the install go bad? What am I doing wrong? Should I be using a browser and going to localhost? * Thread Starter [mberrios74](https://wordpress.org/support/users/mberrios74/) * (@mberrios74) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4269985) * Update: since i could not progress on WAMP… I uploaded my wordpress files to my site. So now I’m getting the classic, “Error establishing database connection” instead of the site. * Would love to figure out a way, ANY WAY to create the SQL file for MYPHPadmin, or any other method that may improve this. I’ll be reading over all the install and database links again this evening. * Thank you. * [renjithmb22](https://wordpress.org/support/users/renjithmb22/) * (@renjithmb22) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4269992) * [http://www.microsoft.com/web/post/your-first-website-using-webmatrix](http://www.microsoft.com/web/post/your-first-website-using-webmatrix) * I believe you had developed site through above link.As you are using webmatrix( i use wamp) i googled to get some solution.But I was not found right solution( most results suggest we cannot export data from webmatrix). anyway you try to right click the desired database in webmatrix to get see if any options available. * ==================================================== Considering your case wamp will provide more flexible solutions to export data.you have to create site in wamp * for that 1.use this([http://www.homeandlearn.co.uk/php/php1p3.html](http://www.homeandlearn.co.uk/php/php1p3.html) or [http://www.youtube.com/watch?v=MsMaiHqkKkQ‎](http://www.youtube.com/watch?v=MsMaiHqkKkQ‎)) to make sure wamp webserver is up and running. * 2.if its fine go to phpmyadmin in wamp create desired(eg:yourdbname) database. * 3.copy your wordpress file to www(root folder(eg:wamp\www)) * 4.edit following in wp-config.php. define(‘DB_NAME’, ‘yourdbname’); * /** MySQL database username */ define(‘DB_USER’, ‘root’); * /** MySQL database password */ define(‘DB_PASSWORD’, ”); * /** MySQL hostname */ define(‘DB_HOST’, ‘localhost’); * 5.then go to browser typically [http://localhost/wordpressfolder](http://localhost/wordpressfolder) * that’s it .then enjoy the power of wordpress. * if you stuck over any of the above step feel free to contact me * [Krishna](https://wordpress.org/support/users/1nexus/) * (@1nexus) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4269995) * **renjithmb22**, * > if you stuck over any of the above step feel free to contact me * Limit support and helping out to these forums. Soliciting is not allowed here. [http://codex.wordpress.org/Forum_Welcome#Helping_Out](http://codex.wordpress.org/Forum_Welcome#Helping_Out) * [renjithmb22](https://wordpress.org/support/users/renjithmb22/) * (@renjithmb22) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4269996) * I meant this forum only…anyway thanks for the information. * Thread Starter [mberrios74](https://wordpress.org/support/users/mberrios74/) * (@mberrios74) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4270010) * WAMP won’t run on my Windows 7 OS. The icon is red instead of green. I’ve read many posts today about what is causing this. When I try to run the Apache on my WAMP I get an error saying port 80 is being used by “Server: Microsoft HTTPAPI/ 2.0”. There are also many posts and solutions regarding this port 80 error – so many that I am a bit discouraged. I have disabled my firewall, changed the port for Skype, uninstalled Dropbox. Also, I have IIS installed. Many different little programs all of which I fear to uninstall… REad about SSRS (SQL Reporting Service) but can’t find it so don’t know how to disable it. * Have confirmed I have VC++ packs that are essential to run Apache are installed… still its red and won’t run the phpmyadmin. Any WAMP/Windows warriors out there? * Thread Starter [mberrios74](https://wordpress.org/support/users/mberrios74/) * (@mberrios74) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4270017) * OK. I got WAMP running. Icon is green. Apache is running. * But the wordpress database is not listed. * Any suggestions? Why is it that this database does not get listed? Is it hiding somewhere in the file system? Why? * Thanks. * [renjithmb22](https://wordpress.org/support/users/renjithmb22/) * (@renjithmb22) * [12 years, 7 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4270029) * Sorry i was on veccation for 3 days. good to see that wamp is running on your machine.Now you won 70% of the task. * now you have to install wordpress on wamp server(since we can not take database from webmatrix) you may follow this tutorial. [http://www.wpexplorer.com/install-wordpress-in-windows-wamp/](http://www.wpexplorer.com/install-wordpress-in-windows-wamp/) * Thread Starter [mberrios74](https://wordpress.org/support/users/mberrios74/) * (@mberrios74) * [12 years, 6 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4270059) * Thank you for responding! I decided to install WordPress directly onto the host– they had a WordPress package so I opted to do that. * Now working on the host and the install seems good and the database is on there. * Now I have new problems with getting my home site address URL to work. I will post separately about that. * Thank you again for your help! Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Import wordpress database – SQL file…?’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 12 replies * 3 participants * Last reply from: [mberrios74](https://wordpress.org/support/users/mberrios74/) * Last activity: [12 years, 6 months ago](https://wordpress.org/support/topic/import-wordpress-database-sql-file/#post-4270059) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics