WordPress SQLite to MySQL Migration Complete

Just finished migrating my website from SQLite to MySQL. What a rush. (lol) It was actually not as bad as I thought. A lot of sed, grep and other sorcery involved; especially in transforming of SQLite statements to MySQL. Some quick commands I used: sqlite techish.db .dump > production_2018-08-23.dump.sql I found that it used quotes for tables and column names, so I had to remove those first and foremost. sed -i '/INSERT INTO/,/VALUES (/s/"//g' production_2018-08-23.dump.sql Next Continue reading →

#sqlite, #wordpress

Change WordPress Password using MySQL

If the Forgot password option doesn't work for you (which it really should), then you can change the password of your self-hosted WordPress login. Check the contents of wp-config.php for the database login. Use that login information for MySQL login. define('DB_NAME', 'wpdatabase'); define('DB_USER', 'wpdbuser'); define('DB_PASSWORD', 'wpdbpassword'); Replacing DB_USER and DB_NAME from that command with the values from wp-config.php, enter the following command to connect to the database Continue reading →

#wordpress