Title: aaltodesign's Replies | WordPress.org --- # aaltodesign [ ](https://wordpress.org/support/users/aaltodesign/) * [Profile](https://wordpress.org/support/users/aaltodesign/) * [Topics Started](https://wordpress.org/support/users/aaltodesign/topics/) * [Replies Created](https://wordpress.org/support/users/aaltodesign/replies/) * [Reviews Written](https://wordpress.org/support/users/aaltodesign/reviews/) * [Topics Replied To](https://wordpress.org/support/users/aaltodesign/replied-to/) * [Engagements](https://wordpress.org/support/users/aaltodesign/engagements/) * [Favorites](https://wordpress.org/support/users/aaltodesign/favorites/) Search replies: ## Forum Replies Created Viewing 9 replies - 1 through 9 (of 9 total) * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [Where has my dBase gone ?](https://wordpress.org/support/topic/where-has-my-dbase-gone/) * Thread Starter [aaltodesign](https://wordpress.org/support/users/aaltodesign/) * (@aaltodesign) * [12 years, 10 months ago](https://wordpress.org/support/topic/where-has-my-dbase-gone/page/2/#post-3892311) * 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 ? * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [Where has my dBase gone ?](https://wordpress.org/support/topic/where-has-my-dbase-gone/) * Thread Starter [aaltodesign](https://wordpress.org/support/users/aaltodesign/) * (@aaltodesign) * [12 years, 10 months ago](https://wordpress.org/support/topic/where-has-my-dbase-gone/#post-3892264) * _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 D`host dB is called`find50`and the downloaded file gets named`find50find50` – 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. * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [Where has my dBase gone ?](https://wordpress.org/support/topic/where-has-my-dbase-gone/) * Thread Starter [aaltodesign](https://wordpress.org/support/users/aaltodesign/) * (@aaltodesign) * [12 years, 10 months ago](https://wordpress.org/support/topic/where-has-my-dbase-gone/#post-3892249) * 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_posts`I 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 ============================================ * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [Where has my dBase gone ?](https://wordpress.org/support/topic/where-has-my-dbase-gone/) * Thread Starter [aaltodesign](https://wordpress.org/support/users/aaltodesign/) * (@aaltodesign) * [12 years, 10 months ago](https://wordpress.org/support/topic/where-has-my-dbase-gone/#post-3892245) * I have created a local dB called`find50find50` 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 ? * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [Where has my dBase gone ?](https://wordpress.org/support/topic/where-has-my-dbase-gone/) * Thread Starter [aaltodesign](https://wordpress.org/support/users/aaltodesign/) * (@aaltodesign) * [12 years, 10 months ago](https://wordpress.org/support/topic/where-has-my-dbase-gone/#post-3892242) * 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. * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [Where has my dBase gone ?](https://wordpress.org/support/topic/where-has-my-dbase-gone/) * Thread Starter [aaltodesign](https://wordpress.org/support/users/aaltodesign/) * (@aaltodesign) * [12 years, 10 months ago](https://wordpress.org/support/topic/where-has-my-dbase-gone/#post-3892238) * 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 * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [Where has my dBase gone ?](https://wordpress.org/support/topic/where-has-my-dbase-gone/) * Thread Starter [aaltodesign](https://wordpress.org/support/users/aaltodesign/) * (@aaltodesign) * [12 years, 10 months ago](https://wordpress.org/support/topic/where-has-my-dbase-gone/#post-3892236) * 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. * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [Where has my dBase gone ?](https://wordpress.org/support/topic/where-has-my-dbase-gone/) * Thread Starter [aaltodesign](https://wordpress.org/support/users/aaltodesign/) * (@aaltodesign) * [12 years, 10 months ago](https://wordpress.org/support/topic/where-has-my-dbase-gone/#post-3892174) * 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 format`wp_commentmeta`, wp_comments, etc. * Sounds like duplication but how, where ? * I cannot find any mention of this problem anywhere on the web. * S * Forum: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) In reply to: [Where has my dBase gone ?](https://wordpress.org/support/topic/where-has-my-dbase-gone/) * Thread Starter [aaltodesign](https://wordpress.org/support/users/aaltodesign/) * (@aaltodesign) * [12 years, 10 months ago](https://wordpress.org/support/topic/where-has-my-dbase-gone/#post-3892079) * Thanks. I will go thorough this. * I looked at lots of the Forum postings but I missed this. Viewing 9 replies - 1 through 9 (of 9 total)