Import csv into MYSQL DB with Windows Powershell

Question

Post reply

Import csv into MYSQL DB with Windows Powershell

LittleStudent

Old Hand

Points: 328
More actions
August 11, 2022 at 9:37 am

#4075154
Hello guys,
I'm trying to import my csv with a cmdlet into my MYSQL DB. Bit I have issues with connecting to my db cause there is no options to use a user and password.

The MYSQL server is running localy on the same machine.
This is my code:
Write-SqlTableData -DatabaseName DashboardData -TableName akustik -Serverinstance $env:COMPUTERNAME -SchemaName dashboard -InputData $data -Passthru
and it throws this error:
Write-SqlTableData : Fehler beim Herstellen einer Verbindung mit dem Server "VERWALTUNG-MA".
In Zeile:1 Zeichen:1
+ Write-SqlTableData -DatabaseName dashboard -TableName akustik -Server ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (VERWALTUNG-MA:String) [Write-SqlTableData], ConnectionFailureException
+ FullyQualifiedErrorId : ConnectionToServerFailed,Microsoft.SqlServer.Management.PowerShell.WriteSqlTableData

Would be glad if someone could help me cause i havnt much experience with powershell.
Thanks in advance.
Greetings LittleStudent
- This topic was modified 2 years, 10 months ago by LittleStudent.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247159 More actions · Answer 1

Hello and welcome to the forum.

As this is purely a SQL Server forum, you may find that you would get more help by posting in a MySQL forum instead.

Ant-Green SSC Guru Points: 113544 More actions · Answer 2

Write-SqlTableData is for Microsoft SQL Server only. You cannot run that function against MySQL

As Phil said a dedicated MySQL forum would be best here and maybe looking at the module MySQLCmdlets.

Jeff Moden SSC Guru Points: 1004601 More actions · Answer 3

My recommendation would be to start at the following URL...

https://duckduckgo.com/?q=import+csv+into+mysql+workbench

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

LittleStudent Old Hand Points: 328 More actions · Answer 4

Okay thank you very much guys. Meanwhile i resolved it by myself.

Thank you very much for your fast respponse guys :).

Greeting LittleStudent

Import csv into MYSQL DB with Windows Powershell

Cookies on SQLServerCentral