Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
TOO SLOW IS IMPORT .SQL FILE
Posted by: autopolovnjaci (---.adsl.eunet.rs)
Date: May 12, 2012 08:56PM

WITH WAMP SERVER 1.4.4 WAS NORMAL IMPORT SQL FILE,
BUT WITH WAMP SERVER 2.2 IS TO SLOW IMPORT SQL FILE

HELP

Options: Reply•Quote
Re: TOO SLOW IS IMPORT .SQL FILE
Posted by: stevenmartin99 (Moderator)
Date: May 12, 2012 09:08PM

USE MYSQL COMMAND LINE OR INCREASE THE FILE SIZE LIMITS IN PHP.INI OR GET A BETTER PC

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: TOO SLOW IS IMPORT .SQL FILE
Posted by: autopolovnjaci (---.adsl.eunet.rs)
Date: May 13, 2012 01:29PM

I try with mysql comand line but it is slow too.

row affected 0.05 sec <---- average

Options: Reply•Quote
Re: TOO SLOW IS IMPORT .SQL FILE
Posted by: stevenmartin99 (Moderator)
Date: May 13, 2012 01:37PM

That means nothing

What's the query

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: TOO SLOW IS IMPORT .SQL FILE
Posted by: autopolovnjaci (---.adsl.eunet.rs)
Date: May 13, 2012 06:15PM

run: cmd

C:\>cd C:\wamp\bin\mysql\mysql5.0.51b\bin

C:\wamp\bin\mysql\mysql5.0.51b\bin>mysql.exe -use prva -u username -p

mysql> source c:\autopolovnjaci.sql;

Options: Reply•Quote
Re: TOO SLOW IS IMPORT .SQL FILE
Posted by: stevenmartin99 (Moderator)
Date: May 13, 2012 06:22PM

ok i guess you havent a clue

how can i tell if thats too slow if your not showing the queries that are giving a result of .05sec

the entire file? just one line?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: TOO SLOW IS IMPORT .SQL FILE
Posted by: autopolovnjaci (---.adsl.eunet.rs)
Date: May 14, 2012 07:37PM

for import sql file size 4,1 MB it is necessary 90 minute., but when i use wamp5 only a few minute.

.05 sec is for one records, one line. when use mysql console

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login