Posts tagged mysql

Django change the database backend.

Dec. 22, 2016, 8:37 a.m. odo , python , django , sqlite , mysql

In theory if you use django, changing your RDBS from say sqlite to mysql is a breeze. All you need is generate a dump of your existing data with ./manage.py dumpdata, change settings.py and do ./manage.py migrate on the new server. Then you can import the previously exported data through ./manage.py ...

Ruby DBI

April 23, 2012, 11:01 a.m. DBI , mysql , Ruby

This is another left over post from my learn ruby project. Ran into trouble while learning how to use databases with Ruby. test.rb:1:in `require': no such file to load -- dbi (LoadError) from test.rb:1   Tried to do the obvious thing, which is yum install ruby-dbi without any luck. Next tried ...

Mysql Incremental Backup

April 17, 2012, 3:51 p.m. innobackupex , mysql , Percona , xtrabackup

Still using mysql? about time you gave up on it and switched to Percona. It is a drop in replacement for mysql. That means your existing data, and stored procedures, or data retrieval methods don't need to undergo any changes. Even if you don't switch to Percona, you can still use their xtrabackup a ...

Percona xtrabackup

Nov. 24, 2011, 3:30 a.m. mysql , Percona , xtrabackup

Having recently recently replaced MySQL installations with Percona it was time to try out xtrabackup but things didn't get off to an auspicious start.  ...

Percona Installation Woes

Nov. 12, 2011, 1:29 p.m. AWS , Centos , cloud , mysql , Percona , REMI , Webtatic

It turns out that all the EC2 Amazon Machine Instances that have Percona installed by default have older versions of either Percona or PHP or both. My intention was to use Percona on a web app so it's required that the version of PHP is reasonably new.  So the logical thing to do is to install Perco ...

Percona a Drop in Replacement for MySQL

Oct. 14, 2011, 1 p.m. cloud , Couch , mysql , nosql , Percona , Postgres

I have a love hate relationship with MySQL. I first discovered and fell in love with it around twelve years ago. I didn't mind that it didn't have stored procedures and sub queries. My first disappointment was when MySQL announced changes to their client license terms around eight years back. Disill ...

MySQL stored procedures with PDO or mysqli

Aug. 21, 2011, 1:48 p.m. mysql , mysqli , PDO

So it looks like the whole world is moving from the PHP mysqli api to PDO (mysqli? what the hell is mysqli? guess you are asking cause you picked up PHP only during the last two years). There are millions of lines of PHP code out there that still uses the mysqli api and caveat that used to trip up c ...