Popular New Releases in IDE Plugin
leetcode-editor
v2022.1.1-Pro
MinecraftDev
Release 2021.1-1.5.19
sonarlint-intellij
6.7.0.45926
intellij-rainbow-fart
1.3.3
mybatipse
mybatipse-1.2.4
Popular Libraries in IDE Plugin
by shuzijun 
java
2244 Apache-2.0
Do Leetcode exercises in IDE, support leetcode.com and leetcode-cn.com, to meet the basic needs of doing exercises.Support theoretically: IntelliJ IDEA PhpStorm WebStorm PyCharm RubyMine AppCode CLion GoLand DataGrip Rider MPS Android Studio
by minecraft-dev kotlin
924 NOASSERTION
Plugin for IntelliJ IDEA that gives special support for Minecraft modding projects.
by SonarSource java
464 LGPL-3.0
SonarLint for IntelliJ
by izhangzhihao kotlin
433 MIT
🌈一个在你编程时持续夸你写的牛逼的扩展，可以根据代码关键字播放贴近代码意义的真人语音。Inspired by vscode-rainbow-fart
by angelozerr java
334 NOASSERTION
AngularJS Eclipse Plugin
by mybatis java
314 EPL-1.0
Eclipse plugin adding support for MyBatis SQL Mapper Framework.
by cnfree java
308
Eclipse Class Decompiler integrates JD, Jad, FernFlower, CFR, Procyon seamlessly with Eclipse and allows Java developers to debug class files without source code directly
by ruby-debug ruby
273 NOASSERTION
An interface which glues ruby-debug to IDEs like Eclipse (RDT), NetBeans and RubyMine.
by eclipse-ee4j java
272
Eclipse GlassFish
Trending New libraries in IDE Plugin
by izhangzhihao kotlin
433 MIT
🌈一个在你编程时持续夸你写的牛逼的扩展，可以根据代码关键字播放贴近代码意义的真人语音。Inspired by vscode-rainbow-fart
by JetBrains java
121 Apache-2.0
Psalm plugin for PhpStorm
by MSDehghan java
68
IntelliJ plugin that helps developing Ansible files
by lineuman shell
68
英雄联盟语音包系列 目前有九尾妖狐·阿狸 + 风暴之怒·迦娜 vscode-rainbow-fart 扩展语音包
by heixiaobai shell
50 NOASSERTION
rainbow fart语音包，全新台词与真人配音，支持python与JavaScript版本
by chaselen typescript
41
VSCode 上逛 V2EX 网站的插件
by Liang-Qiu python
28 MIT
Code for Structured Attention for Unsupervised Dialogue Structure Induction.
by BlackStartx java
19 MIT
A PyCharm Plugin that simplify the development of Blender Add-On inside the PyCharm IDE.
by wangtao0101 typescript
17 MIT
vscode debug extension for leetcode, can work with vscode-leetcode
Top Authors in IDE Plugin
1
3 Libraries
203
2
2 Libraries
127
3
2 Libraries
41
4
2 Libraries
86
5
2 Libraries
7
6
2 Libraries
226
7
2 Libraries
250
8
2 Libraries
16
9
2 Libraries
289
10
2 Libraries
130
1
3 Libraries
203
2
2 Libraries
127
3
2 Libraries
41
4
2 Libraries
86
5
2 Libraries
7
6
2 Libraries
226
7
2 Libraries
250
8
2 Libraries
16
9
2 Libraries
289
10
2 Libraries
130
Trending Kits in IDE Plugin
No Trending Kits are available at this moment for IDE Plugin
Trending Discussions on IDE Plugin
I cannot read vuex-persist in v-if
What exactly is the difference between an anonymous function and a static anonymous function in PHP?
Is there an easy way to watch selected local PHP files for content changes on Windows?
How to manually add a .xcframework to a Flutter iOS Plugin?
How to hide/remove the import/export buttons on Preferences dialog in Eclipse RCP
compilation.emitAsset is not a function in sitemap-webpack-plugin
Kotlin expression giving different results (runtime vs IDE Evaluate expression)
Export/Import a table from MySQL via command lines
Android Studio 4.2 Kotlin Plugin Issue
Is Isubscriber (server side plugins) supported in azure devops 2020?
QUESTION
I cannot read vuex-persist in v-if
Asked 2022-Feb-24 at 19:06I am trying to use vuex-persist on nuxt.js but when try to read the data in a v-if doesn't work.
I created a new file inside plugins called vuex-persis.js with the following code:
1import VuexPersistence from 'vuex-persist'
2
3export default ({ store }) => {
4 new VuexPersistence({
5 storage: window.localStorage,
6 }).plugin(store);
7}
8and into nuxt.config.js I added the following code:
1import VuexPersistence from 'vuex-persist'
2
3export default ({ store }) => {
4 new VuexPersistence({
5 storage: window.localStorage,
6 }).plugin(store);
7}
8plugins: [{ src: '~/plugins/vuex-persist', mode: 'client' }],
9The code that I use in order to store and get data is the following:
1import VuexPersistence from 'vuex-persist'
2
3export default ({ store }) => {
4 new VuexPersistence({
5 storage: window.localStorage,
6 }).plugin(store);
7}
8plugins: [{ src: '~/plugins/vuex-persist', mode: 'client' }],
9this.$store.commit('login', { idToken });
10
11store.state.isLogin
12and I have added the following file inside the project ./store/index.js
1import VuexPersistence from 'vuex-persist'
2
3export default ({ store }) => {
4 new VuexPersistence({
5 storage: window.localStorage,
6 }).plugin(store);
7}
8plugins: [{ src: '~/plugins/vuex-persist', mode: 'client' }],
9this.$store.commit('login', { idToken });
10
11store.state.isLogin
12export const state = () => ({
13 isLogin: false,
14 idToken: '',
15});
16
17export const mutations = {
18 login(state, newState) {
19 state.isLogin = true;
20 state.idToken = newState.idToken;
21 },
22 logout(state) {
23 state.isLogin = false;
24 state.idToken = '';
25 },
26};
27I have the following navbar when I try to get the data from store:
1import VuexPersistence from 'vuex-persist'
2
3export default ({ store }) => {
4 new VuexPersistence({
5 storage: window.localStorage,
6 }).plugin(store);
7}
8plugins: [{ src: '~/plugins/vuex-persist', mode: 'client' }],
9this.$store.commit('login', { idToken });
10
11store.state.isLogin
12export const state = () => ({
13 isLogin: false,
14 idToken: '',
15});
16
17export const mutations = {
18 login(state, newState) {
19 state.isLogin = true;
20 state.idToken = newState.idToken;
21 },
22 logout(state) {
23 state.isLogin = false;
24 state.idToken = '';
25 },
26};
27navbar-button(to='/board', v-if='$store.state.isLogin')
28 p {{ $t("navbar_board") }}
29navbar-button(v-if='$store.state.isLogin', @click.native='logout')
30 p {{ $t("navbar_logout") }}
31but always enter in the same place, log in.
I tried to use a computed like this but doesn't work on the v-if
1import VuexPersistence from 'vuex-persist'
2
3export default ({ store }) => {
4 new VuexPersistence({
5 storage: window.localStorage,
6 }).plugin(store);
7}
8plugins: [{ src: '~/plugins/vuex-persist', mode: 'client' }],
9this.$store.commit('login', { idToken });
10
11store.state.isLogin
12export const state = () => ({
13 isLogin: false,
14 idToken: '',
15});
16
17export const mutations = {
18 login(state, newState) {
19 state.isLogin = true;
20 state.idToken = newState.idToken;
21 },
22 logout(state) {
23 state.isLogin = false;
24 state.idToken = '';
25 },
26};
27navbar-button(to='/board', v-if='$store.state.isLogin')
28 p {{ $t("navbar_board") }}
29navbar-button(v-if='$store.state.isLogin', @click.native='logout')
30 p {{ $t("navbar_logout") }}
31computed: {
32 isLogin: function () {
33 console.log(this.$store.state.isLogin);
34 return this.$store.state.isLogin;
35 },
36 },
37the console.log prints the value stored in the browser but the console.log in node prints always the default state.
Anyway, the console.log always prints the correct value stored in the localstorage.
Any idea about how can I use that data in the v-if?
Thanks
ANSWER
Answered 2022-Feb-24 at 19:06Finally solved directly using $store.state.isLogin in the v-if
QUESTION
What exactly is the difference between an anonymous function and a static anonymous function in PHP?
Asked 2022-Feb-01 at 15:11Basically the purpose of the static keyword is totally clear to me, the PHP docs only explain the purpose of the keyword in the context of classes. I noticed one of my IDE plugins suggesting me that I should declare many of my callback functions as static.
Without static:
1$myUniqueArray = unique($arrayToFilter,
2 function (ExamQuestion $examQuestion) {
3 return $examQuestion->getId();
4 }
5);
6With static:
1$myUniqueArray = unique($arrayToFilter,
2 function (ExamQuestion $examQuestion) {
3 return $examQuestion->getId();
4 }
5);
6$myUniqueArray = unique($arrayToFilter,
7 static function (ExamQuestion $examQuestion) {
8 return $examQuestion->getId();
9 }
10);
11For the result it does not make a difference, it works both. What exactly is the difference between a callback function and a static callback function in PHP under the hood? What are possible benefits and drawbacks in this context?
ANSWER
Answered 2021-Oct-28 at 19:52You're referring to Static Anonymous Functions [DOC] which are introduced as following in the documentation:
Anonymous functions may be declared statically. This prevents them from having the current class automatically bound to them. Objects may also not be bound to them at runtime.
If you compare that with the explanation of the static keyword in the context of class methods [DOC], this might make the relation more clear. These are introduced as following in the documentation:
Because static methods are callable without an instance of the object created, the pseudo-variable
$thisis not available inside methods declared as static.
So an actual difference is that you don't have $this bound / available within the anonymous function when it is static.
The reason why you get the suggestion within the IDE is that static anonymous functions give you a slightly better performance over the non-static variant. So unless you need $this within the function, you can safely use the static variant over the non-static one.
Anonymous functions have been introduced in PHP 5.3, both with and without the static keyword [RFC] [5.3.0]. In PHP 5.3 $this was not automatically bound when defined within a class (intentionally) and has been changed with PHP 5.4 and it is since then $this is automatically bound for the (non-static) anonymous function.
Since PHP 7.4 you can find arrow functions [DOC] which also come in the static/non-static flavours. However:
Arrow functions support the same features as anonymous functions, except that using variables from the parent scope is always automatic.
It's not only $this that a (non-static) arrow function would bound, it is (even for static ones) that all variables from the parent scope are automatically in use. So this will more likely hit performance than give the occasional benefit of static for anonymous functions.
As you haven't shared which IDE, it is only a guess to which concrete suggestion you're referring to. Our educated guess is Phpstorm with the EA inspections plugin:
[EA] This closure can be declared as static (better scoping; in some cases can improve performance).
From the Static closures can be used EA inspection. And with the further information:
Analyzes closures and suggests using static closures instead.
This can bring additional performance improvements, e.g. as here:
Also, by using static function () {} closures, we squeezed out another 15% of hydration performance when dealing with private properties.
(from the inspection description provided by Php Inspections (EA Ultimate) within Phpstorm)
QUESTION
Is there an easy way to watch selected local PHP files for content changes on Windows?
Asked 2022-Jan-22 at 16:05Is there any easy way (tool or IDE plugin or some other solution for MS Win) how to watch selected local PHP files for local changes of content?
I am developing a PHP application based on open source core which is developed independently and distributed only in zip files so I need to make update manually by overwriting of old version with the new one.
The problem occurs when I make my own changes to core PHP files and during making updates to the current version of the core I rewrite these files with their new version, I do not know which changed files were previously modified by me.
ANSWER
Answered 2022-Jan-22 at 16:05Yes, it is an easy obvious way
- Any VCS, which support branches
- Vendor branches + branches diff|merge
QUESTION
How to manually add a .xcframework to a Flutter iOS Plugin?
Asked 2021-Dec-03 at 05:46I'm trying to create a Flutter Plugin to use a native library. This library I'm trying to use is stored in a private repository and can be used with Swift Dependency Manager.
This is causing me a headache, cause I can't add a private repository dependency in my plugin (I couldn't find a way to do this in .podspec file), so what I've done:
- I've added the plugin to the Example project with Swift Package Manager
- Manually copied
MyDependency.xcframeworkfolder toMyPlugin/iosfolder - Referenced it in podspec file, like this:
1s.preserve_paths = 'MyDependency.xcframework'
2s.xcconfig = { 'OTHER_LDFLAGS' => '-framework MyDependency' }
3s.vendored_frameworks = 'MyDependency.xcframework'
4Doing this I'm able to use MyDependency inside plugin's sources.
My current problem is: This is only working in Simulator.
Before doing this, the project was running without any problem in real devices.
This is the error message I'm receiving every time I tried to run in a real device:
Also, I've made a test using the dependency directly from Swift Dependency Manager and is working fine. I think the problem is the way I'm adding the framework to my plugin.
ANSWER
Answered 2021-Sep-21 at 12:44After doing some research, I've found some links giving me an ideia about the real problem...
To solve this, I've added a simple script to my main project's build process.
This script adds the code signing to inner .framework files.
1s.preserve_paths = 'MyDependency.xcframework'
2s.xcconfig = { 'OTHER_LDFLAGS' => '-framework MyDependency' }
3s.vendored_frameworks = 'MyDependency.xcframework'
4cd "${CODESIGNING_FOLDER_PATH}/Frameworks/"
5
6# flatten nested frameworks by copying to APP.app/Frameworks
7for framework in *; do
8 if [ -d "$framework" ]; then
9 if [ -d "${framework}/Frameworks" ]; then
10 echo "Moving embedded frameworks from ${framework} to ${PRODUCT_NAME}.app/Frameworks"
11 cp -R "${framework}/Frameworks/" .
12 rm -rf "${framework}/Frameworks"
13 fi
14 fi
15done
16
17# remove any leftover nested frameworks (i.e. 'PackageName_359AFEED79E48935_PackageProduct.framework')
18for framework in *; do
19 if [ -d "$framework" ]; then
20 if [ -d "${framework}/Frameworks" ]; then
21 echo "Removing embedded frameworks from ${framework} to ${PRODUCT_NAME}.app/Frameworks"
22 rm -rf "${framework}/Frameworks"
23 fi
24 fi
25done
26
27# codesign for Debugging on device
28if [ "${CONFIGURATION}" == "Debug" ] & [ "${SDKROOT}" != *Simulator* ] ; then
29
30 echo "Code signing frameworks..."
31 find "${CODESIGNING_FOLDER_PATH}/Frameworks" -maxdepth 1 -name '*.framework' -print0 | while read -d $'\0' framework
32 do
33 # only sign frameworks without a signature
34 if ! codesign -v "${framework}"; then
35 codesign --force --sign "${EXPANDED_CODE_SIGN_IDENTITY}" --preserve-metadata=identifier,entitlements --timestamp=none "${framework}"
36 echo "Added missing signature to '${framework}'"
37 fi
38 done
39fi
40QUESTION
How to hide/remove the import/export buttons on Preferences dialog in Eclipse RCP
Asked 2021-Oct-29 at 07:20I have a little experience using Activities with Eclipse RCP to hide plugin UI components, but this one is stumping me. I used the Eclipse Plug-in Selection Spy to try and see which plugin provides the import/export buttons at the bottom of the default Preferences page, and it seems to point to org.eclipse.ui.workbench. At least, that's what comes up when I can actually click on the Preferences dialog. When I do Alt + Shift + F1 and try to click on the Export button, for example, the cursor turns back into a regular pointer and the Plug-in Spy window comes up empty when I click.
The class that provides the default Preferences page is org.eclipse.ui.internal.dialogs.WorkbenchPreferenceDialog. This class extends org.eclipse.ui.internal.dialogs.FilteredPreferenceDialog, which has a method that adds the import/export buttons to the dialog upon calling open().
So, I looked in the org.eclipse.ui.workbench plugin to try and find something to put in my activityPatternBinding that would hide these buttons. I tried using
1<activityPatternBinding
2 activityId="my_hidden_activity"
3 isEqualityPattern="true"
4 pattern="org.eclipse.ui.workbench/org.eclipse.ui.internal.wizards.preferences.PreferencesImportWizard">
5</activityPatternBinding>
6to prevent the import class from being shown and maybe that would stop the button from showing up, but that did not work.
Does anyone know how to get rid of these icons without completely rewriting the default Preferences dialog?
ANSWER
Answered 2021-Oct-29 at 07:03You can only hide items if the code that creates them calls the activity manager to check if they are being filtered - usually by calling WorkbenchActivityHelper.filterItem.
The import / export code in FilteredPreferenceDialog doesn't make this call so it cannot be removed with activities. I don't see any way to suppress these buttons.
QUESTION
compilation.emitAsset is not a function in sitemap-webpack-plugin
Asked 2021-Jul-09 at 15:06I'm trying to build a sitemap in my production environment and I have been trying to use sitemap-webpack-plugin but get the following error:
1ERROR in TypeError: compilation.emitAsset is not a function
2 at /Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:378:41
3 at Array.forEach (<anonymous>)
4 at SitemapWebpackPlugin.<anonymous> (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:377:34)
5 at step (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:86:23)
6 at Object.next (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:67:53)
7 at fulfilled (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:57:58)
8My package.json:
1ERROR in TypeError: compilation.emitAsset is not a function
2 at /Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:378:41
3 at Array.forEach (<anonymous>)
4 at SitemapWebpackPlugin.<anonymous> (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:377:34)
5 at step (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:86:23)
6 at Object.next (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:67:53)
7 at fulfilled (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:57:58)
8"sitemap-webpack-plugin": "^1.1.0",
9"webpack": "4.28.0",
10Inside my webpack.prod:
1ERROR in TypeError: compilation.emitAsset is not a function
2 at /Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:378:41
3 at Array.forEach (<anonymous>)
4 at SitemapWebpackPlugin.<anonymous> (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:377:34)
5 at step (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:86:23)
6 at Object.next (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:67:53)
7 at fulfilled (/Users/ME/Sites/test-site/node_modules/sitemap-webpack-plugin/lib/index.js:57:58)
8"sitemap-webpack-plugin": "^1.1.0",
9"webpack": "4.28.0",
10
11const SitemapPlugin = require('sitemap-webpack-plugin').default;
12const paths = ['url/', 'url/url2'];
13
14// later down the file inside plugins:
15
16new SitemapPlugin({ base: 'https://www.bob.com', paths })
17
18As I'm using webpack 4 I thought emitAsset should work?
Has anyone else come across this?
ANSWER
Answered 2021-Jul-09 at 15:06compilation.emitAsset is available since webpack 4.40.0, see https://webpack.js.org/api/compilation-object/#emitasset, which means you might want to upgrade your webpack first.
QUESTION
Kotlin expression giving different results (runtime vs IDE Evaluate expression)
Asked 2021-May-21 at 14:341val result: Boolean = aList.union(bList).any { it.something?.someOtherFlag == true }
2I have two lists I need to join and check if any of the items has some flag set. This has been giving me some bad results. During debugging:
- the data before the line indicates
result = true(trueshould be the right answer) - I get
result = falseby running the program - directly after the line, when I use the Evaluate expression tool, I get
result = true
What is definitely NOT the problem is that there is NO change in the data in between.
Kotlin versions of my app/IDE plugin are different:
1val result: Boolean = aList.union(bList).any { it.something?.someOtherFlag == true }
2Kotlin Plugin: 203-1.5.0
3App: 1.4.21
4What I am looking for is an explanation: what can be the problem?
ANSWER
Answered 2021-May-21 at 14:34The union method returns a set that will keep only distinct elements, and it might (maybe?) discard different elements when running and when evaluating in debugger. I'm not sure how deterministic it's supposed to be, but the order could matter.
This could happen if equals() and/or hashCode() for your elements are defined without using something, or if equals()/hashCode() for something's class is defined without using someOtherFlag. How are these classes defined?
Note that for data classes, only the properties that are present in the primary constructor are taken into account for the generated equals and hashcode methods.
QUESTION
Export/Import a table from MySQL via command lines
Asked 2021-May-13 at 19:25I'm trying to back up a my users table from my cia db
I've created this example snippet
Example
1#db = cia
2#table = users
3
4mysqldump cia users > cia.users.sql && L <<-------- ✅
5mysql -u root cia -e "TRUNCATE TABLE users;" <<-------- ✅
6mysql -u root cia -e "SELECT COUNT(*) FROM users;" <<-------- ✅
7mysql -u root cia users < cia.users.sql <<-------- 🐞❌ stuck...
8mysql -u root cia -e "SELECT COUNT(*) FROM users;"
9rm -rf cia.users.sql
10echo "--------------------------- DONE."
11#
12I got
1#db = cia
2#table = users
3
4mysqldump cia users > cia.users.sql && L <<-------- ✅
5mysql -u root cia -e "TRUNCATE TABLE users;" <<-------- ✅
6mysql -u root cia -e "SELECT COUNT(*) FROM users;" <<-------- ✅
7mysql -u root cia users < cia.users.sql <<-------- 🐞❌ stuck...
8mysql -u root cia -e "SELECT COUNT(*) FROM users;"
9rm -rf cia.users.sql
10echo "--------------------------- DONE."
11#
12mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
13Copyright (c) 2000, 2021, Oracle and/or its affiliates.
14
15Oracle is a registered trademark of Oracle Corporation and/or its
16affiliates. Other names may be trademarks of their respective
17owners.
18
19Usage: mysql [OPTIONS] [database]
20 -?, --help Display this help and exit.
21 -I, --help Synonym for -?
22 --auto-rehash Enable automatic rehashing. One doesn't need to use
23 'rehash' to get table and field completion, but startup
24 and reconnecting may take a longer time. Disable with
25 --disable-auto-rehash.
26 (Defaults to on; use --skip-auto-rehash to disable.)
27 -A, --no-auto-rehash
28 No automatic rehashing. One has to use 'rehash' to get
29 table and field completion. This gives a quicker start of
30 mysql and disables rehashing on reconnect.
31 --auto-vertical-output
32 Automatically switch to vertical output mode if the
33 result is wider than the terminal width.
34 -B, --batch Don't use history file. Disable interactive behavior.
35 (Enables --silent.)
36 --bind-address=name IP address to bind to.
37 --binary-as-hex Print binary data as hex. Enabled by default for
38 interactive terminals.
39 --character-sets-dir=name
40 Directory for character set files.
41 --column-type-info Display column type information.
42 -c, --comments Preserve comments. Send comments to the server. The
43 default is --skip-comments (discard comments), enable
44 with --comments.
45 -C, --compress Use compression in server/client protocol.
46 -#, --debug[=#] This is a non-debug version. Catch this and exit.
47 --debug-check This is a non-debug version. Catch this and exit.
48 -T, --debug-info This is a non-debug version. Catch this and exit.
49 -D, --database=name Database to use.
50 --default-character-set=name
51 Set the default character set.
52 --delimiter=name Delimiter to be used.
53 --enable-cleartext-plugin
54 Enable/disable the clear text authentication plugin.
55 -e, --execute=name Execute command and quit. (Disables --force and history
56 file.)
57 -E, --vertical Print the output of a query (rows) vertically.
58 -f, --force Continue even if we get an SQL error.
59 --histignore=name A colon-separated list of patterns to keep statements
60 from getting logged into syslog and mysql history.
61 -G, --named-commands
62 Enable named commands. Named commands mean this program's
63 internal commands; see mysql> help . When enabled, the
64 named commands can be used from any line of the query,
65 otherwise only from the first line, before an enter.
66 Disable with --disable-named-commands. This option is
67 disabled by default.
68 -i, --ignore-spaces Ignore space after function names.
69 --init-command=name SQL Command to execute when connecting to MySQL server.
70 Will automatically be re-executed when reconnecting.
71 --local-infile Enable/disable LOAD DATA LOCAL INFILE.
72 -b, --no-beep Turn off beep on error.
73 -h, --host=name Connect to host.
74 --dns-srv-name=name Connect to a DNS SRV resource
75 -H, --html Produce HTML output.
76 -X, --xml Produce XML output.
77 --line-numbers Write line numbers for errors.
78 (Defaults to on; use --skip-line-numbers to disable.)
79 -L, --skip-line-numbers
80 Don't write line number for errors.
81 -n, --unbuffered Flush buffer after each query.
82 --column-names Write column names in results.
83 (Defaults to on; use --skip-column-names to disable.)
84 -N, --skip-column-names
85 Don't write column names in results.
86 --sigint-ignore Ignore SIGINT (CTRL-C).
87 -o, --one-database Ignore statements except those that occur while the
88 default database is the one named at the command line.
89 --pager[=name] Pager to use to display results. If you don't supply an
90 option, the default pager is taken from your ENV variable
91 PAGER. Valid pagers are less, more, cat [> filename],
92 etc. See interactive help (\h) also. This option does not
93 work in batch mode. Disable with --disable-pager. This
94 option is disabled by default.
95 -p, --password[=name]
96 Password to use when connecting to server. If password is
97 not given it's asked from the tty.
98 -P, --port=# Port number to use for connection or 0 for default to, in
99 order of preference, my.cnf, $MYSQL_TCP_PORT,
100 /etc/services, built-in default (3306).
101 --prompt=name Set the mysql prompt to this value.
102 --protocol=name The protocol to use for connection (tcp, socket, pipe,
103 memory).
104 -q, --quick Don't cache result, print it row by row. This may slow
105 down the server if the output is suspended. Doesn't use
106 history file.
107 -r, --raw Write fields without conversion. Used with --batch.
108 --reconnect Reconnect if the connection is lost. Disable with
109 --disable-reconnect. This option is enabled by default.
110 (Defaults to on; use --skip-reconnect to disable.)
111 -s, --silent Be more silent. Print results with a tab as separator,
112 each row on new line.
113 -S, --socket=name The socket file to use for connection.
114 --server-public-key-path=name
115 File path to the server public RSA key in PEM format.
116 --get-server-public-key
117 Get server public key
118 --ssl-mode=name SSL connection mode.
119 --ssl-ca=name CA file in PEM format.
120 --ssl-capath=name CA directory.
121 --ssl-cert=name X509 cert in PEM format.
122 --ssl-cipher=name SSL cipher to use.
123 --ssl-key=name X509 key in PEM format.
124 --ssl-crl=name Certificate revocation list.
125 --ssl-crlpath=name Certificate revocation list path.
126 --tls-version=name TLS version to use, permitted values are: TLSv1, TLSv1.1,
127 TLSv1.2, TLSv1.3
128 --ssl-fips-mode=name
129 SSL FIPS mode (applies only for OpenSSL); permitted
130 values are: OFF, ON, STRICT
131 --tls-ciphersuites=name
132 TLS v1.3 cipher to use.
133 -t, --table Output in table format.
134 --tee=name Append everything into outfile. See interactive help (\h)
135 also. Does not work in batch mode. Disable with
136 --disable-tee. This option is disabled by default.
137 -u, --user=name User for login if not current user.
138 -U, --safe-updates Only allow UPDATE and DELETE that uses keys.
139 -U, --i-am-a-dummy Synonym for option --safe-updates, -U.
140 -v, --verbose Write more. (-v -v -v gives the table output format).
141 -V, --version Output version information and exit.
142 -w, --wait Wait and retry if connection is down.
143 --connect-timeout=# Number of seconds before connection timeout.
144 --max-allowed-packet=#
145 The maximum packet length to send to or receive from
146 server.
147 --net-buffer-length=#
148 The buffer size for TCP/IP and socket communication.
149 --select-limit=# Automatic limit for SELECT when using --safe-updates.
150 --max-join-size=# Automatic limit for rows in a join when using
151 --safe-updates.
152 --show-warnings Show warnings after every statement.
153 -j, --syslog Log filtered interactive commands to syslog. Filtering of
154 commands depends on the patterns supplied via histignore
155 option besides the default patterns.
156 --plugin-dir=name Directory for client-side plugins.
157 --default-auth=name Default authentication client-side plugin to use.
158 --binary-mode By default, ASCII '\0' is disallowed and '\r\n' is
159 translated to '\n'. This switch turns off both features,
160 and also turns off parsing of all clientcommands except
161 \C and DELIMITER, in non-interactive mode (for input
162 piped to mysql or loaded using the 'source' command).
163 This is necessary when processing output from mysqlbinlog
164 that may contain blobs.
165 --connect-expired-password
166 Notify the server that this client is prepared to handle
167 expired password sandbox mode.
168 --network-namespace=name
169 Network namespace to use for connection via tcp with a
170 server.
171 --compression-algorithms=name
172 Use compression algorithm in server/client protocol.
173 Valid values are any combination of
174 'zstd','zlib','uncompressed'.
175 --zstd-compression-level=#
176 Use this compression level in the client/server protocol,
177 in case --compression-algorithms=zstd. Valid range is
178 between 1 and 22, inclusive. Default is 3.
179 --load-data-local-dir=name
180 Directory path safe for LOAD DATA LOCAL INFILE to read
181 from.
182
183Default options are read from the following files in the given order:
184/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
185The following groups are read: mysql client
186The following options may be given as the first argument:
187--print-defaults Print the program argument list and exit.
188--no-defaults Don't read default options from any option file,
189 except for login file.
190--defaults-file=# Only read default options from the given file #.
191--defaults-extra-file=# Read this file after the global files are read.
192--defaults-group-suffix=#
193 Also read groups with concat(group, suffix)
194--login-path=# Read this path from the login file.
195
196Variables (--variable-name=value)
197and boolean options {FALSE|TRUE} Value (after reading options)
198--------------------------------- ----------------------------------------
199auto-rehash TRUE
200auto-vertical-output FALSE
201bind-address (No default value)
202binary-as-hex FALSE
203character-sets-dir (No default value)
204column-type-info FALSE
205comments FALSE
206compress FALSE
207database (No default value)
208default-character-set auto
209delimiter ;
210enable-cleartext-plugin FALSE
211vertical FALSE
212force FALSE
213histignore (No default value)
214named-commands FALSE
215ignore-spaces FALSE
216init-command (No default value)
217local-infile FALSE
218no-beep FALSE
219host (No default value)
220dns-srv-name (No default value)
221html FALSE
222xml FALSE
223line-numbers TRUE
224unbuffered FALSE
225column-names TRUE
226sigint-ignore FALSE
227port 0
228prompt mysql>
229quick FALSE
230raw FALSE
231reconnect FALSE
232socket (No default value)
233server-public-key-path (No default value)
234get-server-public-key FALSE
235ssl-ca (No default value)
236ssl-capath (No default value)
237ssl-cert (No default value)
238ssl-cipher (No default value)
239ssl-key (No default value)
240ssl-crl (No default value)
241ssl-crlpath (No default value)
242tls-version (No default value)
243tls-ciphersuites (No default value)
244table FALSE
245user root
246safe-updates FALSE
247i-am-a-dummy FALSE
248connect-timeout 0
249max-allowed-packet 16777216
250net-buffer-length 16384
251select-limit 1000
252max-join-size 1000000
253show-warnings FALSE
254plugin-dir (No default value)
255default-auth (No default value)
256binary-mode FALSE
257connect-expired-password FALSE
258network-namespace (No default value)
259compression-algorithms (No default value)
260zstd-compression-level 3
261load-data-local-dir (No default value)
262ANSWER
Answered 2021-May-13 at 19:23The mysql client accepts a database name, but there is no need to name the table in that command line usage. The name of the table comes from the statements in your dumped data file.
Change this:
1#db = cia
2#table = users
3
4mysqldump cia users > cia.users.sql && L <<-------- ✅
5mysql -u root cia -e "TRUNCATE TABLE users;" <<-------- ✅
6mysql -u root cia -e "SELECT COUNT(*) FROM users;" <<-------- ✅
7mysql -u root cia users < cia.users.sql <<-------- 🐞❌ stuck...
8mysql -u root cia -e "SELECT COUNT(*) FROM users;"
9rm -rf cia.users.sql
10echo "--------------------------- DONE."
11#
12mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
13Copyright (c) 2000, 2021, Oracle and/or its affiliates.
14
15Oracle is a registered trademark of Oracle Corporation and/or its
16affiliates. Other names may be trademarks of their respective
17owners.
18
19Usage: mysql [OPTIONS] [database]
20 -?, --help Display this help and exit.
21 -I, --help Synonym for -?
22 --auto-rehash Enable automatic rehashing. One doesn't need to use
23 'rehash' to get table and field completion, but startup
24 and reconnecting may take a longer time. Disable with
25 --disable-auto-rehash.
26 (Defaults to on; use --skip-auto-rehash to disable.)
27 -A, --no-auto-rehash
28 No automatic rehashing. One has to use 'rehash' to get
29 table and field completion. This gives a quicker start of
30 mysql and disables rehashing on reconnect.
31 --auto-vertical-output
32 Automatically switch to vertical output mode if the
33 result is wider than the terminal width.
34 -B, --batch Don't use history file. Disable interactive behavior.
35 (Enables --silent.)
36 --bind-address=name IP address to bind to.
37 --binary-as-hex Print binary data as hex. Enabled by default for
38 interactive terminals.
39 --character-sets-dir=name
40 Directory for character set files.
41 --column-type-info Display column type information.
42 -c, --comments Preserve comments. Send comments to the server. The
43 default is --skip-comments (discard comments), enable
44 with --comments.
45 -C, --compress Use compression in server/client protocol.
46 -#, --debug[=#] This is a non-debug version. Catch this and exit.
47 --debug-check This is a non-debug version. Catch this and exit.
48 -T, --debug-info This is a non-debug version. Catch this and exit.
49 -D, --database=name Database to use.
50 --default-character-set=name
51 Set the default character set.
52 --delimiter=name Delimiter to be used.
53 --enable-cleartext-plugin
54 Enable/disable the clear text authentication plugin.
55 -e, --execute=name Execute command and quit. (Disables --force and history
56 file.)
57 -E, --vertical Print the output of a query (rows) vertically.
58 -f, --force Continue even if we get an SQL error.
59 --histignore=name A colon-separated list of patterns to keep statements
60 from getting logged into syslog and mysql history.
61 -G, --named-commands
62 Enable named commands. Named commands mean this program's
63 internal commands; see mysql> help . When enabled, the
64 named commands can be used from any line of the query,
65 otherwise only from the first line, before an enter.
66 Disable with --disable-named-commands. This option is
67 disabled by default.
68 -i, --ignore-spaces Ignore space after function names.
69 --init-command=name SQL Command to execute when connecting to MySQL server.
70 Will automatically be re-executed when reconnecting.
71 --local-infile Enable/disable LOAD DATA LOCAL INFILE.
72 -b, --no-beep Turn off beep on error.
73 -h, --host=name Connect to host.
74 --dns-srv-name=name Connect to a DNS SRV resource
75 -H, --html Produce HTML output.
76 -X, --xml Produce XML output.
77 --line-numbers Write line numbers for errors.
78 (Defaults to on; use --skip-line-numbers to disable.)
79 -L, --skip-line-numbers
80 Don't write line number for errors.
81 -n, --unbuffered Flush buffer after each query.
82 --column-names Write column names in results.
83 (Defaults to on; use --skip-column-names to disable.)
84 -N, --skip-column-names
85 Don't write column names in results.
86 --sigint-ignore Ignore SIGINT (CTRL-C).
87 -o, --one-database Ignore statements except those that occur while the
88 default database is the one named at the command line.
89 --pager[=name] Pager to use to display results. If you don't supply an
90 option, the default pager is taken from your ENV variable
91 PAGER. Valid pagers are less, more, cat [> filename],
92 etc. See interactive help (\h) also. This option does not
93 work in batch mode. Disable with --disable-pager. This
94 option is disabled by default.
95 -p, --password[=name]
96 Password to use when connecting to server. If password is
97 not given it's asked from the tty.
98 -P, --port=# Port number to use for connection or 0 for default to, in
99 order of preference, my.cnf, $MYSQL_TCP_PORT,
100 /etc/services, built-in default (3306).
101 --prompt=name Set the mysql prompt to this value.
102 --protocol=name The protocol to use for connection (tcp, socket, pipe,
103 memory).
104 -q, --quick Don't cache result, print it row by row. This may slow
105 down the server if the output is suspended. Doesn't use
106 history file.
107 -r, --raw Write fields without conversion. Used with --batch.
108 --reconnect Reconnect if the connection is lost. Disable with
109 --disable-reconnect. This option is enabled by default.
110 (Defaults to on; use --skip-reconnect to disable.)
111 -s, --silent Be more silent. Print results with a tab as separator,
112 each row on new line.
113 -S, --socket=name The socket file to use for connection.
114 --server-public-key-path=name
115 File path to the server public RSA key in PEM format.
116 --get-server-public-key
117 Get server public key
118 --ssl-mode=name SSL connection mode.
119 --ssl-ca=name CA file in PEM format.
120 --ssl-capath=name CA directory.
121 --ssl-cert=name X509 cert in PEM format.
122 --ssl-cipher=name SSL cipher to use.
123 --ssl-key=name X509 key in PEM format.
124 --ssl-crl=name Certificate revocation list.
125 --ssl-crlpath=name Certificate revocation list path.
126 --tls-version=name TLS version to use, permitted values are: TLSv1, TLSv1.1,
127 TLSv1.2, TLSv1.3
128 --ssl-fips-mode=name
129 SSL FIPS mode (applies only for OpenSSL); permitted
130 values are: OFF, ON, STRICT
131 --tls-ciphersuites=name
132 TLS v1.3 cipher to use.
133 -t, --table Output in table format.
134 --tee=name Append everything into outfile. See interactive help (\h)
135 also. Does not work in batch mode. Disable with
136 --disable-tee. This option is disabled by default.
137 -u, --user=name User for login if not current user.
138 -U, --safe-updates Only allow UPDATE and DELETE that uses keys.
139 -U, --i-am-a-dummy Synonym for option --safe-updates, -U.
140 -v, --verbose Write more. (-v -v -v gives the table output format).
141 -V, --version Output version information and exit.
142 -w, --wait Wait and retry if connection is down.
143 --connect-timeout=# Number of seconds before connection timeout.
144 --max-allowed-packet=#
145 The maximum packet length to send to or receive from
146 server.
147 --net-buffer-length=#
148 The buffer size for TCP/IP and socket communication.
149 --select-limit=# Automatic limit for SELECT when using --safe-updates.
150 --max-join-size=# Automatic limit for rows in a join when using
151 --safe-updates.
152 --show-warnings Show warnings after every statement.
153 -j, --syslog Log filtered interactive commands to syslog. Filtering of
154 commands depends on the patterns supplied via histignore
155 option besides the default patterns.
156 --plugin-dir=name Directory for client-side plugins.
157 --default-auth=name Default authentication client-side plugin to use.
158 --binary-mode By default, ASCII '\0' is disallowed and '\r\n' is
159 translated to '\n'. This switch turns off both features,
160 and also turns off parsing of all clientcommands except
161 \C and DELIMITER, in non-interactive mode (for input
162 piped to mysql or loaded using the 'source' command).
163 This is necessary when processing output from mysqlbinlog
164 that may contain blobs.
165 --connect-expired-password
166 Notify the server that this client is prepared to handle
167 expired password sandbox mode.
168 --network-namespace=name
169 Network namespace to use for connection via tcp with a
170 server.
171 --compression-algorithms=name
172 Use compression algorithm in server/client protocol.
173 Valid values are any combination of
174 'zstd','zlib','uncompressed'.
175 --zstd-compression-level=#
176 Use this compression level in the client/server protocol,
177 in case --compression-algorithms=zstd. Valid range is
178 between 1 and 22, inclusive. Default is 3.
179 --load-data-local-dir=name
180 Directory path safe for LOAD DATA LOCAL INFILE to read
181 from.
182
183Default options are read from the following files in the given order:
184/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
185The following groups are read: mysql client
186The following options may be given as the first argument:
187--print-defaults Print the program argument list and exit.
188--no-defaults Don't read default options from any option file,
189 except for login file.
190--defaults-file=# Only read default options from the given file #.
191--defaults-extra-file=# Read this file after the global files are read.
192--defaults-group-suffix=#
193 Also read groups with concat(group, suffix)
194--login-path=# Read this path from the login file.
195
196Variables (--variable-name=value)
197and boolean options {FALSE|TRUE} Value (after reading options)
198--------------------------------- ----------------------------------------
199auto-rehash TRUE
200auto-vertical-output FALSE
201bind-address (No default value)
202binary-as-hex FALSE
203character-sets-dir (No default value)
204column-type-info FALSE
205comments FALSE
206compress FALSE
207database (No default value)
208default-character-set auto
209delimiter ;
210enable-cleartext-plugin FALSE
211vertical FALSE
212force FALSE
213histignore (No default value)
214named-commands FALSE
215ignore-spaces FALSE
216init-command (No default value)
217local-infile FALSE
218no-beep FALSE
219host (No default value)
220dns-srv-name (No default value)
221html FALSE
222xml FALSE
223line-numbers TRUE
224unbuffered FALSE
225column-names TRUE
226sigint-ignore FALSE
227port 0
228prompt mysql>
229quick FALSE
230raw FALSE
231reconnect FALSE
232socket (No default value)
233server-public-key-path (No default value)
234get-server-public-key FALSE
235ssl-ca (No default value)
236ssl-capath (No default value)
237ssl-cert (No default value)
238ssl-cipher (No default value)
239ssl-key (No default value)
240ssl-crl (No default value)
241ssl-crlpath (No default value)
242tls-version (No default value)
243tls-ciphersuites (No default value)
244table FALSE
245user root
246safe-updates FALSE
247i-am-a-dummy FALSE
248connect-timeout 0
249max-allowed-packet 16777216
250net-buffer-length 16384
251select-limit 1000
252max-join-size 1000000
253show-warnings FALSE
254plugin-dir (No default value)
255default-auth (No default value)
256binary-mode FALSE
257connect-expired-password FALSE
258network-namespace (No default value)
259compression-algorithms (No default value)
260zstd-compression-level 3
261load-data-local-dir (No default value)
262mysql -u root cia users < cia.users.sql
263To this:
1#db = cia
2#table = users
3
4mysqldump cia users > cia.users.sql && L <<-------- ✅
5mysql -u root cia -e "TRUNCATE TABLE users;" <<-------- ✅
6mysql -u root cia -e "SELECT COUNT(*) FROM users;" <<-------- ✅
7mysql -u root cia users < cia.users.sql <<-------- 🐞❌ stuck...
8mysql -u root cia -e "SELECT COUNT(*) FROM users;"
9rm -rf cia.users.sql
10echo "--------------------------- DONE."
11#
12mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
13Copyright (c) 2000, 2021, Oracle and/or its affiliates.
14
15Oracle is a registered trademark of Oracle Corporation and/or its
16affiliates. Other names may be trademarks of their respective
17owners.
18
19Usage: mysql [OPTIONS] [database]
20 -?, --help Display this help and exit.
21 -I, --help Synonym for -?
22 --auto-rehash Enable automatic rehashing. One doesn't need to use
23 'rehash' to get table and field completion, but startup
24 and reconnecting may take a longer time. Disable with
25 --disable-auto-rehash.
26 (Defaults to on; use --skip-auto-rehash to disable.)
27 -A, --no-auto-rehash
28 No automatic rehashing. One has to use 'rehash' to get
29 table and field completion. This gives a quicker start of
30 mysql and disables rehashing on reconnect.
31 --auto-vertical-output
32 Automatically switch to vertical output mode if the
33 result is wider than the terminal width.
34 -B, --batch Don't use history file. Disable interactive behavior.
35 (Enables --silent.)
36 --bind-address=name IP address to bind to.
37 --binary-as-hex Print binary data as hex. Enabled by default for
38 interactive terminals.
39 --character-sets-dir=name
40 Directory for character set files.
41 --column-type-info Display column type information.
42 -c, --comments Preserve comments. Send comments to the server. The
43 default is --skip-comments (discard comments), enable
44 with --comments.
45 -C, --compress Use compression in server/client protocol.
46 -#, --debug[=#] This is a non-debug version. Catch this and exit.
47 --debug-check This is a non-debug version. Catch this and exit.
48 -T, --debug-info This is a non-debug version. Catch this and exit.
49 -D, --database=name Database to use.
50 --default-character-set=name
51 Set the default character set.
52 --delimiter=name Delimiter to be used.
53 --enable-cleartext-plugin
54 Enable/disable the clear text authentication plugin.
55 -e, --execute=name Execute command and quit. (Disables --force and history
56 file.)
57 -E, --vertical Print the output of a query (rows) vertically.
58 -f, --force Continue even if we get an SQL error.
59 --histignore=name A colon-separated list of patterns to keep statements
60 from getting logged into syslog and mysql history.
61 -G, --named-commands
62 Enable named commands. Named commands mean this program's
63 internal commands; see mysql> help . When enabled, the
64 named commands can be used from any line of the query,
65 otherwise only from the first line, before an enter.
66 Disable with --disable-named-commands. This option is
67 disabled by default.
68 -i, --ignore-spaces Ignore space after function names.
69 --init-command=name SQL Command to execute when connecting to MySQL server.
70 Will automatically be re-executed when reconnecting.
71 --local-infile Enable/disable LOAD DATA LOCAL INFILE.
72 -b, --no-beep Turn off beep on error.
73 -h, --host=name Connect to host.
74 --dns-srv-name=name Connect to a DNS SRV resource
75 -H, --html Produce HTML output.
76 -X, --xml Produce XML output.
77 --line-numbers Write line numbers for errors.
78 (Defaults to on; use --skip-line-numbers to disable.)
79 -L, --skip-line-numbers
80 Don't write line number for errors.
81 -n, --unbuffered Flush buffer after each query.
82 --column-names Write column names in results.
83 (Defaults to on; use --skip-column-names to disable.)
84 -N, --skip-column-names
85 Don't write column names in results.
86 --sigint-ignore Ignore SIGINT (CTRL-C).
87 -o, --one-database Ignore statements except those that occur while the
88 default database is the one named at the command line.
89 --pager[=name] Pager to use to display results. If you don't supply an
90 option, the default pager is taken from your ENV variable
91 PAGER. Valid pagers are less, more, cat [> filename],
92 etc. See interactive help (\h) also. This option does not
93 work in batch mode. Disable with --disable-pager. This
94 option is disabled by default.
95 -p, --password[=name]
96 Password to use when connecting to server. If password is
97 not given it's asked from the tty.
98 -P, --port=# Port number to use for connection or 0 for default to, in
99 order of preference, my.cnf, $MYSQL_TCP_PORT,
100 /etc/services, built-in default (3306).
101 --prompt=name Set the mysql prompt to this value.
102 --protocol=name The protocol to use for connection (tcp, socket, pipe,
103 memory).
104 -q, --quick Don't cache result, print it row by row. This may slow
105 down the server if the output is suspended. Doesn't use
106 history file.
107 -r, --raw Write fields without conversion. Used with --batch.
108 --reconnect Reconnect if the connection is lost. Disable with
109 --disable-reconnect. This option is enabled by default.
110 (Defaults to on; use --skip-reconnect to disable.)
111 -s, --silent Be more silent. Print results with a tab as separator,
112 each row on new line.
113 -S, --socket=name The socket file to use for connection.
114 --server-public-key-path=name
115 File path to the server public RSA key in PEM format.
116 --get-server-public-key
117 Get server public key
118 --ssl-mode=name SSL connection mode.
119 --ssl-ca=name CA file in PEM format.
120 --ssl-capath=name CA directory.
121 --ssl-cert=name X509 cert in PEM format.
122 --ssl-cipher=name SSL cipher to use.
123 --ssl-key=name X509 key in PEM format.
124 --ssl-crl=name Certificate revocation list.
125 --ssl-crlpath=name Certificate revocation list path.
126 --tls-version=name TLS version to use, permitted values are: TLSv1, TLSv1.1,
127 TLSv1.2, TLSv1.3
128 --ssl-fips-mode=name
129 SSL FIPS mode (applies only for OpenSSL); permitted
130 values are: OFF, ON, STRICT
131 --tls-ciphersuites=name
132 TLS v1.3 cipher to use.
133 -t, --table Output in table format.
134 --tee=name Append everything into outfile. See interactive help (\h)
135 also. Does not work in batch mode. Disable with
136 --disable-tee. This option is disabled by default.
137 -u, --user=name User for login if not current user.
138 -U, --safe-updates Only allow UPDATE and DELETE that uses keys.
139 -U, --i-am-a-dummy Synonym for option --safe-updates, -U.
140 -v, --verbose Write more. (-v -v -v gives the table output format).
141 -V, --version Output version information and exit.
142 -w, --wait Wait and retry if connection is down.
143 --connect-timeout=# Number of seconds before connection timeout.
144 --max-allowed-packet=#
145 The maximum packet length to send to or receive from
146 server.
147 --net-buffer-length=#
148 The buffer size for TCP/IP and socket communication.
149 --select-limit=# Automatic limit for SELECT when using --safe-updates.
150 --max-join-size=# Automatic limit for rows in a join when using
151 --safe-updates.
152 --show-warnings Show warnings after every statement.
153 -j, --syslog Log filtered interactive commands to syslog. Filtering of
154 commands depends on the patterns supplied via histignore
155 option besides the default patterns.
156 --plugin-dir=name Directory for client-side plugins.
157 --default-auth=name Default authentication client-side plugin to use.
158 --binary-mode By default, ASCII '\0' is disallowed and '\r\n' is
159 translated to '\n'. This switch turns off both features,
160 and also turns off parsing of all clientcommands except
161 \C and DELIMITER, in non-interactive mode (for input
162 piped to mysql or loaded using the 'source' command).
163 This is necessary when processing output from mysqlbinlog
164 that may contain blobs.
165 --connect-expired-password
166 Notify the server that this client is prepared to handle
167 expired password sandbox mode.
168 --network-namespace=name
169 Network namespace to use for connection via tcp with a
170 server.
171 --compression-algorithms=name
172 Use compression algorithm in server/client protocol.
173 Valid values are any combination of
174 'zstd','zlib','uncompressed'.
175 --zstd-compression-level=#
176 Use this compression level in the client/server protocol,
177 in case --compression-algorithms=zstd. Valid range is
178 between 1 and 22, inclusive. Default is 3.
179 --load-data-local-dir=name
180 Directory path safe for LOAD DATA LOCAL INFILE to read
181 from.
182
183Default options are read from the following files in the given order:
184/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
185The following groups are read: mysql client
186The following options may be given as the first argument:
187--print-defaults Print the program argument list and exit.
188--no-defaults Don't read default options from any option file,
189 except for login file.
190--defaults-file=# Only read default options from the given file #.
191--defaults-extra-file=# Read this file after the global files are read.
192--defaults-group-suffix=#
193 Also read groups with concat(group, suffix)
194--login-path=# Read this path from the login file.
195
196Variables (--variable-name=value)
197and boolean options {FALSE|TRUE} Value (after reading options)
198--------------------------------- ----------------------------------------
199auto-rehash TRUE
200auto-vertical-output FALSE
201bind-address (No default value)
202binary-as-hex FALSE
203character-sets-dir (No default value)
204column-type-info FALSE
205comments FALSE
206compress FALSE
207database (No default value)
208default-character-set auto
209delimiter ;
210enable-cleartext-plugin FALSE
211vertical FALSE
212force FALSE
213histignore (No default value)
214named-commands FALSE
215ignore-spaces FALSE
216init-command (No default value)
217local-infile FALSE
218no-beep FALSE
219host (No default value)
220dns-srv-name (No default value)
221html FALSE
222xml FALSE
223line-numbers TRUE
224unbuffered FALSE
225column-names TRUE
226sigint-ignore FALSE
227port 0
228prompt mysql>
229quick FALSE
230raw FALSE
231reconnect FALSE
232socket (No default value)
233server-public-key-path (No default value)
234get-server-public-key FALSE
235ssl-ca (No default value)
236ssl-capath (No default value)
237ssl-cert (No default value)
238ssl-cipher (No default value)
239ssl-key (No default value)
240ssl-crl (No default value)
241ssl-crlpath (No default value)
242tls-version (No default value)
243tls-ciphersuites (No default value)
244table FALSE
245user root
246safe-updates FALSE
247i-am-a-dummy FALSE
248connect-timeout 0
249max-allowed-packet 16777216
250net-buffer-length 16384
251select-limit 1000
252max-join-size 1000000
253show-warnings FALSE
254plugin-dir (No default value)
255default-auth (No default value)
256binary-mode FALSE
257connect-expired-password FALSE
258network-namespace (No default value)
259compression-algorithms (No default value)
260zstd-compression-level 3
261load-data-local-dir (No default value)
262mysql -u root cia users < cia.users.sql
263mysql -u root cia < cia.users.sql
264QUESTION
Android Studio 4.2 Kotlin Plugin Issue
Asked 2021-May-10 at 01:09Cannot build a new project using Android Studio 4.2 because of the following error:
1A problem occurred configuring root project 'My Application'.
2> Could not resolve all artifacts for configuration ':classpath'.
3 > Could not find org.jetbrains.kotlin:kotlin-gradle-plugin:1.5.0-release-764.
4 Searched in the following locations:
5 - https://dl.google.com/dl/android/maven2/org/jetbrains/kotlin/kotlin-gradle-plugin/1.5.0-release-764/kotlin-gradle-plugin-1.5.0-release-764.pom
6 - https://repo.maven.apache.org/maven2/org/jetbrains/kotlin/kotlin-gradle-plugin/1.5.0-release-764/kotlin-gradle-plugin-1.5.0-release-764.pom
7 Required by:
8 project :
9
10Possible solution:
11 - Declare repository providing the artifact, see the documentation at https://docs.gradle.org/current/userguide/declaring_repositories.html
12When I changed the Kotlin plugin version from ext.kotlin_version = "1.5.0-release-764" to ext.kotlin_version = "1.5.0" app builds successfully but the following warning appears:
1A problem occurred configuring root project 'My Application'.
2> Could not resolve all artifacts for configuration ':classpath'.
3 > Could not find org.jetbrains.kotlin:kotlin-gradle-plugin:1.5.0-release-764.
4 Searched in the following locations:
5 - https://dl.google.com/dl/android/maven2/org/jetbrains/kotlin/kotlin-gradle-plugin/1.5.0-release-764/kotlin-gradle-plugin-1.5.0-release-764.pom
6 - https://repo.maven.apache.org/maven2/org/jetbrains/kotlin/kotlin-gradle-plugin/1.5.0-release-764/kotlin-gradle-plugin-1.5.0-release-764.pom
7 Required by:
8 project :
9
10Possible solution:
11 - Declare repository providing the artifact, see the documentation at https://docs.gradle.org/current/userguide/declaring_repositories.html
12Kotlin version that is used for building with Gradle (1.5.0) differs from the one bundled into the IDE plugin (1.5.0-release-764)
13
ANSWER
Answered 2021-May-07 at 08:07According to Android Studio's message, Kotlin's latest stable version is 1.5.0-release-764. If you want to (or in this case I guess everyone needs to) use version 1.5.0:
Go to
Toolsin the menuGo to
KotlinChoose
Configure Kotlin Plugin UpdatesIn the drop-down, choose the early access preview version of 1.5.x and then click OK.
Gradle sync will now configure the Studio with Kotlin 1.5.0.
QUESTION
Is Isubscriber (server side plugins) supported in azure devops 2020?
Asked 2021-Apr-16 at 03:32We are using server side plugins for automatically creating and updating work items. if we upgrade to server 2020 will the plugins work ?
ANSWER
Answered 2021-Apr-16 at 03:32Checked \Application Tier\Web Services\bin\Plugins, plugin should be supported in azure devops server 2020. You can try to rebuild your plugin using Microsoft.TeamFoundation.Framework.Server.dll from Azure DevOps Server 2020.
Here is a ticket you can refer to.
Community Discussions contain sources that include Stack Exchange Network
Tutorials and Learning Resources in IDE Plugin
Tutorials and Learning Resources are not available at this moment for IDE Plugin
Share this Page
Get latest updates on IDE Plugin