Not Solved [Error Message] Backups
#11
Not Solved
(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?
Regards, Ad Bakker (NL)
Reply
#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
#13
Not Solved
To start with, you could completely delete the line which caused the error message:


/*!40103 SET @[email protected]@TIME_ZONE */;


And then try to load the backup again.

But I fear that all the lines starting with /* and ending with */ must be removed. That cannot be done with a normal text editor. With knowledge of unix this will be possible, otherwise a small php program can handle that.

How large is the .sql file?
Regards, Ad Bakker (NL)
Reply
#14
Not Solved
(2015-07-23, 09:08 PM)Ad Bakker Wrote: To start with, you could completely delete the line which caused the error message:


/*!40103 SET @[email protected]@TIME_ZONE */;


And then try to load the backup again.

But I fear that all the lines starting with /* and ending with */ must be removed. That cannot be done with a normal text editor. With knowledge of unix this will be possible, otherwise a small php program can handle that.

How large is the .sql file?

3.17 MB

And it starts loading and then goes to a complete white page. I had this problem before with .sql files.
Reply
#15
Not Solved
(2015-07-24, 12:22 AM)SilentThief Wrote: 3.17 MB

I think you still have my e-mail address. Can you send it as e-mail attachment?

I will see that I can remove all these weird lines.
Regards, Ad Bakker (NL)
Reply
#16
Not Solved
(2015-07-24, 07:47 AM)Ad Bakker Wrote:
(2015-07-24, 12:22 AM)SilentThief Wrote: 3.17 MB

I think you still have my e-mail address. Can you send it as e-mail attachment?

I will see that I can remove all these weird lines.

I can, but the problem still stands that I get a white screen every time I upload a .sql.
Is there anyway I can try to repack it and see if that works?
Reply
#17
Not Solved
(2015-07-24, 04:01 PM)SilentThief Wrote: Is there anyway I can try to repack it and see if that works?

That's what I want to achieve by removing all lines that start with /* and end with */ (these are intended as comment lines I think, but they still cause trouble).
Regards, Ad Bakker (NL)
Reply
#18
Not Solved
(2015-07-24, 04:22 PM)Ad Bakker Wrote:
(2015-07-24, 04:01 PM)SilentThief Wrote: Is there anyway I can try to repack it and see if that works?

That's what I want to achieve by removing all lines that start with /* and end with */ (these are intended as comment lines I think, but they still cause trouble).

E-Mailing it to you now.
Reply
#19
Not Solved
(2015-07-24, 04:59 PM)SilentThief Wrote: E-Mailing it to you now.

I received it, and changed all lines starting with /* into real comment (lines starting wit --).
I imported this file into my database without any errors. I sent it back by e-mail, try it.
Regards, Ad Bakker (NL)
Reply
#20
Not Solved
(2015-07-24, 06:45 PM)Ad Bakker Wrote:
(2015-07-24, 04:59 PM)SilentThief Wrote: E-Mailing it to you now.

I received it, and changed all lines starting with /* into real comment (lines starting wit --).
I imported this file into my database without any errors. I sent it back by e-mail, try it.

Still get this white page.

[Image: TP7tYFK.png]
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)