Restoring database from files; how to use SequelPro to know if it's there?!?

[MikeLevin]

I'm a newbie using MySQL on an Apple 10.6 server as a back end for an
email archiving app. I'm trying to recover a fresh MySQL system by
restoring files from a backup. I've copied the ib* files and the files
in myemaildb/ and put in a force_recovery of 6 (following instructions
on the web) into the .cnf file. The server is running. How do I use
SequelPro to know when when/if it has finished "owning" the contents
of my (50 Gig) database in the ibdata1 file and imported everything
back to how it was? How do I use SequelPro to diagnose whether the
database is being read?

thank you,

Mike

[Jakob Egger]

Did you try the "Show server processes…" command from the "Database" menu?
You won't see much (no progress bar), but at least you might see what's happening on the server.
I'm not sure if the restore process will be shown in this view, though.

> --
> You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
> To post to this group, send email to seque...@googlegroups.com.
> To unsubscribe from this group, send email to sequel-pro+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sequel-pro?hl=en.
>

[MikeLevin]

Sorry, where (on the Apple OS X server) do I get the Database menu (to
issue the show server processes command)?

thanks,

Mike

[Jakob Egger]

I meant the database menu in Sequel Pro. Obviously this only works if you can actually connect to the MySQL server.

A good idea is always checking logs in Console.app, and checking the mysql log files. Here's some information where MySQL stores files: http://www.sequelpro.com/docs/Where_are_MySQL%27s_Files%3F
(I'm not sure exactly where OSX Server stores the MySQL logs…)

best regards,
Jakob