Icy Phoenix

Old Support Topics - Backup Problem

Costa [ Sat 25 Jan, 2014 10:43 ]
Post subject: 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: [Hide] [Select]

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

Is this a known issue, or I should resolve this with the provider?

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: 563.59 MB Gzip compression: ON

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: 9.03 MB Gzip compression: ON

mort [ Sat 25 Jan, 2014 11:16 ]
Post subject: 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.

TheSteffen [ Mon 27 Jan, 2014 17:24 ]
Post subject: 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 ]
Post subject: 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.