mysql - Cannot run a database restore on Powershell because of < character -

-

i'm trying run following command:

&$parameterhash["mysql"] -u $parameterhash["user"] -p"$($parameterhash['password'])" -h $parameterhash["host"] $parameterhash['database'] `< $parameterhash['backup-path']

pay attention part of whole command:

$parameterhash['database'] `< $parameterhash['backup-path']

this syntax of mysql command-line restore backup (i.e. a sql script) file system location given database name.

first of all, had escape > in powershell backtick.

the issue entire command isn't recognized mysql command line when run powershell. once run it, mysql outputs help.

if output command string , try run in regular cmd (i.e. cmd.exe) works expected.

for now, can't figure out what's going on.

update

i've tried this:

$restoreargs = "-u $($parameterhash["user"]) -p""$($parameterhash['password'])"" -h $($parameterhash["host"]) $($parameterhash['database']) < $($parameterhash['backup-path'])" start-process $parameterhash["mysql"] $restoreargs

...and got same result.

powershell doesn't support input redirection, output redirection. don't have mysql @ hand right now, can't test, try 

get-content $parameterhash['backup-path'] | &$parameterhash["mysql"] -u $parameterhash["user"] -p"$($parameterhash['password'])" -h $parameterhash["host"] $parameterhash['database']

if input must single string call get-content parameter -raw (powershell v3 , newer):

get-content $parameterhash['backup-path'] -raw | ...

or pipe get-content output through out-string first:

get-content $parameterhash['backup-path'] | out-string | ...

another option run commandline cmd, support input redirection:

$mysql  = $parameterhash["mysql"] $user   = $parameterhash["user"] $pass   = $parameterhash['password'] $server = $parameterhash["host"] $db     = $parameterhash['database'] $backup = $parameterhash['backup-path']  cmd /c "$mysql -u $username -p $password -h $server -d $db < $backup"

Comments

Post a Comment

Popular posts from this blog

sequelize.js - Sequelize group by with association includes id -

-
so when requesting group sequelize follows: return models.workingcalendar .findall({ attributes: [ 'workingcalendar.periodid', 'workingcalendar.date', 'period.name' ], include: [ { model: models.period, attributes: [] } ], where: { getsudoid: currentgetsudo.id, unitplantid: unitplantid }, group: ['workingcalendar.periodid', 'workingcalendar.date', 'period.name'], }); sequelize run query: select [workingcalendar].[id], [workingcalendar].[periodid], [workingcalendar].[date], [period].[name] [workingcalendars] [workingcalendar] left outer join [periods] [period] on [wor...
Read more

delphi - Take screenshot in webcam using VFrames in Console Application -

-
i'm doing program take picture of webcam using delphi xe2 , vframes achieve this, problem have figured out, in graphic application works fine, when use unit in console application, returns me error saying first chance exception @ $76b6b727. exception class eaccessviolation message 'access violation @ address 004a271b in module 'console.exe'. read of address 00000260'. process console.exe (3676) my unit : unit webcam; interface uses sysutils, windows, vcl.imaging.jpeg, vcl.graphics, vsample, vframes, classes; type twebcam = class private procedure newvideoframeevent(sender: tobject; width, height: integer; dataptr: pointer); public constructor create; destructor destroy; override; procedure capture_webcam(take_name: string); end; var web_image: tvideoimage; name_screen: string; implementation constructor twebcam.create; begin inherited create; end; destructor twebcam.destroy; begin inherited destroy; end; ...
Read more

angular - Angular2 Router: Cannot find primary outlet to load 'HomeComponent' -

-
tried switch new router in version "@angular/router": "3.0.0-beta.2" in combination "@angular/*": "2.0.0-rc.4", following official docs on componentrouter. however, i'm facing issue when trying load app default homecomponent: cannot find primary outlet load 'homecomponent' it seems has using templateurl , external html file instead of using inline template style. homecomponent not shown in window , error printed console. however, when use link home component gets shown second hand. as change from templateurl: 'home.html' to template: '<router-outlet></router-outlet>' error gone, homecomponent shown , routing works expected. is known issue? work using templateurl? there have respect work? the problem was, due app loading screen, <router-outlet></router-outlet> did not exist yet, due race condition. if need hide html part containing outlet, use [hidden] instead o...
Read more