← back to the blog
fousa tag
Current tag: tag
2010
8
FEB
Convert MySQL DB to PostgreSQL DB
When I was converting my blog to the heroku, I decided to convert my local database from MySQL to PostgreSQL. This for developing purposes because it's a bad practice to have 2 different systems in development and production. This is my current setup: 1 local MySQL database with my production dump in it. A new PostgreSQL database that is up a...
21
JAN
Create a user for your MySQL database
When you want to start to develop a new web application then you'll have to create a new database. In my case I prefer using a MySQL database because it is the same as on my remote server. And I also prefer to create a specific user for each database. And here is how you do that! CREATE USER Go to your console and type the following line t...