I would suggest using either phpMyAdmin or backup/restore
I just did this last night. Used the phpmyadmin faq, down at 6.4 and 6.5.
I followed the instructions, downloaded the gzip’d file to my hard drive (which turned out to be a dumb thing since after that I just had to unzip it and upload the unzipped file). When I unzipped it, it asked me what sort of file I wanted it to be and I put .sql on the end.
Then I deleted every single table in the database. You probably want to skip that step but I wanted to see if the restore would work. 🙂
Then uploaded it using those instructions and it did it’s thing and recreated the database just like it was.
Pretty nifty, really. I’m moving to a new host this week so I wanted to make sure it goes smoothly.
Good luck!
phpmyadmin supports uploading of gzip.
databases can run in megs mate! compressed file makes it a lot convinient…
Upload in gzip. Check. 🙂
I tell you… there isn’t a container big enough to fit all the crap I don’t know. Thanks for the tip!
Thread Starter
sadish
(@sadish)
Thanks for the Input guys !
I was able to import the entries. but when I try to login, it still went to the old website.
I figured it was because it is stored in the table tableprefix_blogoptions table.
I opened it using phpMyAdmin and changed to the new URL to make it work.
To avoid this step, I could have opened the SQL in notepad and change this field, before doing the Import .
I thought this should be logged somewhere.
can somebody who understand what this is, post it on wiki somewhere.
Thanks,
Sadish
http://www.alittleaway.com
