Make sure you have a current version of npm and NodeJS installed. Launches an interactive connection to the NEAR blockchain ( REPL)įor EVM support see Project Aurora's aurora-cli. Returns contract state (key / value pairs) in either utf-8 or borsh serializedĭisplays current epoch validator pool detailsĭisplays validator details for the next epochĭisplays validator proposals for the epoch after next Makes a contract call which can only invoke a view method Makes a contract call which can invoke change or view methods Generates a local key pair or shows public key & implicit accountĭisplays all access keys for a given accountĭeletes an account and transfers remaining balance to a beneficiary accountĭeploys a smart contract to the NEAR blockchainĬreates a development account and deploys a contract to it ( testnet only) Stores a full access key locally using NEAR Walletĭisplays all access keys and their details for a given account Overview Ĭlick on a command for more information and examples. "3"|"NYC"|"+1 2"|"523 East 53rd Street"|"apt.The NEAR CLI also comes with an implementation in Rust called near-cli-rs. Mysql -u"$user" -p"$password" "$database" <<EOFĮxecute mkdir -p chmod +x cat /tmp/csvs/offices.csv Restart or Reload mysqld sudo systemctl restart mariadb MariaDB> UPDATE er SET File_priv = 'Y' WHERE user='someuser' AND host='localhost' If you're exporting by non-root user then set permission like below mysql -u root -p | 7 | London | +44 20 7877 2041 | 25 Old Broad Street | Level 7 | NULL | UK | EC2N 1HN | EMEA | | 4 | Paris | +33 | 43 Rue Jouffroy D'abbans | NULL | NULL | France | 75017 | EMEA | | 1 | San Francisco | +1 6 | 100 Market Street | Suite 300 | CA | USA | 94080 | NA | | officeCode | city | phone | addressLine1 | addressLine2 | state | country | postalCode | territory | This keeps it all running under your web user and no need to invoke the mysql user.įor future readers, one easy way is as follows if they wish to export in bulk using bash, mysql -u someuser -p test -e "select * from offices" Immediately after, followed by unlink(file) to delete the file. Just prior to doing the SQL command, then chmod($dir,0755) If you're like me (paranoid about 0777) then you can set your target directory using: chmod($dir,0777) If your files are owned by a different user then just trying to unlink($file) won't work. There is a potential problem if you want to rinse-repeat the process as INTO OUTFILE won't work if the file exists. As previous posters have said, you can use the MySQL temp folder too, I don't suppose it really matters but you definitely don't want to make it 0777 permission (world-writeable) unless you want the world to see your data. That allows the mysql user to write the file. There are a few ways to do this but I ended up putting a folder in : /home/user/tmp/db Since cP/WHM took away the ability to modify User privileges as root in PHPMyAdmin, you have to use the command line to: mysql> GRANT FILE ON *.* TO 2 is to allow that user to dump a file in a specific folder.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |