Hello my friends!
Can anyone explain or write a guide about how to tranfer huge wallpaper website to different host?
I know the files needed to be transferred via FTO (I know there is a prob with this bacause most of the servers dont show more than 2000 files in a dir) but my real prob is how to transfer the sql database? someone once told me i need to choose the export option in the phpMyAdmin panel but it just runing huge script that got stuck in the middle.
Can anyone help?
1.Files can be transferred using net2ftp installed on your own hosting, but for big sites we need to choose move files or folder options repetitively till all files are transferred.
If u need personal help, leave a mail to me, i wont charge you for this buddy ;-)
2.SQL Database can be transferred through a tool which i m not able to recall name, but i ll tell once i m able to recall... but its possible.. and can be done...
For the database you should be able to export from PHPAdmin in compressed file and than import using the PhPAdmin on the other side. There maybe a limit to 20mb in some. You can always export half of it an than the other half. You should have the options to choose the tables. You can export individually also. Hope That Helps
thanks Nikhil and Zeero6
Zeero6 do you know if I need to choose special options in the exporting panel and what encoding type should I choose?
Nikhil, what do you mean by repetitively?
Thanks
No special options. Just save as file and give it a name. Than should give you the option to save somewhere on your PC
hey zeero6,
thanks alot for the help. I realy appreciate it.
I managed to export the file and save it on my computer but when i'm trying to import it on the new hosting it wont do it.
something with the user name or database name.
in the new hosting the have a new name for the db.
I mean the begining of the db name is already set by the host (according to my user name in that host) and i cant change it and it different from the former host db name.
is this the reason it wont work? if so how can i fix it?
thaaaaaaaaaaaaaaaaaaaaaaaaaanks
http://www.mysqldumper.de/en/ for large database transfers and net2ftp for inter server file transfers, both hosted at your own domains for full control... and you know what I really appreciate Zeero6 for the contribution to community, I ll give his site special partner status at my wallpaper sites and also a free theme if he feels like having one... hey I m not related to Wallpaper script forum, I m extending this favor as a token of recognizing his efforts...
thanks Nikhil
for your kind words
to import to a new database it must be empty sometimes, otherwise some tables will conflict. Hard to help since sometimes it requires a visual meaning doing it ourselves
I ve given you a partner link zeero6
Thanks Nikhil
Got you also on mine
thanks Nikhil and Zeero6!
I managed to do it.
one last question - after moving the files and the mysql database where in the wallpaperscript should i put the new mysql database host, db name, db user and pass?
thanks
db_info.php
thank you nikhil
You must log in to post.
