Not Solved [Error Message] Backups
#12
Not Solved
(2015-07-23, 07:35 PM)Ad Bakker Wrote:
(2015-07-23, 07:31 PM)SilentThief Wrote: Okay I unpacked it, but how do I repack it into the .sql.gz?

You don't need to repack it, phpMyAdmin import can also handle non-packed .sql files.

But the first thing now is to open the .sql file in a text editor. Then you must find that complete line starting with /* and ending with */ and delete it. Then save the file and try to import it in phpMyAdmin.

Can you show here the 1st 25 lines of the file?

-- MySQL dump 10.13  Distrib 5.1.57, for redhat-linux-gnu (x86_64)
--
-- Host: localhost    Database: a7707238_getRekt
-- ------------------------------------------------------
-- Server version	5.1.57
/*!40103 SET @[email protected]@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @[email protected]@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @[email protected]@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @[email protected]@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @[email protected]@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `mybb_adminlog`
--

DROP TABLE IF EXISTS `mybb_adminlog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mybb_adminlog` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `ipaddress` varbinary(16) NOT NULL DEFAULT '',
  `dateline` int(10) unsigned NOT NULL DEFAULT '0',
  `module` varchar(50) NOT NULL DEFAULT '',
  `action` varchar(50) NOT NULL DEFAULT '',
  `data` text NOT NULL,
  KEY `module` (`module`,`action`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
Reply


Messages In This Thread
Backups - by SilentThief - 2015-07-23, 03:36 PM
RE: Backups - by Ad Bakker - 2015-07-23, 03:57 PM
RE: Backups - by SilentThief - 2015-07-23, 05:45 PM
RE: Backups - by .m. - 2015-07-23, 06:04 PM
RE: Backups - by Ad Bakker - 2015-07-23, 06:07 PM
RE: Backups - by SilentThief - 2015-07-23, 06:18 PM
RE: Backups - by Ad Bakker - 2015-07-23, 07:00 PM
RE: Backups - by SilentThief - 2015-07-23, 07:01 PM
RE: Backups - by Ad Bakker - 2015-07-23, 07:11 PM
RE: Backups - by SilentThief - 2015-07-23, 07:31 PM
RE: Backups - by Ad Bakker - 2015-07-23, 07:35 PM
RE: Backups - by SilentThief - 2015-07-23, 08:56 PM
RE: Backups - by Ad Bakker - 2015-07-23, 09:08 PM
RE: Backups - by SilentThief - 2015-07-24, 12:22 AM
RE: Backups - by Ad Bakker - 2015-07-24, 07:47 AM
RE: Backups - by SilentThief - 2015-07-24, 04:01 PM
RE: Backups - by Ad Bakker - 2015-07-24, 04:22 PM
RE: Backups - by SilentThief - 2015-07-24, 04:59 PM
RE: Backups - by Ad Bakker - 2015-07-24, 06:45 PM
RE: Backups - by SilentThief - 2015-07-24, 07:31 PM
RE: Backups - by Ad Bakker - 2015-07-24, 07:55 PM
RE: Backups - by SilentThief - 2015-07-24, 09:28 PM
RE: Backups - by Ad Bakker - 2015-07-24, 09:34 PM
RE: Backups - by SilentThief - 2015-07-24, 10:45 PM
RE: Backups - by SilentThief - 2015-07-26, 02:06 AM
RE: Backups - by Ad Bakker - 2015-07-26, 08:04 AM
RE: Backups - by SilentThief - 2015-07-26, 03:18 PM
RE: Backups - by Ad Bakker - 2015-07-26, 03:33 PM
RE: Backups - by SilentThief - 2015-07-26, 03:38 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)