<HTML ><HEAD ><TITLE >MySQL Front, how to administer a MySQL DB from Windows </TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP-Nuke: Management and Programming" HREF="book1.htm"><LINK REL="UP" TITLE="Programmer's tools " HREF="c2221.htm"><LINK REL="PREVIOUS" TITLE="PHPMyadmin, administering MySQL via web" HREF="x2692.htm"><LINK REL="NEXT" TITLE="Foxserv, making PHP-Nuke work on Windows Systems" HREF="x2797.htm"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP-Nuke: Management and Programming</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="x2692.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 11. Programmer's tools</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="x2797.htm" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="MYSQL-FRONTEND" ></A >MySQL Front, how to administer a MySQL DB from Windows</H1 ><P >Mysql Front<A NAME="AEN2756" ></A > is a client for Windows<A NAME="AEN2758" ></A > that allows for the management to manage a local or remote DB through a client interface. Since we consider PHP-Nuke to be more aproppriate and flexible tool for this task, we would like to focus our attention a little on a functionality of MySQLFront that on PHPMyAdmin has shown itself to be little reliable. That is the ability to load, import and export DBs of great dimensions without losing data or getting errors.</P ><P >In this section we will limit ourselves in analyzing the connection phase, the import and upload.</P ><P >Connection (<A HREF="x2753.htm#FIG-MYSQLFRONT-CONNECTION" >Figure 11-3</A >): Clicking on File->Connection, we will get an interface in which we are asked to enter the host, user and password. If we have to use MySQLFront locally, we will leave the localhost entry untouched. </P ><P ><DIV CLASS="FIGURE" ><A NAME="FIG-MYSQLFRONT-CONNECTION" ></A ><P ><B >Figure 11-3. MySQL Front: Connection </B ></P ><DIV CLASS="MEDIAOBJECT" ><P ><IMG SRC="./images/snapshot20.png"><DIV CLASS="CAPTION" ><P >MySQL Front: Connection</P ></DIV ></P ></DIV ></DIV ></P ><P >Download (or copy) of an existing DB: choose the database you wish to be exported and then click on "Export Tables" (fifth from the right, <A HREF="x2753.htm#FIG-MYSQLFRONT-EXPORT-TABLES" >Figure 11-4</A >). Then choose a destination path for the database dump. As you may notice, the system, through the use of flags, gives us even the possibility to choose individually those tables we want to import.</P ><P ><DIV CLASS="FIGURE" ><A NAME="FIG-MYSQLFRONT-EXPORT-TABLES" ></A ><P ><B >Figure 11-4. MySQL Front: export tables </B ></P ><DIV CLASS="MEDIAOBJECT" ><P ><IMG SRC="./images/snapshot21.png"><DIV CLASS="CAPTION" ><P >MySQL Front: export tables</P ></DIV ></P ></DIV ></DIV ></P ><P >Upload of a DB: clicking on the SQL Query button (<A HREF="x2753.htm#FIG-MYSQLFRONT-SQL-QUERY" >Figure 11-5</A >), an interface appears that allows us to carry out the upload of an existing database. It suffices to click on the symbol of the open folder, choose the database dump and click on the button that looks"Play"-like button. Before starting this operation will have to select the destination database.</P ><P ><DIV CLASS="FIGURE" ><A NAME="FIG-MYSQLFRONT-SQL-QUERY" ></A ><P ><B >Figure 11-5. MySQL Front: SQL Query </B ></P ><DIV CLASS="MEDIAOBJECT" ><P ><IMG SRC="./images/snapshot22.png"><DIV CLASS="CAPTION" ><P >MySQL Front: SQL Query</P ></DIV ></P ></DIV ></DIV ></P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="x2692.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="book1.htm" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="x2797.htm" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >PHPMyadmin, administering MySQL via web</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="c2221.htm" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Foxserv, making PHP-Nuke work on Windows Systems</TD ></TR ></TABLE ></DIV ></BODY ></HTML >