Problem: phpmyadmin interfaces are slow and often attacked by script kids, if you can don’t use it! Solution: To backup and restore use command line To Backup a database: $mysqldump -u root -p wordpressdb > /backups/wordpressdb-dump.sql [Enter root password] To restore: $mysql -u root -p wordpressdb < /backups/wordpressdb-dump.sql[Enter root password] Remark: this is not recogized […]
Schlagwort: backup
WordPress MySQL: Cleanup old revisions old posts old entrys
Problem: If you use wordpress and edit often your posts a high count of old revisions are backuped inside the mysql database: Solution: Login mysql $mysql -u root -p [Enter root password] at mysql command line select wordpress your database mysql>use wordpressdb; [Enter] System echo=Database changed.. delete old backups of posts mysql>DELETE FROM wp_posts WHERE […]
SME Server usefull Backup Tips Custom Templates Customizing SME
On SME Server: Data Path which are saved by Console Backup – save all Custom-Scripts which you run with Cron or Root at Location /root – save all modified Custom Templates at /etc/e-smith/templates-custom – all ibays – all /home – if you not know how to make /etc/e-smith/templates-custom files copy the standard templates from /etc/e-smith/templates […]
SME Server USB Disk Stick mount Problem at SME Server Backup Console
Problem: On SME Server the HAL Daemon often not recognize a USB Stick or Disk which you can use for „Console“ Backup Program. Solution: – Create a Script with #nano /root/backup.sh – insert: service haldaemon restart service messagebus restart console exit This restart the HAL Environment before Console (SSH-Admin-Tool)is opened. To prevent Users to write […]