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.
According to the reviews on the App Store, it sounds like it sucks, though. I think I'll wait a couple more weeks.
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.