Video Tutorials (63)

 How to import and export MySQL database via SSH

You can easily import/export your database using phpMyAdmin menu in cPanel, but when dealing with large databases over 50Mb it is recommended to manage them via SSH. In this article, I will cover exporting and importing a database via SSH. Make sure that you replace the following variables in the commands below:

USERNAME - the MySQL user assigned to your database.

DATABASE - the name of your MySQL database.

Exporting a MySQL database

To export a MySQL database, you need to use the mysqldump command. Here is the full command for exporting your database:

mysqldump -uUSERNAME -p DATABASE > backup.sql

You will be prompted for a password - this is your MySQL user's password.

The MySQL database will be exported to a file named "backup.sql" in your current directory.

Importing a MySQL database

To import a MySQL database, you need to use the mysql command. Here is the full command:

mysql -uUSERNAME -p DATABASE < backup.sql

Again, you will be prompted for the password of your MySQL user.

The backup.sql is the name of the file that you are importing to your database. It must be in your current working directory.

Video Tutorial


Is it not a great idea to follow me to be recieve my last posts? Follow me now!


If you got an email from cPanel regarding "Disk Usage Warning" that means your "/backup" disk reached critical status and you have to remove the old backup files from your server and backup disk. Here in this video tutorial you'll learn how to delete the backup file and directory by using "rm" command in linux.

cPanel Monitoring

The rm ("remove") command is used to delete files. When used recursively, it may be used to delete directories.

rm removes each file specified on the command line. By default, it does not remove directories; see removing directories below for details.

The removal process unlinks a file name in a filesystem from its associated data, and marks that space on the storage device as usable by future writes. In other words, when you remove a file, the data in the file isn't changed, but it's no longer associated with a filename.

The data itself is not destroyed, but after being unlinked with rm, it becomes inaccessible. Remove your files wisely! It's not like putting something in the Windows Recycle Bin; once you rm a file or directory, there is no way to undo it.

Examples

rm myfile.txt

Remove the file myfile.txt. If the file is write-protected, you will be prompted to confirm that you really want to delete it.

rm -f myfile.txt

Remove the file myfile.txt. You will not be prompted, even if the file is write-protected; if rm can delete the file, it will.

rm *

Remove all files in the working directory. If it is write-protected, you will be prompted before rm removes it.

rm -f *

Remove all files in the working directory. rm will not prompt you for any reason before deleting them.

rm -i *

Attempt to remove every file in the working directory, but prompt before each file to confirm.

rm -I *

Remove every file in the working directory; prompt for confirmation if more than three files are being deleted.

rm -r mydirectory

Remove the directory mydirectory, and any files and directories it contains. If a file or directory that rm tries to delete is write-protected, you will be prompted to make sure that you really want to delete it.

rm -rf mydirectory

Same as the above command, but you will never be prompted; if rm can delete the files, it will.


Is it not a great idea to follow me to be recieve my last posts? Follow me now!


How to Hide All Desktop Icons on Your Mac without Using Any Software or App

If you need to use your Mac for a presentation at work or school, you may want to tidy up your machine by removing all the icons that are cluttering up your desktop. You can drag all the icons off your desktop for your presentation and then drag them back when you are done, but that method can be inconvenient and increases the chance that you could accidentally lose a file or two in the moving process. There is an easier way that allows you to temporarily hide the icons, while still keeping the files in their original location.

There’s a faster and easier way to hide all the icons on your Desktop, though, using the Terminal.
Quickly launch Terminal using an app launcher like Alfred or just double clicking the app in your Utilities folder.

Once there, type or paste the following command in:

defaults write com.apple.finder CreateDesktop false

then restart the Finder with the following:

killall Finder

This will hide all the icons on your Desktop in one fell swoop so you can go about your business on the big projector.

When you’re done and you want to see that giant pile of clutter again, simply reverse the command:

defaults write com.apple.finder CreateDesktop true

killall Finder
 
There you have it – quick, easy, and trouble free without using any free or premium softwares.

Video Tutorial


Is it not a great idea to follow me to be recieve my last posts? Follow me now!


If you have just started with web development or you’ve not yet acquired a great deal of experience, and want to learn more to master your skills but not sure where to start from then we can help you out with the following resources.

Internet is full with myriad of resources and tutorials from which you can learn and master your skills to deliver better results for your clients. Amongst them YouTube video tutorials definitely help designers and web developers who want to expand their knowledgebase.

For this article we have gathered some of the Best YouTube Channels that will help you to learn various programming skills and tricks to make you better developer. Some channels are more tutorial-focused while others pivot around presentations and keynote speeches.
So, let’s check out the channel and get ready to subscribe them.

