Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error

We downloaded a database back up via UpdraftPlus from the Azure WordPress. And the problem became pretty clear. Take a look at the Storage Engine and Collation of the create query: CREATE TABLE `wp_options` ( `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `option_name` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ”, `option_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, … Read more

Access files at new location using old file paths

I believe I’ve found the solution. I add the following RewriteRule ^example_directory/files/(.*) new_directory/$1 to my WordPress .htaccess rules like so: RewriteEngine On RewriteBase / RewriteRule ^example_directory/files/(.*) new_directory/$1 RewriteRule ^index\.php$ – [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] I couldn’t get it working before and I think the key was moving the … Read more

Switched hosts to one with cPanel. To transfer my blog should I do the WP install or just be uploading my old WP directory & database?

You can try the manual transfer, first copy all your tables on your new database. Then you need to update the wp-config.php file in order for it to be able to connect. In case you have the rewriting enabled, you may also need to update the htaccess file (if the rewritebase is different, it’s not … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)