SQLTeam.com | Weblogs | Forums

Help, need to run 2 GB .sql file

Dear guys
I need to run a huge sql file which is almost 2GB size which was given to me
I am totally beginner and couldn't execute it in SQL Managment Studio
Here is the header of the sql file maybe it will help

-- MySQL dump 10.14 Distrib 5.5.64-MariaDB, for Linux (x86_64)

-- Host: 127.0.0.1 Database: drupal


-- Server version 5.6.10-log

/*!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 users

......etc

This forum is for Microsoft SQL Server. Your script is for MySQL. You might have better luck on a MySQL-specific forum.

1 Like

Thanks a lot,, at least you've put me on the right path