Mysql Front is a client for Windows 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.
In this section we will limit ourselves in analyzing the connection phase, the import and upload.
Connection (Figure 28-2): 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.
Figure 28-2. MySQL Front: Connection
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, Figure 28-3). 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.
Figure 28-3. MySQL Front: export tables
Upload of a DB: clicking on the SQL Query button (Figure 28-4), 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.
Figure 28-4. MySQL Front: SQL Query