shell - How do I truncate all data in my MySQL database? -

-

i'm using mysql 5.5 on mac 10.7.5. shell (i'm using bash), i'd able run command o truncate data in tables. also, i'd enter single command won't prompt me password. i've tried this, found on post, no dice. shell command can use truncate database table data? 

mysql -umyuser -p -e 'set foreign_key_checks = 0; show tables' my_db | while read table; mysql -e -umyuser -p "truncate table $table" my_db; done enter password:   mysql  ver 14.14 distrib 5.5.25, osx10.6 (i386) using readline 5.1 copyright (c) 2000, 2011, oracle and/or affiliates. rights reserved.  oracle registered trademark of oracle corporation and/or affiliates. other names may trademarks of respective owners.  usage: mysql [options] [database]   -?, --help          display , exit.   -i, --help          synonym -?   --auto-rehash       enable automatic rehashing. 1 doesn't need use                   'rehash' table , field completion, startup                   , reconnecting may take longer time. disable                   --disable-auto-rehash.                   (defaults on; use --skip-auto-rehash disable.)   -a, --no-auto-rehash                   no automatic rehashing. 1 has use 'rehash'                   table , field completion. gives quicker start of                   mysql , disables rehashing on reconnect.   --auto-vertical-output                   automatically switch vertical output mode if                   result wider terminal width.   -b, --batch         don't use history file. disable interactive behavior.                   (enables --silent.)   --character-sets-dir=name                   directory character set files.   --column-type-info  display column type information.   -c, --comments      preserve comments. send comments server.                   default --skip-comments (discard comments), enable                   --comments.   -c, --compress      use compression in server/client protocol.   -#, --debug[=#]     non-debug version. catch , exit.   --debug-check       check memory , open file usage @ exit.   -t, --debug-info    print debug info @ exit.   -d, --database=name database use.   --default-character-set=name ...

you can dump database without data:

mysqldump -u myuser -p --databases --add-drop-database --no-data my_db > my_db.sql

and restore after that

mysql -u myuser -p < my_db.sql

Comments

Post a Comment

Popular posts from this blog

SVG stroke-linecap doesn't work for circles in Firefox? -

-
i've got problem svg stroke-linecap attribute. i've got circular progress bar in angularjs , set outer circle (blue one) have rounded "ends". @ fiddle . <svg ... height="130" width="130"> <!-- ngif: background --> <circle ... ng-if="background" fill="#fff" class="ng-scope" stroke-width="13" stroke="#cc3399" r="57.5" cy="65" cx="65" stroke-linecap="round" /> <!-- end ngif: background --> <circle ... fill="none" stroke-dashoffset="36.12831551628261" stroke-dasharray="361.28315516282623" stroke-width="13" stroke="#432db3" stroke-linecap="round" r="57.5" cy="65" cx="65" transform="rotate(-89.9, 65, 65)" /> </svg> how can that? ...
Read more

routes - Laravel 4 Wildcard Routing to Different Controllers -

-
realizing i'm going take beating this, have several questions "best practices" when constructing laravel route. do laravel routes run "first come first serve" top bottom? if route found, pass control controller (or perform action) , terminate? i have part of application acts url shortner. so, route looks this: route::get('/{id}', array('as' => 'home.text', 'uses' => 'homecontroller@text'), function($id){ //make sure id exists before pushing controller. if (storage::where('shortcode','=', $id)->count() > 0) { // route found } }); how can improved? one, i'm not sure how pass processing on controller conditionally.. sort of controller::make() ..? 3) there better way in laravel check if record exists versus doing mode::where('column','=','value')->count() 4) have legacy urls http://url.com/?...
Read more

cross browser - XSLT namespace-alias Not Working in Firefox or Chrome -

-
i transforming xhtml xhtml, need xslt stylesheet part of resulting document (the stylesheet contained in <script type"text/template"> element. using the xsl:namespace-alias instruction, works fine in ie, fails in both chrome , firefox. here relevant code: <xsl:output doctype-system="about:legacy-compat" omit-xml-declaration="yes" indent="yes" method="html" media-type="application/xhml" encoding="utf-8"/> <xsl:namespace-alias stylesheet-prefix="wxsl" result-prefix="xsl" /> <xsl:template match="head"> <!-- code omitted clarity --> <script type="text/template"> <wxsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns="http://www.w3.org/1999/xhtml" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:eli="local"> ...
Read more