
attractive, usable web applications
Richard's Blog - Design, coding and life in Japan
MySQL
A bash script to download your remote MySQL schema and load it locally
Submitted by Richard on Tue, 11/10/2009 - 16:46#!/bin/bash REMOTEUSER=username REMOTEPASS=password REMOTECOMPUTER=remotecomputer.com REMOTEMYSQLUSER=mysqllogin REMOTEMYSQLPASS=mysqlpass DB=database FILENAME=dbschema.sql LOCALMYSQLUSER=localuser LOCALMYSQLPASS=localpassword ssh -l "$REMOTEUSER" "$REMOTECOMPUTER" "mysqldump -u$REMOTEMYSQLUSER -p$REMOTE
{syntaxhighlighter brush: bash;gutter: false; fontsize: 100; first-line: 1; }#!/bin/bash REMOTEUSER=username REMOTEPASS=password REMOTECOMPUTER=remotecomputer.com REMOTEMYSQLUSER=mysqllogin REMOTEMYSQLPASS=mysqlpass DB=database FILENAME=dbschema.sql LOCALMYSQLUSER=localuser LOCALMYSQLPASS=localpassword ssh -l "$REMOTEUSER" "$REMOTECOMPUTER" "mysqldump -u$REMOTEMYSQLUSER -p$REMOTEMYS
Tags:
Recent Blog Posts
- Why you should use Rails 3 and not Django 5th Sep 10, 12:28
- Doctrine 2 and why you should use it! 29th Jul 10, 15:23
- How to localize your main blog listing page using Drupal 26th Jun 10, 11:46
- Creating Rails like template helpers in Django 24th Jun 10, 22:01
- Error: No module named messagesdjango.contrib.contenttypes 22nd Jun 10, 22:00