Client backup problems?

[rjerina]

I have a client that is having trouble restoring backups that he made. He hasnt given me too much detail yet, but this is the problem he is having. If this looks familiar, someone please help out.

I don't think the backups are backing up right because when I download a home/sql backup I can't even view it's contents and when I try to restore a SQL backup in cPanel it won't restore. All I see is a blank page :-/.

[rjerina]

i checked his database, it has stuff in it, so it isnt because he has no databases or anything. can anyone help?

[rjerina]

here are the errors in cpanel's error_log:

root@server1 [/usr/local/cpanel/logs]# tail -f error_log
Incorrectly built binary which accesses errno or h_errno directly. Needs to be fixed.
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'uvh_test'. Database exists'

gzip: /tmp/cpanel.TMP.cg6nMcg59i71lfLZ: not in gzip format
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'uvh_test'. Database exists'

gzip: /tmp/cpanel.TMP.Fc95JtPuYtyLOIkH: not in gzip format
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'uvh_test'. Database exists'

gzip: /tmp/cpanel.TMP.aucvi8qCSP64xqwm: not in gzip format

gzip: /tmp/cpanel.TMP.zHGbs8F3X2jvqYxe: not in gzip format

[pxn]

Yup rjerina works for UVH and so do i, the issue we are having i think is with GZIP but not sure where or how.

Any helpful advice is greatly appreciated.

[Website Rob]

Now this may sounds strange, but are you aware that before one can restore a db (from an off-site backup) the db (on the Server) must first be empty?

[rjerina]

Originally posted by Website Rob
Now this may sounds strange, but are you aware that before one can restore a db (from an off-site backup) the db (on the Server) must first be empty?

It's a backup from his account with us. And restoring it, i thought it was supposed to drop corresponding tables first?

[Website Rob]

Well, we all know where 'assuming' gets us.

As there is more than one way or method for doing a db backup, I find it easiest to just delete the Table and then upload the backup. Both are easily accomplished within phpMyAdmin -- unless the db is greater than 5 or so MB. For those I do an import using shell as most Server settings will time out on anything larger, when using phpMyAdmin.

Just wanted to mention that deleting the db setup is not what I meant, earlier -- deleting the db Table is what I actually meant. Most people are familiar with the difference, but thought I mention it anyway.

[rjerina]

it's weird though, on another server we tried this same situation, and it worked like it's expected to, and the databases were there i am pretty sure.

[anand]

Originally posted by rjerina
it's weird though, on another server we tried this same situation, and it worked like it's expected to, and the databases were there i am pretty sure.

As website rob said, "assuming" does create trouble

Originally posted by Website Rob
I do an import using shell as most Server settings will time out on anything larger, when using phpMyAdmin.

Shell indeed at times comes real handy to restore large db's. I also prefer to use shell to restore / backup huge db's.

[pxn]

Assuming he was not i have been working with mysql and PHP for 6 years now and know enough about it to tell you what it does, after testing the Database Backup Cpanel feature on another server i find that it adds a drop table if exist command into the top of the Backup file so once attempted to restore it would delete the tables.

And to top this off deleting the tables or DB on our server made no difference same results and problem, so next time you think someone is assuming why don't you check before you jump down his throat.

Also my thought are gzip because i try to restore one our GZIP archives on another server and it fails it does nothing just has the image restoring image, meaning that the gzip is creating corrupt archives. So we need to know how to correct this issue, thanks anyone who has some helpful advice.

Sincerely,
Jeremy Hewit
PxN President

/----------------------- Data Snippet from 2nd server -----/
--------------
DROP TABLE IF EXISTS tutorials
--------------

--------------
CREATE TABLE tutorials (
id int(10) unsigned NOT NULL auto_increment,
tutorial_name text,
tutorial text,
catergory text,
PRIMARY KEY (id)
) TYPE=MyISAM
--------------

--------------
INSERT INTO tutorials (id, tutorial_name, tutorial, catergory) VALUES (1,'test','test tut','testcat1')
--------------

--------------
INSERT INTO tutorials (id, tutorial_name, tutorial, catergory) VALUES (2,'test2','test tut','testcat2')
--------------

--------------
INSERT INTO tutorials (id, tutorial_name, tutorial, catergory) VALUES (3,'blizum','blamblam`','testcat3')
--------------

[pxn]

Sample Corrupted Archive the server is creating:
http://www.uvh.biz/arphp.gz

[anand]

Originally posted by pxn
Assuming he was not i have been working with mysql and PHP for 6 years now and know enough about it to tell you what it does, after testing the Database Backup Cpanel feature on another server i find that it adds a drop table if exist command into the top of the Backup file so once attempted to restore it would delete the tables.

And to top this off deleting the tables or DB on our server made no difference same results and problem, so next time you think someone is assuming why don't you check before you jump down his throat.

No one is jumping on anyone's throat here pxn. As for your 6 years of experience, good for you (if i were to compare your experience with your posts here to help people, i really won't like to even continue forward on this). I had no intention to offend rjerina in any manner. Besides my post was addressed to him and not you.

rjerina, if you are offended in any manner, please accept my apologies. I was just trying to point that assuming doesn't work most of the times. You need to double check and be sure thats all.

[anand]

Originally posted by rjerina
i checked his database, it has stuff in it, so it isnt because he has no databases or anything. can anyone help?

rjerina, include the cpanel build you are running.

Let me try to get a backup of some dbs through cpanel and c wat happens.

[anand]

ok here it is, mysql backup from cpanel, X theme.

WHM 8.8.0 cPanel 8.8.0-S74
RedHat 7.3 - WHM X v2.1.2

-- MySQL dump 9.09
--
-- Host: localhost    Database: xxxx_xxxx
---------------------------------------------------------
-- Server version    4.0.15-standard-log

--
-- Table structure for table `admins`
--

DROP TABLE IF EXISTS admins;
CREATE TABLE admins (
  admin_id int(11) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  dept varchar(50) NOT NULL default '',
  password varchar(20) NOT NULL default '',
  add_time datetime NOT NULL default '0000-00-00 00:00:00',
  flag int(11) NOT NULL default '0',
  PRIMARY KEY  (admin_id)
) TYPE=MyISAM;

--
-- Dumping data for table `admins`
--


--
-- Table structure for table `admintask`
--

DROP TABLE IF EXISTS admintask;
CREATE TABLE admintask (
  admintask_id int(11) NOT NULL auto_increment,
  admin_id int(11) NOT NULL default '0',
  task_id int(11) NOT NULL default '0',
  PRIMARY KEY  (admintask_id)
) TYPE=MyISAM;

--
-- Dumping data for table `admintask`
-- 

Part dump from a mysql backup generated by cpanel. The DROP looks in place at present.

Perhaps it would be better once we know which build we are talking about.

[pxn]

WHM 8.8.0 cPanel 8.8.0-R73
RedHat Enterprise 3 - WHM X v2.1.2

And he was not guessing was my point he talked it over with me his boss and then we concluded some conclusive facts before he posted, and yet again i agree no offense was intended by my post either if anyone was offended please accept my apology.