How to execute large MySql data-insert script file?

Question

Trying to use PHPMyAdmin doesn't allow me to execute 150Mb data script file. Do you have any work-around for me?

Update

My script is utf-8 encode.

I've update php.ini but all still get error as the below snapshot.

[php.ini]

upload_max_filesize = 256M    
max_execution_time = 0    
memory_limit = 256M

enter image description here

Gajendra Bang · Accepted Answer · 2011-07-18 09:04:04Z

2

Try this: http://www.ozerov.de/bigdump/

Bigdump also provides you changing character set

answered Jul 18, 2011 at 9:04

Gajendra Bang

3,5732 gold badges29 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aseesing · Accepted Answer · 2011-07-18 08:02:50Z

1

Use split on linux or a windows split program to split your script in multiple parts. And then load them one by one.

answered Jul 18, 2011 at 8:02

aseesing

1511 gold badge1 silver badge7 bronze badges

2 Comments

Nam G VU Over a year ago

How much should I split then? It's quite annoying in splitting it though.

aseesing Over a year ago

Depends on many factors, do some trial and error on how much inserts you can do in PhpMyAdmin.

Sahal · Accepted Answer · 2011-07-18 08:05:20Z

1

Give max_execution_time = 1500 (Which means 25 minuets)

Default execution time is 30sec, http://php.net/manual/en/info.configuration.php

answered Jul 18, 2011 at 8:05

Sahal

4,15616 gold badges45 silver badges72 bronze badges

1 Comment

Nam G VU Over a year ago

I set it to be 0 already i.e. infinite but that doesn't work. 25 minutes won't be enough though

RReverser · Accepted Answer · 2011-07-18 08:06:04Z

1

Use native mysql console client. To import that file use

mysql -u [username] -p[password] [database_name] < [your_sql_file]

answered Jul 18, 2011 at 8:06

RReverser

2,05417 silver badges17 bronze badges

6 Comments

Nam G VU Over a year ago

This won't help me to import utf-8 data

Nam G VU Over a year ago

Hic... How can I prove it to you then

RReverser Over a year ago

@Nam Gi VU Hm.. I think you can't because I use this method enough often to claim that it works :)

Nam G VU Over a year ago

This is my sample script in utf8 db.tt/IyNbFAj. Have tried successful using Navicat execute sql file but running from commandline failed

RReverser Over a year ago

@Nam Gi VU Oh.. that's simple problem with your SQL query :) Just add SET NAMES utf8; in the beginning of file.

|

Collectives™ on Stack Overflow

How to execute large MySql data-insert script file?

4 Answers 4

Comments

2 Comments

1 Comment

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related