3.4.3. phpMyAdmin navigation bar: Export

Figure 3-11. phpMyAdmin: database dump.

phpMyAdmin: database dump.

phpMyAdmin: database dump.



The "Export" function is useful for obtaining backups of our database (we recall that this is also possible to do from the administration panel of PHP-Nuke, see Section 7.1). The management console we get for this function is quite detailed (Figure 3-11):

In the central area, we have a list of the database tables, while to the right we have the backup options:

The options that appear in the lower part of the screen have to do with the extra features the created backup file should have:

If we don't select any table from the table list, phpMyAdmin will deduce that we want to save all tables. In case you want to select only some of them, just click on the ones you want with the left mouse button, keeping the CTRL button pressed.

To export a database from the command-line, without the use of the graphical tool of phpMyAdmin, you just do:

mysqldump -u dbuser -h dbhost -p dbname > dbdump.sql

where dbuser, dbhost and dbname are the database user, host and name respectively, exactly as entered in config.php (Section 3.7).


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