33dots

Posts RSS Comments RSS

Archive for October, 2009

Backing up a MySQL MyISAM database using mysqldump.

Give the command,

[tony@localhost ~]$mysqldump --opt --user=username --password=
password --host=yourMySQLHostname dbname > output.sql

For bzipping it,

[tony@localhost ~]$mysqldump --opt --user=username --password=
password --host=yourMySQLHostname dbname | bzip2 -c > output.sql.bz2

To dump individual tables use the command,

[tony@localhost ~]$mysqldump --opt --user=username --password=
password --host=yourMySQLHostname dbname  (tablename tablename tablename) > output.sql

The --opt switch is a shorthand; it is the same as specifying --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset
It should give you a fast dump operation and produce a dump file that can be reloaded into a MySQL server quickly.

For more information on individual options refer man mysqldump

No responses yet

No meta tags available for selection nodewords 6.x-1.2

After nodewords installation, there were no ‘Meta’ tags available in the Meta tag selection form (in the nodewords settings page). Enabling or disabling made no effect. Also no tags were shown in the HTML output. The ‘Global meta tags’ page told, ‘no metatags are selected in the settings page’.
Googling revealed that the scenario also happens if we upgrade to the same version.

Nodewords settings page

The solution is to clear the cache. Go to /admin/settings/performance and at the bottom click ‘clear cached data’.

No responses yet