Cant backup one of my databases?

Client Joined: Dec 04, 2004 Posts: 757

Hello all in cpanel I try to backup a database but it only downloads a small file infact only about 300kb I know that the file should be around 5mb etc? I have other sites there that backup fine no problems etc.
has anyone have nay idea`s?
cheers
mrix

Sells PC To Pay For Divorce Joined: Posts: 5661

have you checked whats in the file and where it stops ?

Posted: Sun Jul 02, 2006 6:40 am

This is what is shows

-- MySQL dump 10.9
--
-- Host: localhost Database: mrix_nuke3
-- ------------------------------------------------------
-- Server version 4.1.19-standard

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

and thats all really
cheers
mrix

Posted: Sun Jul 02, 2006 6:49 am

thats not 300 kb and you know a backup doesnt look like that...
try to run the optimize and try the backup again....
and for the fun of it.....disable any security on your computer....just to rule out other reasons.. Smile

Posted: Sun Jul 02, 2006 7:00 am

In addition to what hitwalker suggested, you could go into phpmyadmin and "browse" the tables. If there is data in them then your dump definitely shouldn't look like that. What you are seeing is what happens when the database is empty. Do you have the right name for the database in your dump? You can also dump the database (export) from phpmyadmin. Try that and see what happens.