Move A Duplicate Gallery to new database on same hosting/domain.

[benwa]

I have on gallery two categories... when you go to one gallery and then click the thumbnail for larger view and then continue to keep hitting next you begin to go back into the overall list of both categories...this is quite annoying.

So I thought to create a new database to list one gallery and keep the existing one for the current one... don't want to reinput so how do I duplicate the existing gallery into a new database and then I will just delete one of the categories to split the two.

Any help would be great... would be awesome if someone could figure out the image view to stay within the category you chose instead of going into them all.

Thanks!

Tried exporting the mysql and importing into the new database I created but keep getting this error (i changed the db name in the doc to the new ones name)...?

SQL query:

--
-- Database: `blah2`
--
CREATE DATABASE `blah2` DEFAULT CHARACTER SET ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

[Dennis+]

CREATE DATABASE `blah2` DEFAULT CHARACTER SET ;

Your SQL statement doesn't define a default character set (in other words: there should be more info on that line).

Try to remove the DEFAULT CHARACTER SET from the statement. Most likely a default character set has been set and will be used in this case.