I'm not sure what additional information you are looking for.Lumpy Burgertushie wrote:hard to tell what you are doing from your description.
I did everything you said except for copying the old board files. I went with a fresh install.to install on a new server from a backup:
1. download all files from old server using ftp.
2. using whatever backup method you choose, make a backup of the database from the old server.
3. create new blank database on the new server.
4. using ftp, upload to the new server all the phpbb files/folders that you backed up before.
5. using phpmyadmin or whatever your host provides, do a import of your database backup to your new blank database.
that should do it.
When attempting to import the database through phpbyadmin, it results in the error "#1062 - Duplicate entry 'rand_seed_last_update' for key 'PRIMARY' "JimA wrote:Do you still have the original database running somewhere? Because it's preferable to use a database management tool like phpMyAdmin to make back-ups over phpBBs ACP backup system.
I have to admit, this has me completely baffled. Restoring a database this way should be the simplest of things.Error
-- -- Dumping data for table `phpbb_config` -- INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('active_sessions', '0', 0), ('allow_attachments', '1', 0), ('allow_autologin', '1', 0), ('allow_avatar', '1', 0), ('allow_avatar_local', '1', 0), ('allow_avatar_remote', '1', 0), ('allow_avatar_upload', '0', 0), ('allow_avatar_remote_upload', '0', 0), ('allow_bbcode', '1', 0), ('allow_birthdays', '0', 0), ('allow_bookmarks', '1', 0), ('allow_emailreuse', '0', 0), ('allow_forum_notify', '1', 0), ('allow_mass_pm', '1', 0), ('allow_name_chars', 'USERNAME_CHARS_ANY', 0), ('allow_namechange', '0', 0), ('allow_nocensors', '1', 0), ('allow_pm_attach', '0', 0), ('allow_pm_report', '1', 0), ('allow_post_flash', '1', 0), ('allow_post_links', '1', 0), ('allow_privmsg', '1', 0), ('allow_quick_reply', '1', 0), ('allow_sig', '1', 0), ('allow_sig_bbcode', '1', 0), ('allow_sig_flash', '0', 0), ('allow_sig_img', '1', 0), ('allow_sig_links', '1', 0), ('allow_sig_pm', '1', 0)[...]
MySQL said: Documentation
#1062 - Duplicate entry 'rand_seed_last_update' for key 'PRIMARY'
I am attempting to import it into the database that was populated when I installed phpBB. I tried clearing out all the data but leaving the fields intact hoping that would solve the problem, but no luck.Lumpy Burgertushie wrote:does your import sql file have the "drop table" command for each table?
and/or are you trying to import it to an already existing database?
Code: Select all
DROP TABLE IF EXISTS `phpbb_acl_groups`; CREATE TABLE IF NOT EXISTS `phpbb_acl_groups` (
This message on your site is not so niceDue to a bug in the phpBB software, we are having difficulty loading the board data. We are working on a solution.
CREATE TABLE IF NOT EXISTS
Yes.3Di wrote:Have you - by any chance - the possibility to recreate the original backup from phpmyadmin or a similar tool?
Which ones?Lighthope wrote:Update: Okay, got it fixed. Just needed to upload the old templates.
The proSilver and one other. We made a slight modification to them and (for some odd reason) the originals are not working correctly.3Di wrote:Which ones?Lighthope wrote:Update: Okay, got it fixed. Just needed to upload the old templates.
Commodore C64Lighthope wrote:Is that an Atari screen as your avatar?