https://supermanhamuerto.com/ 2026-04-23T08:36:40+00:00 https://supermanhamuerto.com/ https://supermanhamuerto.com/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2022-12-02T21:02:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=mysql:changemasters&rev=1670014949&do=diff Changing Masters The problem I have a mysql master database with an slave. I want to change the master server. Downtime it is not a problem, however, I will try to reduce downtime. My servers, for the sake of this example will be named: master, future-master, slave. text/html 2022-12-02T21:02:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=mysql:exportadatabase&rev=1670014949&do=diff Exporting/importing a database <http://codex.wordpress.org/Backing_Up_Your_Database> user@linux:~/files/blog> mysqldump --add-drop-table -h mysqlhostserver -u mysqlusername -p databasename (tablename tablename tablename) | bzip2 -c > blog.bak.sql.bz2 Importar la misma base de datos user@linux> mysql -h hostname -u username -p databasename < blog.bak.sql text/html 2022-12-02T21:02:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=mysql:exportcsv&rev=1670014949&do=diff Make a select and export to csv I've tried this to make a csv file, to import directly into Microsoft Excel. You can try also with character set 'utf-8', to export international character set, but this doesn't match very well with Excel. select blah, blah from table into outfile 'PUT_HERE_YOUR_FILENAME' character set 'latin1' -- latin charset, ideal for importing into excel columns terminated by ';' enclosed by '"'; text/html 2024-10-05T17:19:39+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=mysql:index&rev=1728148779&do=diff Mysql * Make a select and export to csv * Killing proceses in Mysql * Exporting/importing a database * Lista de todos los pueblos de España (1993) * A quick log analyzer * Recovering lost syncrhonization on mysql * Changing masters text/html 2022-12-02T21:02:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=mysql:kill&rev=1670014949&do=diff Killing proceses in Mysql <http://dev.mysql.com/doc/refman/5.0/es/kill.html> text/html 2022-12-02T21:02:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=mysql:listapueblos&rev=1670014949&do=diff Lista de todos los pueblos de España (1993) Esta lista es un poco antigua, pero en un momento dado puede ser de mucha utilidad para normalizar datos, por ejemplo. Contiene únicamente el nombre de la población. [Descargable en formato gzip] text/html 2022-12-02T21:02:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=mysql:quickloganalyzer&rev=1670014949&do=diff A quick log analyzer Here comes a quick log analyzer for web logs. It is an AWK script that parses a log file and generates insert commands. You can pipe this insert commands into a mysql database (the table is provided in the comments) and, using the power of SQL, generate queries about queries per day, queries per month, single visits, etc. text/html 2022-12-02T21:02:29+00:00 Anonymous (anonymous@undisclosed.example.com) https://supermanhamuerto.com/doku.php?id=mysql:recoveringsynchronization&rev=1670014949&do=diff Recovering a lost synchronization in mysql I have a replicated mysql database and recently I've discovered that it has lost synchronization with its slave. I've decided to recover it by the hard way: deleting all the information in the slave and starting with a fresh copy of the master.