All Posts tagged as "database management"

server management

Recovering innodb data after accidental removal of log files

The role of Full Stack web developers is becoming increasingly popular. A Full Stack Web Developer is one who has a working knowledge of all components involved in website development. This includes front-end programming, back-end programming and server administration.

Read

Converting MySQL database to SQlite3 format

SQlite3 is a lightweight relational database that can be used in place of relational database servers such as MySQL and PostgreSQL. SQLite3 databases are commonly used in Mobile applications. In contrast to most relational databases, a SQLite3 database is a single independent file. The file has a .db extension. Most programming languages such as Python and PHP provide libraries for accessing SQLite3 databases.

Read

Database Management - Quick Tips

Following are some quick tips related to Database Management:

Read

Upgrading MySQL server from version 5.6 to 8.0

The latest version of MySQL server currently is 8.03. To upgrade MySQL server from a previous version we need to ensure that we are upgrading from the last stable release. For example from version 5.7 to 8.0.

Read