• UPDATE `slogitem` SET `tid`='205' WHERE `tid`='19' AND `title`='dummy'
  • UPDATE `node__xtitext` SET `xtitext_format`='xtitems_text' WHERE NOT `xtitext_format`='xtitems_text'
  • phpmyAdmin:
  • MySQL Workbench: ..ubuntuusers
  • mysql -uroot -p<pwd> <db-name>
  • use <db-name>;
  • reset query cache;
  • show status LIKE 'Qcache%';
  • mysql -uroot -p<pwd> <db-name> < backup.mysql (holen scp)
  • sed -e „s/ENGINE=InnoDB/ENGINE=MyISAM/g“ afoma-2013-01-31T04-19-02.mysql | mysql -uroot -pquickstart2 arocom-afoma
db/x_uebersicht.txt · Zuletzt geändert: 2025/08/20 11:10 von 84.255.205.56
Recent changes RSS feed Debian Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki