Tag Archives: Database

How-to Restore WordPress Site

In conclusion of “How-to Backup WordPress Site” article, here is small instruction to restore your backup: Upload files to VPS Upload you www.tar.gz and database.sql to the new VPS. You can use WinSCP (as described here) Extract www file structure Extract files: tar -xvf www.tar.gz And copy files: cp -a www/oldsite.com/www/* /var/yoursite.com/www Change permissions: cd /var/yoursite.com/www chown… Read More »


Понадобилось заюзать домены (domain). Набрав SQL запрос типа “CREATE DOMAIN …” я получил ошибку “#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DOMAIN test as VARCHAR …’ at line 1”. Так как мне нравился MySQL то… Read More »