Title: Database import – need assistance Last modified: August 20, 2016 --- # Database import – need assistance * [comodo2010](https://wordpress.org/support/users/comodo2010/) * (@comodo2010) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/) * Hello * I recently moved a friends site to a new host, and forgot to back up her old database. Yes, stupid, I know. Anyway, I did get a hold of the dump file after a lot of mails back and forth with the hosting-company. * Name of file: Dump20111005.sql * Now, I need help with importing this into the new database without fucking everything up. Thing is, I know nothing about this, and her site really needs to be up now, because of work applications. Can someone assist me with this? * I am willing to grant full access to the right person. And will send waves of digital goodwill! * Site is found here: [http://www.monicasholm.com](http://www.monicasholm.com) Viewing 10 replies - 1 through 10 (of 10 total) * [Dhikra](https://wordpress.org/support/users/dhikra/) * (@dhikra) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338578) * You might want to follow the instructions from here: [http://codex.wordpress.org/Restoring_Your_Database_From_Backup](http://codex.wordpress.org/Restoring_Your_Database_From_Backup) * Thread Starter [comodo2010](https://wordpress.org/support/users/comodo2010/) * (@comodo2010) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338579) * Mhm, yeah, read that one, but dont you have to delete all the old tables first? And the variables you have to select when importing, I have no idea which ones to pick. utf-8? * Thread Starter [comodo2010](https://wordpress.org/support/users/comodo2010/) * (@comodo2010) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338580) * I got this error when trying to upload the .sql file. * Error SQL-query: * — — Current Database: `monicasholm` — CREATE DATABASE /*!32312 IF NOT EXISTS*/` monicasholm` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci */; * MySQL said: * #1044 – Access denied for user ‘monicspm’@’localhost’ to database ‘monicasholm’ * [Dhikra](https://wordpress.org/support/users/dhikra/) * (@dhikra) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338581) * Create a database with the same name, user, and password as the old one on the new server. This database will be empty. Then follow the instructions to restore the database via phpMyAdmin from the link I gave you. UTF-8 is the right encoding. * Thread Starter [comodo2010](https://wordpress.org/support/users/comodo2010/) * (@comodo2010) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338582) * New host allows 1 database only. So to create a new database I would have to delete the old one. * Are you saying I should do everything in this order: * 1. Delete database and remove all files from server. 2. Create new database 3. Import sql file 4. Install new WP 5. Upload old files via ftp 6. Activate “ old” theme * Then it should work fine? * [Dhikra](https://wordpress.org/support/users/dhikra/) * (@dhikra) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338584) * If the new site is identical to the old one (i.e. nothing changes, not even the url), then you don’t need to do all that. Just delete the database, create a new one with the same name, username, and password as the old one, and import the old one into it. It should work. * If it doesn’t, then post the errors you get in here. * Thread Starter [comodo2010](https://wordpress.org/support/users/comodo2010/) * (@comodo2010) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338587) * Ok did it, and got the old tables back in the new database. But wordpress dont seem to “understand” that they are there. Nothing shows up. * Do I need to reinstall WP and relink it to the database? * [Dhikra](https://wordpress.org/support/users/dhikra/) * (@dhikra) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338590) * Try to choose the same permalink structure you were using on the old site. * Thread Starter [comodo2010](https://wordpress.org/support/users/comodo2010/) * (@comodo2010) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338594) * Just had to update the php config file with the proper databasename -_- Now everything works. * Please call me terrible names as you please. * Thx for the effort Dhikra! * [Dhikra](https://wordpress.org/support/users/dhikra/) * (@dhikra) * [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338595) * That’s why I had told you to give it the same name 😉 * I’m glad you got it working! Viewing 10 replies - 1 through 10 (of 10 total) The topic ‘Database import – need assistance’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [Import](https://wordpress.org/support/topic-tag/import/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 10 replies * 2 participants * Last reply from: [Dhikra](https://wordpress.org/support/users/dhikra/) * Last activity: [14 years, 7 months ago](https://wordpress.org/support/topic/database-import-need-assistance/#post-2338595) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics