when searching for this error ‘invalid command \N’ when trying to restore my database from a backup I made with the following: $ pg_dump -d foo -t bar > bar.psql I got lots of suggestions but what I needed was to drop the darn table before restoring it … $psql Read more
pg_createcluster -d /var2/lib/postgresql/12/two -l /var/log/postgresql/postgresql-12-two.log -p 5433 12 two
If you want to loop through something with more than one variable in bash this is your ticket to ride: #!/usr/bin/env bash while read -r x y z; do echo “$x $y $z” done <<‘_____HERE a b c 1 2 3 x y z 7 8 9 _____HERE
The Julia community seems shy about posting examples of database things… use LibPQ, Tables db=”db” server=”localhost” usr=”psql” passwd=”nope” conn = LibPQ.Connection(“host=$server dbname=$db user=$usr password=$passwd”) sql = “””select char from foo””” conn2 = LibPQ.Connection(“host=$server dbname=$db user=$usr password=$passwd”) sql2 = prepare(conn2, “””update bar set agility = \$1 , bravery = \$2 where Read more
So the last time I purchased a new wireless router – I tried to find a wireless router that had a future – something where I could replace the stock firmware once the software updates stopped coming from the manufacture. But by this time linksys had sold its soul and Read more
https://github.com/JuliaDatabases/DBInterface.jl mariadb — mysql while doing a query on “conn”, I opended second connection “conn2”, and updated the table while stepping through the results of the first query conn = DBInterface.connect(MySQL.Connection,”localhost”,”user”,”pass”,db=”foo”) sql = “””select char from foo””” response = DBInterface.execute(conn,sql) conn2 = DBInterface.connect(MySQL.Connection,”localhost”,”user”,”pass”,db=”foo”) sql2 = DBInterface.prepare(conn2, “UPDATE foo set agility Read more
LOAD DATA LOCAL INFILE ‘/var/tmp/foo.csv’ INTO TABLE foo FIELDS TERMINATED BY ‘,’ ENCLOSED by ‘”‘ LINES TERMINATED BY ‘\n’;
https://docs.themeisle.com/article/562-how-to-remove-opacity-in-hestia .hestia-ribbon.section-image:after { background-color: rgba(0, 0, 0, 0) !important; }
installing dd-wrt on a EA6350v2 from linux. So linksys hasn’t released a firmare update for the EA6350V2 since 11/2017 and it is still on a 2.6 kernel, so I wanted to try to get to a newer kernel – DD-WRT supports EA6350v1 and the forum has tale of the same Read more
ssh -oKexAlgorithms=+diffie-hellman-group1-sha1 -oCiphers=+aes128-cbc