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

sql - VB.NET Operand type clash: date is incompatible with int error -

-
i trying display records table named staffpresentee database using clause... i using visual studio 2010... the table design follows- .......fieldname..................datatype........allownull 1......staff_id (fk).............numeric(18,0)......yes 2.......date........................date.............no 3......present.....................char(1)..........yes note type of 2nd field date , not datetime... i want display records table have today's date int 'date' field... current query is- cmd = new sqlclient.sqlcommand("select * staffpresentee date=" & date.now.date, cn) dr = cmd.executereader for dr = cmd.executereader error "operand type clash: date incompatible int" i tried select * staffpresentee query without clause runs correctly. try putting date value in sigle quotes maybe. cmd = new sqlclient.sqlcommand("select * staffpresentee date='" & _
Read more

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

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -

-
here code im = cv2.imread('luffy.jpg') gray = cv2.cvtcolor(im,cv2.color_bgr2gray) ret,thresh = cv2.threshold(gray,127,255,0) contours,h = cv2.findcontours(thresh,cv2.retr_tree,cv2.chain_approx_simple) cnt in contours: moment = cv2.moments(cnt) c_y = moment['m10']/(moment['m00']+0.01) c_x = moment['m01']/(moment['m00']+0.01) centroid_color = im[c_x,c_y] centroid_color = np.array((centroid_color[0],centroid_color[1],centroid_color[2])) print type(centroid_color) cv2.fillpoly(im,cnt,centroid_color) i getting error on last line try , pass centroid_color color argument. <type 'numpy.ndarray'> , have been able pass data type cv2.fillpoly color in other instances, not sure why having problem here. fillpoly() expects iterable, i.e. put cnt in brackets. believe duplicate of https://stackoverflow.com/a/17582850/5818240 . moreover, centroid color variable contains strings. need convert them i
Read more