2012-07-07, 08:14 PM
Basically i done a full backup from cpanel and 3 partial backups, But when i try and restore the database doesnt work and i only have 1 database section which is admin log, i hope someone can help me change with only a full backup from cpanel not a database backup from the mybb directly.
I also could do a partial backup but this is the only code in the database one
-- MySQL dump 10.13 Distrib 5.5.24, for Linux (x86_64)
--
-- Host: localhost Database: freegrim_mybb
-- ------------------------------------------------------
-- Server version 5.5.24-cll
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Table structure for table
--
DROP TABLE IF EXISTS
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE
KEY
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
Hope someone can help
help please
I also could do a partial backup but this is the only code in the database one
-- MySQL dump 10.13 Distrib 5.5.24, for Linux (x86_64)
--
-- Host: localhost Database: freegrim_mybb
-- ------------------------------------------------------
-- Server version 5.5.24-cll
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Table structure for table
freegrim_adminlog
--
DROP TABLE IF EXISTS
freegrim_adminlog
;/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE
freegrim_adminlog
(uid
int(10) unsigned NOT NULL DEFAULT '0',ipaddress
varchar(50) NOT NULL DEFAULT '',dateline
bigint(30) NOT NULL DEFAULT '0',module
varchar(50) NOT NULL DEFAULT '',action
varchar(50) NOT NULL DEFAULT '',data
text NOT NULL,KEY
module
(module
,action
)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
Hope someone can help
help please