Import large sql files

[Exiled Pain]

Sup everyone...

I'm trying to import my database into the new one, but seems to be too big, because it exceeds the 300seg time, and so I get the error and it doesn’t import anything. So the question is how to extend this time for bigger databases? or how to import bigger .sql files? I already have the ALLOW partial import selected, for bigger files, but it’s not working... really need this cause backing up my DB is getting to my nerves cause if the files get to big, I wont be able to import them anyway, so help.

Also the files aren't that big, only 3.5mb the full DB sql file. Made many secments also but the biggest one is 2.7mb and doesnt import.

Any pointers plix???

 

[slaw]

You can always copy it from /mysql/data/dbname. There are no limits. ; o

 

[Znote]

When taking backups of your database, don't export it, but enter xampp/mysql/data and copy the database. Since exporting is just buggy :S

as slawkens says, you will have to force add the files in to mysql/data in your xampp/xampplite directory, the file is to big to import through text.

 

[ntmr]

Open your php.ini (probably somewhere inside the xampp folder) and search for max_execution_time, change to 0.

 

[Exiled Pain]

Thanks, both tips work great.

:thumbup:

 

[Gregor]

export the datebase from phpmyadmin you need good computer like 3GB Ram+ ;p

 

[Exiled Pain]

@up...
That's actually what I was doing, but didn't work. My pc has 4GB RAM. But tryed the first two things in this post and worked fine.
Thanks anyway, I apretiate your help. ^_^:thumbup: