Categories: Windows

Memorandum #13.

   Being too busy with writing HTTP/2, I’ll also write about it, which is I moved to MariaDB 10.1.8. Not to update it. Besides, I found PHP5.6.15, phpMyAdmin4.5.1 and ActivePerl-5.20.2.2002 yesterday, so I took care of them all.

  • MariaDB 10.0.21 —>> MariaDB 10.1.8 Changelog

    First, I backed up all the sever data. Especially, MariaDB and MyDB, and then, took a usual way to update. But I had errors like this and the SQL server didn’t start again though the text has the line ‘x:MyDBbinmysqld.exe: ready for connections.’. Oops! くりくりさん wrote about having the same trouble on his blog, and I found some other people had the same experience at updating from 10.0.21 to 10.1.8. ☞ MariaDB 10.1.8 crashes at startup

    So, I deleted both of MariaDB and MyDB completely, and installed very new MariaDB 10.1.8 as my SQL server. I re-started the service again. It was successful with no error. At shutting down it had no error, either. In the error log I found ‘Dumping buffer pool(s) not yet started’, so I made the next two to ON in my.ini. ☞ Dumping and restoring the buffer pool

    • innodb_buffer_pool_load_at_startup = ON
    • innodb_buffer_pool_dump_at_shutdown = ON

    After the two turned to ON, the log changed like this.

    Start the server again. I connected the server from cmd.exe for setting root password.

    1. mysql -u root
    2. SET PASSWORD FOR root@localhost=PASSWORD('password');
    3. quit

    I logged the server on as root by phpMyAdmin. At the time, phpMyAdmin might give you error messages about control user or so, but don’t worry. They will have gone after finishing following steps.

    1. Make the same users as before. I used back-up sql files from the previous server for the users’ privilege settings.
    2. Create the database phpmyadmin and import all table data from back-up sql files, which is for control_user.
    3. Create all other databases and import their data. In my case, I did this for my WordPress.
  • PHP5.6.14 —>> PHP5.6.15 (Changelog)
  • phpMyAdmin4.5.0.2 —>> phpMyAdmin4.5.1 (Changelog)
  • ActivePerl-5.20.2.2001 —>> ActivePerl-5.20.2.2002

   I had no trouble other than about MariaDB 10.1.8.

   That’s it.

By the way, I sent a request, which is o6asan.com for inclusion in Chrome’s HTTP Strict Transport Security (HSTS) preload list, to hstspreload.appspot.com on around Oct 22. It said my domain going into a queue. Today, I found o6asan.com on the list.
o6asan

Recent Posts

Very easy, sweet potato yōkan recipe.

The recipe for sweet potato yōkan that I often made this fall. Ingredients Sweet potato…

5 months ago

On my home network, I’ve built an FTP server that I left for long time.

After a long time, when I checked broken links and fixed them, I got an…

2 years ago

Moving “o6asan’s BBS”.-#2

I made a box, so I prepare the contents. Theme and Plugins. The theme is…

2 years ago

Moving “o6asan’s BBS”.

Hehe, it's been almost a year since my last post. I received a notification email…

2 years ago

I completed my WordPress to Sub-domain.

About a week ago, I finally started to renew my sites, which I had been…

3 years ago

Happy New Year!

   Happy New Year! It is the beginning of a new year.    This is a year…

5 years ago

This website uses cookies.