upload large SQL database

[Blazer9131]

Is there a way I can insert a large SQL database (over 20megs) into a database? Just wanted to know. =P

Thanks

~Blaze

 

[LHVWB]

You should be able to make a sql dump/export using phpmyadmin of the very large database and then run the dump as a sql query in the other database. The only problem would be if the database names were different and then you could change it in the sql dump anyway.

Note that the query will take a long time, 20mb is a fair bit of data.

 

[Blazer9131]

Lol Thanks, I thought phpadmin only let 5megs up...

I ran the script at home, with the database hosted on my PC, It took about 17mins, so yah its a monster of a database..

xD

~Blaze