Category: MySQL

  • Importing a MySQL database with a new name where the original still exists

    So you want to export your MySQL database then import it on the same server with a new name.   I tried this several times and using the SOURCE command inside MySQL or just mysql -p < db.sql both resulted in the database re-importing over the original name.   To fix that run: sed -i…

  • MySQL: How to create a database

      To create a simple database (e.g. if you need to create one for a WordPress or Wiki install) use the following after logging in to MySQL as the root user:   create database [nameOfDatabase];   Don’t forget the ; at the end, or you’ll end up on a new line consisting of a >…