Ma.gnolia: Ivan Storck's Bookmarks Tagged With "mysql" http://ma.gnolia.com/rss/lite/people/ivanoats/tags/mysql en-us 40 Ivan Storck's Bookmarks Tagged With "mysql" http://creativecommons.org/licenses/by-nc-sa/2.5/ Rail Spikes: Remote MySQL GUI with SSH ivanoats http://creativecommons.org/licenses/by-nc-sa/2.5/ <p>How to connect to MySQL on a remote server via ssh</p> Sun, 22 Jun 2008 21:54:55 PDT http://railspikes.com/2007/8/28/remote-mysql-gui-with-ssh http://ma.gnolia.com/people/ivanoats/bookmarks/tramashod mysql ssh tunneling Search and Replace in MySQL database with phpMyAdmin ivanoats http://creativecommons.org/licenses/by-nc-sa/2.5/ <p>UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");</p> Sun, 06 Apr 2008 16:03:39 PDT http://www.zimmertech.com/tutorials/php/60/mysql-search-replace-phpmyadmin.php http://ma.gnolia.com/people/ivanoats/bookmarks/clekaji mysql search and replace MySQL and Ruby on Rails datatypes | Orthogonal Thought ivanoats http://creativecommons.org/licenses/by-nc-sa/2.5/ <p>One of the best features of Ruby on Rails is the ability to interact with database tables as objects using ActiveRecord. Sometimes documentation can be a bit spotty, but after searching for a little bit it’s not hard to find the mapping from Rails Migrati</p> Mon, 13 Aug 2007 05:28:05 PDT http://www.orthogonalthought.com/blog/index.php/2007/06/mysql-and-ruby-on-rails-datatypes/ http://ma.gnolia.com/people/ivanoats/bookmarks/crexohoyow mysql rails rubyonrails datatypes Rails rake tasks to sync your remote database to your local development environment ivanoats http://creativecommons.org/licenses/by-nc-sa/2.5/ <p>So, you’re managing or developing a Ruby on Rails application that you deploy regularly using Capistrano (as any sane Rails developer should), and you want a really easy way to sync up the database on your remote production server with the development environment you have running on your local machine. This is really useful for debugging your app, especially if you have a lot of user-generated content. It’s also just really helpful for design and development if your local environment looks exactly the same as your live environment.</p> Thu, 02 Aug 2007 22:35:50 PDT http://nateclark.com/articles/2007/02/23/rails-rake-tasks-to-sync-your-remote-database-to-your-local-development-environment http://ma.gnolia.com/people/ivanoats/bookmarks/gruqonathub rubyonrails capistrano mysql YourSQL ivanoats http://creativecommons.org/licenses/by-nc-sa/2.5/ <p>YourSQL for MacOSX - the iApp of MySQL clients.</p> Thu, 08 Jun 2006 13:40:10 PDT http://yoursql.ludit.it/ http://ma.gnolia.com/people/ivanoats/bookmarks/scostapolap mysql gui DaDaBIK |\.-./| - DaDaBIK is a DataBase Interfaces Kreator - Create a PHP Web front-end for a MySQL PostgreSQL Oracle MS SQL Server database in a minute ivanoats http://creativecommons.org/licenses/by-nc-sa/2.5/ <p></p> Sat, 28 Jan 2006 15:40:31 PST http://www.dadabik.org/ http://ma.gnolia.com/people/ivanoats/bookmarks/zuqethip php mysql MySQL Forums :: Microsoft SQL Server :: Re: 1251 client does not support... Dreamweaver/MySQL db connection ivanoats http://creativecommons.org/licenses/by-nc-sa/2.5/ <p>why dreamweaver can't connect to mysql</p> Mon, 09 May 2005 11:44:33 PDT http://forums.mysql.com/read.php?60,10844,20624#msg-20624 http://ma.gnolia.com/people/ivanoats/bookmarks/yoditu mysql dreamweaver MySQL Forums :: Microsoft SQL Server :: Re: 1251 client does not support... Dreamweaver/MySQL db connection ivanoats http://creativecommons.org/licenses/by-nc-sa/2.5/ <p>why dreamweaver can't connect to mysql</p> Mon, 09 May 2005 11:44:33 PDT http://forums.mysql.com/read.php?60,10844,20624#msg-20624 http://ma.gnolia.com/people/ivanoats/bookmarks/ranimewash mysql dreamweaver