mariadb - mysql dump in maria db lost data -


i imported mysql dump maria db, , lost serialized data. possible? import process or else @ miss?

besides having maria db , mysql, search , replace on db change domain of site. cause problem serialised data?

a:7:{s:15:"homepage_slider";a:1:{i:0;a:3:{s:10:"slide_text";s:30:"think big. act knowledge.";s:10:"slide_link";a:1:{i:0;s:2:"22";}s:11:"slide_image";a:2:{s:13:"attachment_id";s:3:"132";s:3:"url";s:45:"//act.dev/app/uploads/2016/01/index_slide.png";}}}s:17:"homepage_triplets";a:3:{i:0;s:2:"22";i:1;s:2:"20";i:2;s:3:"113";}s:15:"social_networks";a:4:{i:0;a:2:{s:12:"network_name";s:8:"facebook";s:11:"network_url";s:31:"http://www.facebook.com/act.ge/";}i:1;a:2:{s:12:"network_name";s:8:"linkedin";s:11:"network_url";s:8:"http://2";}i:2;a:2:{s:12:"network_name";s:7:"twitter";s:11:"network_url";s:12:"http://asdas";}i:3;a:2:{s:12:"network_name";s:7:"youtube";s:11:"network_url";s:7:"http://";}}s:13:"office_on_map";a:8:{s:8:"location";s:38:"sairme hill, tbilisi, tbilisi, georgia";s:5:"venue";s:14:"51 sairme hill";s:7:"address";s:11:"sairme hill";s:4:"city";s:7:"tbilisi";s:5:"state";s:7:"tbilisi";s:7:"country";s:7:"georgia";s:3:"zip";s:4:"0194";s:11:"coordinates";a:2:{s:3:"lat";i:0;s:3:"lng";i:0;}}s:12:"office_email";s:14:"geo@act-gr.com";s:11:"office_tell";s:17:"+995 32 2422 322 ";s:14:"office_virtual";b:0;}

enter image description here

php serialized object contains string lengths along actual string values. if modifying external tool need make sure change string lengths when changing string values. length of string goes after s:.


Comments

Post a Comment

Popular posts from this blog

authentication - Mongodb revoke acccess to connect test database -

i have ec2 instance mongodb 3.2.0 installed. have user admin access. can connect user , perform operation remotely. 1 can connect database test remote if knows ip mongo 11.11.11.11. although not able make operations, want restrict access user credentials can connect server. first need create users , grant roles users, example: use admin db.createuser( { user: "myuseradmin", pwd: "abc123", roles: [ { role: "useradminanydatabase", db: "admin" } ] } ) then need start server --auth parameter mongod --auth more information here
Read more

python - GitPython: check if git is available -

gitpython depends on having command line version of git installed (otherwise, issue in question: oserror: [errno 2] no such file or directory on gitpython ). is there way gitpython api check if executable found, or, need wrap gitpython calls in exception handling account possibility? i don't particularly recommend this, did @ least once: try 1 git command while catching oserror case see if can run git (and running it, capture git version number well, in case). if git fails run, complain , disable further invocations of git (or exit or whatever). if not, assume further invocations continue work.
Read more

How to merge four videos on one screen with ffmpeg -

Image
this question has answer here: video grid vstack , hstack 1 answer i have video test.mp4, , need make appear 4 times @ once on screen. here found command makes 2 videos appear @ time ffmpeg -i input0.avi -vf "movie=input1.avi [in1]; [in]pad=640*2:352[in0]; [in0][in1] overlay=640:0 [out]" out.avi but doesn't work mp4 videos, , need 4 videos @ time. thank in advance four different inputs ffmpeg -i input0 -i input1 -i input2 -i input3 -filter_complex \ "[0:v][1:v]hstack[top]; \ [2:v][3:v]hstack[bottom]; \ [top][bottom]vstack,format=yuv420p[v]; \ [0:a][1:a][2:a][3:a]amerge=inputs=4[a]" \ -map "[v]" -map "[a]" -ac 2 output.mp4 two hstack instances make top , bottom, vstack combines those. amerge combines audio streams, -ac 2 downmixes them stereo. same input ffmpeg -i input \ -filter_complex ...
Read more