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.
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.
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.
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.
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.
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.
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.
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:
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
There you have it – quick, easy, and trouble free without using any free or premium softwares.
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.
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.
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.
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.
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.
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.
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.
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.