Have you reviewed Moving_WordPress?
Thanks. I will go thorough this.
I looked at lots of the Forum postings but I missed this.
Hi Esmi,
Thanks for this. useful but no solution.
But when I compare the original and local dB lists of file I see that the local version has exactly twice as many. The original version has 11 files in the format wp_xzwoxz_commentmeta, wp_xzwoxz_comments, wp_xzwoxz_links, etc. The local (copied) version has the same PLUS 11 more without the formatwp_commentmeta`, wp_comments, etc.
Sounds like duplication but how, where ?
I cannot find any mention of this problem anywhere on the web.
S
Are you talking about files or database tables?
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.
What are you using to create the db export/backup file? Have you confirmed that the wp_xzwoxz_comments table exists on the original install?
Hi Esmi,
On the working system the dB is called find50 (11) and it has 11
tables – `comments, links, etc.
I select this dB and then select Export.
Strangely the file that appears in my download folder is find50find50.sql. so the download file name is not the same name
as that of the db that I selected in my live system….
I wonder why ?
any thoughts ?
S
I select this dB and then select Export.
Is this using Phpmyadmin?
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.
I’m not sure why you are getting find50find50 either – although I suspect that it is being caused by something in the remote server’s setup. A quick fix might to ensure that the new database is called find50find50 initially, then you might be able to amend its name later on – after the import has been completed.
I have created a local dB calledfind50find50 and attempted to
import the downloaded file find50find50.sql but then I get
the error message:
MySQL said: Documentation
#1146 – Table ‘find50find50.wp_xzwoxz_comments’ doesn’t exist
so I think my next step is to find if the downloaded file is corrupted.
the best way I can think of is to upload the exact same file to the
same place – but a slightly different dB name as I do not want to screw
up my web site.
any suggestions for ways I might check the dB file for corruption ?
or what the error message might mean ?
any suggestions for ways I might check the dB file for corruption ?
Noe that I can think of. 🙁
or what the error message might mean ?
It implies that either the wp_comments table is missing or the name of the table doesn’t match the other entries in the .sql file.
Can you confirm if there is any wp_comments table in your new database?
can you check the database backup file and see if you have a block similar to the following:
DROP TABLE IF EXISTS'wp_comments';
CREATE TABLE IF NOT EXISTS <code>wp_comments</code> (
<code>comment_ID</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,
<code>comment_post_ID</code> bigint(20) unsigned NOT NULL DEFAULT '0',
<code>comment_author</code> tinytext NOT NULL,
<code>comment_author_email</code> varchar(100) NOT NULL DEFAULT '',
<code>comment_author_url</code> varchar(200) NOT NULL DEFAULT '',
<code>comment_author_IP</code> varchar(100) NOT NULL DEFAULT '',
<code>comment_date</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
<code>comment_date_gmt</code> datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
<code>comment_content</code> text NOT NULL,
<code>comment_karma</code> int(11) NOT NULL DEFAULT '0',
<code>comment_approved</code> varchar(20) NOT NULL DEFAULT '1',
<code>comment_agent</code> varchar(255) NOT NULL DEFAULT '',
<code>comment_type</code> varchar(20) NOT NULL DEFAULT '',
<code>comment_parent</code> bigint(20) unsigned NOT NULL DEFAULT '0',
<code>user_id</code> bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (<code>comment_ID</code>),
KEY <code>comment_post_ID</code> (<code>comment_post_ID</code>),
KEY <code>comment_approved_date_gmt</code> (<code>comment_approved</code>,<code>comment_date_gmt</code>),
KEY <code>comment_date_gmt</code> (<code>comment_date_gmt</code>),
KEY <code>comment_parent</code> (<code>comment_parent</code>)
) TYPE=MyISAM AUTO_INCREMENT=1923 DEFAULT CHARSET=latin1;
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
============================================
wp_xzwoxz_* comes from DreamHost. When you use our 1-click installer, we slap on a random string to your prefix.
It sounds like you install WP, then imported our DB, so make sure your wp-config.php has “wp_xzwoxz_” as the DB Prefix for the imported posts to work.
wp_xzwoxz_* comes from DreamHost. When you use our 1-click installer, we slap on a random string to your prefix.
thanks for this. useful to know.
It sounds like you install WP, then imported our DB,
well I did *finally* manage to import it but I still suspect problems
with the dB exported as my Dhost dB is calledfind50and the downloaded file gets namedfind50find50` – why ?/ does it matter ?
The main problem I have when importing it locally is that I usually get
error #1146 – any ideas why ?
so make sure your wp-config.php has “wp_xzwoxz_” as the DB Prefix for the imported posts to work
OK. This sounds promising.
Can you pl give me more detail ?
eg the dB I create should include in the name “wp_xzw..” ?
or I should pre-create those Tables in the dB ??
S.
