← back to the blog
fousa tag
Current tag: tag
2010
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...
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...
Migrating MySQL to PostreSQL // 4 comments
I never thought I had to do this but I'm migrating my MySQL database to PostgreSQL for my Rails application! The reason why is that I want to use the same type of database in development as in production. The reason for using PostgreSQL as a production DB is thanks to Heroku. This is a great hosting company! I had a few problems while migr...
2009
Problem installing MySQL gem on 64bit machine // 1 comment
When I wanted to use MySQL with Ruby on Rails I always got an error when I tried to install the mysql gem. Maybe the reason was because I was working on a 64bit machine, and it was the first time I did! RESOLUTION So to resolve this problem I did the following. I removed all the mysql gems. > sudo gem uninstall mysql Nex...