data missing from sql backups
Hi,
Recently looked at the backup sql data fro a site and none of the data inserts are present in the sql file.
As you can see where the data dumping takes place, there is no data?
Is the data saved in another place?
Here's how it looks
-- MySQL dump 10.16 Distrib 10.1.4-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: mem_site
-- ------------------------------------------------------
-- Server version 10.1.2-MariaDB-wsrep-cll-lve
/*!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 `app_applications`
--
DROP TABLE IF EXISTS `app_applications`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `app_applications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`html` blob NOT NULL,
`date` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=456 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `app_applications`
--
LOCK TABLES `app_applications` WRITE;
/*!40000 ALTER TABLE `app_applications` DISABLE KEYS */;
/*!40000 ALTER TABLE `app_applications` ENABLE KEYS */;
UNLOCK TABLES;
-
Fixed: one table was empty and the other had the data on one row 0 -
Fixed: one table was empty and the other had the data on one row
Hello :) I'm happy to see you were able to address the issue. Thank you for updating us with the outcome.0
Please sign in to leave a comment.
Comments
2 comments