Okay… spent most of yesterday & today trying to make sure I could back up the MySQL database info from my web hosting service. Here are some notes on that process:

1. Installed myphpadmin , valueweb’s recommended admin tool (see this link), and used it to make a backup of the ‘royborn0′ database on the mysql.royborn.com server. Username & pass are the same as regular account. (Can’t use MySQL Administrator for Valueweb because their version of MySQL is to low - 3.x or something)
• installed to default /web/phpmyadmin directory… should change this?
• currently, config.inc.php file contains plain text password; permissions are read only for user, not for group/other, but is this enough?
2. Installed MySQL (http://dev.mysql.com/downloads/) database at home for testing, and also installed MySQL Administrator, since I have version 5.0 of MySQL.
• Be sure to read installation docs for user config - by default, root user has no password, & other things
• add royborn0 user from gui, create ’schema’ (==database) named royborn0, & give priviledges for everything
3. Then used the command line to restore the backup file to the local database - /usr/local/bin/mysql
• ./mysql -u royborn0 -p
• then use the source command with the backup file, and it will apply those commands to the royborn0 database
• DONE

Now, I haven’t checked if a new install of Wordpress & Coppermine will work with the preexisting database entries - I suppose that could be a problem if paths are different or something like that. I’ll check that next.

This entry was posted on Wednesday, February 1st, 2006 at 6:19 pm and is filed under web stuff. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.