Hi, I just bought this .sql database on DP. And I need help to integrate it into my forum. Please help me out on how to go about it. And yeah, I forgot to mention. I did try to do it myslef. Here's what I tried doing. I logged into the cpanel and then the phpmyadmin. And then clicked on the existing database. And then the sql at the top. Clicked on import. Pointed out to the file on my desktop. But I did notice that the max file size it specified is 51mb. But the file is about 75mb. Got the error about the same after i tried uploading it. So I need to know from you. If that is the right way to import another website's database into yours. Or if thats the wrong method i followed. Am not too good at these things. So I would be very thankful to whoever helps me with this task I have got. Regards
there is a free script called mysql dumper which is pretty good at importing larger sql files. You can upload the sql file by ftp to your server and then have the script import it to your database
if you have ssh access to your server, importing this would be a breeze, importing using the command line is much faster than using phpmyadmin
I just googling and found this: http://codingpad.maryspad.com/2007/06/19/working-with-a-sql-dump-file-a-newbie-tutorial/ hope it can help.
If the file size is 75MB then the best option is to ask the help from your host or use shell access. Otherwise try http://www.ozerov.de/bigdump.php