remove lines in sql export

tiptopweb's profile image tiptopweb posted 11 months 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 11 months 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.