Debian 10 by default ships mariadb, here are the steps to add the official mysql repository to your system and enable the server. Download the MySql apt repository to your system, and install the package as root, or with sudo privileges. You can find the latest version at this location: https://dev.mysql.com/downloads/repo/apt/ At the time of […]
Category: MySQL
Checklist: install and configure MySQL in Ubuntu 18.04 LTS
Update the repository index: # apt-get update Install the MySQL Server: # apt-get install mysql-server Verify status and installation: # mysql –version Secure local installation: # mysql_secure_installation (at the very least remove anymous access and sample stuff) Start mysql shell: # sudo mysql Verify authentication for root: > SELECT user,authentication_string,plugin,host FROM mysql.user; If set to […]
Using LINQ with MySQL
This code demonstrates access to OSCOMMERCE database objects which are hosted on a mysql server, through the enitity framework and LINQ. Additionaly, the connectionstring is overriden at runtime to seperate developent and production environments. Install the MySql connector for visual studio Add a ADO.NET Entity data object to the solution Use the Wizard to create […]
Backup and restore a MySQL Database from the command line
Creating a backup from the command line on the source server mysqldump -h localhost -u username -p database_name > backup_db.sql Restoring this backup to an existing, empty database on the target server mysql -u username -p database_name < backup_db.sql When scheduling your backup with a batchfile you can use a simple trick to include a […]