Spike ,'The Cautionary Tale of Numero Cinco'
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
MySQL gurus:
Let's say I have a database, with a bunch of tables with names like "backup_smf_attachments," "backup_smf_boards," etc, each of which corresponds with another table called "smf_attachments," "smf_boards," and so on.
Now let's imagine I've FUBARED the "smf_***" tables and would like to replaces them with the data from the "backup_smf_***" tables. How would I go about doing that from the mysql command line? Are there convenient commands for this sort of thing?
And while we're at it - how would you go about making backups of 2GB MySQL databases? Every time I try to run a mysqldump on it, the process gets killed before it finishes.
iPhone and iPod touch get their first SSH client
Hot damn.
According to the reviews on the App Store, it sounds like it sucks, though. I think I'll wait a couple more weeks.
what exactly is SSH?
It stands for Secure Shell, it lets you securely terminal into another computer if that computer is running a SSH server.
It can be amazingly useful. With SSH (and screen) I can do all sorts of things on my home network remotely. My wife finds it easier to have me reboot our DVR, on the rare occasions it has a problem, from work than to do it manually.
It's like Telnet, except Telnet is insecure over networks, as the password gets transmitted unencrypted.
SSH is Secure Shell, a way of remotely connecting to systems, using encryption, and getting a command-line interface.
aha! thanks guys.