ryans1

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.

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.

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).

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!