Tag Info

Hot answers tagged

3

Put the mysql jobs in the background: #!/bin/bash num=$(wc -l < ip.txt) while read ip; do mysql --login-path=login -h $ip "database" < "query.sql" & num=$((num-1)) done < ip.txt wait echo "Script 1 Finished!!" The wait causes the script to wait until all background jobs have completed. This is a pretty simple-minded way of doing ...


2

If you run a SHOW MASTER STATUS\G you'll see something like this: mysql> show master status\G *************************** 1. row *************************** File: mysql-bin.000299 Position: 780437462 Binlog_Do_DB: Binlog_Ignore_DB: Executed_Gtid_Set: 075d81d6-8d7f-11e3-9d88-b4b52f517ce4:1-616637650, ...


1

If your CURRENT_USER() does not say root@localhost, then you do not have root privileges and not being allowed to connect as such. To see what actual privileges you do have after getting connected, run this SHOW GRANTS; When you connect to a specific database, you should be able to see the tables of that database metadata in the INFORMATION_SCHEMA for ...


1

You can download the MySQL installer from https://dev.mysql.com/downloads/windows/installer/5.7.html. From it you can click in the MySQL server version you like to download. On the right hand side you then see the client binaries. The command line utility is in this package. You don't have to install the whole server for installing the client bins. EDIT: ...


1

This can be accomplished with a vlookup formula. Insert a column next to your foreign key column and a column next to your foreign key 2 column and use a vlookup to reference your second table (in the screenshot below the second table begins at column I) The standard syntax looks something like this: =VLOOKUP(Lookup Value , Table, Search Column, Exact ...


1

There are a few things to check: Have you enabled PHP over FastCGI with a module mapping?: Have you added a default document type? Have you definitely made sure the php file is in the same directory as the default doc page? have you recycled the app pools since adding the PHP instance? Possibly none of these, but these are common pitfalls I've seen ...


1

No, Windows does not stop anything on its own (linux has OOMKiller but windows does not). MySQL, how ever, may die if it fails to allocate as much memory as it needs. You should do the following: Check event log on (it may contain information telling you why service been stopped) Check MySQL error log: it should have errors. Use Windows Performance ...


1

Use the file utility like so: file <filename> For files with *NIX line endings you should see "ASCII text". For files with Windows line endings you should see "ASCII text, with CRLF line terminators". You can of course use dos2unix and unix2dos to convert between the two.


1

You can use a hex editor and open the exported file, and see for yourself.



Only top voted, non community-wiki answers of a minimum length are eligible