From presence@irev.net Wed Oct 16 09:57:48 2002 Date: Tue, 15 Oct 2002 10:04:51 -0700 (PDT) From: Presence (presence@irev.net) To: Cosmic Hammer (admin@cosmichammer.com) Subject: Re: your mail Regarding MySQL on iRev.net, the MySQL database directory and files for your account's MySQL database is stored in your account's home directory. MySQL, Email, and your website files are all counted as part of your total 200 megs of disk space. So, technically, you could download the raw MySQL database files with your FTP client. iRev also offers phpMyAdmin, a web interface for you to be able to administrate your MySQL database via the web. As far as having access to your MySQL database on your current Service Provider, you may be able to write a PHP or CGI script to dump the contents of your database to a flat file. Depending upon how your provider runs things, something as simple as: (?php system("mysqldump -a --password=mypass --user=myusername mydbname ) ~/mysqldb.txt"); ?) And running that as a .php script from your webpage *should* dump your entire database to one big text file. At least, it would on iRev.net. :) While iRev.net supports you running your own PHP-Nuke installation, we can't necessarily install it FOR you... Actually, I have to say that, but I'd be happy to assist you in getting it installed, to a certain extent. Creation of the MySQL database, importing your 5.5 database, and giving you some suggestions regarding how to upgrade from 5.5 to 6.0 within the database, sure. I have to believe that the PHP-Nuke guys have provided some upgrade methods from 5.5 to 6.0 that automatically update the database and whatnot. However, with your shell account, I'd expect that you can untar the phpnuke package and get it to the point where we configure it to match your iRev account and database. - Paul "Presence" Gorman iRev Support ) We would definitely be needing shell access. ) ) More questions: ) ) I use PHP-Nuke on my current site, but I don't have access to my ) SQL database. If I use PHP-Nuke on an irev site, would I have database ) access through a web interface? ) ) Also, I'm currently running version 5.5 of PHP-Nuke, but the latest version ) available at this writing is 6.0. What extra charges, if any, would be incurred ) for a fresh install of version 6.0 (or whatever version is available when I ) obtain ) my irev acct), migration of my current SQL database into it, and making that ) database compatible with the new version of PHP-Nuke?