XF 1.4 Can't import db

[MohammadMorad]

I'm trying to import a db to my current site and somehow replace it, but this is what I get:

Error
SQL query:

-- -- Dumping data for table `EWRporta_blocks` -- INSERT INTO `EWRporta_blocks` (`block_id`, `title`, `version_string`, `version_id`, `url`, `install_callback_class`, `install_callback_method`, `uninstall_callback_class`, `uninstall_callback_method`, `cache`, `display`, `groups`, `locked`, `active`) VALUES ('BoardTotals', 'Forum Statistics', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', '+1 hours', 'show', '', 0, 1), ('FaceBook', 'Facebook FanBox', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', '+1 days', 'show', '', 0, 1), ('OnlineUsers', 'Members Online Now', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', 'now', 'show', '', 0, 1), ('RecentNews', 'Recent News Article', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', '+1 hours', 'show', '', 1, 1), ('RecentThreads', 'Recently Active Threads', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', 'now', 'show', '', 0, 1), ('SharePage', 'Share This Page', '1.0.0', 1, 'http://8wayrun.com/', '', '', '', '', '+1 days', 'show'[...]

MySQL said:

#1062 - Duplicate entry 'BoardTotals' for key 'PRIMARY'


edit: using phpmyadmin.

 

[Jake Bunce]

Phpmyadmin is generally unreliable for backup / restore operations. The recommended method is to use a shell command:

https://xenforo.com/community/resources/how-to-backup-and-restore-your-forum-linux-windows.359/

That error could mean that you need to empty the database before restoring. Or it could be a bad backup or a problem relating to phpmyadmin.