---迁移wordpress

sudo tasksel install lamp-server

CREATE DATABASE WordPressDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

sudo cp /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-available/mysite.conf

sudo a2ensite mysite

sudo a2enmod rewrite

mysql -u username -p new_database < data-dump.sql

/etc/apache2/apache2.conf:

<Directory /var/xwwwx/blogroot>
        Options Indexes FollowSymLinks
        AllowOverride None
        Require all granted
</Directory>

mysql> CREATE DATABASE wordpress
 utf8
DEFAULT COLLATE utf8_genercal_ci;
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON wordpress.* TO ‘vamei‘@‘localhost‘ IDENTIFIED BY ‘vameiisgood‘;

apache2ctl -S

https://www.cnblogs.com/vamei/archive/2012/12/04/2799381.html
https://www.hostinger.com/tutorials/how-to-install-wordpress-on-ubuntu-using-lamp-stack/