i just joined frihost
and i had an old site but now im taking my old database and uploading it to this new one
so i go into cpanel then phpadmin, find the database- click SQL- then i upload the SQL file- and then it just either freezes or doesnt load fast... anyone have any ideas how i could do this faster???
i dont want to lose any data
Is your sql file very big? It might be normal that it isn't fast.
not big at all...
ive tried this several times
can you help me transfer my old database to my new one???
Just use phpMyAdmin. All you do is to export the info from the old database ( into an sql file ). Open the phpMyAdmin interface on the new site ( after you have created the database ). Open the SQL interface on the new database and it will give you an area into which you can paste SQL into.
Open the Old sql file in a text editor like notepad and copy it into the text buffer ( select all / control-c) and then paste it into the SQL window (phpMyadmin)(control-v) of the new database.
That way all the new population of the database will occur on the new server and nothing actually gets transferred via the 'Net.
Hope that helps,
If you have your database backuped and all of your site's files you'll be fine.
First, does your database is a MYSQL kind of db ??
Is so then try doing this:
goto your phpMeAdmin, on the left menu you have this little icon that looks like a little window and SQL is written on it.. click on it.
Now a windows should pop up, there you goto the Import Files section and after that it's all really piece a cake..
don't forget to upload your site and configure the connection to the database.