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
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 ...