Once I've been given a database, how can I use it?
You'll need to be able to ssh to our development host.
From there, you can use mysql's command line client interface.
If you're having trouble working directly
with the mySQL client, we have installed phpMyAdmin
on our development server for your use.
Can I connect to mysql remotely from the login machines?
yes, from login.itd.umich.edu machines.
How do you manage backups, and how can I roll back?
We currently do a mysqldump every 4 hours. This is
written to local disk. Every day, these files are
copied off that machine by our enterprise Tivoli
system. On some of our servers, we use Innodb's hot
backup to take a snapshot. All of our production
database servers are being replicated to at least
one machine which can be instantly used as a failover.
To access old data, contact us and ask for a restore.
Please specify the last time you had known good
data. We can also provide you with the raw SQL which
you can re-import on your own.
Do you have documentation of how to use mysql, or
Certainly, mysql uses SQL (Structured Query Language),
as do many other RDBMS (Relational Database Management
System) tools. Although, MySql does some operational
We've put together a
of commonly-used SQL commands to be used as a
tutorial, or a reference.