aaltodesign

Phew – big learning curve.

I now understand the need to edit the wp-onfig
and amend the $table_prefix to wp_xzwoxz_

I have copied the exact table prefix from my live site
wp-config file and put it in my local wp-config file.
But when I attempt to open the localhost site I get a
blank page with no error message……

any ideas what I might try next ?

I have now managed to create a local dB called find50, which contains
the downloaded .sql file, and I can access it from WP Admin. BUT in WP Admin I can only see the Hello World post and any mods that I make now.
What I cannot see are the historic posts that *are* in the dB. I know
that they are there because I can see them via phpMyAdmin. Below is
the list of tables/structure that can be seen in the left hand side of
phpMyAdmin for find50.

When I look in Structure wp_xzwoxz_postsI can see my historic posts (not viewable via WPAdmin) and when I examine Structure wp_posts I can see the Hello World post ( which *is* viewable via WPAdmin)

any idea why it is creating 2 versions of these tables ?
and why the older posts might not be visible ?
================================
find50 (22)

Structure wp_commentmeta
Structure wp_comments
Structure wp_links
Structure wp_options
Structure wp_postmeta
Structure wp_posts
Structure wp_terms
Structure wp_term_relationships
Structure wp_term_taxonomy
Structure wp_usermeta
Structure wp_users
Structure wp_xzwoxz_commentmeta
Structure wp_xzwoxz_comments
Structure wp_xzwoxz_links
Structure wp_xzwoxz_options
Structure wp_xzwoxz_postmeta
Structure wp_xzwoxz_posts
Structure wp_xzwoxz_terms
Structure wp_xzwoxz_term_relationships
Structure wp_xzwoxz_term_taxonomy
Structure wp_xzwoxz_usermeta
Structure wp_xzwoxz_users
============================================

esmi,
yup. I use phpMyAdmin for both the export from my live site and to import
into my local site. They are both the same rev no ( 3.x.x).
My host company Dreamhost cannot tell me why when I select a dB named
find50 I get a download file named find50find50.sql.

Right now I am attempting to reload the downloaded dB back into a newly
created dB on my live site. The idea is to see if I will get the same
error as I do on my local site.

Great – I now have to master loading via FTP as the file is too big ;<

Hi Raajen,
thanks for posting.

I did think that the wp-config.php was the problem for a while but I can access the dB find50 from WP Admin. The problem is that I want to load a copy of my live site locally. When I attempt to load the downloaded .sql file locally I get the error message: #1146. blah, blah.

goodness – 2/3 days on this already.

thanks for all your help.
S.

Hi Esmi,
Thanks for following up.

I think that the issue I mentioned above is not the problem
as I see the same Table structure in a dB that is working ok.

I am now trying to Import into my local dB the find50.sql file
that I have Exported from my working dB. I am getting a message:

Error
SQL query:
— — Database: find50 — — — Dumping data for table wp_xzwoxz_commentmeta — — — Dumping data for table wp_xzwoxz_comments — INSERT INTO wp_xzwoxz_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, etc, etc

Followed by
MySQL said:
#1146 – Table ‘find50find50.wp_xzwoxz_comments’ doesn’t exist

I have looked everywhere for some info on this error but cannot find
anything….any ideas ?

S.

Thanks. I will go thorough this.

I looked at lots of the Forum postings but I missed this.