Migrating databases and fixing PC's
When you change your web host, there's a lot of setting up and testing involved. Because
it's a once in a blue moon event, you have hardly the incentive to know it well,
particularly in a new hosting environment.
I am going to write it down so
that I won't be a damsel in distress next time.
How to transfer contents
of old database (guestbook) into the new:
- Transfer files from guestbook
directory on old web host to directory on new web host
- Go to old web host:
get into mysql database and dump both structure and data into a file (ends with
sql) on your PC.
- Go to new web host control panel: visit mysql database,
create a new database, create new user and password
- Go to guestbook's
admin directory and open config.inc.php file (in Wordpad.exe)
- Change the
username and password to match what you've created
- Change the dbase name
to match what you've created
- Save file
- Upload (transfer) config.inc.php
file (to replace old) on new webhost
- Go to new host control panel, my
- Upload SQL file from your PC.
- Test new guestbook.
to add a link to the guestbook menu:
- In FTP, go into the admin directory
and template subdirectory.
- Highlight and click on all files within it.
- Right click and select CHMOD
- Change the number to 777, which
will give you read and write and execute access.
- Go to the guestbook admin.
- Go to Templates and select body.php.
- Insert a line of text
(including the meta tags).
- Submit and save.
- Go back to the FTP,
and right click/CHMOD on the highlighted files again.
- Change the number
back to 644.
My friend came by to diagnose what was wrong with my
laptop. Six and a half hours later, after an upgrade to Windows XP and defragmentation
of my hard disk, I got a brand new machine --- almost too good to let go.
December 2003 Sunday
Forthcoming article by Anne Ku:
Choosing and changing your web host, 8 January 2004
Recommend this page to a friend:||
about her travels, conversations, thoughts, events, music, and anything else that
is interesting enough to fill a web page.
Support the Bon Journal by
keeping analyticalQ.com alive and free. Find out about Sponsorship.