SQL Comuni italiani
Diverse persone hanno reso disponibili in rete, partendo dai dati ufficiali dell’ISTAT, degli script SQL per la memorizzazione dei Comuni, delle Province e delle Regioni d’Italia. Purtroppo, molti di questi lavori non sono adatti per i miei scopi, avendo tutti almeno uno dei seguenti problemi: non sono aggiornati (io mi sono riferito all’elenco del 30 [...]
Moving and exporting a Joomla MySQL DB via eBackup
This post updates a previous one on the same topic. If for some reason you need to restore a MySQL dump of an instance of Joomla (made with eBackup) with the extra component JXplorer, well you could find useful this pre import script I wrote.
Moving and exporting a Joomla MySQL DB via phpMyAdmin
If for some reason (sad or stupid reasons, you have a choice as usual) you need to restore a MySQL dump of a Joomla DB and you have experienced the same problem described here, well, you could find it useful to run this pre import script I wrote. Update (2006-12-07): this might be needed if [...]
An unusual management of a MySQL dump
If for some reason (sad or stupid reasons, you have a choice) you need to import into MySQL 3.x a dump made with phpMyAdmin of a MySQL 5.x DB of Joomla 1.0.x, don’t forget to change the closing sequence of the tables as: +) ENGINE=MyISAM AUTO_INCREMENT={n} DEFAULT CHARSET={c} AUTO_INCREMENT=2 ; -) TYPE=MyISAM AUTO_INCREMENT={n}; where {c} [...]
