Hi, I know you've already chose a new host, but if it isn't too late, you're welcome to share the linux virtual host space I have at Bytemark (see links below). I'm setting up some educational wikis there.

Or else I'd be glad to just host kairosnews.

http://holton.ltc.vanderbilt.edu/wiki/UserModeLinux
http://www.bytemark-hosting.co.uk/index.html

It's a little more than a barebones shared hosting environment, but you get a complete Debian server with more diskspace.

-DougHolton

I really appreciate the offer, but I have three domains of my own and about 8 CMS sites to install on the host (all but one are Drupal), plus Terra's site, writingfly.com (Terra and I are sharing the hosting). Bandwidth is also already close to 4 gig's a month for the server.

The neat stuff is that through CPanel, we get multiple subdomains, listservs, phpbb forum, chatrooms, multiple email accounts for any/all of the domains, choice of webmail access programs, and a bunch of other things that I haven't had the time, nor necessarily the knowledge to administer. Plus, I figure that I've probably invested almost as much money in the server, and would continue to do so with hardware repairs, as with the hosting.

But I really do appreciate the offer :)

You mean Kairosnews might be down on March 6, its two-year blogiversary??? :O

CultureCat

looks like the changeover will be on saturday :)

just kidding ;) i'll wait until sunday.

Yes, Cpanel is quite nice. I've gotten accustomed to it with my host and would hesitate before opting to go without it.

I notice that many hosts offer a plethora of different database options. I wonder which one is the best?

We are now moved to the new host. No problems. Everything went very smooth.

Cool. I moved my site once. Had a heckuva time. The big problem is moving the MYSQL database. I did a dump, but it wouldn't upload properly and kept timing out. I finally had to open the file and copy/paste pieces of it into the window of phpmyadmin. Took FOREVER.

Did you move a mysql database? IF so, PLEASE tell me how you did it.

working from the command line within linux or unix it's easy. at your old host, begin with a dump that includes structure and data:

mysqldump -u [username] -p --opt [database name] > [output file name]

(don't include the square brackets)

the system then prompts you for a password.

then, at the new host, create a db and assign the proper permissions on it to a mysql db user. transfer the db dump over to the new host.

then, from the directory where the db dump resides:

mysql -u [username] -p [database name] < [dump file name]

to explain the syntax a little more, -u denotes to use that username, -p to ask for a password, and the angle bracket says which is going where (into the db or out to a file). and i've forgotten what opt does in the mysqldump command.

also note that mysqldump, in the first instruction above, is a specific mysql application that only does dumps. whereas mysql in the second instance, is the main mysql application (why we need both, i have no idea). you could also create the dump using phpmyadmin, then load it with the command line instruction above, or vice versa. the mysqldump command is handy, though, for creating cronjobs that periodically dump your database automatically. simply specify the password in the mysqldump command:

mysqldump -u [username] --password='[password]' --opt [database name] > [output file name]

note that the output file name can contain a directory listing, in case you are running the command from another directory other than where the dump resides or where it is to be dumped, such as when creating a cronjob.

did this help?

charlie

The problem is, I can't get to a command line. All I have is CPANEL.

Yuck.

Check, though, and see if your Cpanel has the SSH command line interface via the browser (mine does, although I prefer to use putty). If it doesn't, let me suggest that you are not in the most open source application friendly place. If you ever want to switch to opensourcehost, know that they give a coupon for drupal people.

okay, I checked it. I apparently DO have command line access. I'll play around with it and see what happens.