MySQL Front, how to administer a MySQL DB from Windows

28.6. MySQL Front, how to administer a MySQL DB from Windows

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

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

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

MySQL Front: SQL Query

Help us make a better PHP-Nuke HOWTO!

Want to contribute to this HOWTO? Have a suggestion or a solution to a problem that was not treated here? Post your comments on my PHP-Nuke Forum!

Chris Karakas, Maintainer PHP-Nuke HOWTO


Site Info

Last SeenLast Seen
  • EmeliaB171
  • Doulos
Server TrafficServer Traffic
  • Total: 403,331,577
  • Today: 19,649
Server InfoServer Info
  • May 25, 2020
  • 12:39 pm CEST