Tag: development

Posted on

How to Clone a MySQL Database. Useful for Development

You can also use mysqldump and mysqlimport to transfer the database. For large tables, this is much faster than simply using mysqldump. In the following commands, DUMPDIR represents the full path name of the directory you use to store the output from mysqldump.First, create the directory for the output files and dump the database:

shell> mkdir DUMPDIRshell> mysqldump --tab=DUMPDIR db_name

Then transfer the files in the DUMPDIR directory to some corresponding directory on the target machine and load the files into MySQL there:

shell> mysqladmin create db_name # create database
shell> cat DUMPDIR/*.sql | mysql db_name # create tables in database
shell> mysqlimport db_name DUMPDIR/*.txt # load data into tables

Do not forget to copy the mysql database because that is where the grant tables are stored. You might have to run commands as the MySQL root user on the new machine until you have the mysql database in place.

After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant table information.

Source: MySQL :: MySQL 5.0 Reference Manual :: 2.19.5 Copying MySQL Databases to Another Machine

Currently the best way to make a clone of a database on the CALI dev environment. Useful as a aid to development allowing the developer to test new things out on copy of a db so if it goes wrong you can get back to where you were.

 

Posted on

Build splash sites with Gulp AWS Splash

The open-source LaunchRock alternative. Build beautiful splash pages to collect emails & more – primarily focused on performance and rapid development.

Gulp AWS Splash https://github.com/niftylettuce/gulp-aws-splash

You’ve seen those spiffy one page announcement sites for the web’s next big thing. This is an open source system that helps you build them quickly and easily. The idea is to acquire customers quickly and these pages are designed to do that.
Requires node.js and npm. Makes use of Google Analytics, Mailchimp, and various AWS services.

Posted on

Seldon is an open source recommendation platform

Seldon is made up of many components that work together to deliver the best recommendations. Roughly, all user actions are captured via the REST API and streamed to logs. Those logs are processed in batch and new user models are delivered to the API Server. Then recommendations are delivered via the REST API.

http://docs.seldon.io/tech.html

The code for Seldom is on Github at https://github.com/SeldonIO/seldon-server.

Posted on

Windows apps I use regularly

I recently had the opportunity to reinstall Windows 7 on my laptop and figured it was a good time to make a list of the programs and utilities I use regularly on Windows. Most stuff is open source and/or free. There are a few commercial packages that I use a lot that I really like so I’ve included those on the list too. I don’t work in Windows that often, but when I do these are the things I use.

  • Firefox – https://www.mozilla.org/en-US/firefox/
  • Chrome – http://www.google.com/chrome/
  • Classic Shell – http://classicshell.net/
  • Ditto Clipboard Manager – http://ditto-cp.sourceforge.net/
  • Gadwin PrintScreen – http://www.gadwin.com/printscreen/
  • 7 Zip – http://www.7-zip.org/
  • Notepad++ – http://notepad-plus-plus.org/
  • VirtuaWin – http://virtuawin.sourceforge.net/
  • Keepass 2.x – http://keepass.info/
  • Owncloud – http://owncloud.org/
  • Git – https://msysgit.github.io/
  • Putty – http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
  • Filezilla – https://filezilla-project.org/ (watch for crapware installs)
  • LibreOffice – https://www.libreoffice.org/
  • Bitorrent – http://www.bittorrent.com/bittorrent-free
  • Tweak UI – http://www.thewindowsclub.com/ultimate-windows-tweaker-v2-a-tweak-ui-for-windows-7-vista
  • MySQL Workbench – https://www.mysql.com/products/workbench/
  • CALI Author – http://www.cali.org/content/cali-author-download
  • XAMPP – https://www.apachefriends.org/index.html
  • Skype – http://www.skype.com/
  • Dropbox – http://www.dropbox.com/
  • Komodo – http://komodoide.com/
  • Slack – https://slack.zendesk.com/hc/en-us/articles/201746897-Slack-apps-for-computers-phones-tablets