remove lines in sql export

tiptopweb's profile image tiptopweb posted 2 weeks ago in General Permalink

Hi When I export to sql file, at the top and bottom of the file I have some lines and I'd like to export without them

In options, these 4 lines are unchecked : add comments remove auto increment remove definer copy mysqldump command

/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /; /!40101 SET NAMES utf8 /; /!50503 SET NAMES utf8mb4 /; /!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /; /!40103 SET TIME_ZONE='+00:00' /; /!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 /;

/!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') /; /!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') /; /!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) /; /!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /; /!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) /;

Even if they are commented with /*! when I import the sql in phpmyadmin, these lines block the import

Thanks for you help

ansgar's profile image ansgar posted 2 weeks ago Permalink

They should definitely not block the import. And they are required to create a valid export file. You need to find out which of these conditional comments is the problem please.

Please login to leave a reply, or register at first.