How to rename your WordPress database tables prefix after the installation
|

How to rename your WordPress database tables prefix after the installation

ByNikles

It’s really easy. You just need a plugin: Change DB Prefix Make a backup of your database (and maybe your wp-config.php) Make sure the webserver owns the whole WordPress directory (i.e. if you’re using Apache Web Server and your WordPress files resides inside /var/www/webdomain.com/public_html/, just make sure to sudo chown -R www-data:www-data /var/www/webdomain.com/public_html/ Also issue a sudo…

Convert your WordPress Database Charset and Collation to utf8
|

Convert your WordPress Database Charset and Collation to utf8

ByNikles

In the wp-config.php file there are two lines that define your MySQL database charset and collation. define( ‘DB_CHARSET’, ‘utf8’ ); define( ‘DB_COLLATE’, ‘utf8_general_ci’ ); These lines should match those of your database but it’s not always like that; maybe you want to migrate the database content into another one (which is CHARACTER SET utf8 COLLATE…