WP on XAMPP USB – can't connect to database?

Update: still no luck, however 2 things popped out at me during research:
1. there is no ?> closing out the wp-config file (I added it). I removed all line breaks, too. Dropped DB, reinstalled, no change.
2. table wp_options doesn’t exist in wordpress db – should this have been generated on the install? Found reference to this table in another forum post where accessing the db was a problem – although not installed on local xampp

These are the only tables that exist in the db:
wp_commentmeta
wp_comments
wp_terms
wp_term_relationships
wp_term_taxonomy

You don’t nee the closing ?> for what it’s worth.

And it LOOKS like WP is able to write to the DB so that’s good (otherwise you wouldn’t have the tables you do have).

What version of PHP and SQL are you running?

Thank you for your response.

From phpinfo:
mysqlnd 5.0.8-dev – 20102224 – $Revision: 310735 $
PHP Version 5.3.8

Note that I finally got a list of missing tables after changing $cfg[‘ExecTimeLimit’] = 0; in xampp\phpMyAdmin\libraries\config.default.php – this gave it unlimited time to execute the repair as it had appeared to be running very slow.

Missing tables:
wp_users: Table ‘wordpress.wp_users’ doesn’t exist
wp_usermeta: Table ‘wordpress.wp_usermeta’ doesn’t exist
wp_posts: Table ‘wordpress.wp_posts’ doesn’t exist
wp_links: Table ‘wordpress.wp_links’ doesn’t exist
wp_options: Table ‘wordpress.wp_options’ doesn’t exist
wp_postmeta: Table ‘wordpress.wp_postmeta’ doesn’t exist

I re-downloaded the WP zip thinking perhaps something had been corrupted in the download. Ran the checksum on it and it was fine. Re-installed, etc. and no change.

Note that there is over 1.5 G left on thumb drive so it’s not a problem with capacity. I will try to install it to a WAMP system I have on another computer and see if I end up with the same issue.

Unfortunately, the point of putting it on the USB is that I use different systems between work and home and I really need it to be portable.

Okay, since you have nothing on this one, wipe the DB and reinstall THAT again (if the DB is empty, WP will just try to reinstall).

https://tamba2.org.uk/wordpress/usb/

@Ipenstu: I have done that at least 10 times with no change, only installs the same 5 tables.

@samuel B: Yes, I did what was indicated on that page. The instructions were the same as many other pages I reviewed to try to track down the issue.

Note that Apache, PHP, and MySQL work fine on the stick – have been using them for other sites as this is my testing environment.

I have installed WP on WAMP on my old XP machine and the install went without a hitch…
Perhaps I should just export the db and import into the xampp version?

I exported the db from the WAMP version on XP then imported to xampp and it seems to be working. I think the issue must be that the connection to the USB is slow and creating the tables gets timed out. May be time for a new USB stick, but would really like to figure out if this is really the problem and how to fix it.

I just did another install on usb stick to test
works well
you may be correct about the table creation

Yeah – something is timing out – I tried to install a plugin that was pretty large and it timed out, while a smaller plugin installed easily. I just downloaded the zip of the larger one and extracted under plugins, then activated it. It worked fine.

Not sure where the timeout occurs – I’ve looked at a few different files but nothing is really clear as to which timeout out applies where & when. Probably put in place as a security feature and is set just fine for a normal server.