Importing a big database

[dansomers]

Anyone know of a easier way to imported a database using which is about 156mb?

phpmyadmin doesnt like doing big databases at all

[steve]

Large Database Backup 1.0

A full backup process can be split in multiple iterations to not exceed PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.

Maybe this will solve your problem?

[G.C. Admin]

upload it onto your webspace. contact the host and either have them upload via shell or ask if you can have shell access, or use BigDump: The Staggered MySQL Dump Importer

Frank

[benjaminp]

As suggested; bigdump is a great sxript to do this. Have used it myself in the past

[dansomers]

Ill use bigdump it seems pretty simple - Pain though as my upload speed at the moment is stupidly slow

[Fastian]

Originally Posted by dansomers

Anyone know of a easier way to imported a database using which is about 156mb?

phpmyadmin doesnt like doing big databases at all

156MB after GZip or before??
This is not a huge database if its without GZip. (and phpMyadmin shouldn't have a problem with it)

Your host might have some MySQL limits so you can ask your host to provide you a dump file. (If you are getting error in phpmyadmin)

BigDump is a nice tool to have when you are hitting your host limits.

[dansomers]

Lol after unzip the database was 510mb - Taking a while

I have installed on my pc so at least I can play around with it

[SeoLover]

Have you got this working though?

I am not the best with databases and all that stuff