Are the Full backup restore mysql database ????

[mrazh]

I make a full backup but when i restore the account

not give me the databases

Why ????

[kmsd]

Same here... I had to manually restore them. I thought the full backup included EVERYTHING for the account???

[kmsd]

I just downloaded and unzipped one. It has the databases, yes, but, they are empty files.
username_databasename.sql

Each is 0KB.
Mine are through remote FTP backups AND the manual full home backup.

Thanks,
kmsd

[cch]

Originally posted by kmsd
I just downloaded and unzipped one. It has the databases, yes, but, they are empty files.
username_databasename.sql

Each is 0KB.

Is it a cpanel bug? I still get 0k mysql when I download a full backup

thanks

[guru]

Same here. SQL are 0.

[eazistore]

Originally posted by mrazh
I make a full backup but when i restore the account

not give me the databases

Why ????

Hi marazh,

To my understanding and experience, I have try using FULL BACKUPS - Generate/Download a Full Backup.

This will download many folder which you never even seen via FTP before.

After a few trial, I discover that only HOME DIRECTORY - Download a home directory Backup

This will even backup the email accounts too. SQL databases are surely not backup.

To make sure databases are backup, you need to select this options at the cPanel backup utility.

Download a MySQL Database Backup - database name

The answer why I cannot answer. Probably the cPanel team could.

Rgds,
Vincent
http://www.eazistore.com

[kmsd]

I just reconfirmed it.
Manual downloads of a full backup through CPanel have no SQL. Remote full backups through CPanel have no SQL. Remote FTP backups through the cpbackup program have no SQL.

On top of that I have found that in order to backup using remote ftp backup and not get any disk quota errors each user needs to have AT LEAST double his/her free disk space to get a full backup in as you'll get disk quota exceeded errors for ones that don't; when I get those errors my nightly remote file is over a MB.

Has anyone opened up a bug report/support ticket on these issues?

Thanks,
kmsd

[chazzle]

This really sux.. I was wondering why when I restored a full backup the other day that the database was not restored. Why do I have backup running each night if my most important data is not being backed up??
Luckily I had a backup of the database on my local machine.
This would have been really bad.. Still is to those that dont know about it..

[yahoolane]

I have customers will full backups, We had a server
crash and burn.

When I upload the full backups, they do not restore
the make a directory but do not move to where they
belong.

The full mySQL directory is there, binary files.

How Do We Restore Full Backups!!!

[DuxAranea]

The problem I have intermittently is that the databses do get restored, but with no tables inside them! Empty databses. But only soetimes. Some databases do back up correctly, while others dont. I wonder if cpanel knows about this...

[yahoolane]

I have done full backups, and then downloaded
the gz file and unziped them and placed the binaries on
my mysql server. They are there I can see them
in the directory. and they have size.

The Question is not why the SQL databases dont
restore, for me it is more why does not Full Backup
Not Restore.

Need Full backup to Restore.
is my cpanel broken or is it something else.

[eazistore]

Originally posted by yahoolane
I have done full backups, and then downloaded
the gz file and unziped them and placed the binaries on
my mysql server. They are there I can see them
in the directory. and they have size.

The Question is not why the SQL databases dont
restore, for me it is more why does not Full Backup
Not Restore.

Need Full backup to Restore.
is my cpanel broken or is it something else.

Hi Yahoolane,

Have you try use the HOME DIRECTORY - Download a home directory Backup instead of FULL BACKUPS ?

I don't understand why it didn't restore but as when you do a restore, it'll just be a blank page and I have read the forum somewhere here that it's probably due to the file size too huge.

You need to restore the database by using Download a MySQL Database Backup - Restore database.

My understand is that Full Backup does not backup your databases.

If not, you can go to phpmyadmin via your cPanel to create database and import the database (data.sql) manually.

I believe your cPanel is not broken.
I wish you get your database fix.

Rgds,
Vincent
http://www.eazistore.com

[DuxAranea]

Uhhh whats the point of a full backup if it's not 'full'?

[yahoolane]

First for thoes of you who dont think full is full

Unzip the file on your HD, Winzip can do it.

you will see a homedir with all your stuff.

Then look for the mysql directory you will
see 3 file for each table/database these are the
structure, data, indexes. If you copy them
into a working mysql database data directory
and add the user. You will see that this is your data.

Now I have a Full backup I know it is full because
I can winzip the file and view it, How do we restore
the file automaticly.

[DuxAranea]

Then the problem is probably with the restoration script and not with the backup script. Good, we've established something. Hopefully maybe someone who actually works at cpanel will pick up on this.