Title: ryans1's Replies | WordPress.org --- # ryans1 [ ](https://wordpress.org/support/users/ryans1/) * [Profile](https://wordpress.org/support/users/ryans1/) * [Topics Started](https://wordpress.org/support/users/ryans1/topics/) * [Replies Created](https://wordpress.org/support/users/ryans1/replies/) * [Reviews Written](https://wordpress.org/support/users/ryans1/reviews/) * [Topics Replied To](https://wordpress.org/support/users/ryans1/replied-to/) * [Engagements](https://wordpress.org/support/users/ryans1/engagements/) * [Favorites](https://wordpress.org/support/users/ryans1/favorites/) Search replies: ## Forum Replies Created Viewing 4 replies - 1 through 4 (of 4 total) * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [mysql database restored but wordpress acting like new instal](https://wordpress.org/support/topic/mysql-database-restored-but-wordpress-acting-like-new-instal/) * Thread Starter [ryans1](https://wordpress.org/support/users/ryans1/) * (@ryans1) * [18 years ago](https://wordpress.org/support/topic/mysql-database-restored-but-wordpress-acting-like-new-instal/#post-757950) * Thanks for you help man. Had you not shown me how to browse my post tables I would have not know my import was not working. * Turns out the import was never going to work anyway. Once i contacted them and said “I cant see my post tables and i think the back up is empty” they sent me another .sql file and just by looking at the file-size shows they sent me something wrong in the first place… 640 KB v’s 697 bytes!!!!! * Go’s to show some support people have no idea about diagnosing problems and would rather take the easy road out by saying its not a problem with ‘their’ side, go to wordpress support instead. * Thanks HEAPS, my last 3 months of work is not all lost. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [mysql database restored but wordpress acting like new instal](https://wordpress.org/support/topic/mysql-database-restored-but-wordpress-acting-like-new-instal/) * Thread Starter [ryans1](https://wordpress.org/support/users/ryans1/) * (@ryans1) * [18 years ago](https://wordpress.org/support/topic/mysql-database-restored-but-wordpress-acting-like-new-instal/#post-757770) * Yes it does help, I can see the posts once I click on browse…that was simple… I don’t know why my provider could have told me that before. * Anyway none of my posts are there. Either I’m not restoring properly, which i would be surprised because that seems simple too… Import…locate .sql file and press go. But I’m getting all that strange code so i think I’ll call up my provider again and ask them what it means and to walk me through a restore or if the . sql file is actually empty!?! * Thanks for the help. Now i know what to ask them for. * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [mysql database restored but wordpress acting like new instal](https://wordpress.org/support/topic/mysql-database-restored-but-wordpress-acting-like-new-instal/) * Thread Starter [ryans1](https://wordpress.org/support/users/ryans1/) * (@ryans1) * [18 years ago](https://wordpress.org/support/topic/mysql-database-restored-but-wordpress-acting-like-new-instal/#post-757763) * This is what I asked my provider… can i actually see my posts… but he just said the database is just code, you cant see your posts… so what would I look for to see if i have any of the old posts restored. * Also, I don’t know if this helps but when i restore the .sql file i get the following message: * Import has been successfully finished, 8 queries executed. * SQL query: — MySQL dump 10.9 — — Host: p50mysql83.secureserver.net Database: ryansWHC — —————————————————— — Server version 5.0.45-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT =@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows)./*! 40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows). /*!40101 SET @OLD_COLLATION_CONNECTION= @@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows)./*! 40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows)./*! 40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;# MySQL returned an empty result set (i.e. zero rows). /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;# MySQL returned an empty result set (i.e. zero rows)./*! 40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ */;# MySQL returned an empty result set (i.e. zero rows). /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;# MySQL returned an empty result set (i.e. zero rows). * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [mysql database restored but wordpress acting like new instal](https://wordpress.org/support/topic/mysql-database-restored-but-wordpress-acting-like-new-instal/) * Thread Starter [ryans1](https://wordpress.org/support/users/ryans1/) * (@ryans1) * [18 years ago](https://wordpress.org/support/topic/mysql-database-restored-but-wordpress-acting-like-new-instal/#post-757757) * Hi thanks Ivovic, gave me something more to look at since i am really lost now, but I still don’t see anything wrong. I had created a new database to restore the .sql to, so i had to change the hostname from p41mysql119.secureserver.net to p41mysql31.secureserver.net otherwise i get a database location error with‘ localhost’. Now it takes me to a new wordpress blog. * I went into phpMyAdmin and i can see 10 tables wp_comments, wp_links, wp_options etc. and I can see this code in my current wp-config $table_prefix = ‘wp_’; so it looks like it is good?!? * What else can I do? I spent heaps of time on this website/blog and am really regretting deleting it! Viewing 4 replies - 1 through 4 (of 4 total)