I just moved to a new host and I got a backup of my SQL dump stuff luckily tonight after reading I needed it, I had already backed up my old Coppermine files so those were already uploaded.
So, I went to "restore the mySQL table by running the queries of the dump files you created in step 2" as instructed, and it gives me this error:
Error
SQL query:
-- phpMyAdmin SQL Dump
-- version 2.9.0.2
--
http://www.phpmyadmin.net--
-- Host: localhost
-- Generation Time: May 09, 2007 at 10:43 PM
-- Server version: 4.1.22
-- PHP Version: 4.4.2
--
-- Database: `starry_cm`
--
-- --------------------------------------------------------
--
-- Table structure for table `cpg145_albums`
--
CREATE TABLE `cpg145_albums` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',
`uploads` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`comments` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`votes` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`pos` int( 11 ) NOT NULL default '0',
`category` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`keyword` varchar( 50 ) default NULL ,
`alb_password` varchar( 32 ) default NULL ,
`alb_password_hint` text,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =47;
MySQL said: Documentation
#1050 - Table 'cpg145_albums' already exists
And my Coppermine gallery just seems to be blank,
http://melodyjustine.com/cm/Doesnt seem like the dump worked...
Any help would be appreciated. I've been searching/reading for hours. Thanks.