<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">I like mysql workbench too shame it
doesnt work completely with MariaDB though.<br>
<br>
Kev,<br>
<br>
On 10/04/14 18:24, Dan Attwood wrote:<br>
</div>
<blockquote
cite="mid:CAGcBgjgNX4MeqBoOzY2Ff0HAGd=o-kswWK+nK5rDfWZLak9=iA@mail.gmail.com"
type="cite">
<div dir="ltr">imho the best gui for mysql is 'mysql workbench'.
<div><br>
</div>
<div>very easy to use and very powerful. You probably won't be
able to connect to your server with port 3306 but workbench
lets you set up a ssh tunnel.</div>
<div><br>
</div>
<div>as for search the database you can just use grep on a dump
of the database if you know roughly what you're looking for.</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On 10 April 2014 18:16, Sharon Kimble <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:boudiccas@talktalk.net" target="_blank">boudiccas@talktalk.net</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">I have two
wordpress sites in a multi-site setup, and both serviced
with<br>
the same mysql database, on an off-site server. I want to
examine this<br>
database to find where the Facebook sign-on details are and
delete them to<br>
reset the wordpress Facebook sign-on. This is because one
site is directed to<br>
my new Facebook account which is good, but the second site
is directed to my<br>
old Facebook account which is closed and is not good.<br>
<br>
The second site was originally setup as '<a
moz-do-not-send="true" href="http://test.tgmeds.org.uk"
target="_blank">test.tgmeds.org.uk</a>' whilst it was<br>
being built, and then converted to '<a
moz-do-not-send="true" href="http://tgmeds.org.uk"
target="_blank">tgmeds.org.uk</a>' when it went live.
Whilst<br>
it was still a 'test' site I signed up for Facebook and
connected the two<br>
which then worked okay.<br>
<br>
I want to examine a mysql backup database for a Wordpress
Jetpack plugin<br>
specifically looking for where the Facebook signing on and
passwords entries<br>
are. I've just tried looking at an old copy of the database
which was 39mb in<br>
emacs, but the current one is 86mb and is obviously too big
to open it with<br>
emacs. So I'm also looking for a GUI to help me manoeuvre
round the database,<br>
but using 'phpadmin' is not able to be installed.<br>
<br>
Once I've been able to find the entry on a database backup,
then I will be<br>
able to deal with it in the live database, or that's my plan
anyway. I also<br>
have a wordpress plugin available to me, 'Custom Field Bulk
Editor' which<br>
will allow me to interact with the database, although I do
have direct entry<br>
to the database available to me.<br>
<br>
Thanks<br>
<span class="HOEnZb"><font color="#888888">Sharon.<br>
--<br>
A taste of linux = <a moz-do-not-send="true"
href="http://www.sharons.org.uk" target="_blank">http://www.sharons.org.uk</a><br>
my git repo = <a moz-do-not-send="true"
href="https://bitbucket.org/boudiccas/dots"
target="_blank">https://bitbucket.org/boudiccas/dots</a><br>
TGmeds = <a moz-do-not-send="true"
href="http://www.tgmeds.org.uk" target="_blank">http://www.tgmeds.org.uk</a><br>
Debian testing, Fluxbox 1.3.5, emacs 24.3.1<br>
</font></span><br>
_______________________________________________<br>
Kent mailing list<br>
<a moz-do-not-send="true"
href="mailto:Kent@mailman.lug.org.uk">Kent@mailman.lug.org.uk</a><br>
<a moz-do-not-send="true"
href="https://mailman.lug.org.uk/mailman/listinfo/kent"
target="_blank">https://mailman.lug.org.uk/mailman/listinfo/kent</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Kent mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Kent@mailman.lug.org.uk">Kent@mailman.lug.org.uk</a>
<a class="moz-txt-link-freetext" href="https://mailman.lug.org.uk/mailman/listinfo/kent">https://mailman.lug.org.uk/mailman/listinfo/kent</a></pre>
</blockquote>
<br>
</body>
</html>