moiremusic

The easiest method would be to rename your old database to something like inspirot_wrdp1_old. Then try the import.

Good idea. But I tried this, and still get an error:

Error

SQL query:

--
-- Database: <code>inspirot_wrdp1</code>
--
-- --------------------------------------------------------
--
-- Table structure for table <code>wp_commentmeta</code>
--
CREATE TABLE IF NOT EXISTS <code>wp_commentmeta</code> (
<code>meta_id</code> bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
<code>comment_id</code> bigint( 20 ) unsigned NOT NULL default '0',
<code>meta_key</code> varchar( 255 ) default NULL ,
<code>meta_value</code> longtext,
PRIMARY KEY ( <code>meta_id</code> ) ,
KEY <code>comment_id</code> ( <code>comment_id</code> ) ,
KEY <code>meta_key</code> ( <code>meta_key</code> )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;

MySQL said: Documentation
#1046 - No database selected

You can’t create a new database with the same name as the old one.

Thanks, esmi. Then how do I alter the database manually and replace the old one?

Thank t-p. The link you sent makes perfect sense until the last step (“2. Put the backed-up SQL back into MySQL:”).

I was trying to use the Import tab. Is this wrong? I’m not really sure how to use the commands listed on that link:

user@linux:~/files/blog> mysql -h mysqlhostserver -u mysqlusername
 -p databasename < blog.bak.sql

Enter password: (enter your mysql password)
user@linux~/files/blog:>

And here are the default export and import settings:

Or I guess even one that tiles them horizontally like Google Images instead of vertically like Pinterest.

I guess I should be more specific about what I would ideally want:

1) A header image
2) A field of images below (either with title appearing on hover, or just always visible)
3) No sidebar on the front page, possibly info on the bottom
4) Links across the top or bottom of the image field to tagged articles
5) A fairly traditional article page.

Woothemes’ Object theme might not be a bad start, but their article page is far from what I’m after, and Woothemes are all built on 960 width pages, which just seems to be getting a little antiquated.

Thanks alithenake. Photoxibit hasn’t been updated for quite awhile and doesn’t work with anything later than WP 2.5.x. And unfortunately, the creator’s contact form is broken.

I’m just looking for any image gallery plugin that can be tweaked to offer the same functionality.

I’m having tons of trouble with this plugin. I don’t think a version has been released that works above WordPress 2.5x. And the contact form on Sterling’s site is broken.

Ah, perfect. Thanks.