Dragan Eror el22or

## frontendDevlopmentBookmarks.md

      
              1 file
            
          
              1100 forks
            
          
              124 comments
            
          
              4959 stars
            
          
                dypsilon
                / frontendDevlopmentBookmarks.md
            
            
              Last active
              June 13, 2024 10:59
            
              
                A badass list of frontend development resources I collected over time.
              
          
    Frontend Development

Attention: the list was moved to
https://github.com/dypsilon/frontend-dev-bookmarks
This page is not maintained anymore, please update your bookmarks.


## mysql-export-import
## SSH - Remote export > local import
ssh USER@HOST mysqldump -uREMOTEDATABASEUSER -pREMOTEDATABASEPASSWORD -hREMOTEHOST REMOTEDATABASENAME | mysql -uLOCALDATABASEUSER -pLOCALDATABASEPASSWORD LOCALDATABASENAME

## Export to CSV
mysql -uUSER -pPASS DATABASENAME -B -e "select * from \`korisnici\`;" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > filename.csv

## Export to CSV 2
mysql -uUSER -pPASS DATABASE -B -e "SELECT users.uid AS 'ID', users.name AS 'Username', users.mail AS 'Email', from_unixtime(users.created) AS 'Created', from_unixtime(users.login) AS 'Last login' FROM users WHERE users.status=1 AND users.login!=0 ORDER BY users.login DESC;" | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > vehicle_categories.csv

## Export to SQL gzipped file with compression

## draganeror.pub
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEA9k/2nrH/FwFhclJJ0xgzaQr9H0KaxVW5kHgWEyhYCSDcflLVTU4D4Qfo5SPB2cGmcAw+c4MluEzH7Udj7KuWyKdIOKMj+tv8Arr0ufgV3NwsxassTeeTWzgPu635xz7j46JC0wXLG4nA1nzPZIKSKvPulCnwskkzo0lwaE3dHmA4t3yEL6fqn/sOZdjpUT1BSK0cASv+R74A38wS9IJNvC4EJiqruaaF6jgKDVUuyoX5aKeeDYC5FAQOBvMuPBgD6TJa4+CvMQlwS8Qqcy9cgTlx7TOcMlUrLz4OLMh8riYJm+JuK8nNAkRPrxX+LJVBz4XOyV3MasVx5aI9cLENEQ== draganeror@gmail.com

## README.md

      
              5 files
            
          
              303 forks
            
          
              50 comments
            
          
              2017 stars
            
          
                addyosmani
                / README.md
            
            
              Last active
              April 2, 2024 20:18
                — forked from 140bytes/LICENSE.txt
            
              
                108 byte CSS Layout Debugger
              
          
    CSS Layout Debugger

A tweet-sized debugger for visualizing your CSS layouts. Outlines every DOM element on your page a random (valid) CSS hex color.
One-line version to paste in your DevTools
Use $$ if your browser aliases it:
~ 108 byte version

  
## screen-to-dropbox
#!/bin/bash

# Take a screenshot of an area of the screen, upload it to dropbox and put the url into the clipboard

# Put file in any directory under your dropbox
# If it is subfolder, than you need to make them manually
FILENAME=~/Dropbox/Public/Screenshots/Screenshot_`date +%Y-%m-%d-%H:%M`.png

# Select an area and save the screenshot
# you need to instal gnome-screenshot

## README.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                el22or
                / README.md
            
            
              Last active
              February 27, 2020 09:22
            
              
                Gist tips
              
          
    Gist tips

Search

Search gist for keyword and by specific user
git user:el22or

☛git user:el22or
	## SSH - Remote export > local import
	ssh USER@HOST mysqldump -uREMOTEDATABASEUSER -pREMOTEDATABASEPASSWORD -hREMOTEHOST REMOTEDATABASENAME \| mysql -uLOCALDATABASEUSER -pLOCALDATABASEPASSWORD LOCALDATABASENAME

	## Export to CSV
	mysql -uUSER -pPASS DATABASENAME -B -e "select * from \`korisnici\`;" \| sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > filename.csv

	## Export to CSV 2
	mysql -uUSER -pPASS DATABASE -B -e "SELECT users.uid AS 'ID', users.name AS 'Username', users.mail AS 'Email', from_unixtime(users.created) AS 'Created', from_unixtime(users.login) AS 'Last login' FROM users WHERE users.status=1 AND users.login!=0 ORDER BY users.login DESC;" \| sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > vehicle_categories.csv

	## Export to SQL gzipped file with compression
	#!/bin/bash

	# Take a screenshot of an area of the screen, upload it to dropbox and put the url into the clipboard

	# Put file in any directory under your dropbox
	# If it is subfolder, than you need to make them manually
	FILENAME=~/Dropbox/Public/Screenshots/Screenshot_`date +%Y-%m-%d-%H:%M`.png

	# Select an area and save the screenshot
	# you need to instal gnome-screenshot