A chronological documentation test project, nothing serious, really!
This convertion could be obtained by first converting the tables in the mdb-file into CSV-files (Comma Separated Values) using MDB Tools and then by importing the csv-files into MySQL using phpMyAdmin. To export a given table from a mdb-file, we type: mdb-export db.mdb customers >> customers.csv In my case, since I got some danish characters, […]
eZ Publish kom med denne feilmelding i dag jeg fikk ikke endret eller laget nye artikler, eller for den saks skyld lagt til nytt innhold generelt. I loggen til eZ Publish sto følgende feilmelding Transaction in progress failed due to DB error, transaction was rollbacked. Feilen viste seg å være at databasen til eZ Publish […]
#!/bin/bash # Shell script to restart MySQL server if it is killed or not working # due to ANY cause. # When script detects mysql is not running (it basically sends ping request # to MySQL) it try to start using /etc/init.d/mysql script; and it sends an # email to user indicating the status. # […]
/var/lib/mysql har blitt over 1,5GB stor så jeg Googlet litt for å finne ut hva som kunne gjøre dette og det viser seg at mysql logger all aktivitet. RESET MASTER sletter logger osv og etter å ha kjørt kommandoen så var /var/lib/mysql bare 222MB. You can delete all binary log files with the RESET MASTER […]