persiandc
Junior Member
Posts: 42
Joined: Jun 2009
Reputation: 0
|
The problem Beckup
Hi friends, I once again mybb I upload and then for up to phpmyadmin import Beck Beck went to upload up to do but this will Error Please help :
Error
SQL query:
-- -- Dumping data for table `mybb_adminoptions` -- INSERT INTO `mybb_adminoptions` (`uid`, `cpstyle`, `codepress`, `notes`, `permissions`, `defaultviews`) VALUES (0, '', 1, '', 'a:5:{s:6:"config";a:16:{s:3:"tab";s:1:"0";s:8:"settings";s:1:"0";s:7:"banning";s:1:"0";s:14:"profile_fields";s:1:"0";s:7:"smilies";s:1:"0";s:8:"badwords";s:1:"0";s:6:"mycode";s:1:"0";s:9:"languages";s:1:"0";s:10:"post_icons";s:1:"0";s:14:"help_documents";s:1:"0";s:7:"plugins";s:1:"0";s:16:"attachment_types";s:1:"0";s:9:"mod_tools";s:1:"0";s:7:"spiders";s:1:"0";s:9:"calendars";s:1:"0";s:7:"warning";s:1:"0";}s:5:"forum";a:5:{s:3:"tab";s:1:"0";s:10:"management";s:1:"0";s:13:"announcements";s:1:"0";s:16:"moderation_queue";s:1:"0";s:11:"attachments";s:1:"0";}s:5:"style";a:3:{s:3:"tab";s:1:"0";s:6:"themes";s:1:"0";s:9:"templates";s:1:"0";}s:5:"tools";a:14:{s:3:"tab";s:1:"0";s:13:"system_health";s:1:"0";s:5:"cache";s:1:"0";s:5:"tasks";s:1:"0";s:8:"backupdb";s:1:"0";s:10:"optimizedb";s:1:"0";s:8:"adminlog";s:1:"0";[...]
MySQL said: Documentation
#1062 - Duplicate entry '0' for key 1
|
|
| 07-01-2009, 07:15 AM |
|
Polarbear541
Premium User
Posts: 1,191
Joined: Aug 2008
Reputation: 5
|
RE: The problem Beckup
You need to completely empty your mybb database before you can reinstall mybb.
Thanks, Polarbear541
MyBB SQA Team
|
|
| 07-05-2009, 01:22 AM |
|
Spyda
Premium User
Posts: 838
Joined: May 2008
Reputation: 8
|
RE: The problem Beckup
I think they are having troubles importing an old database. When you export the database, do so through phpMYadmin instead of the MyBB Acp. Then try to reimport to see if that works. Otherwise, your database is most likely corrupted.
|
|
| 07-08-2009, 03:05 AM |
|
wefobi
Junior Member
Posts: 49
Joined: Jul 2009
Reputation: 0
|
RE: The problem Beckup
For importing, exporting or editing the database i`m using a great tool from Germany. The MySQLDumper. I´ve never had any Problems using this tool.
Feel free to have a lokk at the feature list at: http://www.mysqldumper.de/en/features/
The Guy who coded the Dumper also Supports in English Language in his Support Board.
|
|
| 07-21-2009, 08:56 AM |
|
Spyda
Premium User
Posts: 838
Joined: May 2008
Reputation: 8
|
RE: The problem Beckup
(07-21-2009 08:56 AM)wefobi Wrote: For importing, exporting or editing the database i`m using a great tool from Germany. The MySQLDumper. I´ve never had any Problems using this tool.
Feel free to have a lokk at the feature list at: s
The Guy who coded the Dumper also Supports in English Language in his Support Board.
I use the same when trying to import databases that exceed the max. upload amount for phpmyadmin.
|
|
| 07-22-2009, 10:38 PM |
|
