https://www.icyphoenix.com/viewtopic.php?f=35&t=9192
-----------------------------------
Costa
Sat 25 Jan, 2014 10:43

Backup Problem
-----------------------------------
Hi.
Since I moved my phoenix forum to another hosting provider, with the latest mysql/php versions, I get the following error, during backing up the site: 

Backup from ACP (Icy Phoenix Administration)
DB And Security/DB Backup/ and I select all table

[code linenumbers=false]Critical Error!
message_die() was called multiple times.
________________________________________
Error #2 
SQL ERROR [ mysql ]

[0]

BACKTRACE

FILE: includes/functions.php
LINE: 6092
CALL: sql_db->sql_error()

FILE: adm/admin_db_backup.php
LINE: 114
CALL: message_die()



Line : 977
File : /var/zpanel/hostdata/kdidonis/public_html/a33_gr/includes/db/mysql.php 
[/code]
Is this a known issue, or I should resolve this with the provider?


[hr]
www.a33.gr

Version of Icy Phoenix: 	2.0.0.86 	  	 
Version of PHP: 	5.3.10-1ubuntu3.9 	Version of MySQL: 	5.5.35-0ubuntu0.12.04.1-log
Size of the database: 	[b]563.59 MB[/b] 	Gzip compression: 	ON

[hr]
The same problem
www.acad.gr

Version of Icy Phoenix: 	1.3.24.77 	  	 
Version of PHP: 	5.3.10-1ubuntu3.9 	Version of MySQL: 	5.5.35-0ubuntu0.12.04.1-log
Size of the database: 	[b]9.03 MB[/b] 	Gzip compression: 	ON


-----------------------------------
mort
Sat 25 Jan, 2014 11:16

Re: Backup Problem
-----------------------------------
Well, I'm not having a problem backing up with v2.0.1.87 so maybe you could try grabbing the latest admin_db_backup.php from GIT-HUB?

Maybe admin_db_utilities.php too?

Or I'll post mine here if it helps?

I understand that there were some problems with v1.3.24.77 

And Maybe your DB is too big for v2.*

Preferably - The best way is to download and install mysqldumper for BIG databases.  :mryellow:


-----------------------------------
TheSteffen
Mon 27 Jan, 2014 17:24

Re: Backup Problem
-----------------------------------
I still prefer mysqldumper for such huge DBs

Anyway, can you for me something that sometimes helped me.

Go into ACP
Click left on "DB And Security"
Make a right click on "DB Backup" and say open in a new tap.

Now you get "admin_db_backup.php?mode=backup&sid=yoursid" without header.

Give it another try please ;-)


-----------------------------------
Mighty Gorgon
Mon 27 Jan, 2014 23:51

Re: Backup Problem
-----------------------------------
Unfortunately there isn't an easy way to make a backup within Icy Phoenix. That script has been coded just for small DB.

There could be a limit added by your host which doesn't allow to download the DB once it is backed up... I would do the backup by using MySQLDumper or phpMyAdmin, as it is still the best way to go. :cry:


