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 […]