WordPress.org

Ready to get started?Download WordPress

Forums

Where has my dBase gone ? (17 posts)

  1. aaltodesign
    Member
    Posted 9 months ago #

    Hi,
    I am trying to get a copy of my live site running on my local PC
    but I cannot link to a copy of the original site dB. I am running
    WAMP 2.0 on Win 7.

    1. I installed WAMP and WP 3.5.2 locally.
    2. I down loaded live site dB from Dreamhost using phpMyAdMin
    3. On my PC I created a dB with the same name using phpMyAdMin
    and successfully loaded the downloaded dB ie no error message.
    4. I logged into localhost WP-Admin and see Hello World ;<
    ie no info/data from the downloaded db BUT I do have an empty dB.
    5. repeat process incl restart Wampserver 2.0- many times.
    same result.....
    Any ideas why I cannot see the dB on my local install ?

  2. esmi
    Theme Diva & Forum Moderator
    Posted 9 months ago #

    Have you reviewed Moving_WordPress?

  3. aaltodesign
    Member
    Posted 9 months ago #

    Thanks. I will go thorough this.

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

  4. aaltodesign
    Member
    Posted 9 months ago #

    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

  5. esmi
    Theme Diva & Forum Moderator
    Posted 9 months ago #

    Are you talking about files or database tables?

  6. aaltodesign
    Member
    Posted 9 months ago #

    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.

  7. esmi
    Theme Diva & Forum Moderator
    Posted 9 months ago #

    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?

  8. aaltodesign
    Member
    Posted 9 months ago #

    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

  9. esmi
    Theme Diva & Forum Moderator
    Posted 9 months ago #

    I select this dB and then select Export.

    Is this using Phpmyadmin?

  10. aaltodesign
    Member
    Posted 9 months ago #

    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.

  11. esmi
    Theme Diva & Forum Moderator
    Posted 9 months ago #

    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.

  12. aaltodesign
    Member
    Posted 9 months ago #

    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 ?

  13. esmi
    Theme Diva & Forum Moderator
    Posted 9 months ago #

    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;
  14. aaltodesign
    Member
    Posted 9 months ago #

    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
    ============================================

  15. Ipstenu-DH
    DreamHost Rep
    Posted 9 months ago #

    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.

  16. aaltodesign
    Member
    Posted 9 months ago #

    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.

  17. aaltodesign
    Member
    Posted 9 months ago #

    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 ?

Reply

You must log in to post.

About this Topic