1. DevTips

DevTips

DevTips gives you weekly tutorials and each video covers a topic thoroughly yet in an easy-to-follow manner. You can go into the basics such as HTML and CSS, CSS positioning, and others.

2. Codecourse

Codecourse

Codecourse is another great development tips channel on YouTube, it includes videos for PHP, CSS and you can learn making awesome CSS using Bourbon & Neat, bulding MVC applications in PHP from scratch, and learning material for PHP from the basics up to practical application.

3. Darek Banas

Darek Banas

Derek Banas channel has more than 380k subscribers and it covers the topic of programming languages in the video as a whole. You can see a tutorial on Object Oriented JavaScript, CSS and SASS, Ruby, Go, Swift, Visual C#, Haskel, Dart, Scala and other languages.

4. LevelUpTuts

 LevelUpTuts

This channel covers CSS Styling and web-building, frameworks such as AngularJavaScript, CMS like WordPress or Magento. Scott Tolinski covers tutorials about the Sketch app, giving some sketching tips and guides to using some features. He releases a new video twice a week.

5. Tuts+Web Design

 Tuts+ Web Design

Another useful channel which lets you learn and master skills in web design. You can learn bootstrap, layout on Photoshop and Dreamweaver, build a responsive layout, implement SASS and Compass, making themes for Tumblr, and more. The in 60 Seconds videos make many topics very simple.

6. Coder’s Guide

 Coder's Guide

Coder’s Guide is an amazing channel which you should subscribe today in order to learn HTML/CSS and JavaScript and responsive websites and applying WordPress themes with Bootstrap.

7. CodeGeek

 CodeGeek

CodeGeek is a channel that talks about events, tutorials, courses and webinars about coding and web development. This channel includes AngularJs, NodeJS, JavaScript, NodeJS Frameworks, PHP, Python, MongoDb, NoSQL, Couchbase, SQL Server and more.

8. JREAMdesign

 JREAM

REAM regularly provides programming courses with many topics there that you can learn, covering both front-end development (CSS, JavaScript, jQuery, Gulp) and back-end development (PHP OOP).

9. LearnCode.academy

 LearnCode.academy

This channel will definitely help you with your development related tasks. You will learn the basics of HTML, JavaScript fundamentals, jQuery, CSS, and Modular JavaScript or ES6 Cheatsheet. There are also tutorials on how to use multiple Pro WebDev tools.

10. Google Chrome Developer

Google Chrome Developer

Google Chrome Developer shows web development best practice, HTTP 203, Polycast (about Google Polymer) and a very interesting tool tips series that shows you good tips for using many web fundamental apps or tools.

11. Adam Khoury

 Adam Khoury

Adam Khoury channel aims to help you in mastering web development technologies such as JavaScript, PHP, SQL, HTML, CSS and others.

12. CSS Tricks

 Chris Coyier

CSS Tricks channel is made by Chris Coyier who owns famous CSSTricks site, this channel includes various topics including CSS, Responsive design, SVG and others. There are also screencasts about WordPress Development.

13. Amit Agarwal

Amit Agarwal

Amit Agarwal holds an Engineering degree in Computer Science from I.I.T. and has previously worked at ADP Inc. He is hugely popular and award-winning Digital Inspiration blog where he writes how-to guides around consumer software and mobile apps. He has developed several popular web apps and Google Add-ons including Mail Merge for Gmail.

 

 

Altin Groups IT Solution Center

Is it not a great idea to follow me to be recieve my last posts? Follow me now!


Cascading Style Sheets (CSS) is a style sheet language used for describing the look and formatting of a document written in a markup language. While most often used to change the style web pages and user interfaces written in HTML and XHTML, the language can be applied to any kind of XML document, including plain XML, SVG and XUL. CSS is a cornerstone specification of the web, and almost all web pages use CSS style sheets to describe their presentation.

Ever wanted to edit Image of a document or a PDF file? in this post you will learn how to convert image of a document or PDF ( Portable Document Format) file to editable text.

SEO can be a powerful tool if used correctly. Implemented properly, Search Engine Optimization can improve your site’s visibility in search results, which will translate to a higher traffic volume and ultimately to more sales for your business...

HTML is probably one of the easiest languages to learn, but more often we don’t give it to much attention, as these day’s we focus mainly on the CSS. So this course will help you, remind you and show you some great tips and tricks on how to write HTML more effectively.

Whether you’re a professional or a newbie designer, continuously learning and perfecting your skills will help you become an even better one. Being a designer is more than just about designing business cards and website templates, because you need to stay up-to-date with the rapidly growing market and work on mastering your technique.

Page 1 of 5