MySQL page 1 of 1 for 2 posts
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...
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...