https://www.icyphoenix.com/viewtopic.php?f=1&t=7755&p=52285#p52285
-----------------------------------
spydie
Mon 04 Apr, 2011 15:42

Re: Some News About Icy Phoenix Development - New Users Class
-----------------------------------
DB backup is working fine for me on Local  - Xampp.

checking restore now

Restore has the same problems as ever. Duplicate entrys for primary Keys in Bbcode

[spoiler]SQL ERROR [ mysql4 ]

Duplicate entry '3' for key 'PRIMARY' [1062]

SQL

INSERT INTO mods_bbcodes (bbcode_id, bbcode_tag, bbcode_helpline, display_on_posting, bbcode_match, bbcode_tpl, first_pass_match, first_pass_replace, second_pass_match, second_pass_replace) VALUES (3, 'yy3', '', 0, '[yy3]{TEXT}[/yy3]', '<object style=\"margin:0px\" width=\"620\" height=\"500\">\n <param name=\"movie\" value=\"http://static.slideshare.net/swf/ssplayer2.swf?{TEXT}\" />\n <param name=\"allowFullScreen\" value=\"true\"/>\n <param name=\"allowScriptAccess\" value=\"always\"/>\n <embed src=\"http://static.slideshare.net/swf/ssplayer2.swf?{TEXT}\" type=\"application/x-shockwave-flash\" allowscriptaccess=\"always\" allowfullscreen=\"true\" width=\"620\" height=\"500\"></embed>\n </object>', '!\\[yy3\\](.*?)\\[/yy3\\]!ies', '\'[yy3]\'.str_replace(array(\"\\r\\n\", \'\\\"\', \'\\\'\', \'(\', \')\'), array(\"\\n\", \'\"\', \''\', \'(\', \')\'), trim(\'${1}\')).\'[/yy3]\'', '!\\[yy3\\](.*?)\\[/yy3\\]!s', '<object style=\"margin:0px\" width=\"620\" height=\"500\">\n <param name=\"movie\" value=\"http://static.slideshare.net/swf/ssplayer2.swf?${1}\" />\n <param name=\"allowFullScreen\" value=\"true\"/>\n <param name=\"allowScriptAccess\" value=\"always\"/>\n <embed src=\"http://static.slideshare.net/swf/ssplayer2.swf?${1}\" type=\"application/x-shockwave-flash\" allowscriptaccess=\"always\" allowfullscreen=\"true\" width=\"620\" height=\"500\"></embed>\n </object>')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 289
CALL: sql_db->sql_error()

FILE: adm/admin_db_backup.php
LINE: 391
CALL: sql_db->sql_query()
[/spoiler]


BTW :

Recomendation. I don´t know if you like the idea MG.

I recomend, when DB Backup and Restore is fixed, to maybe include a Cron Job for DB Backup. So Users can setup an automatic DB Backup. 

I´m running this with MysqlDumper on my sites. So if something goes wrong, you´ll never loose more when 1-2 days


